Mixpanel Community Icon

Formula to Combine Email Nomenclatures in Custom People Property

·
·

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?

  • Avatar of kapa.ai
    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

  • Avatar of 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.