Building a state-of-the-art data platform for a global media & entertainment company.
Client
Technology
GCP
Looker Studio
Funnel.io
Our client, one of the biggest media & entertainment companies in the world, was facing challenges in getting the right information and in an efficient manner to drive better marketing-related decisions. Fragmented data across channels and markets resulted in a lack of unified vision of marketing performance and insights, as well as increased dependence on agency resources.
Our Bold Ambition
Our client needed a unified view of their marketing activities, which meant we needed to start with a unified view of their marketing data. Our vision was also to reduce reliance on external resources, align multi market insights whilst delivering a central reporting and data hub. Ultimately, our solution would create efficiencies so that our client team could focus more time delivering relevant, useful, and inspiring connections across every touchpoint to consumers.
Our Solution
Acceleration@EssenceMediacom worked together with Google and the client to develop a client-owned Google Cloud Platform Data Warehouse, streamlining processes for data collection and management across all data sources to feed into an automated reporting dashboard. Also, to future-proof the client’s business reporting capabilities, Acceleration@EssenceMediacom reviewed all reporting requirements and Data Governance standards, as well as providing the in-house client team with appropriate training and skill sets.
Results
Our implementation was able to deliver a 300% ROI, delivered through operational savings in year 1. The client was able to save the equivalent to almost 2 days of UPI & market resources saved due to automation of reporting outputs.
Also, the client finally gained the ability to turn insights into action, by having in-flight creative level reporting now available, allowing them to understand asset usage across markets, as well as analysis of all key metrics at different stages of a campaign to identify best KPIs by market per week.