In this article, we’ll explore the main data tables that you can import from Mixpanel into your Magento BI account. The following tables will be created in your data warehouse after connecting Mixpanel. To view all the fields available for tracking, click the links in the table name column.
Note that due to the limitations of Mixpanel's API, historical data - data older than seven (7) days from the date of connection to Magento BI - will not be replicated.
|mixpanel_export||This table contains raw event data, including the event, event dates, and platform bucket.|
|mixpanel_funnels||This table contains data about your funnels, including the funnel ID, the funnel length (# of days the user has to complete the funnel), and the starting and ending dates of the funnel.|
|mixpanel_engage||This contains data from People Analytics, including session IDs, page and user information, and the date/time the user was last seen.|