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.
IMPORTANT: 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.
NOTE: 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.
(optional) Select a time aggregation for the report.
NOTE: 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) Set the Show Advanced Options toggle to ON if you want to customize reports by the selected parameters.
To filter the Custom report by dimension, do the following:
- Click + Add filter.
- In the Dimension field, select the dimension to filter on.
- In the Filter expression field, enter the desired value or pattern for the dimension.
- Use the Negative filter toggle if you want to exclude records matching the filter expression.
- From the Filter type drop-down menu, choose the matching condition, such as Value exactly matches expression or Value starts with expression, etc.
- (Optional) To add additional filters, repeat steps 1 - 5 for each added filter.
IMPORTANT: Filtering is only enabled when all filter parameters are specified.
(Optional) In the Rollback window field, enter a value between 2 and 90 (default value is 30) days.
NOTE: To learn more, read our Google Analytics 4 Rollback Sync documentation.
Click Next.
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.
- Select the category name on the left panel to see the relevant dimensions and metrics for that category displayed on the right, and select them by checking the box.
IMPORTANT: See the Google Analytics 4 API documentation to learn about the specific dimensions and metrics that are supported.
Click Save.
TIP: 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