what is "on or before" ?

Hi Finn 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> 👋

"On or Before" is a retention criteria used in Mixpanel's analytics platform. It is most commonly used with measurement types of property sum or average. This criteria looks at the total activity done during the period between the start and end event.

For instance, if you want to look at the 30 Day Lifetime Value (LTV) of e-commerce users, you would look at the total money spent on purchases from sign-up for 30 Days. This includes looking at revenue spent from Day 0, Day 1, up to Day 30, where revenue is a property on the event purchase. Similarly, if you want to look at the 30 day Average Revenue Per User (ARPU), you would look at averaging the total revenue spent per user within the first 30 days.

You can find more information about this in the Mixpanel Documentation.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.