Media Plan Converter

Description
Purpose: To translate the media plan, which is stored more in calendar format, to a vertical report.


Reason: Since ultimate aim of the media auditing agencies is to reconcile the spots and highlight if there is any deviation.


Note: Deviation refers to time. If the Company has to run the promotion between a time band of 1pm to 2pm and promotion actually ran at 230pm then its referred as deviation.


This reconciliation and deviation impacts the overall billing and so on.


Why to translate to vertical report format? The report received from the media channel is in the vertical format and to allow a room for reconciliation without complexity, this tool translates the plan to the same formation


Once the plan is converted to a vertical report then the converted version is used in another tool made. The converted plan is uploaded in defined area along with the data received from the third party. 


How to use:
1. Add details in the media plan which start from the data:
1.1. Company
1.2. Brand
1.3. Campaign
1.4. Start Date
Once the above data added, press button named "Update Media Planner"


Proceed with updating other details. Once done, follow the steps mentioned below:


2. Press Button named "Update Media Planner"
3. Press Button named "Refresh"
4. Press Button named "Update Deviation Report"