Creating a contact list using zip code ranges

SOLVE
Highlighted
New Member

I need to create a new contact list that contains zip/postal codes in specific ranges (i.e, 90001-90280).  Is this possible, or do I have to enter every single zip code seperately?

1 Accepted solution

Accepted Solutions
Highlighted
Advisor

Hi @Gabriel_Ramos 

 

Sure thing.  Here it is.  Since this post is in Marketing Hub I assumed you were using HubSpot Marketing.  You need the Lists Tool for this, which is available from Starter on up.  If you're doing this in Free CRM, you may not have as many filter options to choose from.


ZIP Screenshot.png

-Trevor

If my post resolves your issue, please accept my post as a solution.
14 Replies 14
Highlighted
Regular Contributor

Hey @driner,

 

There isn't a way to do a range of numbers in a list, so you'd want to enter them each seperately.

Reply
0 Upvotes
Highlighted
Occasional Contributor

This is something very important to us as well.

 

When I Generate a Call list for a region my sales rep is going to be visiting the following week I need to se the closest Zip codes so my CS can try to arrange a Schedule. Right now I am making a second field (ZIP_CODE_sort) and enterring as number, so i can filter by range. 

But Filtering with "starts with " is basic stuff, Hubspot should have it by now

 

 

 

Reply
0 Upvotes
Highlighted
Advisor

Hi @driner 

 

I would suggest building a smart List list where the Postal Code "starts with any of" "900", "901," "9021," "9022," "9023," "9024," "9025," "9026," "9027," and "90280." 

 

That should accomplish your goal.

 

- Trevor

-Trevor

If my post resolves your issue, please accept my post as a solution.
Highlighted
Occasional Contributor

Hey @trevorjones71 ,

 

My postal code field only allows for exact Match / Different /Emty or field, on your field you can do starts with? can you send me a print screen?

 

Kind regards

Reply
0 Upvotes
Highlighted
Advisor

Hi @Gabriel_Ramos 

 

Sure thing.  Here it is.  Since this post is in Marketing Hub I assumed you were using HubSpot Marketing.  You need the Lists Tool for this, which is available from Starter on up.  If you're doing this in Free CRM, you may not have as many filter options to choose from.


ZIP Screenshot.png

-Trevor

If my post resolves your issue, please accept my post as a solution.
Highlighted
Occasional Contributor

Thank you! Is there any way to paste a set of values into this field, or do i have to type each one separeatly?

 

If I insert a comma bewteen each value it just put the comma inside the value.

Reply
0 Upvotes
Highlighted
Advisor

Hi Again @cbmb!

 

Use a semicolon as your delimiter and copy/paste should work fine.

 

-Trevor

If my post resolves your issue, please accept my post as a solution.
Highlighted
New Contributor

Hi Trevor,

 

Will this also be the case for companies or only contacts? 

Reply
0 Upvotes
Highlighted
Advisor

Hi @Renze,

 

This post is about the lists tool in the Marketing platform.  Filters in the CRM (which is how you would do this for company names) is much more limited in the range of available filter options.

 

For example, the "Starts With" option mentioned above isn't available in the lists of filters in the CRM.  You can, however, us "contains" but unfortunately you must populate the field filter with the full character string.  Meaning, you can't use "041", you have to use the full "04101" 5-digit postal code. 

 

Equally frustrating is that you can't use copy-paste in the CRM, at least with the delimiters I have tried (comma, semicolon, and tab), so if you want to build a list view for sales territories based upon Postal Codes, you'll have to key all of the zip codes in manually.

 

Sorry,

 

-Trevor

If my post resolves your issue, please accept my post as a solution.
Highlighted
Occasional Contributor

I tried this, but the list of postal codes to be manually entered consists of 2229 lines. I had put them in Excel (easier to drag down) as I assumed I could copy in the fields. But no, this will put them all in one field instead of separate ones. 

I would need something lines Postal code is > 3700 and less then 3899 with more lines or i can copy / duplicate the mailing to Postal code 5000 - 6899 

 

@hubspot Any idea on how to deal with emailings that should go to a specific region only?  

Reply
0 Upvotes
Highlighted
Occasional Contributor

I am looking for the exact same thing. But if I type in the starts with numbers, I get zero resultst whereas looking at the contact lists, I know it should come up with almost 1/5 of the contact list. So the option does not seem to work? Any other ideas/recommendations?

Reply
0 Upvotes
Highlighted
Occasional Contributor

Th eonly solution I found for UK post codes was to use "contains exactly" and then type the start of the post code with * at the end

 

So ME1*, ME2*, ME3*, PE1*, PE2*   etc etc

 

Reply
0 Upvotes
Highlighted
Occasional Contributor

Thanks for reaching out. I don't have the option "contains exactly" but did not use the asterix* with my earlier tries. Too bad, it does not work with * Starts with 377*, 380* etc either. This is really necessary option. We came from Mailchimp, where it was pretty easy to do this 😞 

Reply
0 Upvotes
Highlighted
Advisor

Hi @Viv21,

 

I tested my original solution above in the lists tool and it still works appropriately.  Which version of HubSpot are you using?  Again, you can't do this in the CRM.  It has to be done with HubSpot Marketing - Starter or Above.

 

 

 

-Trevor

If my post resolves your issue, please accept my post as a solution.