Formula to Combine Email Nomenclatures in Custom People Property

Sonia · 2024-12-04T04:51:33.267905+00:00

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?

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.

2 comments