Mixpanel does not currently support merging user profile properties (profile properties) in the same way it allows merging of events or event properties via Lexicon. The documentation explicitly states: “user profile properties cannot be merged at this time” Lexicon: Merging Data.
How to clean up duplicate profile properties:
- Manual Cleanup: You can use the Engage API to remove unwanted or duplicate user profile properties. For example, you can use the $unset operation to delete old or redundant properties from user profiles. There’s also a people_unset method in the Mixpanel-utils library that can help automate this process Data Clean-Up.
- Deduplication Utility: The Mixpanel-utils library provides a deduplicate_people function, which can deduplicate people profiles based on a property (like email or name) and optionally merge properties. However, this is for deduplicating entire profiles, not merging property names that differ only by case Mixpanel-utils README.
Recommendation:
You will need to decide which version of each property (lowercase or uppercase) you want to keep, and then use the Engage API or Mixpanel-utils to remove the unwanted properties from all user profiles. There is no automated merge for profile properties with different casing; cleanup must be done by removing one and standardizing on the other.
If you have a large number of profiles, scripting this cleanup via the API is recommended.
Summary:
- You cannot merge user profile properties in Mixpanel.
- Use the Engage API or Mixpanel-utils to remove or unset unwanted properties.
- Standardize property naming conventions going forward to avoid this issue.
If you need more detailed guidance on using the API or Mixpanel-utils for this cleanup, let me know!
