Dublo
Get Hyped Media
Creator-led performance marketing agency
30s → under 2s
dashboard load across every client, and the Supermetrics bill gone.
- Under 2sdashboard load, down from 30 seconds or more
- Minutesto produce a client report, not hours
- $0spent on Supermetrics after the switch
The challenge
Get Hyped Media ran client reporting through Supermetrics piped straight into Looker Studio. Every chart queried the connector live.
Dashboards took 30 seconds or more to load, quota limits bit, and Meta numbers did not reconcile between two reports. Historical depth was capped by the connector, so year-over-year questions had no answer.
Platform data could not be joined, so creator-level and cross-channel performance was assembled by hand in spreadsheets. Each new client meant another fragile pipeline and another licence line.
What we built
We moved the agency off the connector and onto its own warehouse. Airbyte pulls Meta, TikTok, Google, Klaviyo, Shopify and WooCommerce into BigQuery, dbt models the raw data into clean, documented tables, and Looker Studio reads the models instead of the APIs.
Cross-platform joins happen in the warehouse, so spend, creative and creator performance sit in one table and creator-level ROAS is just a query. Orchestration runs the pipeline on a schedule and posts to Slack when something breaks.
Onboarding a client is a config change on an existing model, not a new reporting project.
Built with
The results
- Dashboards load in under 2 seconds, down from 30 seconds or more.
- Reporting that took hours now takes minutes.
- One source of truth across Meta, TikTok, Google, Klaviyo, Shopify and WooCommerce, with creator-level attribution.
- Full history kept in the warehouse, so year-over-year comparisons are possible.
- The Supermetrics licence bill is gone, and new clients onboard without a new pipeline.
Before Dorian, our agency reporting dashboards were slow and unreliable. He built and maintains our performance dashboards across all of our active clients, pulling Meta, Google, TikTok, Amazon, Shopify and Klaviyo into clean, actionable reporting we depend on daily.
Dan CoughlinManaging Director, Get Hyped Media