Google Analytics 4 lets you analyze data about customer engagement with your website or application.
Google Analytics 4 only allows us to connect to the reporting layer of their API, so we can’t access all the raw data like we can for many of our other connectors. Instead, Google requires that it must be queried via a pre-defined report. Each time you go through the setup form, you’ll be creating at least one new report.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| Custom data | ||
| Data blocking | check | Column level and table level |
| Column hashing | check | |
| Re-sync | check | Connector and table level |
| History | ||
| API configurable | check | |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step Google Analytics 4 setup guide to connect Google Analytics 4 with your destination using Fivetran connectors.
Sync overviewlink
API versionlink
The connector uses the Google Analytics Data API to access the source.
Schema informationlink
We provide the following types of reports:
- Prebuilt Report
- Custom Report
Fivetran will deliver tables with the date, property, and _fivetran_id fields for either kind of report.
A Prebuilt Report syncs a pre-defined set of fields.
For a Custom Report, date dimension is always required. You can add up to eight additional dimension fields and ten additional metric fields.
| column | type | notes |
|---|---|---|
| date | DATE | standard field |
| property | STRING | standard field |
| _fivetran_id | STRING | standard field |
| dimension* | custom field | |
| metric* | custom field |
Updating datalink
Because the Google Analytics 4 data is delivered in a cube, changing the way that the cube is formatted is difficult; adding in (or removing) fields changes the way the data is aggregated and synced. This would require that we alter the data in your existing warehouse to ensure consistency.
To ensure that the data you’re receiving is reliable, we require that you create an entirely new connector for the updated version of your Google Analytics 4 report. You must either:
- Name this new/modified report something different than the previous version. Or
- Keep the name of the new/modified report and sync it into a different schema.