Filter vs. Breakdown in Funnels

There are two different ways that you can limit or organize the data you are looking at in your funnel: filtering in your funnel creation, or by breaking down the results of the funnel through Breakdown.

Filtering

When you are building your filter, you can choose to filter a step by a particular property by clicking the Filter button on each step. This limits the data that you will see in the funnel to events with that property.

Multiple property filters can be chosen for each step in your funnel. Free Mixpanel plans can only apply up to two filters, while Paid Mixpanel plans can apply as many filters as they like.

Screen_Shot_2019-06-14_at_11.09.12_AM.png

You can select whether you would like the user to match any of these filters, or all of the filters by clicking on or/and beside the filters.

Jun-14-2019_11-20-31.gif

You can also choose to filter the entire funnels report by properties or cohorts by clicking the Filter at the bottom of the report. This will filter the results of the entire funnel to show only data with that property or cohort.

Screen_Shot_2019-06-14_at_11.24.16_AM.png

Breakdown

Breakdown by property or cohorts, on the other hand, is something that you can choose to do in the results of the funnel. Breakdown will group the results of your funnel by property or cohort, allowing you to examine which properties or cohorts have a significant impact on the conversion rates of your funnel.

Select the Breakdown button below the funnel, and select the property or cohort you want to breakdown to see how your users operate in the funnel depending on city, country, browser type, etc.

Screen_Shot_2019-06-18_at_3.06.09_PM.png

This feature is useful for determining if a group factor such as browser type is having an impact on your conversion rates. For example, if there is a bug in your software on Firefox, you might see a decreased conversion rate in the Firefox group.

For cohorts, you will be shown groups of users both in and not in the cohort.

Screen_Shot_2019-06-14_at_11.33.00_AM.png

It is only possible to either group by properties or group by cohorts, but not both.

Statistical Significance

Grouping by property or cohort also allows you to see the statistical significance of each group segment in order to determine whether that segment was statistically significant in conversion.

Learn more about statistical significance in funnels here.

User Count Calculation

When grouping or filtering the results of your funnel, user count will be determined by the number of unique users for each property combination.

For example, if you are an e-commerce site grouping by the property “item” to determine what users are searching for and purchasing, users will appear in the table once for each property they use. In a funnel where Event A is “Search”, Event B is “Add to Cart”, and Event C is “Purchase”, a user may complete the funnel twice, once with the property “hat”, and once with the property “shirt”. This user would convert through the funnel, and be counted in the Group By table for both “hat” and “shirt” when grouping by property “item”. They would be counted in the “overall” row as completing the funnel once.

This behavior matches how users are counted when filtering by property: if a user goes through the entire funnel X times with Y distinct event property values, the user will be counted Y times.

Previously Group By and Filter By only counted unique users once, regardless of their property. This meant that only the first property a customer chose would be shown in the Group By table. This calculation has been changed to improve the accuracy and quality of your data. This change was made on 9/25/2018, and as a result, you will see your results differ from the results calculated using the previous algorithms.

Because of this change all automatic segmentation alerts that were generated with the previous calculation will automatically be removed. Moving forward the alerts will use the new calculation.

Is this article helpful?
12 out of 15 found this helpful

Comments

0 comments

Please sign in to leave a comment.