Standardizing online advertising data by migrating from Microsoft to Snowflake
Overview
Industry
Location
Media and entertainment
Poland
Technology Used
Apache Airflow
AWS Lambda
Microsoft Power BI
Snowflake
Project overview
The project aimed to migrate the siloed data warehouse for ad sales and traffic monitoring areas from Microsoft’s on-site infrastructure to the cloud using Snowflake. This involved reporting and ELT (Extract, Load, Transform) processes that utilize data from programmatic platforms as well as internal client sales and traffic systems. The goal was to standardize online advertising data, enable consistent reporting across all programmatic platforms and provide decision-makers with the Ad data necessary to maximize ad revenue.
Client background
A leading media company in Poland, which operates a diverse portfolio of television channels, digital platforms and streaming services and reaches millions of viewers and users daily. Our client is part of a multinational mass media and entertainment group.
Goals
Standardizing online advertising data to enable consistent reporting across all programmatic platforms. Migrating the siloed data warehouse for ad sales and traffic monitoring areas to a cloud-native solution and extending the data model to handle new data sources. Standardizing reports to allow for new KPI support.
Results
Reducing data process time by 80%
Enhancing productivity by reducing processing time from 10 hours to 2
Increasing data processing stability
Ensuring a more reliable and error-free data processing experience
Extending source integration
Adding support for Google Ad Manager (API and files) and Salesforce, to enable a more seamless flow of data from multiple sources
Maximizing revenue from online advertising
Empowering stakeholders with the data they need to boost ad revenue
We'd love to hear from you!
Fill out the form - we'll get back to you as soon as possible
