From scattered ad data to dashboards for management.
How we built an automated data pipeline for ProAd Sweden, gathering data from Google Ad Manager and Google Analytics every night and making it available for decisions in Looker Studio.
Business-critical data was scattered across several systems, hard to overview and hard to base decisions on.
ProAd Sweden sells digital advertising and represents niche sites, and their key figures lived in several different services, including Google Ad Manager and Google Analytics. Manually compiling data for management was time-consuming and rarely gave a unified picture.
What was needed was an automated solution that gathers data from the sources, stores it in a structured way and makes it easy to visualise, so management can follow the business and make decisions on current figures.
API to Google Ad Manager and Analytics
We built an API that fetches data from Google Ad Manager and Google Analytics, ad revenue and traffic gathered directly from the source.
Nightly synchronisation to a database
Data is synchronised automatically every night and stored in a structured database, always up to date, without manual work.
Dashboards in Looker Studio
The database is consumed by Google Looker Studio, where management gets clear dashboards of the business's key figures, from scattered data to decisions in one place.
Is your data scattered across systems?
Tell us about your sources. We'll gladly show how we'd bring them together for better decisions.