What is the first thing a user does when he logs into my app?
We use CoolaData’s session path to and take only the first 3 events from it. We filter by is_new =1 to only get that user’s first session ever in the app/site.
.
select first(path_to_string(path),3) as path, count(*) as count
from cooladata
where date_range(context)
and filters(context)
and path_count()>5
cluster path by session
group by path
order by count desc
Limit 10
