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-int...
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/
3. 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!
LinkedIn
Twitter
