π This article explains how to set up the Google Analytics 360 integration with Botify. For the GA4 process, please refer to this article.
Overview
Google Analytics 360 stores its data in a database called Google BigQuery. Botify needs access to your dataset to pull the data and integrate it into your crawl reports. To complete this procedure, you must be an admin on the project to share and have activated the BigQuery Export as described on Google's site.
Configuring the GA Integration
Complete the following steps to set up the Google Analytics integration with Botify, and then Send a Request to Botify:
Retrieving Your GA Project and Dataset IDs
Access the Google Developer Console using your professional Google account.
βClick the Select a project button in the middle of the page, then select a project to open.
ββ
Locate your project ID near the end of the project page's URL.
For example, xx-yyy is the project ID in this URL: https://console.developers.google.com/iam-admin/iam/project?project=__xx-yyy__&hl=en.
Keep this tab open to use when you create a Botify user.In another tab, locate your dataset ID by accessing your Google Analytics account.
With the proper Account and Property selected on the Project Settings page, click View Settings:
ββ
In your GA View, copy the View ID number, which is the dataset ID Botify needs to access your GA view:
Confirm Exports are Enabled in BigQuery
Connect to your Google BigQuery interface to verify that exports are enabled.
With the project and dataset selected, verify there is a table set called ga_sessions in the left menu and that there is at least one table in the table set with data (top of the right tab).
π If you just activated BigQuery Exports, you may need to wait 24 hours before seeing a table. For more information, refer to this Google article.
Create a Botify User in GA
Back on the IAM & Admin page project view, click the ADD button at the top of the page to add a new user.
Add the following user:
β501292259273-1d5th5t007a4b2ldg2nauecpjbg2q0pe@developer.gserviceaccount.comGrant this user the following rights:
BigQuery Data Viewer (to view datasets and tables)
BigQuery User (to run queries)
Send a Request to Botify
After granting Botify access to your BigQuery project, email Support with the following information:
Email Subject: βGA360 settings [company name]β
Project ID
Dataset ID
Link to the Botify Project where this data should be linked.
Contact Support
If you need assistance setting up the Google Analytics integration, please contact Support.