Filter by City/State/Country

SOLVE
Highlighted
New Contributor

Is there a way to filter by location? City, State, Country?

Reply
0 Upvotes
3 Accepted solutions

Accepted Solutions
Community Thought Leader

_hubspot-button-accept-as-solution-gif-v00.gif

 

Q: Is there a way to filter by location? City, State, Country?

 

Short A: Yes.

- see image

hubspot-view-filter-contains-exactly-OR-gif.gifHubSpot View Filter | Contains Exactly (boolean example)

 

Help answer your question? If so, remember to accept this solution now.

 

Best,
Frank

Chief HubSpot Consultant


hubspot-solutions-signature-mfrankjohnson-v05.png

MFrankJohnson.com | Perfect HubSpot Series | Connect on LinkedIn

Help find posts quickly ... accept this solution now.

Reply
0 Upvotes
Top Contributor

Yes, it's very easy. You can create a filter or use lists. Depending on if you want to nail down location on a company or contact basis you'll use the corresponding property category and there should be city, state/region and country under both of those. 

 

If you need further help or clarification just let me know. Smiley Happy

 

If this solved your issue make sure to mark it as such so others can find the thread and answer easier. 

Reply
0 Upvotes
Top Contributor

That would be because both the Country and State/Region proprieties are Dropdown fields so you would have to select from a predefined list or add an option to the existing ones.

 

This is done to prevent having Washington DC, DC, D.C, D.C. ect all as separate entries from each unique spelling.

 

Depending on your use case and goals you might be able to segment the states into regional lists to use as criteria.

Reply
0 Upvotes
14 Replies
Community Thought Leader

_hubspot-button-accept-as-solution-gif-v00.gif

 

Q: Is there a way to filter by location? City, State, Country?

 

Short A: Yes.

- see image

hubspot-view-filter-contains-exactly-OR-gif.gifHubSpot View Filter | Contains Exactly (boolean example)

 

Help answer your question? If so, remember to accept this solution now.

 

Best,
Frank

Chief HubSpot Consultant


hubspot-solutions-signature-mfrankjohnson-v05.png

MFrankJohnson.com | Perfect HubSpot Series | Connect on LinkedIn

Help find posts quickly ... accept this solution now.

Reply
0 Upvotes
Top Contributor

Yes, it's very easy. You can create a filter or use lists. Depending on if you want to nail down location on a company or contact basis you'll use the corresponding property category and there should be city, state/region and country under both of those. 

 

If you need further help or clarification just let me know. Smiley Happy

 

If this solved your issue make sure to mark it as such so others can find the thread and answer easier. 

Reply
0 Upvotes
New Contributor

Doesn't work for me. Is that because I have the Free version?

 

Reply
0 Upvotes
Top Contributor

Yeah looking at the pricing tier it seems that lists (couldn't find filters but it's the same functionality) are locked to the starter and above. The starter tier has lists and only costs $50 a month but depending on how/how much you use the platform it may be worth it. 

Reply
0 Upvotes
New Contributor

Hello Connor,

 

I am a sales professional in Hubspot but am unable to filter for a location the way you have described. I can click the country/region but am not allowed to type in the desired city. 

Reply
0 Upvotes
Top Contributor

That would be because both the Country and State/Region proprieties are Dropdown fields so you would have to select from a predefined list or add an option to the existing ones.

 

This is done to prevent having Washington DC, DC, D.C, D.C. ect all as separate entries from each unique spelling.

 

Depending on your use case and goals you might be able to segment the states into regional lists to use as criteria.

Reply
0 Upvotes
Community Thought Leader

Wait @ConnorS.
If we're talking HubSpot default Contact OR Company properties (i.e., Country, City, and State), ALL are Single Line Text property types in HubSpot.

Reply
0 Upvotes
Top Contributor

I just checked the backend in the properties section and both "State/Region" and "Country" default HubSpot Contact Properties show as a dropdown selection.  City is, in fact, a single line text field which is why I opt to use a "Closest Metro Area" custom property so we don't need to filter for all the different spellings and suburbs. 

Reply
0 Upvotes
Community Thought Leader

Maybe something has changed in a weird way. Here's what we see in free, Sales Pro, and Marketing Enterprise portals for both Contacts and Companies!

- see image

hubspot-default-property-city.pngHubSpot Default City Property Type

 

- see image

hubspot-default-property-state.pngHubSpot Default State/Region Property Type

 

- see image

hubspot-default-property-country.pngHubSpot Default Country Property Type

Reply
0 Upvotes
Top Contributor

Yeah, that's odd. Here's what I see. - These are both Contact Properties

StateRegion.PNGCountry.PNG

Within each of those is a prepopulated list. Like I said you were correct about the city field. 

Reply
0 Upvotes
Community Thought Leader

What HS version(s) are you running (or screenshooting)?

Reply
0 Upvotes
Top Contributor

Marketing Suite Pro.

Reply
0 Upvotes
Community Thought Leader

Hi @jennysowyrda@roisinkirby

 

@ConnorS is seeing Dropdown property types for State/Region and Country (both Contact AND Company) default HubSpot properties in their Marketing Pro portal.

 

I see Single Line Text property types for those default HubSpot properties across multiple free, Sales Pro, Marketing Pro, and Marketing Enterprise portals -- the HubSpot default-default! (is that a word?)

 

We suspect the HubSpot default property types have been modified in ConnorS's portal. Have you seen this scenario before?

 

Thanks in advance.

 

Reply
0 Upvotes
Community Thought Leader

HubSpot Sales Professional does NOT include the HubSpot Lists tool.

Reply
0 Upvotes