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.
Facebook Ads IntegrationThe 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.
Reserved PropertiesSo 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"]
}
]
```LBKSLBKS This permanently removes the specified properties and their values from a profile [Delete Property](https://github.com/mixpanel/docs/blob/main/reference/Ingestion%20API/user-profiles/profile-delete-property.md).LBKS2. **Delete an entire profile** using the `$delete` operation:
```LBKS [
{
"$token": "YOUR_PROJECT_TOKEN",
"$distinct_id": "user123",
"$delete": null
}
]
```LBKSLBKS This permanently deletes the entire profile along with all its properties [Delete Profile](https://github.com/mixpanel/docs/blob/main/reference/Ingestion%20API/user-profiles/delete-profile.md).
Using SDKs
You can also delete properties using Mixpanel's SDKs. For example:
iOS SDK
LBKS[[mixpanel getGroup:@"company" groupID:@"mixpanel"] unset:@"employee_count"];LBKSMixpanel SDKs: iOS
Flutter SDK
LBKSmixpanel.getGroup('company','mixpanel').unset('employee_count');LBKSMixpanel SDKs: Flutter
Node.js SDK
LBKSmp.groups.unset('company', 'mixpanel', 'employee_count');LBKSMixpanel SDKs: Node.js
Bulk Deletion
For bulk deletion of profiles, Mixpanel recommends:
- Using the Engage API programmatically
- Using the people_delete method in the mixpanel-utils libraryAs 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 FAQNote 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.