Understanding Global Filter Impact on Funnel Report Cohorts
How to tell whether the global filter is including the selected cohort from the result or excluding it when applied on funnel report? kapa.ai
How to tell whether the global filter is including the selected cohort from the result or excluding it when applied on funnel report? kapa.ai
Please stand by Chansol L. as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
When you apply a global filter using a cohort in a Mixpanel funnel report, the filter will include only users who are in the selected cohort in your results. In other words, the funnel will show data for users who are members of the cohort at the time the query is run. Users not in the cohort are excluded from the results.This is confirmed in the documentation: “You can use cohorts to filter any of your analysis by selecting a cohort from the filter menu. For example, if you’re focused on Onboarding, you can filter all your analyses to the New Users cohort, which might be defined as users who signed up in the past 7 days” — meaning only those users are included in the analysis Using Cohorts in Analysis.Additionally, when you use the breakdown feature with cohorts, you will see both users in and not in the cohort, but with a global filter, only the selected cohort is included Breakdowns.So, to summarize: A global cohort filter in a funnel report includes only users in the selected cohort and excludes all others from the results.
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.
kapa.ai then what if my two selected events are 1)landing page view event & 2) sign up finished event and I filtered new users cohort, who signed up in the past 7 days. What is included and excluded in each funnel in this case?
Let me check the knowledge base for you again. One moment! 📚
If you set up a funnel with these two steps: 1. Landing page view event 2. Sign up finished event…and you apply a global filter using the "New Users" cohort (users who signed up in the past 7 days), here’s what happens: - Included: Only users who are currently in the "New Users" cohort (i.e., users who have completed a sign up in the past 7 days) will be included in the funnel analysis. The funnel will show how these users moved from viewing the landing page to finishing sign up. - Excluded: Users who are not in the "New Users" cohort (i.e., users who signed up more than 7 days ago or never signed up) will be excluded from the funnel results.This means your funnel will only analyze the conversion path for users who are considered "new" by your cohort definition at the time the query is run. The funnel will not show data for users outside this cohort, even if they performed the funnel events.This behavior is described in the documentation: “You can use cohorts to filter any of your analysis by selecting a cohort from the filter menu. For example, if you’re focused on Onboarding, you can filter all your analyses to the New Users cohort, which might be defined as users who signed up in the past 7 days” Using Cohorts in Analysis.Additionally, cohorts are computed dynamically at query time, so only users who are in the cohort "right now" are included How Cohorts are Computed.Summary: - The funnel will include only users who are in the "New Users" cohort (signed up in the past 7 days). - All other users are excluded from the funnel 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.
kapa.ai but the tricky part is since the second event is sign up event, if I want to see the conversion rate of not yet signed up users to sign up applying not yet signup cohort global filter on the report, then wouldn’t it show 0 for the second event cuz it’s sign up finisehd event?
Let me check the knowledge base for you again. One moment! 📚
You are correct in your reasoning. If you apply a global filter using a cohort of "not yet signed up" users (i.e., users who have not completed the sign up event), and your funnel steps are: 1. Landing page view event 2. Sign up finished eventthen the funnel will show 0 conversions for the second step ("sign up finished event"). This is because the global filter restricts the funnel to only users who are currently in the "not yet signed up" cohort, and by definition, these users have not performed the "sign up finished" event. Therefore, none of them can reach the second step in the funnel.This behavior is consistent with how Mixpanel computes cohorts and applies global filters: only users who are in the cohort at the time of the query are included in the analysis, and the cohort is dynamically computed based on current user properties and events How Cohorts are Computed.Summary: - If you filter the funnel by a "not yet signed up" cohort, the second step (sign up finished) will always show 0, because no user in that cohort has completed the sign up event.
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.