Mixpanel Community Icon

Filtering Multiple Emails in Mixpanel: Is Bulk Input Possible?

·
·

Hi Team, I have a query regarding filtering "multiple values" in Mixpanel. Typically, I perform analysis in Excel and gather 20-25 emails that I need to examine. At the moment, I’m manually entering each email in the email field to track user activity. Is there a way to paste all 25 emails into the filter at once?

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·

    This is not exactly the most "convenient" way of doing this, but (1) create a custom property for your filter; (2) make the formula of your custom property have email=="xxx" or email=="yyy" or ...; (3) if you do a copy/paste of the formula into a text editor, you can see what the additional info is to make it copy/paste-able.

    @"""{"label":"Email","propertyDefaultType":"string","resourceType":"user","type":"string","value":"$email"}"""@=="andrew@xxx.com" or @"""{"label":"Email","propertyDefaultType":"string","resourceType":"user","type":"string","value":"$email"}"""@=="andrew@yyy.com"

    So you can use this to build a formula in excel which builds this programmatically out of your excel list of emails. Now when you need to do your filter, edit your custom property and copy/paste the calculated results.

  • Avatar of Avinash B.
    Avinash B.
    ·
    ·

    Thanks Andrew S. for taking time to answer this. I found a quick and efficient solution to the problem. By entering these emails separated by a comma, I can select all 25 emails at once.