Overview, Data Preparation for Funnel Analysis, Excluding Steps in the Analysis.
Funnels enable you to examine the events that are performed in a series.
Through Funnel Analysis, you can root cause the reasons for the drop-offs, analyse things that worked well towards a successful conversion and hence build a comprehensive user experience. A detailed analysis of the events data provides various actionable insights on the user journey.
Taking e-commerce example, where there are users performing events like searching products
, viewing them, adding them to the cart, updating payment
details and finally making a purchase
Next, Navigate to the Funnels tab, to select the funnel field and the events fields.
Select the columns in the Funnel & Event Fields.
Funnel Field: Perform Funnel-Analysis over which Entity (usually on which/by whom events are performed)? (Ex: users or leads).
Event Field: The event that is to be tracked. It is the field on which the funnel needs to be applied (Ex: ecomm_event field which takes values, Browsing, AddToCart, Purchase).
Navigate to Analytics -> Funnels -> New from the left navigation pane.
Click on New, to begin with, a new funnel analysis.
Click + Add Steps to your funnel. This will prompt you to select an event from the drop-down list.
Add Steps Drop-Down
Click on Add filter to add step filters to limit that step data to events within a particular time or user properties. In the below
example, the Search step is limited to the timestamp before 04th January 2022.
Use Filters on Steps
Now choose measures of interest to count for the steps selected. Sprinkle supports Unique Count, Absolute Count, Approximate unique count as measures.
Approximate Unique Counts are useful when building funnels very large data sizes. Approximate counts run the query much faster than the Unique Counts.
Save and Run the funnel report to view the report in the chart section below
Tabular View of Output Data
You can view the data in various available visualization formats. above, the Funnel Chart is selected for the visualization of the data.
You can also exclude some steps from the funnel, which you want to ignore.
Click on the Add Exclusion Steps button, to exclude steps.
Then select the event based on which you want to exclude steps and also choose the steps from which they want to exclude the particular event.
For example, to exclude the steps Purchase and dependents from the steps for e-commerce shopping lifecycle events. Select the Add to cart step from the Exclusion Step dropdown and All Steps from Between dropdown.
Exclude Add to Cart Step
click on Save and Run. The event selected and its dependents would be excluded from the funnel. Now, in the report, only events before Purchase would be visible.
Output: After Add to Cart Excluded
Last modified 5mo ago