Extend your user profile with historic data in Mixpanel

[@rankaujjwal]

Hey Timo great video! Had a doubt or wanted a confirmation actually for User Properties Let's say I don't connect to DW Question : For a product, let's say I want to get amount spend in SF in last 1 year by users. There is a User123 who spent some time in SF (6 months) and in California in the next 6 months. Now, the location variable will be updated. Ideally if I take 1 year time duration, this will lead to all amount being allocated to California. Or if i calculated number of user X city, then this User123 should be counted in both but as per Mixpanel's implementation this would be counted in California right? (Want to confirm on this understanding :) ) I know I can pass location as event property with amount as a solution. The reason I said no DW. Cause this requires good data at the source or at my end and we have identified some issues with it which will take some sweet time to resolve : (. Also good edits, zooming etc on a couple of elements + great explanation with the diagrams!

[@timodechau]

When I got your scenario right, I would solve it with events only, like a purchase event with the amount and the state providing the properties. This should get you the right calculation. It could also been done with user properties, but it would be not really efficient to do so.