Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- COUNT(DISTINCT CASE WHEN event_name = 'session_start' THEN concat(user_pseudo_id, CAST(event_timestamp AS string)) END) AS sessions,
- FROM
- `ventura-cluster.analytics_244044299.events_*`,
- unnest(event_params) AS param1
- WHERE
- _table_suffix BETWEEN '20220501' AND '20220524' --start & end date
- AND param1.VALUE.string_value IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement