Google Analytics 4
The Google Analytics 4 connector gets your Google Analytics 4 data into Google Sheets and Google Data Studio. Use it to track your key metrics in a spreadsheet or a Google Data Studio report.
What you can report on
- Events, sessions, users, and engagement rate
- Traffic source and acquisition channel performance
- Conversion events and key event tracking
- Audience segments and user behavior flows
- Revenue, e-commerce, and purchase data
Prerequisites
- A Google Analytics 4 property
- Viewer access or higher on the property you want to report on
- To report on revenue or cost, the Google account you authorize with must not carry the No revenue metrics or No cost metrics data restriction. See Revenue or cost metrics come back as 0
How to create a connection
- In the Hub, open Connections & accounts.
- Select Create connection.
- Select Google Analytics 4 in the connector list.
- Select Next.
- In Name the connection, enter a name.
- Select Sign in with Google. Then allow Two Minute Reports access.
- Enable the accounts you want to report on.
- Select Done.
How to get Google Analytics 4 data into Google Sheets or Google Data Studio
To get Google Analytics 4 data into Google Sheets:
- In the Two Minute Reports sidebar, open Data Queries.
- Select Add.
- Select the accounts you want to report on. You can select more than one.
- Select your metrics and dimensions.
- Select the date range.
- Set sorting and filters if you need them.
- Select Run query. Two Minute Reports adds the data to your sheet.
To get Google Analytics 4 data into Google Data Studio:
- In the Hub, open Google Data Studio › Google Analytics 4.
- Select Create report.
- Select or create a query config:
- To use a query config you have: select it in Choose your query config. Then select Save.
- To create a query config: if you already have one, first select Create new query config in the list. Enter a name in Name your query config, and select the accounts in Select your accounts. Select Save.
- Select Create from scratch. If templates show under Quick start from a template, you can select one instead.
- Looker Studio (formerly Google Data Studio) opens in a new tab, with the Two Minute Reports connector. If you are in more than one team, select your team in Select your Team.
- In Select Query Config, select your query config.
- Select Connect in the top-right corner.
- In your new report, add Google Analytics 4 metrics and dimensions to the canvas.
Troubleshooting
This Google login doesn't have access to a Google Analytics 4 property
When you create a connection, the Hub can show this message:
This Google login doesn't have access to a Google Analytics 4 property. Sign in with the login you use in Google Analytics, or ask the property's admin to give you Viewer access. If someone else manages the accounts, share a setup link with them.
The Google account that you signed in with cannot see a Google Analytics 4 property. Usually, you have more than one Google account, and you selected the wrong one.
Find the correct Google account
- Open analytics.google.com.
- Select the account menu at the top right. Find the Google account that shows your property.
- To see who has access to a property, open Admin, then Property access management. To see the account level, open Account access management.
Sign in with the correct Google account
- In the Create connection dialog, select Sign in with Google again.
- In the Google account chooser, select the correct account. If it is not in the list, select Use another account and sign in.
The account chooser shows only the Google accounts that are signed in to this browser.
If you do not have access to the property
- Ask an administrator of the property to give you Viewer access or higher. Then sign in again.
- If somebody else manages the property, send them a setup link. They connect their Google account, and you get the data. See Share a setup link.
If you do not have a Google Analytics 4 property
Create a property and add the Google tag to your website first. See Google's guide: Set up Analytics for a website and/or app.
Revenue or cost metrics come back as 0
A Google Analytics role can carry a data restriction on top of the role itself: No revenue metrics or No cost metrics. When the account that authorized the connection has one of them, Google Analytics doesn't reject the query. It returns every row and puts 0 in the restricted columns, so the report looks complete and only the restricted fields are wrong.
- No revenue metrics zeroes fields such as Purchase revenue, Revenue, Gross purchase revenue, Item revenue, and Average purchase revenue.
- No cost metrics zeroes fields such as Advertiser ad cost, Advertiser ad cost per click, Advertiser ad cost per key event, and Return on ad spend.
Every other field in the query is unaffected, which is why sessions, users, and key events can match Google Analytics exactly while revenue reads 0 for the same property and date range.
Two Minute Reports flags a run where this happens with a warning that names the zeroed fields, the property, and the connected Google account. The rows are still written to your report, with 0 in the restricted columns.
How to clear the restriction
- In the Hub, open Connections & accounts. Check which Google account the connection uses.
- In Google Analytics, open Admin.
- Go to Account access management or Property access management, depending on where that account's role is assigned.
- Find the connected Google account in the list and open it.
- Clear the No revenue metrics or No cost metrics data restriction on that account's role, then save. Only an Administrator at that level can change it.
- Run the query again.
If the restricted role can't be changed, authorize a new connection with a Google account whose role carries neither restriction.