Filtering by Property vs. Grouping by Property

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

Filtering

When you are building your filter, you can choose to filter a step by a particular property by clicking Add Filter next to the event name. 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.

FunnelsAddFilter.png

You can add as many filters as you like to an event by clicking the small + button at the bottom of the list.

FunnelsMultipleFilters.png

You can select whether you would like the user to match any of these filters, or all of the filters.

FunnelsFilterMatchAnyAll.png

Grouping

Grouping by property, on the other hand, is something that you can choose to do in the results of the funnel. Select the property you want to group by in the Overview section below the funnel to see how your users operate in the funnel depending on city, country, browser type, etc. 

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.

Screen_Shot_2018-07-12_at_5.10.40_PM.png

You can also choose to filter that grouping to a specific city or several cities using the > arrow button.

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?
6 out of 7 found this helpful

Comments

0 comments

Please sign in to leave a comment.