Lists, Lead Scoring & Workflows

Jespersjogren
Participant

Autofill state/region based on city

I want to create lists based on region. I have the city for each contact.

 

I can also see the IP state/region, but it's completely wrong so I can't use it to make the lists. 

 

So is it possible to search for the region based on the city somehow?

 

Otherwise, this is my solution, please correct me if it's completely wrong. 

When creating a list for "Region XXX" I choose "City is equal to city1, city2, city3, city4, and all the cities in that region. 

The problem is that I have to create lists for all regions in several countries. So manually finding every single city that exists within every single region will take ALOT of time.

 

Any other possible solutions?

0 Upvotes
1 Reply 1
Phil_Vallender
Most Valuable Member | Diamond Partner
Most Valuable Member | Diamond Partner

Autofill state/region based on city

Hi @Jespersjogren 

 

You are right about your solution, you can build a list per region based on every city in that region - but it will take a lot of effort. If you have workflows, you could also build a workflow like this to set a region property based on the city. 

 

The alternative solutions that come to mind are:

  1. You could perhaps use Zapier to reference some external city/region lookup table, if you can find one
  2. If generating contacts via forms, ask them to pick the correct region as a form field.

Hope this helps.

Phil Vallender | HubSpot Website Agency