Sending User Profiles

Format Data for Mixpanel Ingestion

To import data from a warehouse directly, you need to format tables correctly.

Each column in the table will be mapped as a user property.

Read more about best practices for tracking User Properties in Mixpanel here.

User Tables

Once you have created a warehouse source, follow the below steps to send user profiles into Mixpanel.

1. Go to Project Settings > Warehouse Data.
2. Click on + Create and select User Table.
3. Select your warehouse as source from the dropdown.
4. Navigate to the dataset or database where your User table is.
5. Select the Table.
6. Specify which column contains the distinct ID.
7. Optionally, you can select which columns map to Mixpanel Reserved Properties, which receive special treatment in our UI or are used for special processing.

Profile History via Slowly Changing Dimensions Type 2 Tables

Profile History allows you to point Mixpanel at a user table formatted as Slowly Changing Dimensions Type 2 (opens in a new tab). This allows you to set up reports to analyze the historic values of user properties, in addition to latest value.

Setup instructions:

1. When creating a new User Table, there will be a Type option. Select History Table.
2. Map the distinct ID to the User ID column and Start Time to the Start Time column.
3. You will only have the option for a Time Based sync for a History Table. See below for further setup information.

Note: For billing purposes each update in the SCD Type 2 table is processed as events. During early access there is no charge for updates, however high volumes of updates relative to a project's event plan limit may make the project unsuitable for early access. Also, there is a 90 day lookback limit for updates during early access so we recommend doing daily or monthly snapshots even if there are no delta updates to ensure profile history values do not show as (not set). This restriction will be lifted when the feature becomes generally available.

Sync Settings

After pointing Mixpanel at your user table, you can select a Sync Type option. The options are:

• Time Based:
  • If you select this, you will need to add a mapping to an Insert Time column. We expect this to be a monotonically increasing TIMESTAMP_NTZ. We use this as a water mark to figure out which user profile updates are new and ingest them. This allows you to only send Mixpanel delta updates, which would mean paying lower egress and compute costs.
  • If there are profiles with the same distinct ID, the profile with the latest timestamp column will take precedent.
• Full Sync: With this option, Mixpanel will periodically do a full sync on the entire table. This means that periodically, we will update all users' value even if there are no delta updates.

Check the preview to ensure that everything looks correct, and then create the sync.