Build a Funnels Report

Mixpanel’s Funnels allows you to examine how end-users perform events in a series. This article explains how to build a Funnels report. Learn about Funnels report basics in this article. Learn about how to interpret a Funnels report in this article

Create A Funnel

The funnels query builder opens to an empty funnel query. To open a saved funnel, click on the Open button at the top right. Click New to create a new funnel.

Build1.png

To save a funnel after building the query, click Save, or Save New if it’s a new funnel. The query will be lost otherwise.

Add Steps

Click Add step to add steps to your funnel. Select an event from the drop-down list.

Build2.png

Click the ... beside the step and click Add filter to filter that event by an event or people property.

Screen_Shot_2019-10-28_at_2.36.12_PM.png

You also have the option to drag and drop steps in your funnel to rearrange the order.

Oct-28-2019_14-39-50.gif

If you select any order funnels in the Conversion Details section, you have the option to anchor specific steps in your funnel by clicking on the step number. A step will either appear with a number beside it, indicating where it must fall in the funnel, or with an asterix (*), indicating that it can be performed any time before the next anchored step. 

Oct-28-2019_14-42-12.gif

Learn more about any order funnels in the Conversion Details article.

Exclusion Steps

Exclusion steps operate as a "did not do" filter for funnels. This provides the ability to create a funnel where, for example, you look for users that did event A, then event B, did not do event C, but then did continue to do D.

Click on the EXCLUSION STEPS header and click the Add button to exclude a step from your funnel.

Screen_Shot_2019-10-28_at_2.43.00_PM.png

Select an event from the drop-down list and choose whether you would like the event to be excluded between all steps, or between specific steps.

Screen_Shot_2019-10-28_at_2.48.00_PM.png

Click the ... beside the step and click Add filter to filter that event by an event or people property.

Screen_Shot_2019-10-28_at_2.49.22_PM.png

Learn more about Exclusion Steps here.

Example

For example, say you are an ecommerce company who wants to check if users who did not check their spending are more likely to buy a product. To answer this question, you could create a funnel with three steps:

Event 1: Log in

Event 2: Browse product

Event 3: Buy product

You can exclude users who did the event “viewed spending report” during the entire shopping process by adding an exclusion step between Events 1 and 3.

Further example use cases:

  1. Evaluate whether a certain step done alone is beneficial to your flow.
  2. Ensure that a conversion was NOT the result of another detour step being taken in between two key steps.

NOTE:

  1. An exclusion step can be placed between any steps in the funnel. It cannot be the first or last step.
  2. There may be any number of exclusion events between steps.
  3. Exclusion steps have the same two second grace period as other steps in the funnel.

Rename a Funnel or Step

Click on the title of the funnel to rename it. You are only able to edit the title if there are already at least two steps in the funnel.

Click on the ... beside a step and click Rename to rename it.

Screen_Shot_2019-10-28_at_2.50.24_PM.png

Conversion Criteria

At the bottom of the query builder, you have the option to edit the count of the funnel (unique users, total funnel entries, or sessions), the conversion window, or hold a property constant.

Screen_Shot_2019-10-28_at_2.50.52_PM.png

Learn more about the options under Conversion Criteria here.

Filtering

By Date Range

Below the query builder, click the button that says Last 30 days to select the date range of the funnel that you want to filter.

Screen_Shot_2019-10-28_at_2.53.39_PM.png

By Property or Cohort

Click the Filter button and select an event property, people property or cohort.

Screen_Shot_2019-10-28_at_2.54.49_PM.png 

Funnels Reports in Dashboards

You can add Funnels reports to dashboard cards. Dashboard cards show a completion rate and drop off rate for a funnel. The completion rate is the change in the percent of users that completed the funnel from the previous time period to the current time period. The drop off rate is the change in the percentage of users that dropped out of the funnel from the previous time period to the current time period. 

Is this article helpful?

Comments

0 comments

Article is closed for comments.