Weekly reports that build themselves
Numbers are pulled, charted and emailed before Monday starts.
- Client
- Marketing agency
- Timeline
- 3 weeks
- Scope
- Reporting automation
The problem
An analyst spent every Monday copying numbers from ad platforms into slides. Errors were common and reports went out late.
What we built
- Data is pulled from each ad platform on Sunday night.
- Charts and a plain-language summary are built from one template.
- Clients get the report by email at 7:00 AM, with the analyst copied.
6 hrs → 20 minweekly reporting time
22client reports sent weekly
0copy-paste errors
Built with Python, Google Sheets API, scheduled jobs.