“When creating a cohort in Mixpanel for users who completed an order in the last 1 day, does it look at the calendar day (e.g., those who completed an order on the 28th), or does it look at the past 24 hours (e.g., from 6:40 on the 28th to 6:40 on the 29th)? Do you have any idea?”
Hi Selin T., 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
When you create a cohort in Mixpanel for users who completed an order "in the last 1 day," Mixpanel uses a rolling time window, not a strict calendar day. This means it looks at the past 24 hours from the current moment (e.g., from 6:40 on the 28th to 6:40 on the 29th), rather than just users who completed an order on the calendar day of the 28th.This behavior is consistent with how Mixpanel handles date ranges and cohort definitions. The "Last 1 day" preset includes results from the last complete 24 hours, plus any results from the current incomplete day, and is based on rolling intervals rather than fixed calendar days unless you specifically select a calendar-based mode (which is not the default for cohort creation) Docs / Reports Overview Docs / Users / Cohorts.If you want to use strict calendar days (e.g., all users who completed an order on the 28th, regardless of the time), you would need to use a "Fixed" date range rather than a rolling "Last" window. By default, however, Mixpanel cohorts with "last 1 day" use the rolling 24-hour window.
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.
Let me check the knowledge base for you again. One moment! 📚
When creating a cohort in Mixpanel for users who completed an order "in the last 1 day," Mixpanel uses a rolling time window—meaning it looks at the past 24 hours from the current moment, not just the calendar day (e.g., not just midnight to midnight of the 28th). So, if you create this cohort at 6:40 on the 29th, it will include users who completed an order from 6:40 on the 28th to 6:40 on the 29th.This is consistent with how Mixpanel handles "Last" date ranges, which are rolling and not fixed to calendar days unless you specifically select a "Fixed" date range. The default behavior for cohorts is to use the rolling window approach Docs / Reports Overview Docs / Users / Cohorts.If you want to target users based on a strict calendar day, you would need to use the "Fixed" date range option when defining your 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.
Let me check the knowledge base for you again. One moment! 📚
If you set the cohort date range as "last 1 day ending 1 day ago," Mixpanel will include users who completed an order during the 24-hour period that starts 48 hours ago and ends 24 hours ago from the current moment. For example, if it is currently June 30th at 6:40 AM, this setting would select users who completed an order between June 28th at 6:40 AM and June 29th at 6:40 AM.This approach uses a rolling window, not a calendar day, and the "ending" option allows you to shift the window back in time by a specified amount. This is described in the documentation under the "Last" date range with the + Ending button, which lets you shift the rolling window back by a selected number of days Docs / Reports Overview.
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.
