We are setting up Mixpanel with a Data Studio report, and we currently use Google Big Query with all the data from the mixpanel_engage table.
The problem is that there are many thousands rows more than there are people in our Mixpanel account, where many of the rows are duplicated.
I tried to find some documentation or figure out how exactly this data is stored to understand how we can replicate the data we see in the People - Explore functionality.
Why are there so many rows duplicated - is it that every time a new property gets set, a new row is inserted?
How exactly should we query the data to get the current state of users? Is there some documentation on how the data is stored?