Explain to me step by step how to find users who used the system last month and haven`t used this month without using cohorts
Hi Ilya L., 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
To find users who used the system last month but haven't used it this month in Mixpanel, without using cohorts, you can follow these steps using the Insights report:1. Open the Insights report in Mixpanel.2. Set up your first metric: - Choose an event that represents meaningful engagement with your system. - Set the measurement to "Unique Users". - Set the date range to last month.3. Add a second metric: - Use the same event as in step 2. - Set the measurement to "Unique Users". - Set the date range to this month.4. Create a formula: - Click on "+ Add" and select "Formula". - Set up the formula to subtract the second metric (this month's users) from the first metric (last month's users). - This will give you the number of users who were active last month but not this month.5. Optionally, you can add breakdowns or filters to further analyze this group of users.6. Choose an appropriate visualization, such as a single number to show the total count of these users.This approach uses Mixpanel's Insights report to calculate the difference between last month's active users and this month's active users, effectively giving you the count of users who were active last month but not this month.Remember that the exact definition of "used the system" will depend on what event you choose as representative of meaningful engagement in your product.Insights: Visualize trends and compositions within your dataNote: While this method gives you the count and allows for some analysis, it doesn't provide a list of individual users. For that level of detail, you might need to use Mixpanel's cohort feature or export the data for further processing.
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.
Let me check the knowledge base for you again. One moment! đ
To select different date ranges for different metrics in one Mixpanel report, you can use the "Compare to past" feature in the Insights report. Here's how you can do it:1. Open the Insights report in Mixpanel.2. Add your first metric as usual.3. For the second metric (or any subsequent metrics), you can use the "Compare to past" feature to set a different date range. Here's how: - Click on the "Compare to past" button at the top of your Insights graph. - Select the time period you wish to compare to. You can choose from preset options or select a custom date range.This method allows you to compare metrics from different time periods within the same report.Reports Overview explains:"Compare to past allows for comparing a metric against itself on a different time period. You are able to compare against the previous day, week, month, quarter and year. You are also able choose a custom time comparison window."Additionally, the Insights: Visualize trends and compositions within your data document mentions:"Compare the current period of time to previous periods to track trends and growth in your product's use. Compare traffic from a specific campaign period or event from one year to the next, or compare the success of that campaign to your normal traffic."This feature gives you the flexibility to analyze and compare metrics across different time periods within a single Insights report.
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.
Let me check the knowledge base for you again. One moment! đ
Certainly! I'll review the previous conversation and provide clear instructions on your initial request to find users who used the system last month but haven't used it this month, without using cohorts. Here's a step-by-step guide using Mixpanel's Insights report:1. Open Mixpanel and navigate to the Insights report.2. Set up the first metric: - Click "Select Event" and choose an event that represents meaningful system usage. - Set the measurement to "Unique Users" by clicking on the measurement dropdown. - Click on the date range selector and set it to last month.3. Add a second metric: - Click "+ Metrics" to add another metric. - Select the same event as in step 2. - Set the measurement to "Unique Users". - Set the date range to this month.4. Create a formula to find the difference: - Click "+ Add" and select "Formula". - In the formula builder, subtract the second metric (this month's users) from the first metric (last month's users). - This formula will give you the number of users active last month but not this month.5. Choose a visualization: - Select an appropriate chart type, such as a single number, to display the result.6. Analyze the results: - The number shown represents users who were active last month but not this month.This method uses Mixpanel's Insights report to calculate the difference between last month's and this month's active users, giving you the count of users who haven't returned this month.Insights: Visualize trends and compositions within your dataRemember, this approach provides a count and allows for analysis, but it doesn't give you a list of individual users. For that level of detail, you might need to use Mixpanel's cohort feature or export the data for further processing.
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.
Let me check the knowledge base for you again. One moment! đ
Certainly! I'll explain how to use cohorts in Mixpanel to find users who used the system last month but haven't used it this month. Here's a step-by-step guide:1. Create two cohorts: a. Last month's active users: - Go to the Cohort Builder in Mixpanel. - Set the criteria: Users who performed [your chosen event] at least once in the last month. - Name and save this cohort (e.g., "Last Month Active Users"). b. This month's active users: - Create another cohort with criteria: Users who performed [your chosen event] at least once in the current month. - Name and save this cohort (e.g., "This Month Active Users").2. Create a combined cohort: - In the Cohort Builder, create a new cohort. - Use the "Exclude" feature to define: Users in "Last Month Active Users" cohort BUT NOT in "This Month Active Users" cohort. - Name and save this cohort (e.g., "Last Month Only Users").3. Analyze the cohort: - Go to the Insights report. - Select your "Last Month Only Users" cohort as the primary metric. - Choose "Total" as the measurement to see the size of this cohort.4. Optional: Further analysis - You can use this cohort in other Mixpanel reports to analyze their behavior, properties, or other characteristics.This method using cohorts provides more flexibility and allows you to easily reuse the cohort for further analysis or export.Cohorts: Group users by demographic and behavior explains how to create and use cohorts in Mixpanel.Using Cohorts in Analysis provides information on how to visualize cohort size over time and use cohorts in various analyses.Remember, you can also export this cohort for use in other systems or for more detailed analysis outside of Mixpanel, as mentioned in Exporting Cohorts.
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.
Let me check the knowledge base for you again. One moment! đ
I apologize for the confusion in my previous response. You're right that there isn't a direct "Exclude" feature in the way I described. Let me provide a more accurate method to create the cohort you need using Mixpanel's actual features:1. Go to the Cohort Builder in Mixpanel.2. Click on "Create New Cohort".3. In the cohort builder interface, you'll see options to add criteria. Here's how to set it up: - First, add the criteria for users who were active last month: ** Select the event that represents system usage ** Set the time range to "In the last 30-60 days" (this covers last month) ** Set the number of times to "at least 1" or whatever threshold you consider as active - Then, click on "AND" to add another condition
- For this second condition, we'll define users who were NOT active this month: ** Select the same event ** Set the time range to "In the last 30 days" (this covers this month) ** Set the number of times to "exactly 0"4. Name and save this cohort (e.g., "Last Month Active, Inactive This Month").This method effectively creates a cohort of users who were active last month (30-60 days ago) but have not been active in the last 30 days (this month).You can find more details about creating cohorts in the Cohorts: Group users by demographic and behavior documentation.Once you've created this cohort, you can use it in various Mixpanel reports to analyze these users' behavior, as described in the Using Cohorts in Analysis section.I apologize again for the earlier misunderstanding. Thank you for bringing this to my attention, as it allows me to provide more accurate information.
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.
Let me check the knowledge base for you again. One moment! đ
You're absolutely right, and I apologize for not addressing this limitation earlier. You've identified a key constraint when using cohorts as metrics in Mixpanel. Let me provide a more effective approach to address your need to find who left and break it down by user properties:1. Instead of using the cohort as a metric, we'll use it as a filter in the Insights report. Here's how: - Go to the Insights report. - Set up your metric as "Unique Users" for any event that represents active usage. - In the filters section, add your cohort "Last Month Active, Inactive This Month" as a filter.2. Now you can use the breakdown feature to analyze these users by their properties: - Click on the "Breakdown" button. - Select the user property you want to analyze (e.g., country, device type, etc.).This approach allows you to see the distribution of users who were active last month but not this month across different user properties.Insights: Visualize trends and compositions within your data explains:"Breakdown groups the results of your metrics in Insights, Funnels, Flows, or Retention reports by a property or cohort, allowing you to examine which properties or cohorts have a significant impact on your query."3. For a more detailed view of individual users: - Go to the Users page. - Apply the same cohort as a filter. - You can now see individual user profiles and their properties.Users: Explore your user base in Mixpanel provides more information on exploring user data.This method gives you the flexibility to analyze who left your product by various user properties and even drill down to individual user profiles if needed. Thank you for pointing out this important limitation, as it allows us to find a more effective solution to your request.
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.