Spot Reconciliation - Media Audit

Description
Media Auditing is a performance management tool in the advertising industry that tracks how well a set of goals or fundamental principles are being followed and, therefore, how effective and efficient a team is in accomplishing their duties. In its most basic form, a media audit provides confirmation of value delivered. Some see the ultimate goal as a way of measuring an agency’s performance. Others see it as a weapon to gain competitive advantage.



When advertisers began auditing, TV was king and advertisers were still debating if perhaps they should set aside 10% of their media budget for “online”. Oh, how times have changed. Fast forward to today and we have a completely new vocabulary to help identify and distinguish the array of new tools and techniques for reaching the intended consumer. TV now goes by many different names: Linear TV, Data-Driven Linear, Addressable, Video-On-Demand (or VOD), Connected TV (or CTV), etc. And, Digital in all its forms is an outsized piece of the pie.


While the ‘what’ is changing - the ‘why’ is as important as ever. Media continues to be one of the largest investments an advertiser makes. As with any large investment, it’s important to know that you are maximizing value. Measuring media value - and leveraging objective expertise - helps to ensure you get the best possible ROI from your media investment. After all, if you don’t know the true value of your media spend, how can you know if you are getting the right deal and how do you know where and how to improve? 


Here I present the 2nd version i.e. Spot Reconciliation between the Vertical file, translated from Media Plan Converter, and the file received from the Channel.



Tool Feature:

The main feature which it has "the RECONCILIATION OF EXACT TIME VS THE RANGE with ZERO DUPLICATION." For e.g.


Time Range of 13:00 to 14:00 vs 13;29