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 nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrue
Custom dataTrue
HistoryFalse
ReSyncTrueTable level
TemplatesFalse

Data Schema

T
- Table
S
- Sub table
React Flow

πŸ”§ 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)
  • Group_profile (upsert only)

Step 1 - Destination

  1. Click on the Reverse ETL item in the sidebar to navigate to the page.

  2. If this is your first reverse ETL sync the setup guide will automatically start. Otherwise click "Add Reverse ETL Sync" button to start the setup guide.

  3. Find the Mixpanel connector from the list of destinations and choose an existing connection, if any, or click to create a new connection which you will need to authorize.

    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 - Target Details

The Mixpanel connection does not have additional configuration - This will be skipped.

Step 3 - Map Data

  1. Select the source data model that you would like to sync to Mixpanel. This can be a table or a view from your data warehouse.
  2. Select the destination object you would like to sync to. You can choose between event, user, or group profile.
  • For group_profile you need to configure the settings by adding group key. (Note: Some objects might require additional configuration that will be prompted during the setup process.)
  1. You will be presented with several options to configure your sync, which we will go through in the next steps.

SQL Model tips for Mixpanel Reverse ETL

  • Event: Your SQL model should have one row per Event. Requires Primary key.
  • User: Your SQL model should have one row per User. Requires Primary key.
  • Group profile: Your SQL model should have one row per group (e.g. company, organization, or team). Requires a unique group identifier as the primary group.

Sync Mode

Choose how you want to sync data from your source model to the destination object. Depending on the destination object, you might have either one of the following options available:

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

Choose Identifier

If you are syncing to the e.g. event object, you will need to select the identifier property. This is the unique identifier that Mixpanel uses to match records. Choose the column from your source model that corresponds to the identifier property in Mixpanel.

Field Mapping

Map the fields from your source model to the fields in Mixpanel. You can map the fields manually or use the auto-mapping feature to match fields based on their names. Ensure that the fields you map correspond to the properties in Mixpanel.

Step 4 - Schedule Sync

After you finished the steps above, click on Next to proceed to the scheduling step. Here you can choose how often you would like the sync to run:

  • Independent: The sync will run on its own schedule, independent of other syncs.
  • Orchestration: The sync will be part of an orchestration workflow, allowing you to run it in conjunction with other tasks.

Step 5 - Finalise and run

After you have configured the sync, click on Start Sync to finalize the setup. The sync will perform the initial run immediately.

Was this page helpful?