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
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:
📊 SQL Templates
View all →This SQL template generates a comprehensive account report by aggregating user statistics, campaign performance, and event data from Google Analytics. It combines these metrics to provide insights on total users, new users, sessions, user engagement, campaign details, and event revenue for each day. The results are ordered by date in descending order.
This SQL template aggregates monthly user activity data from Google Analytics, including total users, new users, sessions, average sessions per user, screen page views, and user engagement duration.
This SQL template generates a monthly summary report of campaign performance metrics from Google Analytics data. It aggregates data such as total users, sessions, engaged sessions, events per session, engagement rate, event count, conversions, total revenue, and user engagement duration. The results are ordered by period and total users in descending order.
This SQL template provides a monthly overview of channel traffic from Google Analytics, summarizing metrics such as total users, sessions, engaged sessions, events per session, engagement rate, event count, conversions, total revenue, and user engagement duration, grouped by channel.
This SQL template aggregates Google Analytics event data by month, summarizing event counts, user counts, average events per user, and total revenue for each event. It groups the data by period and event name, then orders the results by event count in descending order.
This SQL template aggregates Google Analytics data to provide a monthly overview of page paths, including metrics such as screen page views, total users, new users, event count, conversions, total revenue, and user engagement duration, grouped by traffic source.