Last Event in the Session (Exit Event)

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 Journey Analytics.

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.

Syntax:

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

Example results:

exit events