is there a Mixpanel property that stores when a user signed up?
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
Mixpanel does not automatically create a built-in property that stores the exact time when a user signed up. However, it is a common best practice to track a custom property such as signup_date or similar when a user completes the sign-up process. This property should be set by your implementation—typically as a user property on the profile—at the moment of sign-up. You can then use this property for analysis, such as filtering or cohorting users by their sign-up date.For example, in JQL queries, you might see references to a signup_date property, but this is only available if you have explicitly set it in your tracking code or user profile updates: LBKSfunction main() { // get all users who signed up in 2016 return People( ).filter(function(user){ return user.properties.signup_date > = new Date("2016-01-01") && user.properties.signup_date < new Date("2017-01-01"); }); }LBKS
This example assumes you are setting signup_date as a user property at sign-up time. If you want to analyze sign-up events, you should also track a "Sign Up" event and include relevant properties such as the timestamp and any other context you need <https://docs.mixpanel.com/docs/data-structure/events-and-properties|Events and Properties>.In summary: Mixpanel does not provide a default "sign up date" property, but you can and should set one yourself as part of your implementation if you need to track when users signed up Tracking Plan Methodology.
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.