You can measure login streaks and “days since last login” with the Retention report’s criteria, then refine with filters/breakdowns:
- Streaks (consecutive logins)
- Set A = “Login” and B = “Login”
- Retention Criteria = Streak mode
- Measurement = Unique Users; choose the number of consecutive days you care about (e.g., 5 days) ("Retention Criteria").
This counts users who logged in on consecutive day intervals since their first login (birth). If A and B are the same event, day 0 counts toward the streak ("Retention Criteria").
- “Hasn’t logged in for N days” (e.g., 24h/2/3/4/5 days since last login)
- Use Retention with A = “Login” and B = “Login”
- Retention Criteria = On (exact day buckets) or Custom Retention Brackets to group day ranges (e.g., Days 1–1, 2–2, 3–3, 4–4, 5–5) ("Custom Retention Brackets").
- Interpret the complement: users in Day N “Login” are those who did log in on that day; users not retained in Day N (and not in earlier days) are those who have not logged in for N days since A. Custom brackets let you view ranges compactly (e.g., Days 1–5). Note: Mixpanel reports retention (who did come back), not “non-retention,” so you’ll infer “hasn’t logged in” from the absence in those buckets. The docs do not describe a direct “days since last event” metric in Retention.
- Monday–Friday only (exclude weekends)
- Switch Retention to Calendar Retention Mode so buckets align to calendar days/weeks; this is helpful when evaluating behavior tied to specific calendar periods ("Calendar Retention Mode").
- Then filter your A (and optionally B) events to weekdays using event properties that denote day-of-week, if you capture them. The provided docs don’t detail a built-in weekday filter; they only show general filtering and date controls. If you need strictly Mon–Fri streaks (ignoring weekends), calendar mode aligns buckets to calendar days, but the docs don’t explicitly confirm an automatic “exclude weekends” toggle. You may need to apply filters to limit events to weekdays and/or use weekly calendar buckets and interpret within-business days. The knowledge sources do not explicitly document a native “exclude weekends” switch.
Limits/notes:
- For exact daily windows beyond 60 days, day-based Retention is capped at 60 days; use week/month buckets to look further out ("FAQ").
