01 · Context
What needed to change
Teams needed a daily view of what changed in their customer messaging operations without opening an analytics dashboard.
02 · Challenge
The hard part
Combine saved analytics data into a useful report while keeping generation cost and delivery predictable.
03 · Approach
How I approached it
- Specified the metrics and 24-hour comparisons from existing analytics data.
- Designed prompts and fallback behavior to turn the numbers into a readable email.
- Implemented report generation, billing, email delivery, and the React management UI.
04 · Outcome
What shipped
Shipped a paid report product for 3,000+ teams at $1 per report while keeping OpenAI generation costs below 5% of report revenue using o4-mini.