Skip to content
sandadocs
Console Start free trial

Mixpanel

Connect Mixpanel to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.

View as Markdown

Connect Mixpanel

  1. Open the catalogue. In the console, go to Data · Connections and press New connection.
  2. Choose Mixpanel. It is listed under marketing and analytics; you can also search for it by name.
  3. Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
  4. Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
  5. Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.

Configuration fields

What the connection form asks for. Required fields are marked; the rest are optional.

Field Type Required Description
Authentication one of 2 options Yes Choose how to authenticate to Mixpanel.
Attribution Window integer No A period of time for attributing results to ads and the lookback period after those actions occur during which ad results are counted. Default attribution window is 5 days. (This value should be non-negative integer). Default 5.
Project Timezone string No Time zone in which integer date times are stored. The project timezone may be found in the project settings in the Mixpanel console. Default US/Pacific.
Select Properties By Default boolean No Setting this config parameter to TRUE ensures that new properties on events and engage records are captured. Otherwise new properties will be ignored. Default true.
Start Date string No The date in the format YYYY-MM-DD. Any data before this date will not be replicated. If this option is not set, the connector will replicate data from up to one year ago by default.
End Date string No The date in the format YYYY-MM-DD. Any data after this date will not be replicated. Left empty to always sync to most recent date.
Region string No The region of mixpanel domain instance either US or EU. One of US, EU. Default US.
Date slicing window integer No Defines window size in days, that used to slice through data. You can reduce it, if amount of data in each window is too big for your environment. (This value should be positive integer). Default 30.
Page Size integer No The number of records to fetch per request for the engage stream. Default is 1000. If you are experiencing long sync times with this stream, try increasing this value. Default 1000.
Export Lookback Window integer No 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 delays in event recording. Default is 0 seconds. Must be a non-negative integer. Default 0.
Number of concurrent threads integer No The number of worker threads to use for the sync. The performance upper boundary is based on the limit of your Mixpanel pricing plan. Default 3.

Authentication

Choose how to authenticate to Mixpanel.

Choose one of the following. Each asks for its own fields.

Service Account

Field Type Required Description
Username string Yes Mixpanel Service Account Username.
Secret string, secret Yes Mixpanel Service Account Secret.
Project ID integer Yes Your project ID number.

Project Secret

Field Type Required Description
Project Secret string, secret Yes Mixpanel project secret.

Something unclear or out of date? Tell us, and we will fix the page.