An automated data pipeline from ad APIs
We brought Meta, LinkedIn, Google and Apple ad data into one place automatically and built role-based dashboards in Data Studio, from the CEO to the team.
- Role
- Digital Marketing Manager
- Year
- 2022 - 2023
- Sources
- Meta, LinkedIn, Google, Apple
- Reporting
- Data Studio
The same Excel every week, a different number every time
Every week the team downloaded data from each platform by hand, merged it in Excel and sent it to leadership. It took hours, and the numbers changed from report to report.
Goals
- Collect all ad data automatically
- Role-based dashboards
- Cut the time spent on reporting
How we did it
Source map
Which metric is needed from which platform.
API flow
An automatic daily load.
Data model
One structure for channel, campaign and date.
Dashboards
Separate views for the CEO, marketing and product.
Results in %
- -[X]%time spent on reporting
- [X]data sources in one view
- Dailyautomatic refresh
What matters is not the number of dashboards but the number of decisions made after opening one.