Filter and breakdown are options that exist across Mixpanel reports, including:
Filter allows you to decide which event data to include in your analysis, either in the query builder or in the results. You can filter by event properties, user profile properties, group profile properties, and cohorts.
Breakdown allows you to group event data in the report results. You can breakdown by event properties, user profile properties, group profile properties, and cohorts.
Filter Query Input
When building an Insights, Funnels, or Impact report you can choose to add a filter to limit the property values that are included in the report.
Add a filter to your query by clicking on the … icon beside an event, profile, cohort, or step.
Then, select a property from the drop down list that appears and specify which values to filter.
In Funnels, filtering a step by a particular property will limit the data you see in the funnel to events with that property value.
You can choose multiple property filters for each item in your query.
You can select whether you would like the query to match any of these filters, or all of the filters by clicking on and/or beside the filters.
Filter Query Results
When building an Insights, Funnels, Flows, or Impact report you can choose to filter the entire report by properties or cohorts by clicking the Filter button. This will filter the results of the entire report to show only data with that property or cohort.
Breakdown groups the results of your Insights, Funnels, Flows, or Retention report by a property or cohort, allowing you to examine which properties or cohorts have a significant impact on your query.
This feature is useful for determining if a group factor, such as browser type, is having an impact on the way users interact with your product. Breakdown will display counts, such as the number of events performed or the conversion rates with that property value.
Select the Breakdown button, and select the property or cohort you want to breakdown your results by.
For cohorts, you will be shown groups of users both in and not in the cohort in your results.
It is only possible to either group by properties or group by cohorts, but not both.
For more information on how to interpret these results, view the following articles:
- Interpret an Insights Report
- Interpret a Funnels Report
- Interpret a Flows Report
- Interpret a Retention Report
This feature is in beta. We are no longer accepting any new beta customer.
More powerful breakdowns
Compare specific segments by choosing precise property values when breaking down.
You can quickly answer questions such as:
- How do my users' weekday (Monday - Friday) purchase behavior look like compared to weekend (Saturday - Sunday) purchase behavior?
- How do my users compare between different countries like "South Korea or China", "Austrailia or New Zealand" and "Canada or USA"?
- How do my younger customers (age 10 to 19) compare to older customers (age greater than 40)?
Paired with Mixpanel’s powerful set of operators (equals, greater than, between etc), you can now answer complex questions faster, easier, and in more intuitive way.
How does this work?
Customize Segments is available in the Breakdown feature in the Insights, Funnels and Retention reports. It supports String, Boolean, List, Numeric, Date and Object property data types.
Add a property in Breakdown, then select the Customize Segments icon on the right, which appears on hover.
You will be prompted to select the first two segment groups you wish to compare. Each line represents a segment group you can customize by selecting value(s) and an operator.