After Mixpanel is successfully connected to your Stitch account, you'll have the ability to select individual tables to sync to your data warehouse. In this article, we'll cover:
By default, a historical sync of Mixpanel data goes back 7 days from the Stitch connection date.
We are able to replicate data older than 7 days, but note that the amount of data Stitch may have to replicate can be massive and can use up a lot of your monthly row quota. See the Replication Method section below for more detail.
Stitch will replicate Mixpanel data based on the frequency you define. The default setting is every 30 minutes, but due to the potentially high number of rows for each replication attempt, we recommend changing it to something less frequent to keep your row count down.
The Replication Method section below details how each Mixpanel table is replicated - consider this when setting the Replication Frequency.
When Stitch replicates Mixpanel data, the following tables are replicated using Incremental Replication:
Additionally, these tables can only be queried by day. This means that every time Stitch runs a replication job for Mixpanel, the past day's worth of data for these tables will be replicated.
The other Mixpanel table -
mixpanel_engage - uses Full Table Replication. This means that every time Mixpanel data is queued for replication, all rows - new, existing, and updated - will be replicated to your data warehouse.
After the Mixpanel setup is complete, the following tables will be created in your data warehouse.
This is not an exhaustive list of tables - we're only focusing on the top-level tables in this doc. Because Mixpanel uses nested arrays to structure data in some of its API's endpoints, there may be sub-tables due to the way Stitch deconstructs nested data structures. Refer to the Handling of Nested Data Structures doc for more info.
Click a table name to full a full list of attributes for that table in Mixpanel's API documentation.
mixpanel_engage table contains information from People Analytics, which will enable you to do user-level analysis.
Attributes include the distinct ID, app ID, client ID, browser info, city, country code, email address, first and last name, initial referrer, initial referring domain, last seen, OS, region, timezone, user ID,
mixpanel_export table contains raw event data.
Attributes include the event, time, distinct ID, country code, browser info, city, current URL, initial referrer, initial referring domain, OS, region, screen height and width, and time.
Primary Key: funnel_id :date
mixpanel_funnels table contains information about your funnels.
Attributes include the funnel ID, name, length (the number of days users have to complete the funnel), and beginning and ending dates.