Mixpanel is headed to Money20/20 October 26 - 29 in Las Vegas, Nevada!

Optimizing MixPanel Data Structure for Company-Centric Analytics

Hey peeps! I have a question related to changing the data structure/mapping on MixPanel. We have a project where we'd like to follow certain companies. However, as is, instead of having the companies mapped as the users in MixPanel, we have the employees (typically 1 to 5) of these companies mapped as users. It makes our analytics a bit clunky as personnel change and we are not really interested in what a given company employee does, but more in what the company itself does. I asked a developer if it would be easy to change this, and he said that it would, but I would like to know if there is something to take into account here?

7 comments

· Sorted by Oldest

Andrew S.
·
·
You will want to make sure you have "Group Analytics" so you can set a separate key for your grouping vs users. e.g., in my case "Integration ID" or "Merchant Category".
Andrew S.
·
·
depending on the length of your history you may have to go back and export/transform/import your data into a new project to back populate this info into old events.
Santeri K.
·
·
Thanks for the reply Andrew! Group Analytics seems to be an add-on we don't have. I wonder if it's possible to alter the mapping in the past events retrospectively, without doing a full import
Andrew S.
·
·
Unfortunately events are immutable in Mixpanel so you have to do an export via the API, use text-edit or write a script to do the changes/additions, and then do an import.
Andrew S.
·
·
example script to do an export (need to setup a service account).
Andrew S.
·
·
when I did it recently, I took three separate projects, exported all events from each, appended "source" property to each JSONL object to represent which of the original projects it came from, and then imported the JSONL's to a new combined project. So I wrote a simple python script to add the "missing" property from each.
Santeri K.
·
·
Thank you very much!