Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Ralf Baumgartner (Unlicensed) : write here an step-by-step, simple to follow guide instead of the text below (you can still mention the link, but it should not be necessary to use it at all).

DE: https://support.google.com/analytics/answer/9823238?hl=de&ref_topic=9359001#zippy=%2Cin-this-article%2C%C3%BCbersicht

EN: https://support.google.com/analytics/answer/9823238#step3&zippy=%2Cin-this-article

Note

MAKE SURE THAT YOUR BIGQUERY REGION IS “Multi-Region EU
and not another one like “europe-west-6”

Link BigQuery to a Google Analytics 4 property

First make sure you are using an email address that has OWNER access to the BigQuery Project and also EDITOR role for the Analytics property you want to link.

Go to https://analytics.google.com/analytics/web/#/ and check in the admin section the account and property. Then click BigQuery links.

...

Click on Link to create a new connection.

...

Click Choose a BigQuery project.

...

Select your project from the list, then click Confirm.

...

Note

MAKE SURE THAT YOUR BIGQUERY REGION IS “Multi-Region EU
and not another one like “europe-west-6”

Image Added

Add advertising identifiers if desired and check the frequency options.

...

Review your settings and click submit.

...

After the link is created it might take up to 24 hours for your data to appear in BigQuery.

You will then be able to query your data.

...

Share your datasets access with the Boxalino Service Account emails :and the datastudio email.

  1. boxalino.datastudio@gmail.com

  2. 55483703770-compute@developer.gserviceaccount.com

  3. 285267441728-compute@developer.gserviceaccount.com

  4. Access to daily processing: 473358938625-compute@developer.gserviceaccount.com

  5. Access to full processing: 748704719320-compute@developer.gserviceaccount.com

  6. Access to delta processing : 178258671205-compute@developer.gserviceaccount.com

  7. Access for reports processing: connection-daily@reports-290318.iam.gserviceaccount.com

  8. Access for lab processing: connection-daily@lab-daily.iam.gserviceaccount.com

  9. (optional) Access to mailchimp processing: 44011570818-compute@developer.gserviceaccount.com

  10. (optional) Access for p13nsync processing: 57928973091-compute@developer.gserviceaccount.com

Provide a read access (Data Viewer/Metadata Viewer) on all relevant datasets in your custom GCP projects.

Let Boxalino know the name of the project and dataset and we will integrate it to your data lake.

Additional Sources: https://www.ga4bigquery.com/tutorial-how-to-set-up-bigquery-linking-in-your-google-analytics-4-property-ga4/