Mixpanel Community Icon

Creating a Cohort Chart of User Engagement Over 20 Weeks

·
·

how do i create a chart of the past 20 weeks broken down by the cohort of users who did an event in that week, didn't do the event in the previous week, but had already done the event on any of the previous weeks

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

    Hi Tiago A., 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
    ·
    ·

    To create the chart you're describing, you'll need to use Mixpanel's Insights report with specific cohort definitions and filters. Here's how you can approach this:1. First, create a cohort for users who have done the event at least once: Go to the Cohorts page and create a new cohort with the condition "Users who did [Your Event] at least 1 time ever".2. Then, in the Insights report, set up your chart as follows: - Set the time range to the past 20 weeks - Add your event as the metric - In the Filters section, add three conditions: a. Include the cohort you created in step 1 b. Exclude users who did the event in the previous week c. Include users who did the event in the current week3. Set the chart type to "Column" or "Bar" to visualize the weekly breakdown.4. Use the "Breakdown" feature to segment by week.This approach will give you a chart showing the number of users who did the event each week, excluding those who did it the previous week but including those who had done it before.However, it's important to note that creating this exact chart might be complex and may require some advanced usage of Mixpanel's features. The knowledge sources don't provide a step-by-step guide for this specific scenario.For more detailed information on creating cohorts and using them in analysis, you can refer to these Mixpanel documentation pages::LBKS[Cohorts:: Group users by demographic and behavior](https://docs.mixpanel.com/docs/users/cohorts) Using Cohorts in Analysis Discover InsightsIf you need further assistance or if this doesn't fully address your specific needs, I recommend reaching out to Mixpanel's support team for more tailored guidance.

    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.

  • Avatar of Tiago A.
    Tiago A.
    ·
    ·

    kapa.ai in step 2, how do i do these things

    b. Exclude users who did the event in the previous week c. Include users who did the event in the current week

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

    Let me check the knowledge base for you again. One moment! đź“š

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

    To accomplish steps 2b and 2c in the Insights report, you'll need to use Mixpanel's advanced filtering options. Here's how you can do this:1. In the Insights report, click on the "Filter" button to open the filter menu.2. To exclude users who did the event in the previous week (step 2b): - Click on "Add filter" - Select "Behavioral Properties" from the dropdown - Choose "Frequency per User" - Select your event - Set the time range to "In the last 7-14 days" (this represents the previous week) - Set the condition to "equals 0"3. To include users who did the event in the current week (step 2c): - Click on "Add filter" again - Select "Behavioral Properties" from the dropdown - Choose "Frequency per User" - Select your event - Set the time range to "In the last 7 days" (this represents the current week) - Set the condition to "greater than 0"These steps utilize Mixpanel's Behavioral Properties feature, which allows you to filter users based on their past behavior. The "Frequency per User" option lets you specify the number of times a user performed an event within a given time range.For more detailed information on using advanced filters and behavioral properties in Mixpanel, you can refer to these documentation pages:Advanced Filter & Breakdown Usage Behavioral PropertiesRemember that the exact steps might vary slightly depending on your Mixpanel version and project setup. If you encounter any difficulties, it's recommended to consult Mixpanel's support team for more specific guidance.

    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.

  • Avatar of Tiago A.
    Tiago A.
    ·
    ·

    there's no option to "Set the time range" when filtering by the "Frequency per User" kapa.ai

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

    Let me check the knowledge base for you again. One moment! đź“š

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

    I apologize for the confusion in my previous response. You're correct, and thank you for pointing that out. Let me provide a more accurate explanation based on the current Mixpanel interface.When using the "Frequency per User" behavioral property, you don't directly set a time range within the filter itself. Instead, the time range is determined by the overall report date range and the interval you're analyzing. Here's how you can adjust your approach:1. First, set the overall date range of your Insights report to the past 20 weeks.2. To exclude users who did the event in the previous week and include those who did it in the current week, you'll need to use a combination of filters and possibly custom events. Here's an approach you can try: a. Create a custom event for "Did event this week but not last week": - Go to "Events" in the left sidebar - Click "Create Custom Event" - Set up a condition where the user did your event in the last 7 days (current week) AND did not do the event in the last 7-14 days (previous week) b. Use this custom event in your Insights report3. If custom events are not available in your plan, you can try using the "Add filter" option in Insights: - Click "Add filter" - Choose "Behavioral Properties" - Select "Frequency per User" - Set it to "greater than 0" for your event - In the same filter, add another condition for the same event, set to "equals 0" - The time periods for these conditions will be based on your report's overall date range and interval settingsIt's important to note that the exact implementation might vary depending on your specific Mixpanel setup and the version you're using. For more detailed information on using behavioral properties and custom events in Mixpanel, you can refer to these documentation pages:Behavioral Properties Custom EventsIf you're still having trouble setting this up, I recommend reaching out to Mixpanel's support team for more specific guidance tailored to your account and use case.

    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.