This tutorial describes step by step how share GA4 data with Roivenue using Google BigQuery.
What are the necessities?
GA4 measurement set up
Google Cloud Project* in Big Query with billing details**
* Don't have a Google cloud account yet? Create your account now.
** Set up the billing details here. The billing details are necessary to have the most recent data in the export, otherwise you will have 2 days lag of the exported data. You will not be charged anything unless you switch to a paid plan. If you have a lot of data (10+ mil. sessions monthly), the pricing can be found here. The Big Query is rather cheap and you get plenty of storage and queries monthly for free (more than enough to cover Roivenue integration).
The set up will have to be done by a person with certain rights. These are:
Fill in the project name, select your organisation and location. The name can be anything - for example - Ga4BigQueryExport. For the remaining 2 fields you should have just 1 option in each. Then create the project.
2. Create a link between GA4 property and Big Query
Editor rights in GA4 property or higher
Big Query project owner (if you completed Step 1 you already have this permission)
Head to Google Analytics 4 property which you want to connect to Roivenue, and go to settings (gear button in the left bottom corner).
Under Property settings -> Product links select BigQuery links.
Create a new link by clicking the "Link" button. Screen like this will pop up:
A. Select the project from Step 1.
B. Data location - select European Union (EU)
C. Type of export - select streaming.
(If you select daily export, you will not have data for the previous day!)
D. Events to exclude - none.
This will create an export of data from GA4 to Big Query.
Google Ads <-> Big Query export
If you do not use auto-tagging (not likely), skip this part.
(At the moment, there is one unresolved issue on Google's side, and that is the Google Ads data issue. This issue concerns only accounts with auto-tagging turned on.)
1. Create a link between Google Ads and Big Query
Big Query Admin role on project level
Google Ads read permissions
Firstly you will have to activate Google Big Query API - you can do so here.
Link of Google Ads to big query is done in Big Query -> data transfers -> new transfer ->
You will be asked to fill in these details:
Display name - name of the import, it can be anything.
Schedule - Repeat frequency = Days, At = 00:30
Dataset - create a new dataset where we will feed the Google Ads data.
It should look like this:
a. Make sure to select the same location as for your Google Analytics data!
5. Customer ID - add ID from Google Ads (eg. 5xx-0x5-5xxx)
(can be found in your Google Ads account in the top right corner)
a. If you have multiple accounts, connect your MCC (to save some time)
Refresh window - blank
Table filter: ClickStats,Campaign,AdGroup
Leave the rest in default state
At this moment, the set-up should be successfully finished. We can connect your data to Roivenue.
Sharing access to BQ with Roivenue
To do so, we will need you to invite user - [email protected] to both (GA4 and Google Ads) of your new datasets as Google Big Query Viewer and as a Google Big Query Job User to your project.
In the explorer you can see multiple rows: roivenue-com is a project, analytics_xxxxx are datasets. Click on the 3 dots of the new dataset that you have created by linking GA4 with Big Query and click “share”.
New tab will open. Click “add principal”.
Fill in the details (as in the picture) and save:
4. Repeat the process for all Google Analytics properties.
Open a Big Query Menu (Left top corner 3 lines next to “Google Cloud”. Head to IAM & Admin > IAM. Click "Grant Access".
Same window as for the Data Viewer will open. Use the same email, select BigQuery Job User as role.
At this moment, your BigQuery is connected to the Roivenue. Inform your Client Success Manager that the accesses were given.