Project Description

Leading Cable Network

Post-Buy Analytics

The Challenge

This large, worldwide media and cable giant needed a better way to manage their Post-Buy Analytics that accounts for more that 5 Billion in advertising impressions per month. The legacy post-buy solution had several critical gaps including:

  • Static reports with no auto-refresh
  • Significant manual effort required to resolve exceptions and to post changes
  • No access to data for advanced analysis

Business Impact

Service Costs Savings
SLA Improvement
Data Update Alerts

Project Highlights

Billions of Ad Impressions per Month
Ad Networks Managed
Campaigns Managed






Data Lake

Source Data

ERP Integration

The Solution

Core Compete built a Cloud Native solution that fulfilled the need for: end-to-end post-buy requirements for TV and Digital ad impressions, automated workflow, self-service models, access to real-time views and capabilities for forecasting and advanced analytics.

Business Components

  • Datamart and Post-buy processing are implemented using SAS Data Management on AWS Platform; Data is automatically refreshed from the enterprise systems
  • Post-buy reports are generated using SAS Platform and auto-delivered; Automated alert notifications on reposts / key data changes
  • Post-buy data mart is accessible through SAS Visual Analytics, SAS Forecasting and ML to support advanced analytics
  • Capability for Ad-hoc reporting / Self-service analytics

Technical Components

  • Data Ingestion occurs continuously from multiple source file such as Neilsen, WideOrbit and other ERP systems
  • Data process flows daily and monthly to provide updates and feed post-buy analytics datamart and tables, post-buy reports and .csv files
  • SAS stored process ad-hoc reports are read from the datamart and feed on-demand reporting

The Result

The cloud native post-buy solution revitalized the entire post-buy process and delivering significant business value:

  • Performs post-buy processing for 70 Billion advertising impressions per month
  • Ready to scale for the addition of digital advertisement impressions processing
  • 30% savings in service costs
  • End-to-end process now automated + ability to easily configure posting rules fully eliminated manual data transfers and effort
  • Gained up-to-date view of metrics using self-service dashboards and explorations / analytics

Solution Architecture

Media & Cable Network

  • Industry: Media & Entertainment

  • Revenue: >$10 Billion

  • Location: U.S. & International

  • Employee Base: >10,000

About The Client

Multinational mass media company that owns television, movie and publishing interests around the world.