Splitting User Properties for Mixpanel Cohorts Export to Facebook
kapa.ai Split user property name to $first_name and $last_name and Add two columns. Does this look correct for mixpanel cohorts export for Facebook
kapa.ai Split user property name to $first_name and $last_name and Add two columns. Does this look correct for mixpanel cohorts export for Facebook
Based on the knowledge sources, splitting a user property $name into $first_name and $last_name is a good approach for Mixpanel cohorts that will be exported to Facebook Ads.
According to the documentation, when exporting cohorts to Facebook Ads, Mixpanel will send user profile properties including first name and last name to help Facebook match users:
In order to use this integration, you must set $email as a user profile property or have the advertising ID. In addition to email address, Mixpanel will send a first name user profile property, a last name user profile property, a phone number user property, an advertising id user property and the distinct id.
The reserved profile properties documentation confirms that Mixpanel specifically recognizes $first_name and $last_name as separate properties:
$name, $first_name, $last_name | Name, First Name, Last Name | The user's / group's general name, as well as, first and last names. These are primarily useful because they are used, if available, in various Mixpanel UI / reports. For user Cohort Syncs, only $first_name and $last_name is exported.
So yes, splitting the user property $name into $first_name and $last_name is the correct approach for Facebook Ads cohort exports, as Facebook uses this information (along with email) to match users from your cohort with users in their system.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
âšī¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! đ
You can delete user profile properties in Mixpanel using several methods:
Using the API
The most common way to delete user profile properties is through Mixpanel's Engage API:
1. Delete a specific property using the $unset operation:
[
{
"$token": "YOUR_PROJECT_TOKEN",
"$distinct_id": "user123",
"$unset": ["property_to_delete"]
}
]
This permanently removes the specified properties and their values from a profile Delete Property.
2. Delete an entire profile using the $delete operation:
[
{
"$token": "YOUR_PROJECT_TOKEN",
"$distinct_id": "user123",
"$delete": null
}
]
This permanently deletes the entire profile along with all its properties Delete Profile.
Using SDKs
You can also delete properties using Mixpanel's SDKs. For example:
iOS SDK
[[mixpanel getGroup:@â"company" groupID:@â"mixpanel"] unset:@â"employee_count"];
Flutter SDK
mixpanel.getGroup('company','mixpanel').unset('employee_count');
Node.js SDK
mp.groups.unset('company', 'mixpanel', 'employee_count');
Bulk Deletion
For bulk deletion of profiles, Mixpanel recommends:
- Using the Engage API programmatically
- Using the people_delete method in the mixpanel-utils library
As mentioned in the FAQ: "We recommend deleting profiles programmatically via our Engage API. We also provide a people_delete method in the mixpanel-utils library here." User Profiles FAQ
Note that if you're approaching the 2000 property limit per profile, you can remove properties using the $unset operation to stay under this limit.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
âšī¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.