GA4 -> Bigquery Export Bug

Google Cloud Data Analytics
2

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.