CRM & sales / GUIDE + WORKSHEET
CRM fields your team will actually maintain
Audit CRM fields by the decisions they support, with a keep/change/remove worksheet and a staged retirement process.
THE STARTING POINT
Keep a field when it supports a real decision, handoff, obligation, or integration and someone can maintain it reliably. Change fields with useful intent but unclear definitions. Retire unused fields only after checking reports, automations, exports, and historical requirements that depend on them.
Ask what happens because this field exists
For each field, name the decision or action it enables. 'We might need it later' deserves a different priority from routing an urgent enquiry. Find the person who reads the value and the person responsible for supplying it. If neither can explain the field consistently, clarify the definition before deciding that users simply need more training.
Move questions to the right moment
A field required before the team knows its answer encourages guesses. Separate the minimum needed to create an enquiry from what becomes necessary before a proposal or handoff. Use a small set of clearly defined options when the workflow needs categories. Leave room for an exception instead of forcing every unusual case into the closest misleading label.
Retire carefully and verify dependencies
Inspect workflows, reports, integrations, exports, and historical use before deleting a field. Hiding it from entry screens may be a useful first step while dependencies are resolved. Document a replacement mapping where needed. Check the affected workflow after the change and retain a record of why the field was retired.
WORKED EXAMPLE / ILLUSTRATIVE
A fictional enquiry form audit
The team moves qualification detail out of the first enquiry step and keeps a clear owner. The aim is better information at the right point, not fewer fields at any cost.
| Field | Decision | Change |
|---|---|---|
| Assigned owner | Who takes the next action? | Keep with a fallback owner |
| Detailed project budget | Is a proposal appropriate? | Collect during qualification |
| Legacy region code | No active reader found | Check integration dependencies before retirement |
MAKE IT USEFUL
Field audit card
Repeat for each field in one workflow.
Your notes stay in this page and are not sent to Smithers. Download or copy them before leaving; refreshing clears them.
Before you put it to work
- Check dependencies before deletion.
- Distinguish unknown from not applicable.
- Avoid making staff guess mandatory answers.
- Validate with both data users and data entry staff.
A low fill rate alone does not prove a field is unnecessary. It may be important only for a rare but consequential case.
IF THIS LOOKS FAMILIAR
Your tools. Your particular mess.
The worksheet is yours to use. If the difficult part is making it work with the systems you already have, that's the kind of thing we help with.