CODEWITHSUNDEEP
google-bigquerygoogle-analytics-4
Little Brain
Little Brain

Reputation: 2857

Linking GA4 to BigQuery not working after 24 hours

I'm trying to link a recently-created Google Analytics GA4 data stream to a BigQuery account. I've checked every tutorial I can find and I've set up everything correctly as far as I can tell. However, more than 24 hours later, there is no data connection. I can't find any information on how to debug this - does anybody have any ideas?

Below are pictures showing what I've set up. The BigQuery account is paid, not sandbox.

GA4 report showing there is some data in Google Analytics:

enter image description here

GA4 link to BigQuery:

enter image description here

BigQuery service account:

enter image description here

BigQuery project with no data flowing:

enter image description here

I have blanked out names but I only have one BigQuery project so I've definitely linked GA4 to the correct one.

There is only one data stream, web, and it is selected in the link.

Can anyone think of any other configuration or setting which I might need?

Upvotes: 11

Views: 3516

Answers (2)

Poala Astrid
Poala Astrid

Reputation: 832

As per documentation, the possible reason for the delay is the changes on the property timezone as the export takes 24-hour snapshot of the property. The timezone can affect the export window and might shorten or lengthen the process.

You can try and choose to enable the streaming export to have a continuous export of data rather than daily export as it only performs once a day, to gather the data faster than expected.

It is also recommended to have an editor role to your project or service account when exporting the data.

Upvotes: 1

Little Brain
Little Brain

Reputation: 2857

Two days later and BigQuery has decided to connect to GA4. I changed nothing. It seems that it can take three or four days to connect after you've set everything up, and there's no way to get any feedback while waiting.

Upvotes: 10

Related Questions