Is there a limit to the number of postal codes in a smart list?

Hi Sandy,

I have seen limits to the number of line items in a smart list filter at 999, so I think you should be OK with 807.

Is it possible you said postal code IS xxxxx?  If so, you might want to change the filter to CONTAINS.  This would cover you when there are postal codes formatted with the additional 4 numbers (XXXXX-XXXX).

Thank you,

Courtney

Hi Sandy Hall​, there is a limit to the number of items you can have in a filter but it is some obscure number just over 2000 (I believe @Elliott Lowe​ knows it )

As Courtney suggested, I would use a "starts with" or "contains" operator to include any zip codes that have the 4 digits at the end.

I just built a filter with 6,000 rows, and it worked.

I think the reason for our discrepancy is because Marketo's limit is based on the number of characters, not the number of values in the filter.  For example, I was able to add 2,279 email addresses to the Email Address field filter, but when I tried to add an additional email address, it would not allow it. However, I was able to add an additional value, but only if it was 9 characters in length. The same held true for the State field filter.  The total number of characters allowed in the filter was 47,721.  Similar to Michael, I was able to add 8,221 values (most 5-digit) to the Postal Code field filter, but strangely, the character count (41,780) was less than when I was using email addresses as the value.  The difference in character count is 5,941, which is the same as the additional number of values, so Marketo must also count the CR/LF character at the end of each value towards its limit.  So the total printable and non-printable character limit in a filter is about 50,000.