SOLVED

Postal Code (range)?

Go to solution
Highlighted

Postal Code (range)?

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?

postal range.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Postal Code (range)?

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.

View solution in original post

7 REPLIES 7
Highlighted

Re: Postal Code (range)?

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.

View solution in original post

Highlighted

Re: Postal Code (range)?

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.

Highlighted
Level 10 - Community Moderator

Re: Postal Code (range)?

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.

Highlighted

Re: Postal Code (range)?

Sanford,

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

Highlighted
Level 10 - Community Moderator

Re: Postal Code (range)?

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

Highlighted
Level 3

Re: Postal Code (range)?

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

Highlighted
Level 10 - Community Moderator

Re: Postal Code (range)?

See my response on your other thread.