Case Study
Increasing Ad Revenue by Improved Reporting
The Problem
The Ad Sales Team at a large Publisher needed a better way to provide data to internal teams and external customers that would also help them keep and grow their ad revenue.
This team was servicing thousands of advertisers with a mix of national and local ad products and was forced to spend several days each month configuring Google Data Studio to generate campaign-close reporting for both internal purposes as well as to show their advertising clients how well their ads performed.
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
- Creation of Portals that allowed for Advertisers to see performance of their ad buys across properties, regions, and more.
- Property, Regional, and National roll up views for Ad Sales teams to get a true, consolidated, and segmented view easily and automatically without wrangling spreadsheets.
- Utilized Pickaxe's extensive library of ETL connectors to collect, cleanse, and join data, matching line items and property performance.
The Results
Hundreds of hours saved on 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.
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.
More Case Studies
Spartan reduced CPA by over 50% by implementing CAPI.
Long before BritBox was streaming much loved shows to audiences around the world, they were looking for an experienced team to help them take the idea from concept to launch.
Nexstar CDP Development, Event Data Schema, & Implementation
Nexstar needed a better way to understand user behavior, ad anomalies, and advertising performance across the hundreds of federated stations and websites that they operate from a mix of technology platforms built by them, or that they had acquired from multiple legacy parent companies over the years. The result was inconsistent and disparate reporting.
Britbox Launch and International Expansion
Long before BritBox was streaming much loved shows to audiences around the world, they were looking for an experienced team to help them take the idea from concept to launch.
Customer Marketing Preference Center
The marketing team behind a leading consumer service needed a fast way to test the collection of detailed customer preferences for specific genre interests so that they could do more personalization.
Improving Attribution and ROAS with a custom Media Mix Model
The CMO and marketing team at Spartan Race were having challenges with getting accurate attribution across all of their paid media channels, including above the line sources like TV ads and Out Of Home. And recent changes in cookie blocking and iOS added significant confusion in the data, causing major conflict between what they believed was driving conversion vs what their internal data was showing was driving conversions.
