Case Study
Nexstar Data Schema, CDP Development, & Instrumentation
The Problem
Nexstar Media Group, Inc. is America’s largest local television and media company with 198 full power TV stations (including partner stations) in 116 markets, addressing nearly 62% of U.S. television households, and a growing digital media operation.
Without accurate reporting and the ability to analyze user behavior, they were unable to truly understand the local needs and preferences of the users within those communities, limiting their ability to accurately customize their digital strategy to local markets.
And more importantly, Nexstar wanted to make sure they knew as quickly as possible whenever any ad slot wasn’t performing as it should, ensuring no bleeding of revenue, which meant requiring a solution that could analyze billions of events to find the underperforming ad slots and pages.
What We Did
- Developed a radical new data schema to provide the flexibility and focus needed to ensure data was of the highest quality and business ready.
- Implemented, QA'd, and tested new data pipelines and technologies.
- Fully automated ad anomaly detection and insights analysis, analyzing billions of events every month.
- Architected a federated CDP solution to power future growth.
The Results
Armed with relevant insights and real-time visibility into local markets, Nexstar is now able to compare site performance across all of their brands concurrently, using a single reporting architecture. Additionally, Pickaxe’s results enabled Nexstar to create local station websites with differentiated digital strategies based on a hyperlocal approach.
More Case Studies
Launch of DTC offer for YES Network
When the Yankees Entertainment Network wanted to launch a new DTC offer, they turned to Pickaxe to help.
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.
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.
Increasing Ad Revenue by Improved Reporting
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.
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.
