can I merge two profiles? massively ?
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
Yes, you can merge user profiles in Mixpanel, and there are options for doing this at scale.For individual profile merging, it depends on which ID management system your Mixpanel project is using: 1. Original ID Merge: You can merge two identified users using the $merge
event via the import API. This allows you to merge any two identifiers together as long as the resulting ID cluster doesn't exceed 500 IDs.LBKS{ "event": "$merge", "properties": { "$distinct_ids": [ "user_id_1", "user_id_2" ] } }LBKS
2. Simplified ID Merge: This system doesn't support merging two $user_id
s together. Instead, it's designed to have a single, unchanging $user_id
for each user with other IDs pointing to it.For bulk deduplication of profiles, Mixpanel offers a utility function in their mixpanel-utils Python module: LBKSmputils.deduplicate_people(prop_to_match='$email', merge_props=True)LBKS
This function deduplicates people profiles based on a specified property (default is '$email'). You can also have it merge properties together by setting merge_props=True
 Mixpanel Utils.Note that user profile properties cannot be merged through Lexicon (Mixpanel's data dictionary feature), which only allows merging of events and event properties.If you're considering merging projects entirely, Mixpanel also provides a way to merge Mixpanel projects by exporting data from one project and importing it into another.
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.