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

Data Schema

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 performs two types of operations:

1. New data — Sync all data added since the last run.
2. Lookbacks — Re-fetch and overwrite selected historical days. Google Analytics can update past days as data is processed, so lookbacks help keep your warehouse aligned with the latest values.

Default lookbacks

Unless you configure custom lookbacks (see below), each sync also overwrites:

1. All data from the past 24 hours.
2. The full day exactly 7 days ago.
3. The full day exactly 30 days ago.

Custom lookbacks

You can define your own lookback days in the connector settings. When configured, your selection replaces the default lookbacks above. The new-data sync still runs on every incremental sync.

Choose one or more day offsets between 1 and 30. For each day you select, Weld overwrites data for that single calendar day — exactly that many days ago from the sync date.

For example, if you select 1 and 5, Weld overwrites the full days exactly 1 day ago and exactly 5 days ago.

Setup Guide

Step 1 - Add Data Source

1. 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.

2. Click Authorize to allow Weld to access your Google account using OAuth. You will be redirected to your Google account.

3. 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

1. Select the specific account and related GA4 property you wish you sync.

2. 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.

3. 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

1. 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

1. Select how often you would like the data to sync.
2. 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

View all →

Account Report

User Activity Overview

Campaign Report

Channel Traffic Overview

Event Performance

Page Path Analysis