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
Our Client's 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 driving 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
More than 4OOO campaigns were taxo-checked during the first year of this project alone. By promoting better naming convention compliance, our client obtained more accurate data from its media campaigns, ultimately improving the accuracy of performance and ROI analysis.
+10% Compliance rate after 1 month
4k+ Campaigns checked per year
2K+ Accounts connected from 5 media platforms
Case Studies
Stay Tuned