How to set up BigQuery integration on Google Analytics

intermediate 12 min read Updated 2026-03-18

Quick Answer

To set up BigQuery integration with Google Analytics, navigate to your GA4 property's Admin settings, select BigQuery Linking, and connect your Google Cloud project. This enables automatic export of your analytics data to BigQuery for advanced analysis and reporting.

Try Google Analytics Full Google Analytics Review

Prerequisites

Google Analytics 4 property
Google Cloud Platform account with billing enabled
Editor or Administrator access to GA4 property
BigQuery API enabled in Google Cloud Console

Step-by-Step Instructions

Access BigQuery Linking Settings

In your Google Analytics 4 property, click Admin in the bottom left corner. Under the Property column, select BigQuery Linking. If you don't see this option, ensure you have the necessary permissions and that you're using a GA4 property (not Universal Analytics).

BigQuery linking is only available for GA4 properties, not Universal Analytics properties.

Start the Linking Process

Click the Link button to begin the setup process. You'll be prompted to sign in to your Google Cloud Platform account if you're not already authenticated. Make sure you're using an account that has access to your desired GCP project.

Select Your Google Cloud Project

Choose the Google Cloud Project where you want to export your Analytics data. If you don't see your project listed, ensure that:

The BigQuery API is enabled for your project
You have the necessary permissions (BigQuery Admin or Editor role)
Billing is enabled for the project

Create a dedicated GCP project for analytics data to better organize your BigQuery datasets and control costs.

Configure Data Location and Dataset

Select your preferred Data Location (e.g., US, EU, Asia) for storing your BigQuery data. This cannot be changed later, so choose based on your compliance requirements and query performance needs. The system will automatically create a dataset named analytics_[PROPERTY_ID] in your selected project.

Choose a data location close to where you'll primarily access the data to minimize latency and costs.

Choose Export Settings

Configure your export preferences:

Daily export: Exports data once per day (free)
Streaming export: Exports data in near real-time (paid feature)
Include advertising identifiers: Enable if you need advertising IDs in your exports

Start with daily export if you're unsure about your needs.

Streaming export incurs additional BigQuery costs but provides near real-time data access for time-sensitive analysis.

Review and Confirm Settings

Review your configuration settings including the selected GCP project, data location, and export options. Click Next to proceed. Google Analytics will show you a summary of what data will be exported and any associated costs.

Complete the Link Setup

Click Submit to finalize the BigQuery integration. The setup process may take a few minutes to complete. Once finished, you'll see the link status as Active in your BigQuery Linking settings. Data exports will begin within 24 hours for daily exports.

It can take up to 24 hours for your first data export to appear in BigQuery, so don't worry if you don't see data immediately.

Verify the Integration

Go to the BigQuery Console in your Google Cloud Platform and navigate to your project. You should see a new dataset named analytics_[PROPERTY_ID]. Once data begins flowing, you'll see daily tables with names like events_YYYYMMDD containing your GA4 event data.

Use the BigQuery SQL workspace to run test queries on your data once the first export completes.

Common Issues & Troubleshooting

BigQuery Linking option not visible in Admin settings

Ensure you're using a Google Analytics 4 property (not Universal Analytics) and have Editor or Administrator permissions. BigQuery linking is not available for Universal Analytics properties.

Google Cloud Project not appearing in the selection list

Verify that the BigQuery API is enabled in your GCP project, billing is activated, and you have BigQuery Admin or Editor role permissions for the project.

Data not appearing in BigQuery after 24 hours

Check your GA4 property data retention settings, ensure you have recent traffic in your GA4 property, and verify the link status is Active in BigQuery Linking settings. Sometimes initial exports can take up to 48 hours.

Streaming export not working despite being enabled

Confirm that streaming export is enabled in your linking configuration and that your GCP project has sufficient BigQuery quotas. Check the BigQuery logs in Google Cloud Console for any error messages.

Prices mentioned in this guide are pulled from current plan data and may change. Always verify on the official Google Analytics website before purchasing.

Visit Google Analytics View Google Analytics Pricing