Search documentation...

K
ChangelogBook a demoSign up

Mixpanel Cohorts

Mixpanel Cohorts are groups of users defined by a chosen set of criteria, like a shared property or sequence of events in Mixpanel. You can also use cohorts to target groups of users via Hightouch.

Overview

Hightouch lets you pull data stored in Mixpanel Cohorts and push it to downstream destinations. Connecting Hightouch to Mixpanel requires creating a Mixpanel service account. To create one, follow Mixpanel's instructions. Keep your service account name and password ready for use in the Hightouch UI.

Connection configuration

To get started in Hightouch, go to the Sources overview page and click the Add source button. Select Mixpanel Cohorts and follow the steps below.

Choose connection type

Hightouch can connect directly to Mixpanel Cohorts over the public internet or via an SSH tunnel. Since data is encrypted in transit via TLS, a direct connection is suitable for most use cases. You may need to set up a tunnel if your Mixpanel Cohorts instance is on a private network or virtual private cloud (VPC).

Direct connection vs. SSH tunnel

Hightouch supports both standard and reverse SSH tunnels. To learn more about SSH tunneling, refer to Hightouch's tunneling documentation.

Configure your source

Enter the following required fields into Hightouch:

  • Service account username: This is name of the service account you previously created.
  • Service account secret: The secret for the service account specified above.
  • (Optional) Region: By default, Hightouch assumes that your Mixpanel data is stored in the United States, in which case you must leave this field empty. Otherwise, you can use this field to override that behavior by specifying a different region. For example, insert eu if your data is located in the European Union. You can find your Mixpanel region by looking at the Data Residency field in your Mixpanel Project Settings.

Test your connection

When setting up Mixpanel Cohorts as a source for the first time, Hightouch checks that you have the correct permissions. Once the test passes, click Continue to finish setup.

Next steps

Once your source configuration has passed the necessary validation, your source setup is complete. Next, you can set up models to define which data you want to pull from Mixpanel.

Model setup

  1. In Hightouch, go to the Models overview page.
  2. Click Add model.
  3. Select the Mixpanel Cohorts source you previously created.
  4. Select the Mixpanel data source, project, and cohort you want to use. The project and cohort populate based on your service account credentials. Check your credentials and click the refresh button if you don't see the values you expect.
  5. Choose whether to include users without profile data in the query results.
  6. Preview your model's query results.
  7. Click Continue.
  8. Name your model and select its primary key. Hightouch uses the primary key to determine which rows have been added, changed, or removed since the last sync.

Tips and troubleshooting

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

StatusCodeError: 400 - invalid project id for cluster

You may receive this error if your Mixpanel region is incorrect:

StatusCodeError: 400 {"request":"/api/2.0/engage?project_id=XXXXXXX","error":"request failed with error: invalid project id for cluster...."}

By default, Hightouch assumes that your Mixpanel data is stored in the United States, in which case you must leave the Region field empty. Otherwise, you can use this field to override that behavior by specifying a different region. For example, insert eu if your data is located in the European Union.

Mixpanel region

Ready to get started?

Jump right in or a book a demo. Your first destination is always free.

Book a demoSign upBook a demo

Need help?

Our team is relentlessly focused on your success. Don't hesitate to reach out!

Feature requests?

We'd love to hear your suggestions for integrations and other features.

Last updated: Aug 18, 2023

On this page

OverviewConnection configurationChoose connection typeConfigure your sourceTest your connectionNext stepsModel setupTips and troubleshootingStatusCodeError: 400 - invalid project id for cluster

Was this page helpful?