Mixpanel Community Icon

Home
Groups
Members

Announcements
Community Questions
Mixpanel Bot
Product Ideas
Resources

Community Guidelines

Docs & Guides
Events & Webinars
Contact Us

Powered by Tightknit

Formula to Combine Email Nomenclatures in Custom People Property | Mixpanel Community

Formula to Combine Email Nomenclatures in Custom People Property

·Dec 04, 2024 04:51 AM·

if we have two nomeclature for a people property ie.Email and email ,give me a formulae for custom people property to consider them as a single property?

2 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Hi Sonia, 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
kapa.ai
APP
·
·
To create a custom people property that combines "Email" and "email" into a single property, you can use the following formula: LBKSif(defined(Email), Email, email)LBKSThis formula uses the if function and defined function available in Mixpanel's custom properties feature Custom Properties Reference.Here's how it works: 1. The defined function checks if the "Email" property exists. 2. If "Email" is defined, the formula returns its value. 3. If "Email" is not defined, it returns the value of "email".This approach ensures that regardless of whether the property is stored as "Email" or "email", you'll get a single, consistent property value.Remember that Mixpanel's property names are case-sensitive, so this formula helps you handle the capitalization difference between "Email" and "email".Custom Properties Overview provides more information on how to use and implement custom properties in Mixpanel.
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.