What are the most popular events my shoppers complete right before leaving my site?
Use a session path to take the last 2 (or any other N events) that immediately precede the session’s end. Make sure to ask for sessions with more than 5 events in the path. Use either the sunburst visualization or a regular grid view. This helps us answer questions like what were my users doing right before they quit the site?
select last(path_to_string(path),2) as path, count(*) as count from cooladata where date_range(context) and filters(context) and path_count()>5 and path_count >= 2 cluster path by session group by path order by count desc Limit 10