Combining Duplicate Property Values in Mixpanel Insights
For instances where it 2 property values are the same, how can I combine them together in Mixpanel insight report but using different label, due to data cleaning issues kapa.ai
For instances where it 2 property values are the same, how can I combine them together in Mixpanel insight report but using different label, due to data cleaning issues kapa.ai
You can handle “when two property values are the same” by creating a Custom Property and then use it in an Insights report.Here’s how to do it: 1) Create a Custom Property - In any report, open the properties menu and choose to create a Custom Property. - Define a formula that checks if two properties match, e.g. something like IF(PropertyA == PropertyB, "Same", "Different") and optionally output a unified value when they match. Custom Properties let you compute new fields from existing properties and are usable across reports (save/share on Growth/Enterprise). [Custom Properties]Tip: The docs specifically mention comparing different properties to determine whether two property values are the same as a use case for Custom Properties. [Custom Properties]2) Use it in Insights - In an Insights report, use your new Custom Property to: - Break down a metric by this “Same vs Different” flag, or - Filter to only “Same” to analyze the combined/matched cases. [Reports overview; Insights measurements]If by “combine” you mean merge synonymous property names (e.g., “Country” vs “country”), you can merge property names in Lexicon so they appear as one property across reports (Project Owners only). Note: user profile properties can’t be merged. [Lexicon merging]
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 have two good, supported options—use the one that fits your scope: 1) Merge the property names in Lexicon (governance, global) - If your issue is duplicate/synonymous property names (e.g., “Country” vs “country”), a Project Owner can merge those properties in Lexicon so they act as one everywhere. This doesn’t change raw data and applies across reports. Note: user profile properties cannot be merged. [Merging data]2) Create a Custom Property to relabel and combine values (analysis, flexible) - If the problem is messy values within the same property (e.g., “US”, “United States”, “U.S.”), create a Custom Property that maps multiple raw values to one clean label, then use that in Insights for breakdowns/filters. For example: - Map “us”, “united states”, “u.s.” → “United States” - Everything else → keep original or “Other” - Custom Properties are designed for on-the-fly cleanup/grouping and can be saved globally on Growth/Enterprise or used locally on Free. [Custom Properties]Tip: For quick grouping in a single report, you can also use Custom Buckets on a string breakdown to cluster multiple values under a single bucket label like “United States,” with “Rest of the World” auto-generated for remaining values. [Custom Buckets]Which to choose: - Consistent, org-wide renaming/combining of properties: use Lexicon merge. [Merging data] - Per-report or reusable value relabeling (“US” vs “United States”): use Custom Property or Custom Buckets. [Custom Properties; Custom Buckets]
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.