Google Analytics 4 Setup Guide
Follow our setup guide to connect Google Analytics 4 to Fivetran.
Prerequisites
To connect Google Analytics 4 to Fivetran, you need a Google user account with permissions to access Google Analytics accounts with Google Analytics 4 properties you'd like to sync.
You must use a Google Analytics 4 property.
Setup instructions
Begin Fivetran configuration
- In the connection setup form, enter your chosen Destination schema name.
- (Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice, and then select the same agent for your destination.
- Click Authorize with Google and log in to your Google Analytics account. Click Continue and then Allow to enable Fivetran access to your Google account.
- In the Historical Sync Time Frame drop-down menu, select how many months' worth of reporting data you'd like to include in your initial sync.
- Choose your Accounts sync mode:
- Select Sync All Accounts to automatically sync all accounts you have access to.
- Select Sync Specific Accounts to sync specific accounts only. Use the + Accounts link to add accounts and properties you'd like to sync.
(Optional) Add Custom report
- Click + Custom report.
- Enter a Report name. It must be unique within this connection and must comply with Fivetran's naming conventions.
Give the table a name you will find easy to identify with the report in the future. When you want to enable or disable the sync for a particular report once it is set up, you will do so by selecting its table in the connection's Schema tab.
- Select the Report template name to automatically populate dimensions and metrics with pre-defined values.
- To customize the set of fields populated from the selected template, do either of the following:
- Start typing the dimension's or metric's name in the search field to find it by name, and select it by checking the box.
- Click a category name on the left side of the panel to view its corresponding dimensions and metrics on the right. Then, select the desired items by checking their boxes.
See the Google Analytics 4 API documentation to learn about the specific dimensions and metrics that are supported.
- Click Next.
- (optional) Select a time aggregation for the report.
Each aggregation option requires the corresponding date dimension to be selected in the report dimensions:
- date for Daily
- yearWeek or isoYearIsoWeek for Weekly
- yearMonth for Monthly
- year or isoYear for Yearly
- (Optional): In the Rollback window field, enter a number between 2 and 90 to specify the number of days available for rollback. The default is 30 days if no value is provided.
To learn more, read our Google Analytics 4 Rollback Sync documentation.
- To filter the Custom report by dimension, do the following:
- Click + Add filter.
- From the Filter type drop-down menu, choose whether to include records by selecting Include records where or exclude records by selecting Exclude records where.
- In the Dimension field, select the dimension to filter on.
- In the Operator field, choose the matching condition, Equals or Contains.
- In the Value field, enter the desired value for the dimension.
- If you selected Equals as a matching condition, you can specify multiple values by clicking + Add.
- (Optional) To add additional filters, repeat substeps 1 - 5 for each added filter.
Filtering is only enabled when all filter parameters are specified.
- Click Save.
Repeat the steps above if you want to add another Custom report.
- (Optional) Once you have finished adding custom reports, click Validate custom reports. The test verifies the reports' settings.
Finish Fivetran configuration
Click Save & Test. Fivetran will take it from here and sync your data from your Google Analytics account.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connection Configuration