How to Set Up a Google Analytics 4 Data Pipeline to BigQuery

Sending your Google Analytics 4 data to BigQuery unlocks a level of analysis you just can't get inside the standard GA4 interface. By housing raw, event-level data in a powerful data warehouse, you can perform sophisticated analyses, join your analytics data with other business data, and bypass sampling limitations entirely. This article guides you through the process, from understanding the benefits to setting up the connection and running your first query.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Connect GA4 to BigQuery?

While the native reporting in GA4 is improving, serious analysts and data-driven teams eventually hit a wall. Connecting GA4 to BigQuery tears that wall down, giving you direct access to the raw data your website or app generates. Here’s why that’s a game-changer:

• Escape Data Sampling: For high-traffic sites, GA4 reports often rely on sampled data, which is an estimation rather than an exact count. In BigQuery, every single event is recorded, giving you access to 100% unsampled data for unparalleled accuracy in your reporting.
• Own Your Data for Good: GA4's data retention for granular, event-level information is limited to a maximum of 14 months. Any analysis looking back further than that is impossible. When you export your data to BigQuery, you own it permanently. This allows for true year-over-year analysis and the preservation of historical trends.
• Create a Single Source of Truth: Your user journey doesn't start and end on your website. BigQuery allows you to join your GA4 data with other essential datasets. You can blend your website behavior data with advertising costs from Facebook Ads, customer transaction history from Shopify, or lead status from a CRM like Salesforce to create a comprehensive, 360-degree view of your business performance.
• Perform Sophisticated Analysis: With the full power of SQL at your fingertips, you are no longer limited by the reports available in the GA4 UI. You can build advanced user segments, create custom attribution models, conduct deep funnel analysis, and calculate complex metrics like lifetime value with complete flexibility.

Prerequisites for Connecting GA4 to BigQuery

Before you jump into the setup, there are a few essential things you need to have in place. Getting these sorted out first will make the process smooth and prevent common errors.

1. A Google Cloud Platform (GCP) Project

BigQuery is a component of Google Cloud Platform. To use it, you need a GCP account and an active project. If you don't have one, you can sign up quickly. New accounts are often eligible for free credits, which is more than enough to get started without any costs.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Billing Enabled on Your GCP Project

This is the most common reason the setup process fails. Even though BigQuery has a very generous free tier (including 10 GB of storage and 1 TB of queries processed per month), you must have a billing account linked to your GCP project. Google requires this to handle any potential charges if you exceed the free limits. For most websites, staying within the free tier is very manageable, but this step is non-negotiable for the integration to work.

3. The Correct Account Permissions

To create the link, you'll need the right level of access in two places:

• In Google Analytics 4, you need Administrator access to the property you want to link.
• In your Google Cloud Platform project, your account needs to have the Editor role.

Trying to set up the connection without these permissions will result in a frustrating dead end.

The Step-by-Step Guide to Linking GA4 and BigQuery

Once your prerequisites are handled, the actual linking process is surprisingly straightforward. You can have it done in just a couple of minutes.

Step 1: Navigate to the Admin Section in GA4

Log in to your Google Analytics account and navigate to the property you want to connect. Click on the Admin gear icon in the bottom-left corner of your screen.

Step 2: Find the BigQuery Links Option

In the 'Property' column (the middle column), scroll down until you see the 'Product Links' section. Click on BigQuery Links.

Step 3: Create a New Link

On the next screen, you’ll see any existing links. To create a new one, click the blue Link button in the top-right corner.

Step 4: Choose Your BigQuery Project

Click on Choose a BigQuery project. A sidebar will appear listing all the GCP projects your account has access to. Select the GCP project you’ve already prepared (the one with billing enabled) and click Confirm. Then, click 'Next'.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 5: Configure Your Data Settings

This step tells GA4 where and how often to send your data. It's an important one.

• Location: Choose a geographic region to store your data. Pick a location that makes sense for your business, as this can’t be changed later.
• Data frequency: You have two options here:

For beginners, starting with the 'Daily' export is recommended. You can always edit the link to enable streaming later.

• Advertising identifiers: You also have the option to include mobile ad IDs, which is relevant if you have an app data stream.

Once you’ve made your selections, click 'Next'.

Step 6: Review and Submit

Finally, you’ll see a summary of all your settings. Carefully review everything to make sure it's correct – your chosen project, data streams, and export frequency. Once you’re happy with the configuration, click Submit.

That's it! Your link is now active. You'll be redirected back to the BigQuery links page where you’ll see your newly created connection.

What Happens Next? Your Data in BigQuery

Now that the connection is active, your work in GA4 is done. All the action will happen over in your Google Cloud Platform project.

Data Starts to Flow

Crucially, the BigQuery export is not retroactive. It will only send data collected from the moment the link was created. You won't find historical GA4 data in your tables.

• If you chose the Daily export, you should see your first table appear within 24-48 hours.
• If you enabled Streaming, you will see a real-time table populated almost immediately.

The Table Structure

In your BigQuery project, Google automatically creates a new dataset named analytics_YOUR-PROPERTY-ID. Inside this dataset, you will find daily tables named events_YYYYMMDD. The streaming export creates a temporary events_intraday_YYYYMMDD table that is later consolidated into the main daily table.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Writing Your First Query

Ready to see your data? In your GCP console, navigate to BigQuery and select your project. Under the analytics_... dataset, you'll see your tables. You can use the query editor to write SQL to interact with them.

Here’s a simple starter query to count the total events from a specific day. Be sure to replace the project name, dataset ID, and date with your own values.

SELECT
  event_name,
  COUNT(event_name) AS event_count
FROM
  `your-project-id.analytics_123456789.events_20240520`
GROUP BY
  event_name
ORDER BY
  event_count DESC

Final Thoughts

Creating a data pipeline between GA4 and BigQuery puts a world-class analytics suite at your fingertips. By gaining access to raw, unsampled event data, you remove the limitations of the GA4 interface and pave the way for a much deeper understanding of your users' behavior. It combines the data collection power of Google Analytics with the full analytical power of a professional data warehouse for a very small initial price.

Of course, building data pipelines and writing SQL isn’t for everyone. If you’d rather get straight to the insights, that’s where we built Graphed. We connect directly to your data sources like Google Analytics, Shopify, and Facebook Ads, so all your business data updates in real-time in one place. Instead of spending hours wrangling data or writing complex queries, you can simply ask questions in plain English to build dashboards and get immediate answers about your performance.