GA4 BigQuery – Connect Google Analytics 4 with BigQuery

Last Updated: June 29, 2022

What is GA4 Bigquery?

Google BigQuery is a cloud data warehouse that allows you to run high-volume data in just a few seconds. The GA4 BigQuery connection provides the opportunity to conduct an in-depth analysis of business performance and user interactions. 

Why use BigQuery for your Google Analytics 4 property?

Connecting Google Analytics 4 with BigQuery is completely free of charge. Yes, you heard it right; there are no charges on exporting data from a Google Analytics 4 property to BigQuery. You can also export to a free instance of BigQuery called BigQuery Sandbox.

Now, you can take this opportunity to the next level and go beyond the reporting interface of GA4, with unlimited advanced analytics options.

Here are a few of the advantages below:

How to connect Google Analytics 4 with BigQuery?

Now let’s dive into this step-by-step guide to connecting your Google Analytics 4 property to BigQuery.

Follow the steps below to connect Google Analytics 4 with BigQuery and then send the GA data to it:

Step-1: Navigate to your BigQuery account: https://console.cloud.google.com/bigquery

Step-2: At the top of your screen, click on the drop-down menu:

connect google analytics 4 with bigquery click on the drop down menu

Step-3: Click on the ‘New Project’ button:

connect google analytics 4 with bigquery New Project

We will use this new project to collect and query Google Analytics 4 data into BigQuery.

Step-4: Name your new project and then click on the ‘Create’ button:

connect google analytics 4 with bigquery Name your new project 1

Step-5: At the top of your screen, click on the drop-down menu:

connect google analytics 4 with bigquery click on the drop down menu 1

Step-6: Click on the name of the project you want to switch to (in our case, ‘DBRT GA4’):

connect google analytics 4 with bigquery Click on the name of the project you want to switch to 1

Congratulations! You are now in the ‘DBRT GA4’ project.

You will know that you are on the right project because the project name will appear at the top of your screen:

connect google analytics 4 with bigquery Navigate back to your BigQuery account

Step-7: Log in to your Google Analytics 4 property and click on ‘Admin’ under the left-hand side reporting menu.

Admin 11

Step-8: Click on ‘BigQuery Linking’ under ‘Product Linking’:

GA4 BigQuery - Connect Google Analytics 4 with BigQuery

Step-9: Click on the ‘Link’ button:

connect google analytics 4 with bigquery Link button ga4

Step-10: Click on ‘Choose a BigQuery project’:

connect google analytics 4 with bigquery Choose a BigQuery project ga4

Step-11: Select the BigQuery project where you want to send your GA4 data and click on the ‘Confirm’ button. In our case, that project is ‘DBRT GA4’:

connect google analytics 4 with bigquery Confirm 1

Step-12: Select your data location and click on the ‘Next’ button.

Data location is the cloud region where your data is stored.

connect google analytics 4 with bigquery Select your data location ga4 1

Step-13: ‘Edit’ your data stream(s) if required. Otherwise, move on to the next step. By default, all of the data streams are selected.

You have the option to select a specific data stream for which you will be exporting the data to BigQuery. Just click on ‘Edit’ if you want to edit your data streams:

connect google analytics 4 with bigquery Edit your data stream ga4

Step-14: Click on the checkbox “Include advertising identifiers for mobile app streams” if you have a mobile app and you want to export mobile advertiser identifiers. Otherwise, move on to the next step.

connect google analytics 4 with bigquery Include advertising identifiers for mobile app streams ga4

Step-15: Select the frequency of your data import to BigQuery by selecting both ‘Daily’ and ‘Streaming’ settings and then click on the ‘Next’ button:

connect google analytics 4 with bigquery frequency of your data import to BigQuery

You should now see a screen like the one below:

connect google analytics 4 with bigquery submit button

Step-16: Click on the ‘Submit’ button. You should now see a screen like the one below:

connect google analytics 4 with bigquery link created ga4

Congratulations! 

Your GA4 account is now successfully linked to your Big Query project.

Step-17: Navigate to https://console.cloud.google.com/apis/dashboard

Step-18: Make sure your BigQuery project for GA4 is selected:

connect google analytics 4 with bigquery Make sure your BigQuery project for GA4 is selected 1

Step-19: Click on the ‘+ENABLE APIS AND SERVICES’ button:

connect google analytics 4 with bigquery ENABLE APIS AND SERVICES bigquery

You should now see a screen like the one below:

connect google analytics 4 with bigquery welcome to the api library 1

Step-20: Search for “Big Query” and then click on the ‘Big Query API’ button:

connect google analytics 4 with bigquery bigquery api 1

Step-21: Click on the ‘Manage’ button:

connect google analytics 4 with bigquery bigquery api manage 1

Step-22: Click on the ‘Credentials’ link from the left-hand side navigation menu:

connect google analytics 4 with bigquery Credentials

Step-23: You would now need to add a firebase service account.

This account would be used to export Google Analytics 4 data to BigQuery. To do that, click on the ‘+create credentials’ button:

connect google analytics 4 with bigquery add a firebase service account

Step-24: Click on the ‘Service account’ link to create a new service account:

connect google analytics 4 with bigquery Service account 1

You should now see a screen like the one below:

connect google analytics 4 with bigquery create service account 1

Step-25: Enter [email protected] as the service account name:

connect google analytics 4 with bigquery service account name 1

Step-26: Click on the ‘Create’ button:

connect google analytics 4 with bigquery create 1

You should now see a screen like the one below:

connect google analytics 4 with bigquery done service account

Step-27: Click on the ‘DONE’ button.

You should now see your new service account listed like the one below:

connect google analytics 4 with bigquery new service account listed

Step-28: Wait for a full 24 hours.

It usually takes around 24 hrs for your GA4 data to be available in your BigQuery project.

Step-29: Navigate back to your BigQuery account and make sure that your project used for collecting GA4 data is selected:

connect google analytics 4 with bigquery Navigate back to your BigQuery account 1

Step-30: Scroll down and then click on the project ID of the project which collects GA4 data:

connect google analytics 4 with bigquery click on the project ID of the project which collects GA4 data

You should now be able to see a data set named “analytics_<property_id>“:

connect google analytics 4 with bigquery analytics property id

For each Google Analytics 4 property linked to BigQuery, a single dataset named “analytics_<property_id>” is added to your BigQuery project.

Property ID refers to your Analytics Property ID, which you can find in the property settings for your GA4 property.

In my case, the property ID is 207472454

That’s why the name of my data set is ‘analytics_207472454

This data set contains the following two data tables which contain your GA4 data:

  1. events_(<number of days>)
  2. events_intraday_<current date>
connect google analytics 4 with bigquery data set contains the following two data tables 1

If you want to learn more about these two data tables, then check out this article: events_ & events_intraday_ tables in BigQuery for GA4 (Google Analytics 4)

Conclusion

You can use a Google Analytics 4 property and BigQuery to evaluate the limitless possibility of new insights and define your own advanced analytics capabilities.

Furthermore, you can also connect BigQuery with third-party tools using native connectors to integrate more data.

BigQuery also supports most visualization tools, and you can use them to build dashboards and insights to enhance your business growth.

If you want to send GA3 data to Google Big Query and that too without using GA 360 then check out this article: Sending Google Analytics data to BigQuery without 360

#1 Google Analytics 4 Intro

  1. What is GA4 (Google Analytics 4) – The Apps + Web Property?
  2. Key Benefits of Using Google Analytics 4 (GA4)
  3. Setup GA4 – Upgrade to GA4 – Implementation Tutorial
  4. Google Analytics 4 (GA4) vs Universal Analytics – What is the difference?
  5. Google Signals GA4 – See demographics (gender, age) in Google Analytics 4
  6. Understanding Google Analytics Measurement ID (GA4)
  7. Google Analytics 4 training & tutorial with FREE GA4 ebook
  8. Using the GA4 (Google Analytics 4) Test Property
  9. Google Analytics 4 Sub Properties Tutorial
  10. Google Analytics Account Hierarchy (Structure Explained)
  11. Roll up Property in Google Analytics 4 (GA4) – Tutorial
  12. GA4 vs GA4 360 – Pricing, Limits, Billing and More

#2 Google Analytics 4 Integrations

  1. How to connect GA4 (Google Analytics 4) with Google Data Studio
  2. How to link GA4 (Google Analytics 4) with Google Ads
  3. How to link Google Search Console to Google Analytics 4 (GA4)
  4. How to Install Google Analytics 4 on Shopify
  5. GA4 Firebase Integration – Correctly Add App Data Streams to GA4 Property

#3 Google Analytics 4 Events

  1. GA4 (Google Analytics 4) Event Tracking Setup Tutorial
  2. Understanding Event Parameters in Google Analytics 4 (GA4)
  3. Recommended events in Google Analytics 4 (GA4)
  4. Enhanced measurement events in Google Analytics 4 (GA4)
  5. Automatically collected events in Google Analytics 4 (GA4)
  6. How to set up GA4 Custom Events via Google Tag Manager
  7. Events Report in Google Analytics 4 (GA4)
  8. How to rename events in Google Analytics 4 (GA4)
  9. How to use Google Analytics 4 Event Builder

#4 Google Analytics 4 Conversions

  1. Google Analytics 4 Conversion Tracking Guide – GA4 Goals
  2. How to import conversions from GA4 property to your Google Ads account

#5 Google Analytics 4 Dimensions

  1. GA4 (Google Analytics 4) Dimensions Tutorial
  2. GA4 (Google Analytics 4) Custom Dimensions Tutorial
  3. GA4 User Properties (User Scoped Custom Dimensions) – Tutorial
  4. Event Scoped Custom Dimensions in GA4 – Tutorial

#6 Google Analytics 4 Metrics

  1. GA4 (Google Analytics 4) Metrics Tutorial with Free Google Analytics 4 Ebook
  2. GA4 (Google Analytics 4) Custom Metrics Tutorial
  3. What are predictive metrics in Google Analytics 4 (GA4)

#7 Google Analytics 4 Ecommerce

  1. GA4 (Google Analytics 4) Ecommerce Tracking via GTM – Tutorial

#8 Google Analytics 4 Specialized Tracking

  1. GA4 (Google Analytics 4) Enhanced Measurement Tracking Tutorial
  2. Cross Domain Tracking in GA4 (Google Analytics 4) Setup Guide
  3. GA4 Site Search – Tracking Site Search in Google Analytics 4
  4. GA4 (Google Analytics 4) Scroll Tracking Tutorial
  5. Self-referral Google Analytics 4 – Referral exclusion GA4
  6. GA4 (Google Analytics 4) Data Import Tutorial
  7. Google Analytics 4 Content Grouping – Create Content Groups in GA4
  8. How to track single page apps in Google Analytics 4 (GA4)

#9 Google Analytics 4 filters

  1. GA4 filters – Understanding data filters in Google Analytics 4
  2. How to create and test filters in Google Analytics 4 (GA4)?
  3. Exclude internal traffic in GA4 (Google Analytics 4) via IP filter

#10 Google Analytics 4 Explorations

  1. Free Form Report in GA4 (Google Analytics 4) – Exploration Report
  2. How to use the user lifetime report in Google Analytics 4 (GA4)
  3. How to use Path exploration report in GA4 (Google Analytics 4) – Path analysis
  4. How to use Segment Overlap Report in Google Analytics 4 (GA4)
  5. How to use the Funnel Exploration Report in GA4 (Google Analytics 4) – Funnel Analysis
  6. Cohort Exploration Report in Google Analytics 4 (GA4)
  7. How to Create Landing Pages Report in Google Analytics 4 (GA4)

#11 Google Analytics 4 Advanced

  1. Understanding Google Analytics 4 Sessions
  2. GA4 (Google Analytics 4) Measurement Protocol Tutorial
  3. How to build comparisons (advanced segments) in Google Analytics 4 (GA4)
  4. Understanding Automated Insights in Google Analytics 4 (GA4)
  5. Understanding Channel Groupings in Google Analytics 4 (GA4)
  6. Understanding Data Sampling in Google Analytics 4 (GA4)

#12 Google Analytics 4 Reporting

  1. How to create custom insights in Google Analytics 4 (GA4)
  2. How to use Debug View report in Google Analytics 4 (GA4)

#13 Google Analytics 4 Attribution

  1. Guide to Attribution Models in GA4 (Google Analytics 4)
  2. How to Change Attribution Models in GA4 (Google Analytics 4)?
  3. GA4 (Google Analytics 4) Conversion Paths Report in Attribution
  4. GA4 (Google Analytics 4) Model comparison report in Attribution
  5. Advertising Snapshot in GA4 (Google Analytics 4) Attribution

#14 Google Analytics 4 Audiences

  1. GA4 Audiences – Creating custom audience in Google Analytics 4
  2. How to create a remarketing audience in Google Analytics 4 (GA4)
  3. Understanding Audience Triggers in Google Analytics 4 (GA4)
  4. Google Analytics 4 (GA4) Predictive Audiences – Tutorial

#15 Google Analytics 4 BigQuery

  1. GA4 BigQuery – Connect Google Analytics 4 with BigQuery
  2. How to connect and export data from GA4 to BigQuery
  3. events_ & events_intraday_ tables in BigQuery for GA4 (Google Analytics 4)

Frequently asked questions about Connecting Google Analytics 4 with BigQuery

How do I link Google Analytics 4 to BigQuery?

Follow the below steps to link Google Analytics 4 to BigQuery
1. Click on ‘Admin’ in the GA4 account, and under the ‘Property’ column, click on ‘BigQuery Linking’.
2. Now click on ‘Link’ to create a new connection.
3. Click on ‘Choose a BigQuery Project’.
4. Select your BigQuery Project (You can create a new project if needed).
5. Select your data location.
6. Select the data streams for which you want to export the data.
7. Select the frequency.
8. Review your configuration and click on ‘Submit.

What are the cost involved in GA4 and BigQuery export?

GA4 and BigQuery exports are completely free of cost. You can export your GA4 data to a free instance of BigQuery (BigQuery Sandbox). However, if your export exceeds the limit of BigQuery Sandbox, it will incur charges.

What are the advantages of GA4 and BigQuery export?

Following are the advantages of GA4 and BigQuery export.
1. Store data in BigQuery, and then after processing, you can send it to other data warehouses like AWS or Azure.
2. Perform advanced analysis on the raw data from the GA4 property.
3. Connect multiple data streams from GA4. For example, you can pull data into BigQuery from Android apps, IOS apps, and websites, all from one central point.
4. Join your data with other marketing or CRM tools.
5. Export to BigQuery is completely free for GA4 properties. Earlier, this was only available in GA360 (Premium Universal Analytics) accounts with a paid subscription.
6. Visualize your data in tools such as Tableau, Qlik Sense, PowerBI, and Data Studio.

Register for the FREE TRAINING...

"How to use Digital Analytics to generate floods of new Sales and Customers without spending years figuring everything out on your own."



Here’s what we’re going to cover in this training…

#1 Why digital analytics is the key to online business success.

​#2 The number 1 reason why most marketers are not able to scale their advertising and maximize sales.

#3 Why Google and Facebook ads don’t work for most businesses & how to make them work.

#4 ​Why you won’t get any competitive advantage in the marketplace just by knowing Google Analytics.

#5 The number 1 reason why conversion optimization is not working for your business.

#6 How to advertise on any marketing platform for FREE with an unlimited budget.

​#7 How to learn and master digital analytics and conversion optimization in record time.



   

My best selling books on Digital Analytics and Conversion Optimization

Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.

Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.

Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.

Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.

About the Author

Himanshu Sharma

  • Founder, OptimizeSmart.com
  • Over 15 years of experience in digital analytics and marketing
  • Author of four best-selling books on digital analytics and conversion optimization
  • Nominated for Digital Analytics Association Awards for Excellence
  • Runs one of the most popular blogs in the world on digital analytics
  • Consultant to countless small and big businesses over the decade
error: Alert: Content is protected !!