New Data Schema, CDP Development, & Instrumentation for Nexstar’s hundreds of federated websites.

The Problem

The CDO of 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.

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.

Our Solution

We created a full schema that radically overhauled how their data was being collected, ensuring that all key KPIs were being met, and advancing their overall corporate strategy and worked directly with their internal development team to ensure that newly instrumented events and data schema work as expected.

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.

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.

learn more

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

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Thank You!

We'll be in touch!

REQUEST A DEMO

Let us give you a customized walkthrough of all of our platform’s capabilities. Reach out to learn more! 

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.