Standardizing Property Values for Consistent Event Tracking

Hi kapa.ai I want to merge 2 property values together Property name is “display_mode” and events sent from iOS devices are sending display_mode = weekly while events sent from Android devices are sending display_mode = week I want to have consistant values, and turn all “week” values into “weekly”

7 comments

kapa.ai
APP
·
·
To standardize your property values for display_mode (i.e., convert all "week" values to "weekly"), you can use Mixpanel's data governance features, specifically the Lexicon tool. In Lexicon, you can merge property values so that both "week" and "weekly" are treated as a single, consistent value in your reports.Here’s how you can do it: 1. Go to Lexicon in your Mixpanel project. 2. Find the property: Locate the display_mode property. 3. Select the values to merge: Choose both "week" and "weekly". 4. Click the Merge icon: This will open the merge dialog. 5. Choose the canonical value: Set "weekly" as the value Mixpanel should recognize. 6. Confirm the merge: Click Merge. Now, all "week" values will be treated as "weekly" in your analysis.This process does not affect the raw data but ensures consistency in your reporting and analysis. You can also unmerge them later if needed. Note that this feature is available for event properties, but not for user profile properties at this time Lexicon: Merging Data.If you need to transform property values at the time of export (e.g., for a data pipeline), Mixpanel applies certain transformation rules, but for in-app analysis and reporting, Lexicon merging is the recommended approach Transformation Rules.Let me know if you need step-by-step guidance for your specific Mixpanel plan or interface!
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.
Tanguy D.
·
·
You explained me how to merge properties, not how to merge property values
Tanguy D.
·
·
kapa.ai
kapa.ai
APP
·
·
Sorry Tanguy D., I'm not sure what you mean. Please try again. 👋
Tanguy D.
·
·
kapa.ai You explained me how to merge properties, not how to merge property values
kapa.ai
APP
·
·
Let me check the knowledge base for you again. One moment! 📚
kapa.ai
APP
·
·
Thank you for your clarification.Based on the knowledge sources provided, Mixpanel’s Lexicon allows you to merge properties (i.e., property names), but there is no mention of a feature that allows you to merge or remap property values (such as turning all "week" values into "weekly" for the same property) directly within the Mixpanel UI or Lexicon. The documentation only describes merging property names, not their values Lexicon: Merging Data.If you need to standardize property values, you would typically need to do this at the data collection or ingestion stage (e.g., update your tracking code on Android to send "weekly" instead of "week"), or use a data transformation process outside of Mixpanel.I'm sorry, but the knowledge sources do not describe a way to merge or alias property values within Mixpanel itself.
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.