Mixpanel Community Icon

Can I merge two user profile properties together?

·
·

Can I merge two user profile properties together?

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

    Hi Christopher C., 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
    ·
    ·

    Based on the knowledge sources provided, it is not possible to directly merge two user profile properties together in Mixpanel. However, there are some related operations you can perform on user profile properties:1. You can use the $union operator to append new values to a list property while excluding duplicates. This allows you to create a list profile property that only contains unique values Mixpanel SDKs: Javascript.2. You can use the $append operator to add values to an existing list property, which does allow duplicates Mixpanel SDKs: Node.js.3. It's possible to merge events and event properties using the Lexicon feature, but this functionality is not available for user profile properties Lexicon: Describe your events and data using a dictionary.4. If you need to combine data from multiple user profiles, you might consider using the deduplicate_people() function from the mixpanel-utils module. This allows you to deduplicate profiles based on a specified property and optionally merge properties together Mixpanel-utils Module.It's important to note that Mixpanel does not recommend merging two $user_ids together, as stated in their FAQ: "It is not possible to merge 2 $user_ids together using the Simplified API. We don't recommend doing this in general, as it adds complexity to your identity resolution strategy." Identifying Users (Simplified)If you have a specific use case that requires merging user profile properties, you may need to consider alternative approaches or contact Mixpanel support for further guidance.

    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.