Boldspace
Real-time customer feedback analytics with AI-powered insights across 50K+ reviews for a creative and PR agency.
Headline outcome
50K+
Reviews processed
FivetrandbtBigQuery
SigmaThe challenge
Where they started.
A creative and PR agency with no unified ingestion. Sources connected ad-hoc. No dbt adoption; business logic lived inside dashboards. No structured warehouse layer. Ingestion, transformation, and analytics were three disconnected islands. Each client got their own bespoke dashboard. Nothing scaled.
The approach
What we actually built.
01
Multi-tool ingestion
Airbyte for SaaS sources, Hevo for marketing platforms, Fivetran for finance, custom Python for the niche APIs.
02
dbt transformation
Built the warehouse layer from zero. Business logic moved out of dashboards and into versioned, tested code.
03
Sigma dashboards
Consistent, trustworthy visualization across all client engagements. No more per-client dashboard forks.
04
LLM-powered insights
AI commentary layer on top of the warehouse — sentiment detection, theme extraction, and auto-generated insights for client reports.
Results
The numbers that shifted.
50K+
Reviews processed
+65%
ROI boost
1 week
New client onboarding (was 6 weeks)