Luxury & Cosmetics
Client
Leading Luxury Client
Service
Cloud Services
Date
November 2024
Results
+10%
Compliance rate after 1 month
4k+
Campaigns checked per year
2k+
Accounts connected from 5 media platforms
- Head of Media Performance
CHALLENGE
For our client, an international luxury conglomerate, inadequate adherence to existing naming conventions in media campaigns hindered data consolidation across different markets and channels. This resulted in inaccurate assessments of media campaign ROI and performance analysis.
Without a consistent naming convention, the group faced challenges in generating relevant reports and making performance comparisons across campaigns, markets, and brands.
Solution
After gaining access to the group's media stack, fifty-five transferred data from various media platforms to BigQuery by utilizing Fivetran connectors for data extraction and loading.
fifty-five then created a scripted Taxonomy Checker that was ready for variability to automate compliance checks and develop the data architecture using Google Cloud Platform services. All visualizations were created using Power BI.
Results
+10% Compliance rate after 1 month
4k+ Campaigns checked per year
2K+ Accounts connected from 5 media platforms
Case Studies
Stay Tuned