ETL: Google Analytics 4 (GA4) Source

Configure the Google Analytics 4 source component to read analytics report data from your GA4 property in Integrate.io ETL data pipelines.

Connection Setup

Step 1: Create a Service Account within your GCP project

Create a Service Account

1. Access your Google Cloud Console.

2. On the sidebar, choose IAM & Admin > Service Accounts.

3. Click + CREATE SERVICE ACCOUNT.

4. Fill up the Service account details and click “Done”.

   

Generate a private key for your service account

1. Navigate to IAM & Admin > Service Accounts.

2. Click the Service Account you created from the previous step.

3. Click the “KEYS” tab.

4. Click “ADD KEY” > “Create new key” > “JSON” and click “CREATE”.

5. A private key (JSON) file will be automatically downloaded to your machine.

   

Step 2: Enable the APIs

1. Enable Google Analytics Admin API

   
2. Enable Google Analytics Data API

   

Step 3: Grant Google Analytics 4 Property Access to Service Account

1. Navigate to Google Analytics and click the “Admin” cog in the left sidebar.

2. Ensure that you are in the correct Account and Property, and then click “Property Access Management”.

3. Click the blue + button to add access permissions to new users, and select “Add users”.

4. Paste the Service Account email address you created earlier. Deselect “Notify new users by email” and select “Viewer” and click “Create”.

Step 4: Create GA4 Connection on Integrate.io ETL

1. Navigate to the Connections tab and click Google Analytics - GA4.

   

   
2. Fill up the Connection Name.

3. Upload the JSON key you generated from Step 1.

4. Click Test Connection and Create Connection.

   

   

---

Connection

Select an existing Google Analytics 4 (GA4) connection or create a new one.

Source Properties

• Api Version - Select api version Google Analytics 4 API. See list of available APIs from Google here
• Date range - Select a date range from the dropdown list of ranges. If you select custom date range..., you will be prompted to enter From date and To date. Click either inputs and select the dates from the calendar. You can also use variables as values for the custom date range in the format yyyy-MM-dd.
• Include custom dimensions and metrics - Fetch list of custom dimensions and metrics from selected accounts and show it on tables of dimensions and metrics in schema section
• Property IDs - Leave empty to read data for all accessible Google Analytics 4 properties or type in the IDs of your Google Analytics properties (or tables) in the form of properties/xxx. You can enter multiple ids separated by comma or use a variable too. Source Schema

Select the metrics and dimensions to use in the source. The source also includes pre-defined fields for the Google Analytics account name, property name, property id and account id. Data can be also previewed by clicking “Refresh” button.

Migrating from Universal Analytics to Google Analytics 4 (GA4)

For metrics and dimensions mapping, please visit GA4 migration guide here