GA4 -> Bigquery Export Bug

[TimoDataAnalyst]

GA4-Export intraday-Table had complete data, but the batch load of that day only includes partially that data. Data gets not refreshed over the next days, so that we are facing a huge data gap for that day.

As you can see, in general our numbers are much higher, but in some cases the batch load seems to have errors and we get the data only partially. Of Course, I cross-checked that with our performance and numbers in GA4 UI.

How can we restore the data of the day in order to close the gap for our data-processing?
Is Google aware that this is happening?
Are you facing similar issues?

PS: We have 360, so limits should not affect us.

[jangemmar]

Hi @TimoDataAnalyst,

Welcome to Google Cloud Community!

Seems like you’re experiencing a common issue with GA4 data with partial or missing data in your BigQuery export. On occasion, Analytics may update the daily tables anytime after the 72-hour window under circumstances that require Analytics to reprocess historical data. 

Here are the possible workarounds that you can do:

• Consider re-running your GA4 export for the specific day.
• Review the logs of your BigQuery batch load process. Look for any warnings or errors related to data loading or processing. These errors might indicate data truncation or incomplete loading.
• Go into your GA4 property's settings and verify your data retention period. If it's set too short, increase it.

If the issue persists, consider reaching out to Google Analytics support for assistance.

I hope the above information is helpful.