standardize-geo-values

What problem does it solve?

Converts inconsistent country and state/region values into a single, standardized set across HubSpot Contacts and Companies to improve geographic segmentation and reporting accuracy.

Core Features & Use Cases

• Audit and identify non-standard geo values across Contacts and Companies.
• Build and maintain a mapping table from variants to canonical values (e.g., "US"/"USA"/"U.S." -> "United States"; "NY" -> "New York").
• Perform batch updates via HubSpot API or bulk UI workflows with safeguards and retry logic.
• Enforce standardization going forward by validating form dropdowns and preventing free-text deviations.
• Verify results with before/after checks and export audit trails for compliance and traceability.

Quick Start

Audit your HubSpot data for non-standard country and state values, run the Included Before/Execute/After workflow to apply the mappings, and verify that all records reflect standardized geographic values.