Missing data in events_ table

Google Cloud Data Analytics
,
1

In my events_ table I’m missing the data of one certain day (05-22). We didn’t change anything in GA4 and I can’t think of anything what could have happened here. Is there anything I can do to add the data of that day back to this table.

I

Scherm­afbeelding 2023-06-06 om 09.46.51.png
Scherm­afbeelding 2023-06-06 om 09.46.51.png276×313 2.53 KB

2

Good day @MichelleGijs ,

Welcome to Google Cloud Community!

You can check the following solutions if it will solve your problem:

  1. If you are currently using GA4 Standard, the daily export is only limited to 1 million events, you can check if it exceeds that limit. To resolve this issue, you need to upgrade your GA4 Standard to 360, this will allow billions of export per day and alternatively, you can also use streaming export to bigquery. You can check this link to learn more: https://support.google.com/analytics/answer/9823238?hl=en#zippy=%2Cin-this-article

  2. You can also check this thread as it may be related to your case: https://www.googlecloudcommunity.com/gc/Data-Analytics/BigQuery-GA4-missing-events-tables-events-intradays-tables/m-p/444030#M475

Sometimes the streaming process takes 3-4 days to process and insert it to BigQuery. So it is possible that sometimes you have a table from the date 18/07/2022 but you are missing a table from 15/07/2022.>

It was recommended also that if the data is missing for more than the given days that you reach out to Google Cloud Support. You can use this link to reach out to Google Cloud Support: https://cloud.google.com/support/

  1. You can also try using time travel to access data stored in Bigquery that has been changed or deleted. You can try restongring a table that was deleted, please note that you can access the deleted table within the time travel window which is 7 days by default, you can also try checking the logs if there are any deletions that happened. You can check this link for more information regarding time travel: https://cloud.google.com/bigquery/docs/time-travel

Hope this helps!

3

Hi @MichelleGijs

You may debug the problem using third party connector. E.g. export your GA4 data into windosor.ai account first, then import your GA4 data into BigQuery.