GA4 To BigQuery in 3 Simple Steps

In partnership with

If you have already connected GA4 to BigQuery then you can skip this email. If you haven’t yet started then continue reading.

Recently a lot of Universal Analytics clients were scrambling to backup there old data. Some of them learned that they can't back up the entire historical data because of the data retention settings they had in place.

If you have migrated to GA4, it is time to make sure that you don't run into the same issues in the future.

In my recent live session, I covered three simple steps to get your GA4 data backed up in BigQuery every day, and that's what I am going to show you in this post. If you would rather watch the video then go to https://www.youtube.com/watch?v=n3vrKaMdtkw.

GA4 to BigQuery in 3 Simple Steps

1. Create a BigQuery Account and Project in Google Cloud

2. Enable GA4 to BigQuery Setting in GA4

3. Enable BigQuery API in Google Clouds

Step 1: Create a BigQuery and Project In Google Cloud

Go to https://cloud.google.com/bigquery

Click on "Get Started for Free" or a big button on the page that let's your create your account.

Go through the steps and make sure to enter your credit card and signup for paid version. Don't worry you won't be charged right away and you might never be charged as BigQuery give you a lot of free data storage and query processing every month. If you are worried then reach out to us and we can help you setup some alters which will alter you if you are about to go over your free threshold.

When you create an account, your project will be automatically created. Project is where your GA4 dataset will be created.

Step 2: Enable GA4 + BigQuery integration

Go to Admin panel in GA4.

Go to "Product links" section and click on "BigQuery links".

Follow the prompts and pick the project that you just created in the previous step.

Check all the boxes that you see. If you want to know what those boxes are for then watch the video.

Go ahead and save.

Now you are ready to send the GA4 data to BigQuery.

Step 3: Enable BigQuery APIs.

In BigQuery click on the hamburger menu in the top left corner, scroll down to API & Services and then select Library.

You can also go directly to https://console.cloud.google.com/apis/library

Search for BigQuery APIs and then click on enable button.

That's it, now your GA4 data will start to flow to BigQuery. You will have to wait for 24 hours or so for the first day of the data.

We can get you and your team trained on BigQuery. If interested then email me at [email protected]. We can also help you setup everything and get it working for you.

Watch The GA4 to BigQuery in 3 Steps Video

Upgrade to Premium Level

I cover a lot of advanced level concepts and SQL in the advanced section of my newsletter. Currently, you have an opportunity to lock in a low discount prices and get access to all of my premium content.

Upgrade by visiting https://bigquery.beehiiv.com/upgrade

Learn AI in 5 Minutes a Day

AI Tool Report is one of the fastest-growing and most respected newsletters in the world, with over 550,000 readers from companies like OpenAI, Nvidia, Meta, Microsoft, and more.

Our research team spends hundreds of hours a week summarizing the latest news, and finding you the best opportunities to save time and earn more using AI.

Sign up with 1-Click