Hi @jleow,
This is an excellent guide, thank you for sharing.
I also wanted to share (and full disclosure I work for them as a product marketer) that Insycle can help with this problem.
With Insycle, you could use the Cleanse Data module to view all of the variations that you have in your “State/Region” field. Then, you can select a variation group and update the entire group to whatever you would like. For example, you could select all contacts with a state of “California” and update them in bulk to be “CA” if you prefer to the abbreviation. I’ve included a screenshot of what this looks like.
Also, you can do this for any field in HubSpot CRM. It makes for a simple but powerful way to standardize data.
Hope that helps anyone that has this problem.
Best,
Ryan