Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

the linkage between BigQuery and google analytics

I've linked between google analytics and BigQuery but nothing shows on the console of BQ that indicates that they are linked, did I do something wrong?
Do I need to wait for something or should it create the table immediately?
0 1 394
1 REPLY 1

Hi Greenix,

Assuming that you are not on GA4, to link Google Analytics to BigQuery you must pay attention to 2 things:

- You must be an administrator of the Google Analytics property (the edit permission is no more valid since few months)

- You must be the owner of the BigQuery project

If you already made the linking but don't have data please check if:

- In the IAM console in the BigQuery project verify if the linking service account analytics-processing-dev@system.gserviceaccount.com have the editor permission
- In the Logging Service, check the BigQuery logs errors you may have about the session tables creation and past it if you can't understand it.

More about linking: https://support.google.com/analytics/answer/3416092?hl=en [You must be an administrator of the Google Analytics property, the edit permission is no more valid since few months]

 

Best regards