https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
t

thankful-oil-10632

10/09/2023, 4:20 PM
Copy code
SELECT
  user_pseudo_id as anonymous_id,
  TIMESTAMP_MICROS(event_timestamp) as timestamp,
  count(
    DISTINCT CONCAT(
      user_pseudo_id,
      "-",
      (
        SELECT
          value.int_value
        FROM
          unnest (event_params)
        WHERE
          key="ga_session_id"
      )
    )
  ) as value
FROM
  `red-land-cotton-ga4.analytics_309366137.events_*`
GROUP BY
  1,
  2
2 Views