Day 1 — Audit and prioritise
Start small. List every free‑text field across your CRM and marketing systems (HubSpot, Salesforce, Marketo, Pardot) and score them by impact: does this field drive reports, automations, billing or handoffs? Pick the top 1–3 fields that cause the most pain.
Run a quick export or sample (1,000 rows or 10% of records, whichever is smaller) and capture distinct values. Look for high‑volume variants, obvious typos, case differences and meaningful free text that can realistically become options.
Days 2–4 — Extract, group, create a canonical list and backfill safely
Work in a spreadsheet. Normalise the exports (trim, lower case, remove punctuation) and group common variants into buckets. This is manual work but you only need a minimal, practical list — aim for 6–12 canonical options per field.
Decide safe mappings: map clear variants automatically, create an "Other — review" bucket for ambiguous cases, and keep the original free text in a provenance column (or a spare custom field) so nothing is lost.
Backfill in controlled batches: test on a 50–200 record subset, then run bulk updates using your CRM’s bulk update/import tool or a small automation. On Salesforce use Data Loader or Mass Edit; in HubSpot use imports or workflows; Marketo/Pardot have similar bulk update paths. Keep a rollback snapshot before each batch.
Days 5–7 — Lockdown forms, add quick UI fallbacks and set monitoring/ownership
Turn the canonical list into a dropdown/picklist on the platform (HubSpot property options, Salesforce picklist/record types, Marketo custom field, Pardot prospect field). For external forms, enforce the dropdown; for internal edits, show the dropdown with a small "Other (explain)" free‑text fallback so people can capture a real exception without breaking automations.
Add lightweight monitoring and one owner: create a saved list or report that shows records still using free text or newly created "Other" values, and check it weekly for 4–6 weeks. Give one person responsibility to merge new variants into the canonical list or assign them to the review queue.
Document the one‑sentence rule for the field (who sets it, when to use Other, and how to add a new option). If you want practical help to run this as a week‑long project, Optira can support the audit, mappings and safe backfill.