How can I track login in streaks? How can I see when a user hasn't logged in in 24 hours, hasn't logged in 2 days, hasn't logged in 3 days, hasn't logged in 4 days, and hasn't logged in 5 days - also how do I exclude weekends? So it only tracks Monday through Friday?
Hi Rafael 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
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").
- You can also define “On or After” if you want cumulative come-back rates, but for “hasn’t logged in N days” use “On” or custom brackets ("Retention Criteria", "Custom Retention Brackets").
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.
