Integration Setup
Prerequisite: Setting up the GA4 -> BigQuery export
Before setting up this integration, you should already have linked your GA4 property to a BigQuery project in Google Cloud Platform, and the linkage should already be populating data in the BigQuery project.
If you don't have your GA4 property linked to a BigQuery project, here are some instructions on how to do so.
If you have never used Google Cloud Platform or BigQuery, the following video will help you navigate successfully setting up the GA4 -> BigQuery linkage:
Google Cloud Platform costs
By setting up the GA4 -> Bigquery linkage and the Google Analytics via BigQuery integration, you will incur costs on Google Cloud Platform.
Google Cloud Platform charges you in two ways:
Storage costs - You will be charged monthly based on the amount of data you have stored in Google Cloud Platform. Unless you have millions of visitors a day, this will likely only be a few dollars per month.
Analysis costs - You will also be charged monthly based on the amount of analyses you run on your data stored in Google Cloud Platform. If you stick to only the standard queries that we plan to run on your data and do not have millions of visitors per day, again this should only be a few dollars per month.
In the days after setting up the GA4 -> Bigquery linkage and the Google Analytics via BigQuery Daasity integration, you should monitor your Google Cloud Platform costs to get a sense of how much this process will cost you. You can view this information via the Billing page in Google Cloud Platform.
Setting up the Google Analytics 4 via BigQuery Daasity integration
Once you have established the GA4 -> BigQuery linkage and data is populating, you can set up the Google Analytics 4 via BigQuery integration in Daasity.
Step 1: Create a new Google Analytics 4 via BigQuery integration
In the Daasity App, navigate to Integrations > New Integration and select Google Analytics 4 via Big Query
Step 2: Add BigQuery Configuration details
The new integration will have a BigQuery Configuration section like the one below:
To get these details, navigate to https://console.cloud.google.com/bigquery and make sure you are in the project that contains your exported GA4 data.
The GCP Project and Dataset can be found in the lefthand menu. The dataset you choose should have the same 9-digit number as your GA4 property:
NOTE: If you do not see an analytics_ dataset, it may be because (A) you are in the wrong project, in which case you should navigate to the project that you used to set up the GA4 -> BigQuery export, or (B) your GA4 -> BigQuery export has not begun sending data, in which case you should check back again in 24 hours.
The Stream ID setting in the BigQuery Configuration is optional. Only add this if you want data from a single stream ID to flow into this integration. You can learn more about stream IDs here.
Step 3: Create a service account for Daasity
In order for Daasity to be able to extract your GA4 BigQuery data, we need you to create a service account that we can use to give us read access.
To start creating a service account, navigate to https://console.cloud.google.com/iam-admin/serviceaccounts/create
In the details section, use whatever name, ID, and description details you prefer:
Then, click CREATE AND CONTINUE.
Grant the service account BigQuery User and BigQuery Data Viewer roles in the project.
The easiest way to do this is search for those specific roles in the dropdowns:
Then, click CONTINUE.
Granting users access to the service account is entirely optional:
Finally, click DONE
Step 4: Generate a service account key for the Daasity service account
The service account key will act as a password that will allow the Daasity service account access to your BigQuery data.
To generate it, first navigate to https://console.cloud.google.com/iam-admin/serviceaccounts
Then, click on the email of the service account you created in the previous step:
On the next page, navigate to the KEYS tab:
Click ADD KEY and choose Create new key:
In the pop-up, choose JSON and click CREATE:
This should generate a .json file that will be downloaded to your computer. You will use this file in the next step.
Step 5: Add the service account key to the integration in Daasity
Go back to the integration setup screen in Daasity.
In this step, you're going to add the service key information you generated in the previous step in the BigQuery Account of the integration settings:
You have 2 choices of how to do this:
A. Drag the file you downloaded in Step 4 onto the screen where it says Drag file here, or
B. Open the file you downloaded in Step 4, copy the contents, click the Enter Key tab, and paste the contents
Once this is done, move to Step 6.
Step 6: Link to other integrations
The Link to Commerce Integration section allows you to tell us which old Universal Analytics integration the GA4 BigQuery integration corresponds to and which ecommerce integration the data is related to:
If this GA4 BigQuery integration will be taking over for a Universal Analytics integration after the July 1 UA sunset, choose it from the Linked Universal Analytics integrations menu.
If you want GA4 BigQuery data to take precedence over Universal Analytics data before 7/1/2023, specify the date in the GA4 Cutover Date section.
If the GA4 BigQuery data is specific to an existing ecommerce integration in Daasity, choose it from the Linked eCommerce Store menu.
Click the CREATE button in the upper right corner of the screen.
Was this helpful?