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?

2 comments

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.
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.