Back to stack
Layer 04/ 05

BigQuery.

The warehouse where every event lands.

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
1
URL for reporting
How I solve it

How I set it up for you.

  • 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
Sources → fact table
Source
HubSpot
12.4k rows
Source
GA4
184k rows
Source
LinkedIn
2.1k rows
Source
Stripe
892 rows
Daily join
FACT_TABLE
199.392 rows

Four source tables join daily into a single fact table. Lead → touchpoint → stage → revenue. One source for everything.

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 me to build this for you?

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