Case Study

Media & Entertainment Company Ad Sales Team

A national publisher and OTT provider with hundreds of local sites and stations, and thousands of advertisers on their networks wanted to improve their internal ad agency performance.

The Problem

With thousands of advertisers, this Publisher was spending several days each month configuring Google Data Studio to generate campaign-close reporting. Not only were the visualizations lackluster and off brand, but the Publisher was also running into significant Infosec concerns granting advertisers access to their data in a secure way.

What We Did

The Results

Hundreds of hours saved reporting every quarter – no more wrangling spreadsheets.

Client renewals increased by 15%.

Ad Sales team improved their relationship with customers, and provided valuable insights back to advertisers in real time.

15%

Growth in Client Renewals

The Solution

Pickaxe created a reporting framework that provided three levels of insights: 

  • A national view across the entire portfolio of sites and stations, with anomaly detection, performance insights and alerts, and powerful query tools.
  • A station level view, with all of the above filtered to only include the stations data plus benchmark comparisons (by DMA size).
  • A customized view for each of their thousands of advertiser.  

Advertiser Portal

When advertisers login, they only see their campaigns and media performance across all the sites on which they advertised.  Alerts are provided for assets that are particularly strong performers. An integration with GAM and the order management system allows for the publisher to have advertisers granted access when their campaigns flight (and for access to be removed automatically at the appropriate cadence after campaign close reporting).  

Station Views

Station managers can view all of the campaigns trafficked across their sites. They get 

National View

The Publisher’s national Sales and Account teams can leverage Pickaxe to view Order Management Data, Site Analytics, and Campaign Performance across the entire portfolio of sites and stations, with anomaly detection, performance insights and alerts, and powerful query tools.  They get alerts if their clients’ ads are trafficking too often in the overnight hours, if Acquisition Campaigns are generated appropriate click-thru and Awareness campaigns are meeting CPM and Impression goals. 

Pickaxe Connectors Used

Pickaxe connections to GAM, BigQuery, and Google Analytics.

learn more

Let us show you how we can help you make the most of your data.