Cross Channel Reporting for a Large Media House in UK

Project Description

The end client is one of the largest media house which carries out media planning, execution and reporting for its end clients.

Key Challenges:

  • Diverse data sources varying with client and high volume associated with click level tracking
  • Identification and implementation of standard sources and standard reports for a diverse client base
  • Seamless and reduced timeline to onboard multiple clients
  • Ensure data reconciliation with standard reports published by data providers

Solution

  • Build of Standard connectors to source all data from data providers to ensure standardization across clients
  • Build of a data warehouse at the most granular level to provide comprehensive reporting & analytics capability
  • Client specific marts to ensure robust security and address client specific dimensional reporting
  • Flexibility of user specified visualization tools accessing SSAS cubes
  • Rich set of auxiliary applications
  • Extend reporting capabilities through user defined KPI
  • On boarding tool to ensure seamless on boarding of multiple clients with diverse requirements
  • Robust validation process to ensure reconciliation with data providers

Benefits

  • Creation of a consistent data asset integrating multiple sources for enterprise wide use in a secure manner
  • Ability to determine efficacy of different media channels on a single reporting platform
  • Near real time reporting that allows alteration to campaigns
  • Increased leverage of platform through seamless on boarding of multiple clients