Connect Google Analytics with Google BigQuery

Google Cloud account

First, you will need to have a Google Cloud account. If you have already set up the Firebase project, it automatically creates a relevant Google Cloud account with the same credentials. The recommendation is to use the same GCP (Google Cloud Platform) account, but you can also create a different account for this, you can flow Google guide for creating a GCP account.

Create a Big Query project

Once you have a GCP account, you should make sure you have the relevant project, and to enabled the BigQuery service. If you have already set up the Firebase project, it automatically creates a relevant project in GCP, you can use this project, or create a new one following Google guide.

Now, we should enable the Big Query service:

• In the Google Cloud console, go to the project selector page.
• Select the Google Cloud project.
• Enable billing on your project, enabling billing is required only once per project. You can enable billing by following this Google guide.
• Then, you should enable Big Query API here.
• Finally, you will need to enable the BigQuery Data Transfer Service.

After setting up the BigQuery project, you should provide Applicaster access to the BigQuery project. With this access, we will deploy all the relevant schedule queries used by the Data Studio dashboard:

• From your Google Cloud Platform dashboard, navigate to IAM & Admin > IAM.
• Next, click the GRANT ACCESS icon at the top of the page to add a new user to your project.
• In the principals field, enter Applicaster user email (you will get it from the CSM). In the Roles field, select the BigQuery Admin permissions.
• Finally, click the SAVE button to send an invitation.

Link Google Analytics to your BigQuery project

To link your Google Analytics property to the BigQuery project, you can follow the Google guide here, and also Google video tutorial here.