Issue
The client was a leading network that served multiple clients. Consolidated reporting needs to be provided on a daily basis by extracting data from more than 40 partner dashboards. This took about 1 full person with a lot of scope for human error. The client was looking to become more efficient where consolidated data is available faster with fewer errors
Our Approach
We’ve used combination of scheduled reports and scraping for different platforms under and automated the quality checks derived from these reports
- Automated the process of manipulating the raw data into reportable format
- Created datastudio dashboards with custom views for consolidated overview, optimisations, billing, etc.
Impact
Effort spent on reporting was reduced by 85%. and The team progressed towards optimization strategies, AB Testing activities, value driven activities
