Sprinkle Docs

Funnel Analysis

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

Feature Walkthrough

Data Preparation for Funnel Analysis

The first step is to create a new model or update an existing model to add funnel fields.
Column Fields
Next, Navigate to the Funnels tab, to select the funnel field and the events fields.
Funnel Tab
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).

Creating Funnels

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.
Select Measures
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.

Exclude Steps from Analysis

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
And then
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