Mixpanel

Mixpanel is an advanced analytics platform that helps businesses analyze user behavior, track user interactions, and gain valuable insights into their product or service performance. It is designed to help businesses understand how users engage with their digital products, websites, and mobile apps.

Features

Feature name	Supported
Column Hashing	True	Field level
Blocking	True	Field level
Incremental	True
Custom data	True
History	False
ReSync	True	Table level
Templates	False

Data Schema

---

🔧 Setup Guide - ELT

Step 1 - Get credentials from Mixpanel

In the connector setup form enter the following fields:

1. Label: Enter the destination schema name of your choice.
2. Project ID:
   1. In Mixpanel, click the Settings icon in the top right corner;
   2. Choose Organization Settings;
   3. In Organization Settings, select Projects;
   4. Click on the relevant project name;
   5. You will find the Project ID in the Project Details.
3. Service Account: For the Service Account username and secret, you will need to create a Service Account in Mixpanel:
   1. In Mixpanel, click the Settings icon in the top right corner;
   2. In Organization Settings, select Service Accounts;
   3. Select + Service Account (top right corner);
   4. Fill in the details and create service account:
      • Name: Give it a name, for example weld_service_account
      • Organization role: Admin
      • Projects: Select relevant projects
      • Project role: Admin
      • Expires: Never
   5. Click Create and you will be shown the Service Account username and secret. Note that once you close this, you will never be able to access the secret again, so be sure to save it somewhere secure.
4. Region: Select the Data Residency region of your MixPanel Project:
   1. In Mixpanel, click the Settings icon in the top right corner;
   2. Choose Project Settings;
   3. Under overview you will find the field Data Residency.

Step 2 - Connect

1. Click Connect to allow Weld to access your Mixpanel account.

---

🔧 Setup Guide - Reverse ETL

Mixpanel reverse ETL allows you to sync data on a schedule from your Weld App automatically into Mixpanel.

• User (upsert only)
• Event (insert only)

Step 1 - Authenticate

1. Click on the Reverse ETL button in the side bar and click + New on the top right;

2. Select the Mixpanel from the drop down menu or or else click + Add new connection to authorize the connector.

   Find Project Token and API Secret:

   1. Open MixPanel in the project you want to activate data to;
   2. Click the settings icon in the top right of Mixpanel and select Project Settings;
   3. Under access keys, locate the Project Token and API Secret for the Project you want to Activate data to;
   4. Copy-paste the Secret and Token for the specified project into the connect form in the Weld app and click Connect.

Step 2 - Begin Configuration

1. Select your object:
   • Event
   • User

Step 3 - Model

1. Choose the SQL model that contains the data that you would like to sync.

Step 4 - Sync Operation

Choose how you would like to sync your data:

• Insert: Inserts new records;
• Upsert: Inserts new records and updates already synced data.

Step 5 - Schedule

Choose how often you would like the sync to run. You can choose to have the sync running on an independent schedule or as part of an orchestration workflow.

Step 6 - Mapping

Primary key: Select the unique identifier fields to match your record between your source and destination (this is usually the email or ID).

Map the column from your data model to the property in Mixpanel. If the property does not exist in Mixpanel then you can create it from within Weld.