Hello kapa.ai How do i find the list of user whose DOB is not set in user listing?
To find the list of users whose DOB (Date of Birth) is not set in Mixpanel's user listing, you can filter users where the DOB property is "undefined" or "null." In Mixpanel, if a user profile property like DOB is not set, it will appear as “undefined” or “null” in reports. You can exclude all users where DOB is set, or directly filter for users where DOB is not set.Here’s how you can do this: 1. Go to the Users page in Mixpanel.
2. Add a filter for the DOB property.
3. Set the filter to show users where DOB “is not set” (this will include both undefined and null values).Alternatively, in Insights or other reports, you can segment or filter by the DOB property and exclude all values except “undefined” or “null” to see users without a DOB set. These values are parsed as (not set)
in the UI, but represent users missing that property in their profile data. You can also export this list if needed by using the export feature on the Users page or in the View Users overlay Docs: Supported Properties Data Type Docs: Users.Note: If you want to download this list, simply use the Export icon on the Users page after applying your filter.Let me know if you need step-by-step instructions for a specific Mixpanel 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.