Fivetran Sync Strategy for the Google Analytics 360 Connector

Question

What is the sync strategy of the Google Analytics 360 connector?

Answer

Fivetran doesn't directly download the report and data from Google Analytics 360. Instead, it picks data from your GCP bucket.

Sync data from the Google Analytics 360 UI to your destination. Follow the Google's suggested workflow to:

1. Create a Google API Console project and enable BigQuery.
2. Prepare your project for BigQuery Export. Every day, the data from Google Analytics 360 is pushed to your GCP bucket.
3. Configure Google Analytics 360 export.

From now on, Fivetran will pull data from the GCP bucket and load it to the destination.

Since Fivetran doesn't download the report directly, it depends entirely on how Google Analytics 360 sends data to the GCP bucket. If the report data in the bucket has all the dimensions and metrics, then Fivetran will sync that data to the destination.