Hi! I need to create a daily alert to check if any of my users who purchased a subscription did not receive their first question email within 7 days after the purchase date. The alert should run daily and send a list of such users. I have an event for subscription purchase called checkout_success and an event for when the email is sent called question_email_sent.
Hi Serhii 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
Short answer: Mixpanel Alerts can watch a metric and notify you, but they don’t send lists of users. You can approximate this by building a daily “missing email within 7 days” metric and alerting when it’s > 0, then click through to view users. If you specifically need an emailed list, the knowledge sources don’t show support for sending user lists via alerts.How to set up the metric and alert in Mixpanel: 1) Build a cohort: “Purchased but no email within 7 days” - Users who did checkout_success in the last 7 days AND - Did not do question_email_sent within 7 days after doing checkout_success Save as a cohort. You can create cohorts via the Cohort Builder and use behavioral conditions like “did event” and “did not do” with time constraints (cohorts group users by behavior and can be built from reports; examples include frequency and time-window logic) (Cohorts).2) Create an Insights report to count the cohort daily - Measure Unique Users for that cohort over time (daily). Insights supports user counts like DAU/WAU/MAU and unique users; using a daily time bucket will give a daily line of users who match the cohort (Insights: Users).3) Add an Alert on the report - Save the report, then create an alert. - Use a Custom Threshold: “Above 0” with daily notification frequency. This will notify you on days when there are any users missing the email within 7 days. Alerts are available on Insights, can be delivered via email or Slack, and support custom thresholds; anomaly detection is optional and limited to certain chart types (Alerts overview, Alert criteria).What you’ll get - An alert when the metric > 0. From the alerted report point, use “View Users” to see and export the user list that triggered the count that day (creating cohorts from report points and viewing users is supported) (Creating cohorts via a report).Limitations - Alerts don’t email an attached user list per the docs; they notify when conditions are met. You can click through to view/export users after receiving the alert. If you need automated list delivery, the knowledge sources do not mention such a feature.
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.
how to create that cohort?
Let me check the knowledge base for you again. One moment! đź“š
Here’s how to build a cohort of users who purchased but did not get the first question email within 7 days: - Open Cohort Builder: Users > Create Cohort (or from any report via Create Custom > Cohort) (Creating Cohorts).- Define conditions: 1) Users who did checkout_success within the last 7 days 2) AND did not do question_email_sent within 7 days after doing checkout_success In the builder, use “Users who did <event> ” and “Users who did not do <event> ” conditions with time constraints. Cohorts support combining event-behavior rules with AND/OR and time windows to precisely define membership (Creating Cohorts).- Save and name the cohort (e.g., “Purchased — No Question Email in 7d”). The cohort computes dynamically each time it’s used, reflecting who matches the criteria right now, not a static snapshot (How Cohorts are Computed).Tips: - You can also create it from a report point via “View Users,” then save as a cohort if that’s more convenient (Creating cohorts via a report).
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! đź“š
You can build it in the Cohort Builder with two behavior rules combined by AND: - Users who did checkout_success (the “first event”) - AND Users who did not do question_email_sent within 7 days after doing checkout_successCreate it via Users > Create Cohort (or Create Custom > Cohort from any report). In the builder, define “did <event> ” and “did not do <event> ” conditions with the time window relative to the first event, then save the cohort (you can chain rules with AND/OR) (Creating Cohorts). Tip: You can also select users from a report point via View Users and save as a cohort if that’s easier (Creating cohorts via a report).
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! đź“š
Mixpanel supports time‑bounded cohort rules, but the docs don’t show an explicit UI screenshot/text for “within N days after <event> ” in the Cohort Builder. I’m sorry, but the knowledge sources don’t explicitly detail the exact clicks/fields to set “within 7 days after checkout_success” inside the cohort UI.Workarounds supported by the docs: - Create the cohort from a report point where the time relationship is defined, then “View Users” and save as a cohort. For example, build a Retention report with “A: checkout_success” and “B: question_email_sent,” set a 7‑day window/criteria, click the relevant cell/bar, then “View Users,” and save that selection as a cohort. You can then invert to “did not do” by selecting the non‑retained segment before saving (creating cohorts via reports is supported) (Creating cohorts via a report, Retention criteria overview).- Use Retention with “On or Before” and a 7‑day measurement to define those who did receive the email in 7 days; click “View Users” to save that as a cohort, then use NOT this cohort when alerting or in Insights to get “did not receive” (Retention criteria “On or Before” measures activity between start and end events within the window) (Retention Criteria).If you prefer the Cohort Builder directly, you can define: - Users who did checkout_success - AND Users who did not do question_email_sent in the 7 days after that But the docs provided don’t show the exact UI control names to set “after doing A” for the second rule; they only state cohorts can be built with behavioral “did/did not do” conditions and time constraints (e.g., “in the last 7 days,” “first time in past 30 days”) (Creating Cohorts).
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.
