Skip to main content

Mixpanel

This page contains the setup guide and reference information for the Mixpanel source connector.

Prerequisites​

To set up the Mixpanel source connector, you'll need a Mixpanel Service Account and it's Project ID, the Project Timezone, and the Project region (US or EU).

Set up the Mixpanel connector in Calabi Connect​

  1. Log into your Calabi Connect or navigate to the Calabi Connect dashboard.
  2. Click Sources and then click + New source.
  3. On the Set up the source page, select Mixpanel from the Source type dropdown.
  4. Enter the name for the Mixpanel connector.
  5. For Authentication, select Service Account from the dropdown and enter the Mixpanel Service Account secret.
  6. For Project ID, enter the Mixpanel Project ID.
  7. For Attribution Window, enter the number of days for the length of the attribution window.
  8. For Project Timezone, enter the timezone for your Mixpanel project.
  9. For Start Date, enter the date in YYYY-MM-DD format. The data added on and after this date will be replicated. If left blank, the connector will replicate data from up to one year ago by default.
  10. For End Date, enter the date in YYYY-MM-DD format.
  11. For Region, enter the region for your Mixpanel project.
  12. For Date slicing window, enter the number of days to slice through data. If you encounter RAM usage issues due to a huge amount of data in each window, try using a lower value for this parameter.
  13. For Export Lookback Window, enter the number of seconds to look back from the last synced timestamp during incremental syncs of the Export stream. This ensures no data is missed due to event recording delays. Default is 0 seconds.
  14. Click Set up source.

Supported sync modes​

The Mixpanel source connector supports the following sync modes:

Note: Incremental sync returns duplicated (old records) for the state date due to API filter limitation, which is granular to the whole day only.

Supported Streams​

Primary key selection for Export stream​

Mixpanel recommends using [insert_id, event_time, event_name, distinct_id] as the primary key. However, note that some rows might lack an insert_id for certain users. Ensure you select a primary key that aligns with your data.

Performance considerations​

Syncing huge date windows may take longer due to Mixpanel's low API rate-limits (60 reqs per hour).