-
Incomplete Event Data in GA4 Daily Rollup Tables
“Why are we losing event data in our GA4 BigQuery daily rollup tables? Our site events show up fine in the intraday table, but when it comes to the daily report, some events disappear, even events that had no issues showing up previously. We’ve double- and triple-checked our site event setups and all seems fine there. We also tested with Google Signal turned on and off. It’s crucial to have all events because we use them further for user sessions, and it’s a pain if they’re missing from the rollup. To top it off, this problem shows up in our GA4 reports too. Now, we’re at a loss. What could be going wrong?”
-
2 Replies
-
Your issue might have different sources. This could be due to data thresholds or data sampling in Google Analytics 4 (GA4) causing data discrepancies between real-time and historical data. This feature of GA4 helps protect user privacy, but can cause changes or distortions in the reported data. It could also be the result of a delay in the processing of data into BigQuery. Sometimes, you might see data in the intraday table that hasn’t yet appeared in the daily table because BigQuery processes large data sequentially and intraday data sooner than the rest. A third potential cause could be a technical glitch in GA4 or BigQuery leading to data loss. They are complex systems and occasionally do experience such issues. In all cases, you should reach out to Google support to investigate the matter further.
-
The problem you are experiencing could be due to a number of factors and it’s difficult to identify the exact issue without further analysis. It’s possible that the events are getting filtered out during the rollup process due to some filtering settings, or there might be a delay in processing the event data. If the amount of data being sent is large, some events may be dropped due to throttling. You should also verify if there’s a discrepancy between your raw data set and BigQuery’s exported data. It’s also worth noting that GA4 filters out bots and spiders, so some traffic may not get recorded. Another possibility is that GA4 discards sessions with events that have out-of-bounds timestamps. It’s suggested to seek support from Google Cloud Support for a more in-depth analysis of your situation.
Log in to reply.