Command note: An automation is only as reliable as the messiest record it reads.
When "AZ", "Ariz." and "Arizona" all live in the same field, every filter, branch and AI summary has to guess. Guessing is where leads fall through.
Where mixed formats hide:
• Phone numbers with and without country codes
• Dates typed as text instead of stored in date fields
• States and cities spelled three different ways
• Yes/No fields that also hold "y", "maybe" and blanks
• Lead source values that drift every time someone adds a form
Do it now:
1) Pick the five fields your workflows and reports lean on most.
2) Write one allowed format for each, with an example, in the account notes.
3) Where a field drives a branch or filter, use a dropdown, date or number field instead of free text. Build the new field; don't rename a live one.
4) Point every form and import at those same fields and options.
5) Pull 50 recent contacts and fix the outliers by hand.
6) Recheck the same five fields next month.
A filter can only find what was written the same way twice.