Creating a User Cohort by Signup Time Range
how can I create a cohort of users that signed up between an specific range of hours during the days
how can I create a cohort of users that signed up between an specific range of hours during the days
Hi Juan I., 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
The knowledge sources don’t describe a built‑in way in the Cohort Builder UI to filter users by hour-of-day of signup; they only cover date‑based ranges (days, weeks, months) and general cohort creation. [Cohorts; Date range]
What is documented:
- You can create cohorts based on:
- “Users who did <event> in the last X days / between dates”
- “Users where <profile property> equals / is between values” [Cohorts]
- Date ranges in reports (and thus in “did event” filters) are day‑level, not hour‑level, in the standard UI. [Date range]
Because there’s no explicit mention of hour‑of‑day filters for cohorts in the provided docs, I can’t confidently give you a step‑by‑step UI recipe for “signed up between 14::00–18::00 each day.”
What you can do with what’s documented:
1. If you already have an hour‑level property (e.g. a user property like signup_hour or an event property you later copied to the profile):
- In the Cohort Builder, define:
- “Users who did Sign Up” (or your signup event) in the desired date range, AND
- “Users where profile property signup_hour is between X and Y”.
- This pattern (event condition + profile property condition) is supported. [Cohorts]
2. If you don’t have such a property yet, the docs here don’t cover how to derive and persist an hour‑of‑day field (e.g. via ETL or JQL backfill), so I can’t describe that process based on the sources.
So, with the information available:
- Creating a cohort “users who signed up between specific hours of the day” is possible if you have (or create outside the scope of these docs) an hour‑of‑day property and then use it in the Cohort Builder alongside your signup event filter. - The knowledge sources do not explicitly document a native, hour‑of‑day picker or time‑of‑day filter for cohorts, only date‑based ranges.
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.