Cohort Analysis Criteria for Delivery App Users: Validity Check

I'm doing cohort analysis for Dormant User, New User, Resurrected User, and Retained User for a delivery app. My criteria is: Dormant User

Criteria:

Users who did not do "Place Order" in the last 30 days.
AND Users who did "Place Order" at least once in the 30 days ending 30 days ago.

New User

Criteria:

Users who did "Place Order" in the last 30 days.

For the first time ever.

Resurrected User

Criteria:

Users who did "Place Order" at least once in the last 30 days.
AND Users who did not do "Place Order" in the 30 days ending 30 days ago.
AND Users who did "Place Order" at least once in the last 365 days ending 60 days ago.

Retained User

Criteria:

Users who did "Place Order" at least once in the last 30 days.
AND Users who did "Place Order" at least once in the 30 days ending 30 days ago.

Is there something wrong in my criteria of doing these cohorts? Think step by step.

2 comments

kapa.ai
APP
·
·
Hi Mohamed B., 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
kapa.ai
APP
·
·
To analyze your cohort criteria for a delivery app, let's examine each cohort definition step by step:1. Dormant User: Your criteria look correct. It captures users who were active 30-60 days ago but have not been active in the last 30 days.2. New User: This criteria is also correct. It identifies users who placed their first order ever within the last 30 days.3. Resurrected User: This definition is mostly correct, but there's a small issue: - The first two conditions are correct: active in the last 30 days, inactive in the 30 days before that. - However, the last condition "Users who did 'Place Order' at least once in the last 365 days ending 60 days ago" might be too restrictive. It excludes users who were inactive for more than a year before becoming active again. Consider changing it to "Users who did 'Place Order' at least once before the last 60 days" to include all resurrected users, regardless of how long they were inactive.4. Retained User: This criteria is correct. It captures users who were active both in the last 30 days and in the 30 days before that.Overall, your cohort definitions are well-thought-out and mostly correct. The only suggestion would be to adjust the Resurrected User criteria as mentioned above.To implement these cohorts in Mixpanel, you can use the Cohort Builder. According to Mixpanel's documentation on Cohorts, you can create cohorts based on precise sets of conditions, including users who did or did not perform certain events within specific time frames.For example, to create the Dormant User cohort, you would: 1. Use the condition "Users who did not do 'Place Order' in the last 30 days" 2. AND "Users who did 'Place Order' at least once in the 30 days ending 30 days ago"Mixpanel's Cohort Builder allows for this level of specificity in defining user groups based on their behavior over time.
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.