Import GA4 (Google Analytics 4) to Google Data Studio

“How do I import GA4 data into Google Data Studio?”
“How do I connect GA4 with Google Data Studio?”
“Is there a way to integrate Google Analytics 4 and Google Sheets?

Digital marketer

In 2020, Google introduced a new version of Google Analytics–Google Analytics 4 or GA4. It will lead the charge in web analytics and Google Analytics 3 (Universal Analytics) will be discontinued on July 1, 2023. Marketers need to adjust to new environments. Apart from setting up new web analytics installation, setting up new dashboards follows.

How to Connect GA4 with Google Data Studio

This article shows two options on how to import GA4 data to Google Data Studio. Option 1 is using a free Google connector. Option 2 is using a paid third-party connector. In either option, go to Google Data Studio to start.

Option 1: Built-In Connector (Free)

The first option to import GA4 data to Google Data Studio is to use the built-in connector. It’s free and is enough to start building dashboards.

Create Data Source

1 – Go to Google Data Studio.

data studio dashboard for seo

2 – Click on + Create in the top left. Then click on Data source.

data source google data studio

3 – Fine and choose Google Analytics.

ga4 data studio 07

4 – Once inside, click on the Authorize button if it appears. Then click on Allow. This authorizes email access.

After which, you see a list of Google Analytics accounts. These accounts are the ones the authorized email has access to. So, the email should have access first from GA to proceed.

5 – Choose the appropriate Account and appropriate GA4 property. Know the label and names of your Google accounts. Another note is that the email you’re using should have access to the GA4 property. Otherwise, ask for help from your web analysts. The example below is for the GA4 merchandize store.

ga4 data studio 08

6 – Click on Connect on the upper right.

Viola! This data source is now saved to your Google Data Studio workspace.

Create Dashboard

The next phase is to create a dashboard from the GA4 data source.

1 – Go to Google Data Studio.

data studio dashboard for seo

2 – Click on + Create in the top left. Then click on Data source.

ga4 data studio 09

3- Once inside, click on My data sources in the navigation.

ga4 data studio 10

4 – Find and click on the Data source you added earlier.

5 – Click on the Add button on the bottom right.

6 – Click on the Add to Report button if it appears.

ga4 data studio 11

7 – Name your dashboard on the upper left.

8 – Click on Add a control from the top. Click on Date range control and drag it on the canvas.

data range control google data studio

9 – Click on Add a chart from the top. Click on the first Scorecard and drag it onto the canvas.

scorecard seo dashboard

10 – Click on Add a chart from the top. Click on the first Time series and drag it onto the canvas.

line chart google data studio

You would see something like this…

data studio seo

At this point, you now have a solid foundation for adding data to the dashboard. You can add other dimensions and metrics from Google Analytics 4. Design your GA4 dashboard further by using the navigation on the right.

Option 2: Third-Party Connector (Paid)

The second option to import GA4 data to Google Data Studio is to use a paid third-party connector. It’s free and is enough to start building dashboards. You’ll use Two Minute Reports for this example. TMR imports data from the API directly to Google Data Studio in minutes. Another connector to use is Supermetrics.

tmr gds homepage

Create Data Source

1 – Go to Google Data Studio.

data studio dashboard for seo

2 – Click on + Create in the top left. Then click on Data source.

data source google data studio

3 – Search for Two Minute Reports and look for the Google Analytics connector.

ga4 data studio 12 tmr

4 – Once inside, click on the Authorize button if it appears. Then click on Allow. This authorizes email access.

5 – After which, name your GA4 data source.

6 – Click on Sign in with Google. This authorizes the tool to acquire the GA4 accounts.

ga4 data studio 13 tmr

7 – Click on Yes to create a query config for this data source? column

ga4 data studio 14 tmr

8 – Under Name, give your GA4 query a name.

9 – Under Use (Data Source), select the GA4 data source you named earlier.

10 – Under Account Views, select the GA4 property you’d like to get data from.

11 – Under Data Options, add checkmarks to Include missing time values and Replace blank metrics with zeros.

12 – Click on Save.

ga4 data studio 15 tmr

Then you’ll go back to the winder as before.

13 – Under Select Query Config, select the GA4 query configuration you created earlier.

ga4 data studio 16 tmr

14 – Click on the Add button on the lower right.

Viola! This data source is now saved to your Google Data Studio workspace.

Create Report

1 – Go to Google Data Studio.

data studio dashboard for seo

2 – Click on + Create in the top left. Then click on Data source.

ga4 data studio 09

3- Once inside, click on My data sources in the navigation.

ga4 data studio 10

4 – Find and click on the Data source you added earlier.

5 – Click on the Add button on the bottom right.

6 – Click on the Add to Report button if it appears.

ga4 data studio 11

7 – Name your dashboard on the upper left.

8 – Click on Add a control from the top. Click on Date range control and drag it on the canvas.

data range control google data studio

9 – Click on Add a chart from the top. Click on the first Scorecard and drag it onto the canvas.

scorecard seo dashboard

10 – Click on Add a chart from the top. Click on the first Time series and drag it onto the canvas.

line chart google data studio

You would see something like this…

data studio seo

At this point, you now have a solid foundation for adding data to the dashboard. You can add other dimensions and metrics from Google Analytics 4. Design your GA4 dashboard further by using the navigation on the right.

Designing a comprehensive dashboard requires dedication and time. It requires a deep understanding of Google Data Studio. You may copy dashboard templates from other websites. How do you now copy a GA4 dashboard from another source?

How to Copy a GA4 Dashboard Template

Copy a dashboard template from another source if you don’t have the time to build your own dashboard. Here’s a template that you can copy:

ga4 data studio 01

1 – Click on the three dots on the upper right. This is the More options button.

2 – Click on Make a copy.

ga4 data studio 02

3 – Under New Data Source, find the data source you created earlier.

ga4 data studio 03

4 – Click on Copy Report.

Viola! At this point, the template shows your data from your GA4 property. After which, you can update and tweak for your specific needs.

Google Analytics 3 vs. Google Analytics 4 Data

Google Analytics 3 (or Universal Analytics) is not 100% the same as GA4.

Some of the dimensions and metrics from GA3 are not yet in GA4. In Data Studio, you still need to manually create a 1:1 translation of GA3 data to GA4. The table below shows the data differences I’ve discovered so far. Since GA4 is still evolving, Google might add other data points in the future.

GA3 (Universal Analytics)GA4 (Google Analytics 4)
Average sessions durationUser engagement / Sessions
Conversion rateConversions / Sessions
Goal completions per userConversions / Total users
Pages / SessionViews / Sessions
Value per SessionEvent value / Sessions
Value per UserEvent value / Total users
*Note: I’ll update once Google adds new features to GA4.

The table above shows the appropriate formula on the GA4 side to acquire the same GA3 data. Edit the data source you imported and add a new calculated field.

How To Add a New Calculated Field

Calculated fields allow you to create new dimensions and metrics from your existing data points. It helps you extend the current information you have so that you can build more custom reports. Conversion rate is an example of a calculated metric–“Conversions divided by Sessions” (Conversions / Sessions). Add this new metric to the data source.

1 – Go to your Data Source.

ga4 data studio 04

2 – Click on Add a Field.

ga4 data studio 05

3 – Give the new Field a name on the upper left. This is important so that you can find this new Field in the future.

4 – Add the formula in the field. In this example, it’s Conversions / Sessions.

ga4 data studio 06

5 – Click on Save on the lower right.

Viola! Conversion rate is now added to the GA4 data source and you can now add this new metric to your GA4 reports. The steps above are important for automating reports. With the steps above, you avoid adding the same new calculated field for every dashboard you create. Once the steps are done, they are re-usable to every dashboard in the future.

Conclusion: Create GA4 Reports in Data Studio

These are the options to connect data from GA4 to Google Data Studio. These methods (more in the future) allow API integrations between tools. Some connectors cost money, but the benefits outweigh more.

Avoid import and export spreadsheet hell. Maintain everything step-by-step in Data Studio with tools if needed. Stop wasting time on repetitive tasks and start focusing on important things that impact the business. Hire a web analyst to help you.


About The Author