The new Path behavioral report enabled you to 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”.
The SunBurst visualization is designed for and particularly useful for analyzing paths, though it also supports other distribution queries.
The required result for SunBurst visualization is two columns:
- string / comma+space delimited list of strings
In the basic configuration (one string per row) the SunBurst visualization is a standard donut chart, showing the distribution of each item in the first column out of the total of the second column (like pie chart).
Example – Events Distribution (Donut)
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
However, it can do much more!
For path analysis, use the path_to_string() function. It returns the first column as a list of string, comma+space delimited. The SunBurst visualization treats every string in the list as the next step in the session’s path, and displays it as a following (outer) ring.
Use the path_count() function to limit the number of rings in the visualization (see example below).
Hovering or clicking (to pin the selection) over any part of the visualization will show the items in that section as a sequence below the chart (above the legend), and the share of that section out of the total as a percentage. Point to the center of the circle to show the text explanation of what is shown.
Example – Path Distribution
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
The legend can be turned on/off.
Exporting the results will provide the same output as the standard table view output (CSV).
Sankey visualization is a flow diagram in which the width of the arrows is shown proportionally to the flow quantity.
Like Sunburst, the required result for Sankey visualization is two columns:
- string / comma+space delimited list of strings
Sankey displays the users’ journey in a flatten way than until his exit point.
It’s available in CQL report and in Path report.