Reconciling Industry Classification Between Clay and HubSpot
Solution: Custom AI Formula Mapping
Create a custom AI formula in Clay that automatically maps industry values to your standardized industry list.
Setup Steps
-
Define your industry categories - Create 5-6 predefined industry classifications with clear descriptions and examples for each category
-
Create an AI prompt that instructs the formula to:
- Map incoming industry values to your predefined list
- Select only values from your approved list
- Return "Other" if no reasonable match exists
- Example prompt: "Map this industry value to our list and select the best match. Only return values from the list. If no reasonable match exists, select 'Other'."
Benefits
- Automated mapping requires no ongoing maintenance
- Consistent filtering across all future campaigns
- Standardized data ensures clean HubSpot sync