Connect to Google Analytics

In Oracle Analytics, you can connect to a Google Analytics data source and analyze Google Analytics data. For example, you might analyze the number of hits to website landing pages over time.

Before you start, set up a Google Analytics application. See the Google documentation. To analyze historical data, obtain a JSON file from your Google Analytics V4 environment that specifies the custom tables to analyze. See Specifying Google Analytics Custom Tables in a JSON File.

1. In Console, register the following domains as safe in the Safe Domains page:
   api.google.com
   *.google.com
2. On the Oracle Analytics Home page, click Create, then click Connection.
3. Click Google Drive or Google Analytics to display the Create Connection dialog.
4. Enter a Connection Name and optional Description.
5. Copy the URL displayed in the Redirect URL field.
6. In the Google application, on the Credentials page, paste the Redirect URL value into the Google "Authorized redirect URIs" field, then click Add.
7. In Google, on the Credentials page copy the "Client secret" value and the "Client ID" value.
8. In Oracle Analytics, paste the Google "Client secret" value into the Client Secret field.
9. In Oracle Analytics, paste the Google "Client ID" into the Client ID field.
10. In the Google application, copy the "Account ID" from the Account details and copy the "Property ID" from the Property details.
    In the Google administration settings, navigate to Account, then Account details to obtain the "Account ID", and navigate to Property details to obtain the "Property ID".
11. In Oracle Analytics, use the "Account ID" and "Property ID" that you copied in the previous step to specify the Account ID value and the Property ID value.
12. Optional: If you want to analyze historical data from Google Analytics, click Import File, and select a JSON file that specifies the Google Analytics V4 custom tables to analyze.
    See Specifying Google Analytics Custom Tables in a JSON File.
13. Click Authorize if you're creating a connection or Re-Authorize if you're updating a connection.
14. In the Google prompt to authorize the connection, click Allow.
    The Create Connection dialog refreshes and displays the name of the Google account, and its associated email account.
15. Click Save.
16. Use the connection to connect to your data. For example, from the Home page, click Create, then click Dataset, then select the connection that you just created.