Mixpanel

Perform deeper analysis and better understand user behavior by bringing enriched customer data from your data warehouse into Mixpanel

Overview

Ideally, your data warehouse is the single source of truth for all your customer data. When that's the case, using your warehouse as the source for your Mixpanel data enables richer product-usage analysis. You can sync enriched data from your warehouse to create more granular segments on Mixpanel as well as bring in data from your engagement tools. Moreover, you can ensure that your product and growth teams work with data that's always up-to-date and in the expected format. Lastly, if your company also uses a Business Intelligence tool such as Looker or Mode, you can ensure that the data is consistent across both systems.

Supported syncing

• In Upsert mode, new users and groups are inserted into Mixpanel and all attributes are kept up-to-date.
• In Insert mode, new events are inserted as track calls.
• In All sync mode, the entire lookup table is replaced with each sync.

For more information about sync modes, refer to the sync modes docs.

Getting started

To configure your Mixpanel destination you need to provide the following information:

• Project ID
• Project Token
• Service Account Username and Secret
• Group Keys, when syncing group objects

Project ID

To find your Project ID, click the Settings icon, then Project Settings. Then navigate to Overview > Project Details.

Project token

To find your Project Token, click the Settings icon, then Project Settings. Then navigate to Overview > Access Keys.

Service account

To receive your Service Account Username and Secret you must first create a Service Account.
Click the Settings icon, then Project Settings. Then navigate to Service Accounts > Add Service Account and copy the Username and Secret.

Group keys

If you are syncing group profiles or assigning users to groups, you need to indicate which Group Key to use. To find your Group Keys, click the Settings icon, then Project Settings. Then navigate to Overview > Group Keys. Copy the appropriate Key value.

Syncing data

Objects

You can decide to sync either User Objects or Group Objects.

When syncing Group Objects, enter the appropriate group key into the Mixpanel group key field.

Record matching

You can match records from your source to your Mixpanel workspace by Mixpanel User ID, email or Group ID.

Field mapping

You can sync columns from your source to your default and custom fields in Mixpanel. If you're syncing User Objects, you can see two sections: one for native Mixpanel fields and one for custom fields.

If you're syncing Group Objects, you can only see one section.

Users location

By default, users uploaded using Hightouch won't have any associated location in Mixpanel. To set a location, provide an IP address (field $ip), or longitude and latitude coordinates (fields $longitude and $latitude). For more information, you can visit Mixpanel's official documentation.

Assigning users to groups

To assign users to groups, create a sync for User Objects. Then, create a column in your model which contains the group IDs that you want to assign the user to. For example, to sync organizations, use a column called organizations containing either a group ID (google) or an array of group IDs ([google, apple, microsoft]). Then, find your group key, and use it as the destination field to sync to.

Events

Hightouch supports sending events of a given name, for example, Signed Up.

Hightouch lets you choose the column containing the event timestamp.

Record matching

You can match records from your source to your Mixpanel workspace by Mixpanel User ID.

Field mapping

Hightouch allows you to pass data to the event properties of a Mixpanel event.

Assigning events to groups

To assign events to groups, create a sync to events. Then, create a column in your model which contains the group IDs that you want to assign the event to.
For example, to sync organizations, use a column called organizations containing either a group ID (google) or an array of group IDs ([google, apple, microsoft]). Then, find your group key, and use it as the destination field to sync to.

Lookup tables

To sync data to your Lookup tables, choose Enrichment. Then choose the specific Lookup table you want to replace.

Record matching

You can match records from your source to your Mixpanel workspace by the ID mapping of your choice. The ID mapping should reference the unique identifier field of the events or profiles you are seeking to enrich.

Field mapping

You may also sync columns from your source to your Mixpanel Lookup table's custom fields.

Creating lookup tables in Mixpanel

To create Lookup tables, you can import them directly in Mixpanel. You can do this by clicking on the Data Management icon and then on Lexicon. Navigate to Lookup Tables > Import > Lookup Table.

Limitations

Mixpanel's Lookup table endpoint comes with the following limits:

• Only 100 requests are allowed in a rolling 24 hour period. Please be mindful of this when choosing your sync schedule. Mixpanel recommends updating Lookup tables at most hourly.
• A Lookup table must not exceed 100 MB uncompressed (roughly 1-2M rows).

Tips and troubleshooting

Common errors

If you encounter an error or question not listed below and need assistance, don't hesitate to reach out. We're here to help.

Changing projects

If you need to change your Project ID, you also need to update the API Key that you originally provided. Project ID and API keys are paired together in the Mixpanel platform.

Live debugger

Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.

Sync alerts

Hightouch can alert you of sync issues via Slack, PagerDuty, SMS, or email. For details, please visit our article on alerting.