Learn business growth with Google Analytics 4 › Forums › Google Analytics 4 › Identifying session-level traffic sources in BigQuery using CASE statements › Reply To: Identifying session-level traffic sources in BigQuery using CASE statements
-
Yes, your understanding is correct. You’re trying to use a multi-condition CASE statement in BigQuery to categorize traffic sources for your GA4 data. In specific scenarios where utm tags aren’t present, you’re looking to designate the utm_medium as ‘organic’ and the utm_source as the referral site. You’re curious if this CASE statement approach can be executed in BigQuery.