medium10 pts · first answer countswindow-functionssqlgaps-and-islands

Splitting clicks into sessions

You want a session number per user, where a gap of more than 30 minutes starts a new session. What is the usual window-function approach?

A.Flag rows whose gap from LAG(ts) is over 30 minutes, then running SUM the flagsB.Use NTILE to split each user's events into equal-sized groupsC.Use DENSE_RANK over the event timestamp within each userD.GROUP BY user and fixed 30-minute clock buckets of the timestamp

Discussion 0

Join free to post in the discussion.

Splitting clicks into sessions

Discussion 0

Related questions