Leading Cable Network

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

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.

• 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
  

• 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 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