-
While the query seems to be working generally, the higher engagement rate suggests that there might be an overcount of the engaged sessions. This could be due to any number of reasons, such as duplicate session data in the raw table, incorrect filtration on the query, or even a miscalculation of the engaged sessions. Checking for these issues may help. Incorrect schema or data manipulation can also affect the results. Additionally, if the engagement goals or parameters are set differently in BigQuery compared to GA4, it could account for the discrepancy in numbers. Without further information and troubleshooting, it’s hard to say for certain why the results are off. You may want to consult with a BigQuery expert or hire a data analyst who could dig deeper into the data and potentially figure out what’s causing the anomaly.
