TV Media Invoice Verification & Implementation Analysis

Broadcasting Company

Objectives

Verification of all the TV media invoices with supporting documents (TC & BARC report) and implementation analysis dashboards for spends on TV medium

Approach

  • To analyse the deviations of the implemented activity as received from the client, from the planned objectives

  • Free Commercial Time (FCT) difference between Implemented (as per BARC report) vs Billed campaign (check against Telecast certificate) by Channel/activity

  • Regular activity, incorrect time-band/program wise deal rate used

  • Highlight slot not part of deal, Combined slots, Same time-band but different program

  • FCT outside deal time-bands billed

  • Compliance on committed time-band wise dispersion – greater fringe hours

  • Hourly FCT dispersion – Check for uneven allocation/skew to low delivery hours and impact on deliveries

  • Planned vs delivered - Spots/FCT/Gross Rating Points

  • Cost Per Rating Point (CRPP) comparison – planned vs delivered

  • Pre- vs Post evaluations at campaign level tracking and split by different reasons for under-delivery

Outcome

Billing deviation of 1.3% in annual agency billing for TV media as compared to supporting (telecast certificate)

01
02

0.1% excess cost due to execution of TV spots outside agreed time bands

0.2% opportunity cost on account of null spots (spots with nil viewership rating)

03
04

30 channels (out of 57 channels) with premium spots percent lower than benchmark premium spots percent