Background
The studio had a steady flow of leads but struggled to understand which ads actually converted into revenue. Their tracking stack was stitched across pixels, funnels, and forms — making weekly decisions feel like guesswork.
The challenge
They were spending more, but learning less. Campaigns looked profitable inside Meta Ads, yet GA4 told a different story, and attribution inside HubSpot was unreliable.
What I built
- A clean GA4 setup mapping real business conversions to marketing touchpoints
- Meta + GA4 + HubSpot attribution stitched using campaign IDs and client identifiers
- Automated nightly pipelines pulling paid + CRM data into BigQuery
- A performance dashboard that highlights which campaigns actually generate profitable bookings
The outcome
The team regained trust in their data and confidently reallocated budget toward genuinely high-performing campaigns. What previously took hours of spreadsheet stitching became a 10-minute dashboard review.
They stopped arguing over numbers and started acting on them. The feeling of "we think this campaign works" became "we know — and here's how to scale it."