Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Expected Mixpanel Data

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:

Replicating Mixpanel Data

Historical Sync

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.

Frequency

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.

Replication Method

When Stitch replicates Mixpanel data, the following tables are replicated using Incremental Replication: 

  • mixpanel_export
  • mixpanel_funnels

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.

Mixpanel Tables in 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
Primary Key:
mp_reserved_distinct_id

The 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
Primary Key:
event:time:distinct_id:_sdc_record_hash

The 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.

mixpanel_funnels
Primary Key: 
funnel_id :date

The 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.

Related

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!