Mixpanel Community Icon
Join Our Community
Mixpanel Bot

Splitting User Properties for Mixpanel Cohorts Export to Facebook

Avatar of Aditya G.Aditya G.
·
·

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

5 comments

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Please stand by Aditya G. as I search the knowledge base. I normally take about 15 seconds or so. đź‘‹

    Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    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 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.

  • Avatar of Aditya G.
    Aditya G.
    ·
    ·

    kapa.ai how to delete User profile properties in mixpanel

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Let me check the knowledge base for you again. One moment! đź“š

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    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.