Question

How to join user profile and event data from the API?

  • 25 October 2019
  • 2 replies
  • 199 views

Badge

Using the Mixpanel API, we can export raw events using the 'Event Export API' (https://data.mixpanel.com/api/2.0/export) and user profile data through https://mixpanel.com/api/2.0/engage.


What I would like is a reference (a foreign key field of some sorts) on every raw event to the user who 'performed' or 'caused' this event. This is supported in the interface of Mixpanel itself, but I can't seem to find out how to get this from the API.


Thanks in advance!




2 replies

Badge

Bump? :)


Userlevel 3
Badge

Hey there @lennartk,

I believe what can help connect exported events to user profiles would be the distinct ID. If you are using the their 2.0 Export API to export events, the distinct_id value can be used to map back to user profiles.



Reply