SOLVED

Re: Postal Code (range)?

Go to solution
Allison_Proehl
Level 4

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
Devraj_Grewal
Level 10 - Champion Alumni

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
Devraj_Grewal
Level 10 - Champion Alumni

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.

Allison_Proehl
Level 4

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.

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

Allison_Proehl
Level 4

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.

SanfordWhiteman
Level 10 - Community Moderator

Re: Postal Code (range)?

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

Mark_Knight
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

SanfordWhiteman
Level 10 - Community Moderator

Re: Postal Code (range)?

See my response on your other thread.