In mixpanel dashboard, is it possible to create a custom user property that accumulates distinct days they did an event?
Hi Howard A., 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
Based on the knowledge sources, Mixpanel allows you to create custom properties using its custom property builder, and you can use functions to compute values such as the number of days between two dates or extract information from event properties. However, the documentation does not explicitly state that you can create a custom user property that accumulates the distinct days a user performed a specific event and have this property persist on the user profile itself.You can, however, analyze the number of distinct days a user did an event within reports (such as Insights or Retention) using behavioral properties or frequency views. For example, you can segment users by the number of unique days they performed an event, but this is a virtual property used for analysis, not a persistent user property stored on the user profile. Custom properties are typically calculated on the fly for use in reports and are not automatically written back to user profiles as persistent properties Custom Properties: Calculate new properties on the fly Behavioral Properties.In summary: - You can analyze and segment users by the number of distinct days they performed an event using behavioral properties in reports. - There is no documented way to create a persistent custom user property on the user profile that accumulates this value automatically within the Mixpanel dashboard.If you need this as a persistent user property, you would need to calculate it externally (e.g., in your backend or via a scheduled job) and then update the user profile via the API.
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.
