kapa.ai Hi, I'm currently working with Mixpanel and encountering an issue related to user properties. I have stored a user property as an object, which contains two parts:
A numeric value
A date/time value
However, Mixpanel does not support using object-type properties in retention charts, which is limiting my ability to filter based on the numeric part of this property. My goal is to use the numeric value as a filter in retention analysis, but due to the object format, Mixpanel doesn't allow this. Is there an appropriate or recommended way to handle this scenario in Mixpanel? For example:
Should I store the numeric and date/time values as separate properties instead of a single object?
Is there any workaround to extract or reference the numeric part for filtering?
Any guidance would be greatly appreciated.
You're correct that Mixpanel has limited support for object-type properties, especially when it comes to using them in filters or breakdowns for reports like retention. Specifically, while objects can be used in some core reports as filters and breakdowns, their keys (i.e., the individual parts of the object) are not fully supported in the UI, and you cannot directly filter on a nested value within an object property in retention analysis Supported Properties Data Type - Overview.Recommended Approach:Summary: To enable filtering on the numeric value in retention charts, you should store the numeric and date/time values as separate properties rather than as parts of an object. This will make your data fully compatible with Mixpanel’s analysis features and avoid the limitations of object-type properties in the UI Supported Properties Data Type - Overview.If you have already ingested data as an object, you would need to update your tracking implementation to send these as separate properties going forward. There is no workaround in the UI or via custom properties to extract a nested value from an object for use in retention filters.
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.
