Cross Channel Reporting for a Large Media House

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