Mixpanel Connector Overview

• Mixpanel utilizes Fivetran’s Priority First sync strategy which syncs the most recent 30 days of Event data during the initial sync.
• Once the most recent 30 days of data has been synced, Fivetran will pull the historical data at regular intervals defined by the connector’s sync frequency
• For the Event and Transaction table Fivetran uses a timestamp as a primary key meaning all events and transactions result in a new row in their respective tables
• The Event table timestamp only supports date level granularity. This means we must re-import the table for each sync that occurs within a given day. Therefore, MAR for the Event table is the high water mark for that day and is not equal to the total number of records inserted for that day.
• For all other tables when Fivetran detects a change in the data, we update or insert (upsert) into the destination, overwriting old data
• Mixpanel does not support deletes
• Custom fields configured in Mixpanel will be captured and synced by Fivetran

What Contributes Towards MAR?

There are 4 primary actions that will contribute toward MAR:

1. A new record is inserted.
   1. For the Event and Transaction table Fivetran uses a timestamp as a primary key meaning all transactions result in a new row
2. An existing table is updated (CAMPAIGN or PEOPLE)
3. A new custom field is added for a table
4. The historical sync after the initial 30 days counts toward MAR

Managing MAR for this Connector

• Table level exclusion is possible but the data is likely valuable to the client
• Limit the events tracked in Mixpanel

Reference

• Mixpanel Connector Overview
• Consumption Based Pricing Overview
• Priority First Sync Overview