Mixpanel Community Icon

Sort Funnel Breakdown by Conversion Rate Excluding Low Counts

·
·

On a funnel breakdown view with 150 values, I want to sort the values from highest to smallest conversion rate, while excluding those with only one or 2 conversions (I can see the number of conversions in the table) How can I do that ?

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Hi Romane T., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹

    Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Based on the knowledge sources, there are a few ways to approach sorting your funnel breakdown by conversion rate while excluding low-conversion segments.When viewing a funnel breakdown with many values, you can sort the results by conversion rate in descending order by clicking on the column header in the table. According to the documentation, you can sort the data in different ways: 1. First, you can click on the column header to sort by that column. Clicking again will reverse the sorting order Insights sorting documentation.2. For filtering out segments with only 1 or 2 conversions, you have a couple of options: - You can use the statistical significance feature that's built into funnel breakdowns. Mixpanel automatically calculates statistical significance and shows segments with confidence levels > 0.95 (statistically significant) first when you sort by statistical significance. Segments with fewer than 30 samples are marked as "Insufficient samples" Advanced Breakdown Functionality. - You can also use the "View N" control in table visualizations to control how many segments to display, though this doesn't specifically filter by number of conversions Insights sorting documentation.Unfortunately, the knowledge sources don't provide a direct method to filter out segments with only 1 or 2 conversions specifically. You might need to: 1. Sort by conversion rate (highest to lowest) 2. Manually ignore the segments with only 1-2 conversions in your analysis 3. Or export the data and filter it in another toolIf you need more precise filtering capabilities, you might want to consider using Mixpanel's API to query the funnel data and apply custom filters in your own analysis.

    kapa.ai is still learning and improving, please let me know how I did by reacting below.

    ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.