Is it possible to merge two values of a single event property. eg: property_name : A property_value : "string_a" property_name : A property_value: "string_b" I want to consider "string_a" and "string_b" as same when I evaluate property A
Hi Nidhin M., 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 different values of a single event property in Mixpanel using the Lexicon feature. This functionality allows you to treat different property values as the same for analysis purposes.
Merging Property Values
In Lexicon, project owners can merge event properties. Here's how you can merge the values "string_a" and "string_b" for property A: 1. Navigate to Lexicon in your Mixpanel project 2. Select the properties you want to merge 3. Click the "Merge" icon that appears 4. In the "Merge Properties" window, specify which property value Mixpanel should recognize as the newly merged property name 5. Click MergeAfter merging, the property will appear with a "Merged" status in the "Status" column.Lexicon: Describe your events and data using a dictionary
Benefits of Merging Properties
Merging property values can help: - Streamline your implementation - Reduce costs by eliminating redundant events - Simplify report analysis by using optimal events and properties
Unmerging Properties
If you later decide you want to separate the merged property values: 1. Select the merged property 2. Click the "Unmerge" icon 3. The merged property will revert to the original distinct propertiesThis merging functionality is particularly useful when you have inconsistent data tracking (like capitalization differences or spelling variations) but want to analyze them as the same value.
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're right, I misunderstood your question. Let me clarify the correct information about merging values of the same property in Mixpanel.In Mixpanel's Lexicon, project owners can merge different values of the same property. This is exactly what you're looking for - treating "string_a" and "string_b" as the same value when evaluating property A.According to the documentation, you can merge property values through Lexicon: 1. Navigate to Lexicon in your Mixpanel project 2. Find the specific property (property A in your case) 3. Select the property values you want to merge ("string_a" and "string_b") 4. Click the "Merge" icon that appears 5. In the "Merge Properties" window, specify which value should be the display name for the merged values 6. Click MergeAfter merging, both "string_a" and "string_b" will be treated as the same value in your analyses, while the underlying raw data remains unchanged.Lexicon: Describe your events and data using a dictionaryIf you later need to separate these values, you can unmerge them following a similar process.This feature is particularly useful for handling inconsistencies in data tracking, such as different spellings, capitalizations, or variations of the same conceptual value.
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.
