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.
