Use this query to view common last events (‘exit events’), before the end of a user’s session. For example, for an online quiz or survey: question_displayed, question_answered, and quiz_complete.
This query represents a great tool for getting insight into user behavior, and is easy to do with CoolaData.
By running this query, you can:
- Learn what the most popular last events are before users left a session.
- Understand why users ended a session with a wanted or unwanted action.
- Set a KPI for changing the commonality/popularity of a specific exit event.
For example, you can check why users abandoned the shopping cart and did not complete their purchase, say if they saw an error page or banner ad before before completing their purchase which caused them to exit.
SELECT last(path_to_string(path), 1) as last_event, count(session_internal_id) as cnt FROM cooladata WHERE date_range(doc.date_range) CLUSTER PATH BY SESSION GROUP BY last_event ORDER BY cnt DESC