Google Analytics 4

Google Analytics 4 Reporting API offers multiple distinct API versions for generating reports with varying combination of dimensions and metrics. Visit the documentation website for a more in-depth overview.

Features

Feature name	Supported
Column Hashing	True	Field level
Blocking	True	Field level
Incremental	True
Custom data	False
History	False
ReSync	True	Table level
Templates	False

Google Analytics applies global rate limits across your account

This means that Google Analytics imposes certain restrictions on how often you can make requests or perform certain actions on their platform for a specific account. This is usually done to prevent misuse or overuse of their services.
If you're using the Google Analytics API for multiple purposes, you might encounter problems when trying to sync data with Weld as the global rate limits might have been reached.
When you reach 80% of your rate limit Weld will slow down all Google Analytics syncs to avoid maxing out rate limits.

Data Schema

- Table

- Sub table

React Flow

Details on sync behavior

Initial sync

The data is being fetched in an incremental manner, with the first sync running a FULL import, starting from the date the user specifies during connector setup.

Rate limits are calculated depending on the complexity of the requested report and due to rate limiting constraints, the initial sync can be slower than subsequent syncs.

Incremental sync

Every incremental sync will perform four distinct operations:

Sync all the new data since the last run.
[Lookback] Overwrite all the data in the past 48h.
[Lookback] Overwrite data for one day window, exactly 7 days ago.
[Lookback] Overwrite data for one day window, exactly 30 days ago.

🔧 Setup Guide

Prerequisites

To establish a connection between Google Analytics 4 and Weld, you'll need a Google User account with the necessary permissions to access Google Analytics accounts that contain the desired Google Analytics 4 properties.

Important: Please ensure that you have a Google Analytics 4 property.

Step 1 - Add Data Source

In the connector setup form, enter the destination schema name of your choice. This is the name of the connection which can be used for both incoming and outgoing syncs.
Click Authorize to allow Weld to access your Google account using OAuth. You will be redirected to your Google account.
Click Grant Access to allow Weld to connect to your Google app.
When authorization is complete, you will be redirected back to the Weld connections overview.
The configuration is complete.

Step 2 - Connection Settings

Select the specific account and related GA4 property you wish you sync.
Optional - create custom report (up to 20)
- Choose a name for the custom report
- Choose the desired dimensions (up to 8)
- Select at least one Metric (up to 10) The date dimension is mandatory as the reports are synced on a daily basis.
Limit historical data to only sync data after the selected date to only include that data in the initial sync.

Step 3 - Data To Sync

Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.

Step 4 - Configure Sync

Select how often you would like the data to sync.
Provide a unique destination table name.

Weld will take over from here and commence syncing data from your Google Analytics account.

Custom Report Query Limits:

In order to sync reports on a daily basis, the inclusion of the date dimension is essential.
Please note that not all dimensions and metrics can be queried together. Valid combinations of dimensions and metrics are limited.
It is recommended to double-check beforehand using the following Google references:
- GA4 Dimensions & Metrics Explorer
- GA4 Query Explorer

📊 SQL Templates

Get started with Google Analytics 4 SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Google Analytics 4.