GA4BigQueryData exportAnalytics
GA4 to BigQuery: when and how to export your marketing data
By The MB Data Automation team··6 min read
TL;DR
- →GA4 has a free, native BigQuery export - it unlocks raw, unsampled data and history.
- →Turn it on when GA4's interface limits you: sampling, retention, or joining sources.
- →You do not need a data team to start - just the export plus a few modeled tables.
GA4's BigQuery export is one of the most useful - and underused - free features for agencies. It streams raw event data into BigQuery, where you can query it without sampling, keep unlimited history, and join it to ad and ecommerce data.
When to turn it on
| Signal | What the export solves |
|---|---|
| GA4 reports are sampled | Raw, unsampled event data in BigQuery |
| You need old data | History beyond GA4's retention limits |
| You join GA4 + Ads + Shopify | One place to model and join sources |
| You want AI on clean data | Structured tables AI can read |
How to start (without a data team)
- In GA4 Admin → BigQuery Links, connect a BigQuery project (free tier works).
- Let event data flow in; confirm the daily tables appear.
- Build a few clean, documented tables (sessions, conversions, spend) on top of the raw export.
- Point Looker Studio at the modeled tables instead of raw GA4.
Start small, grow into it
You do not need to model everything on day one. The export plus a handful of well-structured tables already gives you unsampled reporting and an automation-ready foundation. Add depth as your needs grow.
The Pro Kit includes BigQuery schema templates and dbt-style models to structure your GA4 export into clean, query-ready tables.