Entry and exit page per session

For each session, return the entry page (first event's page) and the exit page (last event's page). Use the session_no logic from M1.

Sort by user_id then session_no ascending.

Returnuser_idsession_noentry_pageexit_page

Columns

sess_events5 columns

columntype

event_idVARCHAR

user_idVARCHAR

event_tsTIMESTAMP WITH TIME ZONE

event_typeVARCHAR

pageVARCHAR

12 rows · 5 columns

sess_eventsfirst 5 of 12 rows

event_iduser_idevent_tsevent_typepage

ev_01u_a2026-06-01 10:00:00page_view/home

ev_02u_a2026-06-01 10:15:00page_view/products

ev_03u_a2026-06-01 10:25:00logout/products

ev_04u_a2026-06-01 10:30:00page_view/checkout

ev_05u_b2026-06-01 09:00:00page_view/landing

If you get stuck

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows