How to Create a 3-Day Consecutive Activity Cohort on kapa.ai

Mohan D. · 2026-01-15T21:31:11.263Z

@kapa.ai How do I exactly create a cohort of people who've been active consecutively for 3 days on our app (only to be checked for first time when they have this streak e.g. After sign up first time they are on a streak for 3 days)

How to Create a 3-Day Consecutive Activity Cohort on kapa.ai | Mixpanel Community

3 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Please stand by Mohan D. 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
kapa.ai
APP
·
·
The knowledge sources don’t describe an out‑of‑the‑box “3‑day first streak” cohort recipe step‑by‑step, so I can’t give you an exact click‑path. They do describe the underlying retention “streak mode” concept you’d base this on.From the docs, “Streak mode” in Retention is meant to count users doing consecutive actions across time intervals (e.g. “played a game for 5 consecutive days since sign‑up”).[Retention criteria] In principle, your logic is: 1. Build a Retention report in Streak mode - A (birth) event: your “Sign Up” (or first key activation event). - B (return) event: your “Active” event (e.g. “App Opened” or whatever you use to define “active”). - Retention Criteria: set to Streak mode. - Time unit: Days. - Measurement: Unique Users. - Streak length: 3 days (3 consecutive days since the A event).[Retention criteria]2. Use that result to define a cohort - In the Retention report, click the cell/point that corresponds to users who achieved a 3‑day streak after sign‑up. - Click View Users, then Create/Save Cohort. This saves “users who have a 3‑day streak since sign‑up” as a cohort you can reuse elsewhere.[Define cohorts; Cohorts basics]3. “First time they have this streak” nuance - The docs explicitly cover “first time ever” filters for single events, not for streaks.[Filters] - There is no explicit description of a “first time 3‑day streak” toggle in cohorts or retention, so I cannot confirm you can automatically exclude users who later achieve additional 3‑day streaks. - Practically, the cohort you create from the Retention report will represent users who have that 3‑day streak; the docs don’t state a way to constrain it to “only the first time they ever achieve such a streak.”If you need it to be strictly “first time ever 3‑day streak,” the knowledge sources don’t describe a supported way to express that directly in the UI; they only describe streak counting in Retention and then turning any selected result into a cohort.
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.
Ansh A.
·
·
Mohan D. The retention chart has an option streak. You can utilize that.

kapa.ai
APP
·
·
Please stand by Mohan D. 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
kapa.ai
APP
·
·
The knowledge sources don’t describe an out‑of‑the‑box “3‑day first streak” cohort recipe step‑by‑step, so I can’t give you an exact click‑path. They do describe the underlying retention “streak mode” concept you’d base this on.From the docs, “Streak mode” in Retention is meant to count users doing consecutive actions across time intervals (e.g. “played a game for 5 consecutive days since sign‑up”).[Retention criteria] In principle, your logic is: 1. Build a Retention report in Streak mode - A (birth) event: your “Sign Up” (or first key activation event). - B (return) event: your “Active” event (e.g. “App Opened” or whatever you use to define “active”). - Retention Criteria: set to Streak mode. - Time unit: Days. - Measurement: Unique Users. - Streak length: 3 days (3 consecutive days since the A event).[Retention criteria]2. Use that result to define a cohort - In the Retention report, click the cell/point that corresponds to users who achieved a 3‑day streak after sign‑up. - Click View Users, then Create/Save Cohort. This saves “users who have a 3‑day streak since sign‑up” as a cohort you can reuse elsewhere.[Define cohorts; Cohorts basics]3. “First time they have this streak” nuance - The docs explicitly cover “first time ever” filters for single events, not for streaks.[Filters] - There is no explicit description of a “first time 3‑day streak” toggle in cohorts or retention, so I cannot confirm you can automatically exclude users who later achieve additional 3‑day streaks. - Practically, the cohort you create from the Retention report will represent users who have that 3‑day streak; the docs don’t state a way to constrain it to “only the first time they ever achieve such a streak.”If you need it to be strictly “first time ever 3‑day streak,” the knowledge sources don’t describe a supported way to express that directly in the UI; they only describe streak counting in Retention and then turning any selected result into a cohort.
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.
Ansh A.
·
·
Mohan D. The retention chart has an option streak. You can utilize that.