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.
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.
Be sure to give your Service Account Owner or Admin permissions.
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.
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.
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.
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.
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.
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.
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.
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).
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.
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.