WhatsApp · AutomationMar — Jul 2026Product Ops
FoodEase Bot
Turning a 3-hour reporting chore into 10 seconds.
3h → 10s
daily reporting
Nightly
automated reports
Real screens · sensitive data blurred
01
The problem
Order logs lived in messy Excel files; commissions and churn were calculated by hand every day.
02
How I approached it
- 1.Built a Python pipeline to clean logs, dedupe order IDs and compute commissions.
- 2.Connected Google Sheets to Looker Studio with nightly PDF reports.
- 3.Designed churn tracking using abandoned order IDs.
03
What shipped
Automated reporting pipelineLooker Studio performance dashboardChurn & payment-funnel trackerPartner commission reconciliation
Next project
Pure Fitness Africa →