01 — The brief
The problem
Merchants drowned in raw review text.
02 — How we built it
The approach
- Built a topic-extraction pipeline with GPT-4.
- Designed merchant dashboards in Looker Studio.
- Automated weekly summary emails.
- Optimised technical SEO: 40% organic traffic lift.
03 — Outcomes
The results.
1.2M
Reviews/mo processed
+40%
Organic traffic
78%
Weekly digest open rate
Stack
PythonGPT-4PandasLooker StudioPostgres