Mixpanel Community Icon

Creating a Cohort Retention Chart for 7-Day Retention Analysis

·
·

How can I create a cohort retention chart where I can see 7 day retention for each weeks cohort

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

    Hi Daniel D., 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 a cohort retention chart showing 7-day retention for each week's cohort in Mixpanel, you can follow these steps: 1. Go to the Retention report in Mixpanel.2. Define your Retention Behavior: - Set the first event (A event) to the action that defines your cohort, such as "Sign Up Completed" or any other relevant event. - Set the second event (B event) to "Any Event" or a specific event you want to track for retention.3. Set up the Retention Criteria: - Under "Retention Criteria", select "Each Week" as the time unit. - Set the retention period to 7 days.4. Choose your Measurement: - By default, it will be set to "Retention Rate". You can keep this or change it to "Unique Users" if you prefer absolute numbers.5. Set the date range: - Choose a date range that covers multiple weeks to see retention for different weekly cohorts.6. Visualize the data: - Select "Retention Curve" as your visualization type.This setup will show you the 7-day retention rate for each weekly cohort. Each row in the resulting chart will represent a different week's cohort, and the columns will show the retention rate after 7 days.For more detailed instructions and advanced options, you can refer to the Mixpanel Retention documentation.Remember that you can further customize your report by adding filters or breakdowns if needed. For example, you might want to filter for specific user segments or break down the retention by user properties.

    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.