Given user M triggered event A triggered on 9/10. User M has a user property of "Company name" = Apple. If User M's Company name user property is changed to Banana on 9/12, does that mean the use property on event A which triggered on 9/10 is also updated?
Yeah. So I have a property that I capture at the user level. that property updates with a track as their property value updates (e.g., "ratings count"). But I also have a property that I attach to an event to capture what existed at the time of the event. So when a user gives a rating, I attach "ratings count" to that event so I know for that rating, how many ratings did that user have. So. if they rated an 11th time, the user property would have 11 for the ratings count, but the event would have 10, because it was at 10 prior to that rating.
Ty Andrew. In your approach, I would be adding them as event properties, correct?
If you are relying upon the user property than anything having to do with that, User will reflect the new value of that property. If you add that property to the event, programmatically, grabbing it from the User and submitting it with the event track, then that property would reflect the company value at the time of the event
Yes, in Mixpanel, user profile properties (such as "Company name") are joined to events at query time, not at the time the event was ingested. This means that when you analyze event A (triggered on 9/10), it will display the latest value of the user property "Company name" as of your query—so if the property was changed to "Banana" on 9/12, event A will now show "Company name" = Banana, even though at the time of the event it was "Apple".If you need to analyze the value of a property as it was at the time of the event, you should track it as an event property, not just as a user profile property. User profile properties always reflect the most recent value, not the historical value at the time of the event Mixpanel Data Model | User Profiles FAQ.
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.
Hi Jorge C., 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