Postal Code (range)?

[Allison_Proehl]

I'm trying to break up my smart group with some geo targeting using a range of postal codes, but I cant seem to find a filter of it. I originally saw it in Josh Hill​ 's response: Postal Code Range Filter but it doesn't show up in my Smart List Filter Options (see screenshot). Are my missing something? Does it not exist anymore?

[Devraj_Grewal · Accepted solution]

Ali,

I would navigate to Admin > Field Management. From there you can check to see which fields are mapped with your CRM fields. Sometimes address fields are parsed out into another field and it can be labeled something else like zip code, zip, mailing code, or postal code.

[Allison_Proehl]

Thanks Devraj,

I was thinking that I didn't already have it as a field in Field Management and it wasn't mapped to my CRM.

[SanfordWhiteman]

Postal Code (Range) is a custom field, not a built-in field.  It would have to be an integer field in order to be constrained with [between].

Storing postal codes as numbers is, generally speaking, a really bad idea (it's one of the well-known data management errors w/common person data). I guess if it's only for this specific purpose, it's acceptable as a secondary field.

[Allison_Proehl]

Sanford,

Thanks for the input on data-management. I think we may try going about it another way to avoid any errors.

[SanfordWhiteman]

As a secondary field it's probably okay, if it suits your purposes​.

[Mark_Knight]

I am having a similar issue - but currently have no CRM integration. All data just held in Marketo.

I need to create a segment where Postal code is less than or equal to 3000 and country = Switzerland (to target french speaking people in Switzerland)

BUT i only have my post code data in a text field, so cant do as a range.

Reading above, I have created a new field 'Postal Code Range' but how to duplicate the 'Postal Code' data into this new field so i can run the 'is Between' filter on the Postal Code range field?

Many thnaks

Mark

[SanfordWhiteman]

See my response on your other thread.