GA4 BigQuery Export

GA4 BigQuery Export

Analytics & Attribution
Google
The event-level data behind every GA4 report, in a table you can join to pipeline, with a documented 1 million event daily ceiling.
Source
Google
Tools
GA4, BigQuery
Runs
Daily, or streaming
Cost
Free tier, then Cloud rates
Last updated
August 7, 2026

What it is.

Linking a GA4 property to BigQuery exports the raw events, so you write SQL against user and session data and stop working around the report shapes in the interface. Standard properties have a daily export limit of 1 million events.

Streaming export is the second option and makes the current day queryable within minutes through an events_intraday table. It costs $0.05 per gigabyte and drops traffic_source fields for new users, which matters if you attribute acquisition.

Once GA4 events and CRM or billing data sit in the same warehouse, a question like which content touched closed-won deals becomes a query you can write.

What you get.

  • Daily tables of raw GA4 events in your own BigQuery dataset.
  • User, session, and event parameters at the grain GA4 collects them.
  • An optional streaming export with an events_intraday table for same-day analysis.
  • A dataset you can join to CRM, billing, or product tables.
HOW TO USE IT

How to set it up.

1

Create or pick a Google Cloud project and enable BigQuery on it.

2

In GA4 Admin, open BigQuery links and create a link to that project.

3

Choose daily export, streaming, or both, knowing streaming bills at $0.05 per gigabyte.

4

Pick the events to include or exclude, because one high-volume click event can eat the daily limit on its own.

5

Check the 1 million events per day ceiling against your traffic before you rely on the data being complete.

6

Confirm the first daily table arrives, then write your first query against a single day.

Use cases

Get the event grain back

Export daily so you can query events GA4 reports only in aggregate.

Join sessions to accounts

Put the events next to CRM records in the same dataset.

Rebuild a report the interface refuses

Write the query yourself when the interface refuses the breakdown.

Best for

Joining marketing to revenue

GA4 reports stop at the session. In a warehouse, a session can be matched to a closed deal.

Custom analysis

Any question that needs a join, a window function, or an attribution model of your own.

Keeping raw history

The exported tables are yours, so retention becomes a setting in your own project.

Open the original.

Hosted on Google, free to open.
Open the Tool

Questions about GA4 BigQuery Export

Is there a daily limit?
Should I use streaming or daily?
Do I get past data?

Questions about Analytics & Attribution

Why move analytics into a warehouse?
Does exporting solve sampled reports?
Strengths
  • The daily limit is published at 1 million events, so you can size it before you commit.
  • Streaming export is a separate switch, which means same-day data is available without changing the daily setup.
  • The fields the streaming export drops are documented, so the gap is known instead of discovered.
Limitations
  • 1 million events a day on standard properties, and a busy site can hit it.
  • Streaming export leaves out traffic_source.name, source, and medium for new users, so acquisition analysis needs the daily tables.
  • Streaming costs $0.05 per gigabyte on top of normal BigQuery charges.
  • Nothing from before the link gets exported, so switch it on before you need the history.
Skip this if
  • Skip it if you have no warehouse to land the events in.
Ideal for
  • Growth analysts
  • Analytics engineers
  • Stage: Series A onward

Want this running without building it yourself?

TripleDart has scaled 300+ tech companies with expert operators and AI workflows behind every play.