-
Yes, it appears there’s a discrepancy between the session counts in the GA4 user interface and those resulting from your BigQuery query. The difference seems large, considering the same sources and date ranges have been applied in both cases. You’re absolutely right in identifying unique sessions by combining the session ID and the pseudo user ID. However, this discrepancy suggests there may be an overlooked aspect in your query or a difference in how GA4 and BigQuery are filtering and counting sessions. It’s also worth ensuring that the data in BigQuery is up-to-date and that there is no lag or delay in data availability affecting your results. A deeper investigation would indeed be useful to identify and fix the issue.
