Clean Contact State

Challenges with the Hubspot state property

Just like the Country property on Hubspot contact records, the State property is also a text field and therefore faces many of the same challenges:

1. Users can enter state names in various formats and spellings.
2. Importing contacts from other sources often also have state data in different formats.
3. This leads to inconsistent state data making it difficult to slice and dice your data for territory assignment, correct mailing, or even simple reporting per US state.

Options to solve state inconsistencies

Contrary to the country property, it's difficult to change the property to a dropdown field because there are many more states than countries. For example, you might want to add France's arrondissements, and United States' states. Once you have a reasonable number of countries, this would result in a huge dropdown list that's difficult to manage. So the option to normalize the existing text field values is the most viable approach.

Added complexity for state cleaning is that it's dependent on the Country value. A common mistake is that the state name would be cleaned, for example from "CA" to "California", but if the country field was "France", it doens't make a lot of sense.

Solution cleaning Hubspot state property

This solution will work if we have the following things in place:

1. Always normalize any incoming country name to the allowed list. Please look at switching this setting on under App Settings -> Configuration Options
2. Run the Contact State Properties Job to clean up existing values.

Unrecognised state values

Works exactly the same as for country values, but we only do it for states in the list of available countries we support. The job type will run all state values through a manually verified list of common misspellings and variations. When a value is not recognized, it will use AI to suggest the most likely correct value. If the AI is not confident, it will flag the value for manual review. We will not change the value in the field in case we are not confident in the correct value.

Normalized State list

We support normalization the state/region for the following list of countries. The final list is based on ISO 3166-2 states and territories. Countries are listed in their English names.

Any country not listed will keep the state property values untouched.

1. United States
2. Canada
3. Australia
4. Brazil
5. China
6. Ireland
7. India
8. Italy
9. Mexico

Click on any of the countries above to see the full state list used.

United States

• Alabama
• Alaska
• American Samoa
• Arizona
• Arkansas
• California
• Colorado
• Connecticut
• Delaware
• District of Columbia
• Florida
• Georgia
• Guam
• Hawaii
• Idaho
• Illinois
• Indiana
• Iowa
• Kansas
• Kentucky
• Louisiana
• Maine
• Maryland
• Massachusetts
• Michigan
• Minnesota
• Mississippi
• Missouri
• Montana
• Nebraska
• Nevada
• New Hampshire
• New Jersey
• New Mexico
• New York
• North Carolina
• North Dakota
• Northern Mariana Islands
• Ohio
• Oklahoma
• Oregon
• Pennsylvania
• Puerto Rico
• Rhode Island
• South Carolina
• South Dakota
• Tennessee
• Texas
• United States Minor Outlying Islands
• Utah
• Vermont
• Virginia
• Virgin Islands
• Washington
• West Virginia
• Wisconsin
• Wyoming

Canada

• Alberta
• British Columbia
• Manitoba
• New Brunswick
• Newfoundland and Labrador
• Nova Scotia
• Ontario
• Prince Edward Island
• Quebec
• Saskatchewan
• Northwest Territories
• Nunavut
• Yukon

Australia

• Australian Capital Territory
• New South Wales
• Northern Territory
• Queensland
• South Australia
• Tasmania
• Victoria
• Western Australia

Brazil

• Acre
• Alagoas
• Amapá
• Amazonas
• Bahia
• Ceará
• Distrito Federal
• Espírito Santo
• Goiás
• Maranhão
• Mato Grosso
• Mato Grosso do Sul
• Minas Gerais
• Paraná
• Paraíba
• Pará
• Pernambuco
• Piauí
• Rio Grande do Norte
• Rio Grande do Sul
• Rio de Janeiro
• Rondônia
• Roraima
• Santa Catarina
• Sergipe
• São Paulo
• Tocantins

China

• Anhui
• Beijing
• Chongqing
• Fujian
• Gansu
• Guangdong
• Guangxi
• Guizhou
• Hainan
• Hebei
• Heilongjiang
• Henan
• Hubei
• Hunan
• Jiangsu
• Jiangxi
• Jilin
• Liaoning
• Inner Mongolia
• Ningxia
• Qinghai
• Shaanxi
• Shandong
• Shanghai
• Shanxi
• Sichuan
• Taiwan
• Tianjin
• Xinjiang
• Tibet
• Yunnan
• Zhejiang
• Hong Kong
• Macao

Ireland

• Carlow
• Cavan
• Clare
• Cork
• Donegal
• Dublin
• Galway
• Kerry
• Kildare
• Kilkenny
• Laois
• Leitrim
• Limerick
• Longford
• Louth
• Mayo
• Meath
• Monaghan
• Offaly
• Roscommon
• Sligo
• Tipperary
• Waterford
• Westmeath
• Wexford
• Wicklow

India

• Andaman and Nicobar Islands
• Andhra Pradesh
• Arunachal Pradesh
• Assam
• Bihar
• Chandigarh
• Chhattisgarh
• Delhi
• Dadra and Nagar Haveli and Daman and Diu
• Goa
• Gujarat
• Haryana
• Himachal Pradesh
• Jammu and Kashmir
• Jharkhand
• Karnataka
• Kerala
• Ladakh
• Lakshadweep
• Madhya Pradesh
• Maharashtra
• Manipur
• Meghalaya
• Mizoram
• Nagaland
• Odisha
• Puducherry
• Punjab
• Rajasthan
• Sikkim
• Tamil Nadu
• Telangana
• Tripura
• Uttar Pradesh
• Uttarakhand
• West Bengal

Italy

• Abruzzo
• Agrigento
• Alessandria
• Ancona
• Arezzo
• Ascoli Piceno
• Asti
• Avellino
• Bari
• Barletta-Andria-Trani
• Basilicata
• Belluno
• Benevento
• Bergamo
• Biella
• Bologna
• Bolzano
• Brescia
• Brindisi
• Cagliari
• Calabria
• Caltanissetta
• Campania
• Campobasso
• Caserta
• Catania
• Catanzaro
• Chieti
• Como
• Cosenza
• Cremona
• Crotone
• Cuneo
• Emilia-Romagna
• Enna
• Fermo
• Ferrara
• Firenze
• Foggia
• Forlì-Cesena
• Friuli Venezia Giulia
• Frosinone
• Genova
• Gorizia
• Grosseto
• Imperia
• Isernia
• L'Aquila
• La Spezia
• Latina
• Lazio
• Lecce
• Lecco
• Liguria
• Livorno
• Lodi
• Lombardia
• Lucca
• Macerata
• Mantova
• Marche
• Massa-Carrara
• Matera
• Messina
• Milano
• Modena
• Molise
• Monza e Brianza
• Napoli
• Novara
• Nuoro
• Oristano
• Padova
• Palermo
• Parma
• Pavia
• Perugia
• Pesaro e Urbino
• Pescara
• Piacenza
• Piemonte
• Pisa
• Pistoia
• Pordenone
• Potenza
• Prato
• Puglia
• Ragusa
• Ravenna
• Reggio Calabria
• Reggio Emilia
• Rieti
• Rimini
• Roma
• Rovigo
• Salerno
• Sardegna
• Sassari
• Savona
• Sicilia
• Siena
• Siracusa
• Sondrio
• Sud Sardegna
• Taranto
• Teramo
• Terni
• Torino
• Toscana
• Trapani
• Trentino-Alto Adige
• Trento
• Treviso
• Trieste
• Udine
• Umbria
• Valle d'Aosta
• Varese
• Veneto
• Venezia
• Verbano-Cusio-Ossola
• Vercelli
• Verona
• Vibo Valentia
• Vicenza
• Viterbo

Mexico

• Aguascalientes
• Baja California
• Baja California Sur
• Campeche
• Chiapas
• Chihuahua
• Ciudad de México
• Coahuila de Zaragoza
• Colima
• Durango
• Guanajuato
• Guerrero
• Hidalgo
• Jalisco
• Michoacán de Ocampo
• Morelos
• México
• Nayarit
• Nuevo León
• Oaxaca
• Puebla
• Querétaro
• Quintana Roo
• San Luis Potosí
• Sinaloa
• Sonora
• Tabasco
• Tamaulipas
• Tlaxcala
• Veracruz de Ignacio de la Llave
• Yucatán
• Zacatecas