Connecting to Google Analytics
This applies to: Managed Dashboards, Managed Reports
Google Analytics is a service offered by Google that compiles statistics regarding visitors to a website.
This article shows you how to set up a data connector to extract data from your Google Analytics account.
Note: Upgrade to v23.3 or higher to connect to a Google Analytics 4 property. The Google Analytics data provider from earlier versions supports only Universal Analytics properties.
Google Analytics Account
You need a Google Analytics account in order to create this data connector in Managed Dashboards.
Setup
Cloud Console Project
Create or use an existing project in the Google Cloud Console as a first step.
Go to https://console.cloud.google.com/cloud-resource-manager and sign into your Google account.
Once signed in, on this page you'll see a list of existing projects (if there are any) or you can select Create project to create a new one.
Enable the Analytics API
Select the menu button in the top-left corner of the Cloud Console, expand APIs & Services and select Library.
Ensure the correct project is selected at the top-left of the screen, then find and select the API for your version of Google Analytics:
For a Universal Analytics property, enable the Google Analytics API.
For a Google Analytics 4 property, enable the Google Analytics Data API.
Select Enable for the appropriate API if not yet enabled.
Note: There are multiple APIs available with Google Analytics in the name and their names may change over time. The Symphony data connector should require the one mentioned above unless an error message specifies a different one when you try to
Service Account Credentials
This section shows you how to generate Service account credentials which will allow Symphony to access your Google Analytics data.
From the left navigation, select Credentials. Select Create credentials and select the Service account option.
Enter a name and a role for the account.
When done, record the service account email address. Copy this from the account details and paste it somewhere to refer to later such as a Notepad app on your computer.
Next, add a new key for the service account. For example, click to edit the service account and select Add Key. Choose a JSON key type.
When finished, a certificate file should be downloaded. This file will be needed later to set up a data connector in Symphony.
P12 File Type
If you need a P12 key type for a Universal Analytics property instead of the default JSON, additional details are needed.
A popup should be displayed that shows the password for the private key. Copy and paste this password with your service account e-mail to refer to later.
Authorization
Now that the client credentials have been generated, sign into your Google Analytics account in order to give authorization to these credentials.
Go to the Admin area and choose the option similar to User Management or Property Access Management.
If not already listed, click to add the service account, entering the email address that you recorded earlier. Ensure it has an appropriate role or permissions set up to read data. See Google Help for details.
New Data Connector
From the main menu in Symphony, select New, and then select Data Connector.
In the New Data Connector dialog, assign a Name for your connector, and set the Data Provider drop-down:
For a Universal Analytics property, choose Google Analytics.
For a Google Analytics 4 property, choose Google Analytics Data API (GA4).
Select Choose File and select the certificate file downloaded earlier, then review the options:
If the certificate file is of a P12 file type, you have to provide the Service Account E-Mail Address and Password For The .P12 File that you recorded previously.
When the Use Reporting API checkbox is selected, the core v4 version of the API will be used. If unchecked, the core v3 version will be used.
Choose from the available Sampling Level options.
For a Google Analytics 4 property, enter the numeric property ID. This is listed in various places in Google Analytics, or go to Admin, edit Property Settings, and click to copy the property ID.
Select Test connection to check the connection to your account.
Select the submit button at the bottom to save and check in the data connector, and perform data discovery.
Display Google Analytics Data
To see the Google Analytics data, create a new metric set or dashboard.
Go to the Explore window, expand your data connector and its cube, then drag its measures and dimensions to the canvas.
For more information, see: