ga4_session_counts_for_boxplot.sql

--Looker Studio BigQuery custom query to get sessions per user

with s as (select distinct 
  user_pseudo_id,
  concat(user_pseudo_id,(SELECT value.int_value FROM UNNEST(event_params) WHERE key = 'ga_session_id')) AS session_id,
  timestamp_micros(event_timestamp) as timestamp
from `yourbqproject.analytics_1234567.events_*`
where _table_suffix between @DS_START_DATE and @DS_END_DATE
and event_name = 'session_start')

select distinct
  user_pseudo_id,
  count(*) over (partition by user_pseudo_id) AS session_count
from s