The Path behavioral report helps you analyze your user's top paths. Choose between path by collection of events (contains) or steps (starts with…), customize advanced settings, and display the results using the sunburst visualization or in a table.

Path analysis can be used in two ways – sequential path, or non-sequential path:

• Sequential Path: Define a sequence of events you want each path to consist of. Use any of the following options:
  • Starts with: The first event in the path.
  • Followed by: Any events succeeding the first event. Additional events could have been between the first event and this one. You can add additional steps up to a total of 10.
  • Followed directly by: Any events succeeding the first event, with no events in between. You can add additional steps up to a total of 10.
  • Ends with: The last event in the path.
• Non-Sequential Path: Any paths that included a list of events. Choose between path that contain any of the events in the list (OR logical operator) and all of the events in the list (AND logical operator) .

Show top n paths allows you to limit the result set to anything between 1 and 50 rows.

Advanced options allow you to use advanced functions of the Path Analysis:

• Path completed in:
  • Single session: Only show the events performed within the same session. I.e. if the session was broken before the user completed the defined path he will not be included in the analysis.
  • User lifetime (not yet available): Combine all of the user sessions to a continuous string of events. Would include users who completed the defined path even if it was done over multiple sessions within the report's specified date range.
• Events to show:
  • All events in path: The default option – will show the full list of events the users performed in the path.
  • First events in path (not yet available): Only show the first X events in the path.
  • Last events in path (not yet available): Only show the last X events in the path.
  • Only these events: Filter out any events not specified here – in case you are only interested in specific events and want to ignore the rest.
  • First sequence of these events: Only show the first occurrence of a specific sequence of events. Define the sequence by selecting the events in the order you expect them to appear in. Additional events that occurred in between these events will also be shown, but events preceding or succeeding it will not. If the sequence repeats itself more than once during a path, only the first occurrence will be shown.
• Show recurring events:
  • Every time: The default option – will show the full list of events the users performed in the path.
  • Once: Identical events repeated consequentially (with no other events in between) will be filtered and only shown as one event. For example, the sequence: "click, click, click" will be shown once: "click".

select event_name, count(*) as count
from cooladata
where date_range(context)
	and slicers(context) 
group by event_name
order by count desc
limit 100

select path_to_string(path) as path, count(*) as count
from cooladata
where date_range(context)
	and slicers(context)
	and path_count()<5
cluster path by session
group by path
order by count desc
limit 100