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
Project Highlights
Technology
Cloud
Analytics
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