You can export raw GA4 event data to BigQuery for free. Set it up in Admin > Product links > BigQuery links, connect a Google Cloud project, and choose daily or streaming export. Standard GA4 properties can export up to 1 million events per day for free with the daily export. Streaming export has no event cap but adds BigQuery usage costs of about $0.05 per gigabyte.
Most of the time GA4’s reports are enough. But sooner or later you hit a wall: a question the interface can’t answer, a report that’s sampled, or data that aged out of GA4’s retention window. That’s when you export to BigQuery.
BigQuery is Google’s data warehouse. Connecting GA4 to it gives you the raw event data behind every report, with no sampling and no expiry, ready to query with SQL. And the daily export is free for most sites.
Before you start: You need a Google Cloud project (the daily export runs in the free BigQuery sandbox — no billing account required; you only add billing if you want streaming export or need to keep data past the sandbox’s 60-day expiration), and you need the Editor role on the GA4 property plus owner access on the Cloud project.
Why export GA4 to BigQuery
Here’s what the export gives you that the GA4 interface can’t:
- Raw, event-level data. Every event with every parameter, not a pre-built report.
- No sampling. GA4’s Explore reports can sample on big sites. BigQuery data is complete.
- Unlimited history. GA4 keeps detailed data for up to 14 months. In BigQuery it stays as long as you keep it.
- SQL access. Ask any question you can write a query for, and join GA4 with your CRM, cost, or product data.
If none of those sound like a problem you have yet, you can skip this. It’s an advanced move, not a starter step.
What it costs
This is the part people worry about, so here’s the honest version.
- The daily export is free for up to 1 million events per day on a standard property.
- BigQuery gives you a free tier for storage and queries each month, which covers small to mid-size sites comfortably.
- Streaming export (continuous, near-real-time) has no event cap, but it adds BigQuery costs of about $0.05 per gigabyte, where a gigabyte is roughly 600,000 events.
For most sites, daily export sits inside the free tiers. You add cost mainly if you turn on streaming or run heavy queries.
How to set up the BigQuery export
Step 1: Open BigQuery links
In GA4, go to Admin > Product links > BigQuery links.
You should see: A page with a Link button in the top right.
Step 2: Choose your Cloud project
Click Link, then Choose a BigQuery project. Pick the Google Cloud project you want the data to land in, then click Confirm.
If you don’t have a project yet, create one in the Google Cloud console first, with billing enabled.
Step 3: Pick a data location
Choose the region where your data should be stored, then click Next.
Step 4: Choose your export settings
Select your options:
- Pick the data streams to export (usually your web stream).
- Choose Daily export, Streaming export, or both. Start with Daily unless you truly need near-real-time data.
Step 5: Submit
Click Next, then Submit.
You should see: Your project listed on the BigQuery links page. The first daily export table shows up in BigQuery within about 24 hours. Google’s setup guide is Set up BigQuery Export.
Daily vs streaming export
| Daily export | Streaming export | |
|---|---|---|
| Timing | Once a day, previous day’s data | Continuous, within minutes |
| Event limit | 1 million/day (standard) | No limit |
| Cost | Free within limits | About $0.05 per GB |
| Best for | Most sites | Real-time needs, high-traffic sites |
The 1 million events per day limit
Worth repeating, because it surprises people: if a standard property consistently exports more than 1 million events per day, Google pauses the daily export, and it does not go back and reprocess the days it missed.
If you’re near that ceiling, either move to streaming export (no cap, but it costs) or upgrade to Analytics 360. Google covers the limits in BigQuery Export.
Common problems
“The export won’t set up.” Usually a permissions issue — you need the Editor role on the GA4 property and owner access on the Cloud project. The daily export itself runs in the free BigQuery sandbox with no billing account; you only need billing for streaming export or to retain data beyond the sandbox’s 60-day limit.
“No table showed up.” The first daily table takes up to 24 hours. Check again the next day.
“My daily export stopped.” You likely crossed the 1 million events per day limit. Check your event volume and consider streaming or 360.
What to do next
You’ve got raw GA4 data flowing into BigQuery. Here’s where to go from here:
- Connect BigQuery to Looker Studio to build reports on the raw data without writing SQL.
- Keep your GA4 reporting sharp in the meantime with the standard reports.
- Link Google Ads and Search Console so more of your data lives together. See Google Ads and Search Console.
For the full picture of how GA4 works, start with our GA4 beginner’s guide.