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