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

0%
Service Costs Savings
0%
SLA Improvement
0%
Data Update Alerts

Project Highlights

0
Billions of Ad Impressions per Month
0+
Ad Networks Managed
0K
Campaigns Managed

Technology

Cloud

aws-logo

Analytics

sas-logo

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. 

Let’s Connect

Make a connection with one of our specialists to:

  • Learn how cloud analytics can drive business value in your organization
  • Understand how other companies are transforming their business and using AI and ML
  • Identify specific use cases where you can implement a transformation project as soon as 3 months
Request a Briefing