Mixpanel Community Icon

how can I delete property values from a user property?

·
·

how can I delete property values from a user property?

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

    Hi Juan I., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹

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

    To delete property values from a user property in Mixpanel, you can use the $unset operation. This method allows you to permanently remove specific properties and their values from a user profile. Here are a few ways to accomplish this:1. Using the Ingestion API: You can make a POST request to the /engage#profile-unset endpoint. The request body should include the project token, distinct ID, and an array of properties to be removed.Ingestion API - User Profiles provides this example::LBKSLBKS```LBKS{ "$token":: "YOUR_PROJECT_TOKEN", "unset": ["property1", "property2"] }LBKSLBKS2. Using the Mixpanel-utils Library: If you're using Python, you can leverage the `people_unset` method from the Mixpanel-utils library.LBKS[Mixpanel-utils](https://github.com/mixpanel/mixpanel-utils/blob/master/README.md) provides this example:LBKSLBKSmputils.people_unset(['coins','feathers'], query_params={ 'selector' : '(("Albuquerque" in properties["city"])))'})```This method allows you to unset multiple properties at once and also provides the option to target specific user profiles using query parameters.3. Using SDK methods: Most Mixpanel SDKs provide methods to unset user properties. For example:- In JavaScript: mixpanel.people.unset('property_name') - In iOS (Swift): Mixpanel.mainInstance().people.unset(property: "property_name") - In Android: mixpanel.getPeople().unset("property_name")Remember that when you unset a property, it's permanently removed from the user profile. If you need to remove a value from a list property instead of deleting the entire property, you might want to use the remove method instead, which is available in most SDKs.For more detailed information on managing user properties, you can refer to the Mixpanel Data Governance documentation.

    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 Juan I.
    Juan I.
    ·
    ·

    I want to unset specific values of a property in the UI of mixpanel? can I ? otherwise in the inspect window? kapa.ai

  • 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
    ·
    ·

    I apologize, but based on the knowledge sources provided, there is not enough information to definitively answer whether you can unset specific values of a property directly in the Mixpanel UI or through the inspect window.The knowledge sources mainly focus on programmatic methods to unset properties, such as using APIs or SDKs. They don't mention any UI-based or inspect window methods for unsetting specific property values.However, I can provide some related information that might be helpful:1. Lexicon, which is Mixpanel's data dictionary interface, allows you to drop entire properties, but not specific values within a property. As mentioned in the Lexicon documentation: "By dropping a property, you can intercept and drop incoming property. Mixpanel won't store any new data for the property you select to drop."2. If you need to remove specific values from a list-valued property (rather than unsetting the entire property), many Mixpanel SDKs offer a remove method. However, this is done programmatically, not through the UI.3. For more comprehensive data clean-up, including removing specific property values, you might need to use the programmatic methods mentioned in the previous answer, such as the Ingestion API or SDK methods.If you specifically need to modify data through the UI or inspect window, I recommend reaching out to Mixpanel's support team or consulting their most up-to-date documentation, as this information is not available in the provided knowledge sources.

    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.