This article outlines the required inputs for auditing make-good responses, the step-by-step process to be followed, and the expected outputs to be delivered. 


To learn how to upload the RO Master and MG Response files using the TV AdBuy Manager App, click here.


Inputs required

  1. RO Master - To be uploaded using the TV AdBuy Manager

  2. MG Response - To be uploaded using TV AdBuy Manager

  3. ADEX - To be uploaded to shared Google Drive

  4. BARC - To be uploaded to shared Google Drive


Details on Google Drive folders shall be shared separately. 

Please ensure that all the files are in .xlsx format for consistency and ease of processing.


Expected frequency of file uploads

  1. RO Master - Once, at the start of the month

  2. MG Response - As required

  3. ADEX - Once a week

  4. BARC - Once a week


Please ensure timely uploads to maintain the efficiency of the audit process. All errors found while processing the files shall be intimated via email. The files can be corrected and re-uploaded for further processing.


Expected naming convention of input files


File typeFile nameTab name
RO MasterRO_Master_{month}_{year}RO Master
MG ResponseMG_Response_{day}_{month}_{year}MG Response
ADEXADEX_{startdate}_{enddate}Adex
BARCBARC_{startdate}_{enddate}TVR By Cluster


Please ensure that the tab name is correctly followed as per the guidelines to facilitate proper processing.


Expected format of input files


The tables below describe the headings expected in each of the input files.


1. RO Master


Expected fields

Remarks

Spot ID

A unique number with 30 digits

Brand name


Key


Date


Satellite


Channel


Program


Time Band

Time-band of the program

Duration

Duration in seconds

Rate


Spots

Number of spots within the spot ID

Campaign Start Date


Campaign End Date



2. MG Response


Expected fields

Remarks

Spot ID

The value should be present in the RO Master

Channel name


Date


Program


Offered start time


Offered end time


Rate per 10 seconds


Number of spots from RO


Number of paid spots offered


Number of bonus spots offered


Approval status



3. ADEX


Expected fields

Remarks

BRAND


CHANNELNAME


CATEGORY


PROGRAM DATE


PROGRAM START TIME


PROGRAM NAME


AD START TIME


AD DURATION


BREAK NO.


AD POSITION IN BREAK


TOTAL ADS IN BREAK


AD LANGUAGE


AD THEME


PREVIOUS AD


NEXT AD


AD SR.NO.


TOTAL ADS IN PROGRAM


ADVERTISER NAME


SPOT ID

Adex spot ID

DAY OF PRORAM AIRED


REPORTING DATE


AD END TIME



4. BARC


Expected fields

Remarks

Targets

Target group

Channel


Cluster

Satellite name

TimeBand


TVR

Rating of the time band


How to run the process?

  1. Upload the RO Master at the start of the month

  2. Upload BARC 

  3. Upload MG response documents. The MG Auditing will done based on documents uploaded in steps 1, 2 & 3

  4. Upload ADEX (Will be used for RO Master reconciliation)


Outputs


Auditing of RO and MG Response will be based on the latest available ADEX and BARC data in the Shopalyst system.

 
Reports that will be shared are:

  • RO Master Audit report: At the end of the month via Google Drive.

           

  • MG Response Audit report: After each MG response is uploaded, via Google Drive.



The outputs shall be shared with the stakeholders for the MG Audit process.


Looking for more help? Instructions to reach out to support are here.