01Case study · Reporting
A monthly report app for every market
It pulls the numbers, the manager adds the story, and AI ties the two together. I built it for the partner marketing team at Veo Technologies.
Problem
Every month, managers in 12 markets put together a partner performance report by hand. They copied figures out of the data warehouse and spreadsheets, listed their activations from Asana and wrote the story around them. It took about an hour each, every report looked different, and the same metric could mean two things in two markets.
Solution
One app where the numbers are already there. The manager opens their market, pulls the month's activations with a click, adds context, and watches the finished report build itself in one shared format. An AI draft connects the big swings in the numbers to what the manager wrote.
What I built
- A market overview showing which reports are not started, in draft or complete
- Revenue, ARR, new accounts, leads and top partners pulled automatically, with targets and month-over-month change
- One-click import of the month's activations from Asana
- An AI-drafted summary the manager can accept, edit or discard
- A live preview of the finished report while the manager types
- "Mark complete", which freezes the figures, with editing rights set per market
- A page documenting every metric and its source, plus the user guide
Numbers
- Report prep went from about 1 hour to 15 minutes per manager
- Used across 12 markets
- 42 metrics defined and documented in one place
Tech stack
- Python, FastAPI
- BigQuery, Firestore, Asana
- Gemini for the summary
- Google Cloud Run, Terraform, built with Claude Code
Outcome
- Live in production at Veo
- Every market now reports in the same format, with the same definitions
- Managers spend their time on the story, not on copying numbers
Try it: this is a working, simplified demo with made-up data.Open full screen ↗︎