Filtering Users Active on Two Separate Days Within Their First Week
How do I Filter for users who have been active on at least 2 separate days within their first week.
How do I Filter for users who have been active on at least 2 separate days within their first week.
Hi Gabriel W., 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
You can do this with the Retention → Frequency view, using a 1‑week window and cumulative frequency:
1. Go to Reports → Retention. 2. In the top toggle, switch from Retention to Frequency. [Frequency view] 3. Set: - Event: the activity that defines “active” (e.g. “Any event” or a key engagement event). - Interval unit: Week. - Retention window: 1 week (so you’re looking at behavior in the first week after the starting event). 4. Under Frequency Criteria, choose Cumulative Frequency (users who did the event in at least X unique intervals). [Frequency view] 5. Look at / filter for the bucket “≥ 2 unique days” (or the “2+” bucket, depending on UI wording) — this represents users who were active on at least 2 separate days within that week.
If you need this as a reusable segment, you can save the “≥ 2 unique days in first week” bucket as a cohort from the Retention report and then use that cohort to filter other analyses. [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.
i dont understand where i find these options in step 5 kapa.ai
Let me check the knowledge base for you again. One moment! 📚
You’re right to be confused here — the knowledge I have only explains what Frequency view and Frequency Criteria are, not exactly where each control is in the UI, so I can’t point you to precise button labels or screenshots. [Frequency view]
From the docs, here’s what is clear and how it maps to your goal:
1. Open Retention and switch to Frequency view
- Go to Reports → Retention. - In that report, there is a toggle that lets you choose Retention vs Frequency; the docs say: “select the Frequency option under the toggle for retention.” [Frequency view]
2. What Frequency view is doing
- Frequency view “groups unique users in time‑incremented buckets when they first complete an action, and then groups those same users in subsequent buckets when they return and perform the same or different actions.” - The buckets measure how many unique time buckets a user was active: - unique hours in a day - unique days in a week - unique days in a month [Frequency view]
For your case (“at least 2 separate days within their first week”), you’d be looking at: - Interval = week - Buckets = number of unique days in that week a user was active.
3. Frequency Criteria (the “at least 2 days” part)
The docs define two options: [Frequency view]
- Cumulative Frequency = users who did the event in at least X unique intervals. - Non‑cumulative Frequency = users who did the event in exactly X unique intervals.
To get “at least 2 separate days” you want Cumulative Frequency with X = 2 (i.e. “≥ 2 unique days”).
Because the docs don’t show the exact UI layout, I can’t tell you the exact label or panel where “Cumulative Frequency” and the “2 days” selector appear. They are part of the Frequency Criteria section in the Retention → Frequency view, but the precise clicks are not documented.
If you’d like, you can share a screenshot of your Retention → Frequency screen, and I can point out which control corresponds to “Cumulative Frequency” and where you’d set “2 days” based on what’s visible.
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.
okay wait kapa.ai so my settings are: In the last 30 days View - Week / Graph - Frequency Curve Query Event_Name Frequency - Cumulative Frequeceny # User Retention Rate All Groups and the values outputted (Data) is a 2x2 with Date, total profiles, 2 Day, 3Day, 4Day, 5Day, 6Day, 7Day in the top row and weighted average frequency, 100%, 31%, 14%, 7%, 4%, 2%, 1% Do I understand correctly this is the % of users who did the event at least 2 Days but not in a row, 3 Day, 4 Day and so on?
Let me check the knowledge base for you again. One moment! 📚
Yes, your interpretation is essentially correct.
In Frequency view with Cumulative Frequency:
- The buckets (2 Day, 3 Day, … 7 Day) represent “did the event in at least X unique days within the week”, not necessarily on consecutive days. [Frequency view] - Because it’s cumulative, the “3 Day” bucket includes users who did the event on 3 or more unique days in that week; “4 Day” = 4 or more unique days, etc. [Frequency view]
So, reading your row:
- 2 Day = 100% → 100% of users did the event on at least 2 distinct days in the week. - 3 Day = 31% → 31% did it on at least 3 distinct days (not necessarily in a row). - 4 Day = 14% → 14% did it on at least 4 distinct days, and so on.
If you instead wanted “exactly 2 days / exactly 3 days”, you’d switch Frequency to Non‑cumulative Frequency, which “calculates the number of users who did the event in exactly X unique intervals.” [Frequency view]
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.