Mixpanel Email Filtering Limits and Workarounds for Large Cohorts

I have a list of 45k emails of users that already exist in Mixpanel. (I need to create a cohort using criteria that isn’t available in Mixpanel, so I pulled the list of emails externally and uploaded it as a cohort.) The issue is that when I try to filter using this cohort, I get an error (Unsupported Request: Precondition Failed). Smaller cohorts (2200 emails) work fine, but larger groups (4999 emails) or combining smaller cohorts fail. Does Mixpanel have a limit for filtering by email? If so, are there any workarounds for handling large lists like this?

🎫1

1 comment

Thena
APP
·
·
Hi Eliza, Thank you for reaching out to Mixpanel's Support -- I'm Varsha and I'm happy to help with this! I hate to be the bearer of bad news here, but the "Unsupported Request: Precondition Failed" error typically occurs when the system is overwhelmed by the number of users being queried for within a cohort. In these cases, we recommend creating user property to use instead. For example, you could find the associated Distinct IDs to each email address and then use our Bulk Import from CSV option to add a profile property to these users. You can label the profile property something like "Large Cohort" with values of true or false. This way, you can adjust your cohort definition to check if the "Large Cohort" profile property is true, which would heavily save on computation resources. Please note that this would make the cohort static ie it would be based on the value of the profile property "Large Cohort" which would not change unless you manually updated the profile property again. You can find more information on how to update user profiles by CSV here. I recommend that you test this on a small subset of users first before doing it in bulk for all 45K emails. Please let me know if you have any other questions! Best, Varsha