is there a user profile property to see the user sign up datetime?
Hi Elena M., 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
Yes, there are a couple of ways to track user sign-up datetime in Mixpanel user profiles: 1. You can use the reserved profile property $created
which is specifically meant for storing when a profile was created. However, it's important to note that this property is not automatically populated - you need to set it manually when creating the user profile.2. Alternatively, Mixpanel automatically calculates a property called $mp_first_event_time
which represents "the time of the user's very first event in Mixpanel." If your sign-up event is the first event a user triggers, this property would effectively represent their sign-up time.For a custom implementation, you could also: 3. Create your own custom profile property (like "signup_date") and set it once using the $set_once
operation, which is useful for properties like "First login date" as it will not overwrite existing values.Reserved Properties documentation provides more details about the $created
property, and the documentation also mentions that timestamps in Mixpanel are ingested with millisecond precision but exported with second precision.
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.