Mixpanel Setup Guide
Follow our setup guide to connect Mixpanel to Fivetran.
Prerequisites
To connect Mixpanel to Fivetran, you need a billing-enabled Mixpanel account with Owner or Admin permissions.
NOTE: You need Billing permissions to update the billing information of your Mixpanel account. For more information, see Mixpanel's payment documentation.
Supported authentication methods
You can create the connector using one of the following authentication methods for Mixpanel:
- Service Accounts (recommended)
- Project Secret
NOTE: Mixpanel is deprecating its Project Secret authentication method. Therefore, we recommend that you use the Service Accounts authentication method for your connector.
Setup instructions - Service account
Add service account
On the navigation menu, click Service Accounts.
Click + Add Service Account.
Enter a Service Account name.
In the Project Role drop-down menu, select the role you want to assign to the service account.
In the Expires drop-down menu, specify the expiry period for the service account.
Click Add.
Make a note of the Username and Secret. You will need them to configure Fivetran.
Find project ID
Log in to your Mixpanel account.
In the top right corner, click the Settings icon and select Project Settings.
On the navigation menu, click Overview.
Make a note of the Project ID. You will need it to configure Fivetran.
Finish Fivetran configuration
In the connector setup form, enter the Destination schema name of your choice.
(Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice, and then select the same agent for your destination.
Select Service Accounts as the Authentication Method method.
Enter the Service Account Username and Service Account Secret you found.
Enter the Project ID you found.
(Optional) If your Mixpanel data resides in the European Union, select the Data Region as EU. The default region is the US.
Click Save & Test. Fivetran will take it from here and sync your Mixpanel data.
IMPORTANT: If you are using a new Mixpanel project, don't include the
CAMPAIGNtable in your syncs because Mixpanel has disabled the Campaigns feature for new projects. Go to the Schema tab and deselect the table.
Setup instructions - Project secret
Find API secret
Log in to your Mixpanel account.
In the top right corner, click the Settings icon and select Personal Settings.
On the navigation menu, click Projects.
In the All Projects tab, make a note of the API Secret. You will need it to configure Fivetran.
Finish Fivetran configuration
- In the connector setup form, enter the Destination schema name of your choice.
- (Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice, and then select the same agent for your destination.
- Select Project Secret as the Authentication Method method.
- Enter the API Secret you found.
- (Optional) If your Mixpanel data resides in the European Union, select the Data Region as EU. The default region is the US.
- Click Save & Test. Fivetran will take it from here and sync your Mixpanel data.
IMPORTANT: If you are using a new Mixpanel project, don't include the
CAMPAIGNtable in your syncs because Mixpanel has disabled the Campaigns feature for new projects. Go to the Schema tab and deselect the table.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration