How to Gain Real-Time Visibility on TV Ad Spends with Phrazor

Impact
12 brand & 7 category reports auto-generated
3 - 4 data analysts’ workload reduced in the Ad Spend Reporting team

Business Challenge

Assessing the ROI of TV ad spends

Being a consumer brand, marketing is vital in creating awareness and staying relevant in the minds of consumers, especially with numerous brands competing for their attention. This FMCG firm’s marketing team is responsible for allocating budgets for marketing spends, specifically TV, print, and media. TV ad spends are the prime focus.

The key challenge in TV ad spends is the varying rate of available FCT (Free Commercial Time) from channel to channel and also for the same channel over time. Channel viewership is always fluctuating which is why the marketing team needs to understand the cost per rating point (CPRP), which is related to viewership. The team must track the inflation of this cost. How much are they spending for a share of viewership? What are the returns gained from the ad spend?

Issues Identified

  • Market data required to track the cost inflation based on viewership across brands is published by the TV audience measurement body, Broadcast Audience Research Council (BARC)
  • The company employed 3-4 data analysts to manually compute the ROI on TV ad spends based on the CPRP of various channels
  • The manual effort involved made this a time-consuming, cumbersome and error-prone activity
Curious to know what happened next? Unlock now to read the entire case study.

Company Overview

One of the oldest multinational firms in the world produces and supplies fast-moving consumer goods in food, home and personal care product categories in Europe, the Americas, Asia, and Africa. It sells over 400 brands in 190 countries and has a daily consumer base of 2.5 billion people.


Industry
Consumer Products
Function
Marketing
Use Case
Cost Per Rating Point Report