If you’ve used Google Analytics for your website, chances are you’re familiar with Universal Analytics (UA) — the long-standing version that most marketers and analysts grew up on. But now, Google Analytics 4 (GA4) has taken center stage, and it’s not just a redesign — it’s a whole new way of thinking about analytics. Key … Read more
When Consent Mode is enabled in GA4, your session reporting gets a bit trickier — especially if you’re working with raw event data in BigQuery. If a user hasn’t granted analytics consent (analytics_storage = ‘granted’), GA4 won’t assign session or user IDs. That means no session continuity and no proper attribution. But if you’re exporting … Read more
Google Analytics 4 (GA4) stores event-based data in BigQuery, where sessions are derived from event timestamps and session identifiers. Below are the steps to calculate the number of sessions from GA4 BigQuery exports, including an example SQL query. Step 1: Understanding Sessions in GA4 Step 2: Writing the SQL Query Use the following SQL query … Read more