BigQuery Export

The BigQuery export is a free GA4 feature that streams your raw, event-level data into Google BigQuery, where you can query it with SQL. It hands you every event your property collects — one row per event — with none of the aggregation, sampling, or interface limits of the standard reports.

Why it matters

The GA4 interface is a summary. It rounds, groups, and sometimes applies sampling to large queries. The BigQuery export is the underlying truth: the actual events, in full detail, that those reports are built from. For anyone who needs custom joins, longer history, or numbers the interface won't give them, it's the only complete source.

A concrete example

Suppose you want to know the exact path users took before a purchase — every event, in order, per session. The standard reports can't show that cleanly. In BigQuery you write one SQL query against the daily events table, unnest the event parameters, and get the full sequence. It's also how you keep data beyond GA4's retention limit: export it once, and it's yours indefinitely.

The common misreading

People assume the export is retroactive. It isn't — it only captures data from the day you enable it forward, so the sooner it's switched on, the more history you bank. The second misread is treating BigQuery as a replacement for analysis. It's a raw data warehouse, not a dashboard: it gives you everything, but you still have to write the query that turns events into meaning.