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 Load button at the top right. To create a new funnel by resetting the query click on the ... icon and select Reset query.


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.


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


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


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. 


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.


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.


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


Learn more about Exclusion Steps here.


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.


  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.


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.


Learn more about the options under Conversion Criteria here.

Global Filtering

The date range and property or cohort filters below the query builder apply to the entire funnels report.

By Property or Cohort

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


After selecting a property to filter by you can select the Attribution type (last touch, first touch, or step number). Learn more about attribution here.


To create a temporary cohort for the current report select Create cohort under the cohort filter or breakdown. A window will pop up where you can specify the restrictions of your cohort. Learn more about building a cohort here.


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.


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. 

Did this answer your question?



Article is closed for comments.