Hello, I need a report that will find users that made at least one custom event in 2 distinct days over 30 days
Hi Bogdan S., 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 in Retention’s Frequency view: - Go to Reports → Retention → switch the toggle to Frequency. - Set the event to your custom event. - Set Interval to Week or Month (for 30-day period, choose Month). - Frequency Criteria: choose Cumulative (in at least). - Read the “unique days in a month” buckets and select the bucket “≥ 2” to see users who did the event on at least 2 distinct days within the month. You can then click a cell → View Users → Save as Cohort if needed (this saves that group). (See how Frequency buckets count unique days in a month and how to save from a report to a cohort) (Frequency View, Creating Cohorts).Notes: - Frequency counts “unique days in a month” when Interval is Month, which aligns with “2 distinct days over 30 days.” (Frequency View). - If you specifically need a rolling last 30 days window, set the report Date Range to “Last 30 days.” (Date Range).
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.
