Path
Last updated
The Sandstorm Path Report allows you to analyze the most common sequence of property values that eventually lead to a conversion. This lets you uncover what your customers do so that you can see exactly what series lead to more conversions, higher conversion rates, or shorter time to convert.
This report is best used for:
đź‘Ť
discovering the best series of property values that people have that result in a high conversion rate
revealing the best marketing channels for acquiring leads and the best marketing channels for converting leads to customers
seeing how long customers take to convert based on what they do
The Path Report lets you analyze:
The first 5 events that occur in order that lead to a conversion event
The last 5 events that occur in order that lead to a conversion event
The first 5 values of a property in order that lead to a conversion event
The last 5 values of a property in order that lead to a conversion event
The Path Report lets you define:
An event that starts the sequence or path you want to analyze. This helps you narrow down the customer lifecycle that you want to optimize.
A conversion event that the starting event eventually leads to.
A date range for the conversion event.
Sample configurations for analyzing opportunities to closing customers could be:
Show me the first 5 events starting with Signed Up that lead to Subscription Billed.
Show me the last 5 events starting with Signed Up that lead to Subscription Billed.
Sample configurations for analyzing lead generation and marketing channel effectiveness could be:
Show me the last 5 Channels starting with Visited Site that lead to Signed Up within the last 30 days.
Sample configurations for analyzing e-commerce purchase behaviors could be:
Show me the first 5 Channels starting with Visited Site that lead to Add To Cart.
Show me the first 5 events starting with Visited Site that lead to Add To Cart.
Show me the first or last 5 events starting with Purchased that lead to Purchased. This shows you the behavior of how people re-purchase.
The Path Report will show you up to 15 paths that people have done given your report configuration. A summary area will show you high-level information about:
The number of people who were found from your starting event to your conversion event
The number of conversions from all paths
The conversion rate across all paths
How long it took people to convert from starting event to conversion event (using a weighted average)
Clicking a tab in the summary area lets you sort the Path Report by people, number of conversions, conversion rate, or time to convert. Use these tabs to sort your results based on what fits your marketing strategy. Some businesses care about number of conversions more than conversion rates. Some businesses optimize for shorter conversion times if they are meeting goals or quotas.
Each path will contain a series of numbers followed by a property value. These numbers tell you the order or sequence that the property value happened.
If a property value happens consecutive times before another unique property value, we will show this by adding a 2X, 3X, 4X to the property values to show you how many times the property value happened consecutively.
If a path is more than 5 events/properties long, the Path Report will show a “+ X more events” item which will represent the median number of events/properties happening after the first 5 events/properties or preceding the last 5 events/properties. This gives you an idea of how many actions people take before they convert. This median number is rounded down to the nearest whole number in the event that a median has a 0.5 value.
🚧Note:In an export of the Path Report, you will still see 0.5 values in the raw data.
The time convert uses a median calculation from the starting event to the conversion event. This lets you view the overall time to convert in the summary as a median of how long people took the convery and a specific time to convert for any individual path. This is important if you are trying to optimize how fast people convert on your site or app.
The Overall Time to Convert metric in the summary area uses a weighted average to calculate the overall time to convert across all paths. This means that if you have one path with 1,000 conversions and a median time of 1 day, and another path with 10 conversions and a median time of 1 hour, the “overall time to convert” would be closer to a day.
When multiple conversions (such as Purchases) happen within the date range you select, the Path Report will show the paths for the first conversion that happens in the date range. We are planning to improve this functionality to allow you select between the first or last conversion within the date range
If you are doing a last 5 property report, a person can captured for more than one path because it is likely that people can have common ways of converting (i.e. people all have to go through the same checkout flow in E-Commerce or the same way to enter in your payment information for SaaS).
In the first 5 property, people can be part of likely one path because people usually do a unique sequence of events when they first arrive on your site or app. Because of the differences of people’s behaviors, you’ll see different numbers for each configuration.