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?
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
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)LBKS
This 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.