brim/break
Back to stack
04 · Layer

BigQuery.

Reporting that doesn't need Excel exports out of C-level calls.

Sink for HubSpot, GA4, LinkedIn Ads. A joined fact table behind it. Looker Studio or Metabase as the frontend. C-level clicks one URL instead of waiting for PowerPoint.

5+
Data sources
Daily
Sync
~€80
/ month cloud
0
Excel exports / wk
We've all been there

What you've probably seen.

  • GA4 only — lead tracking ends before the pipeline
  • HubSpot reports trapped in the HubSpot UI
  • LinkedIn Ads spend never joined with MQLs
  • Excel-PDF export every Monday, by hand
How we solve it

How we set it up.

  • Airbyte or Fivetran free tier sync daily
  • Joined fact table: Lead → Touchpoint → Stage → Revenue
  • Looker Studio embedded in Notion, Slack, email
  • Self-service: AE clicks their own drill-down
Toolchain
BigQueryAirbyteLooker StudioMetabasedbt (optional)Cloud FunctionsScheduled QueriesMaterialized ViewsBigQueryAirbyteLooker StudioMetabasedbt (optional)Cloud FunctionsScheduled QueriesMaterialized Views
Example workflow

Example: Nightly fact-table build

  1. 0101:00 cron triggers Airbyte sync
  2. 02Joined fact table is built (dbt or SQL)
  3. 03Materialized view is refreshed
  4. 04Looker dashboard is fresh by morning

Want us to build this for you?.

30 min demo. We walk you through a real setup, live.