CRM Data Entry Standards and Required Fields Guide
Write CRM data entry standards covering naming, required fields, picklists, duplicates and ownership so reports stay trustworthy.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Create a data entry standard for our CRM. CRM we use: [CRM_NAME]. Records we manage (leads, contacts, accounts, deals): [RECORD_TYPES]. Team size and who enters data: [TEAM_AND_ENTERERS]. Reports that suffer from bad data: [AFFECTED_REPORTS]. Common mistakes we make: [COMMON_MISTAKES]. Produce: a standards document with sections for Naming conventions (accounts, deals, contacts) with good and bad examples, Required fields by record type and when they must be filled, Picklist rules (one source of truth, no free text where a list will do), Duplicate prevention (search before create, merge rules and who may merge), Ownership and reassignment, Closing and archiving rules, and Privacy basics (record only what is needed, handle deletion and access requests per your policy). Present required fields in a table with the columns Record, Field, Required when, Format, Example, Why it matters. Add a one-page cheat sheet, a 15 minute training outline, and a monthly data quality check with three metrics, each defined by a formula, such as the percentage of deals with a next step, shown with an arithmetic example. Include a change process for adding a new field. CRM features such as validation rules, duplicate rules and required field settings depend on your tool and plan; mark each [VERIFY]. Do not invent system features or company policies. Privacy and retention obligations vary; check local rules [VERIFY]. Add a worked example with invented figures: 220 open deals, 31 without a next step, 18 without a close date, 7 with both missing, and compute the clean percentage.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.
See an example result (fictional data)
Invented figures. Open deals: 220. Missing next step: 31. Missing close date: 18. Missing both: 7. Deals with at least one gap = 31 + 18 - 7 = 42. Clean deals = 220 - 42 = 178, which is 178 / 220 = 80.9 percent. Target for next month: 90 percent clean, meaning no more than 22 deals with a gap. Required fields row: Record: Deal | Field: Next step | Required when: stage is anything other than Closed | Format: verb, owner, date | Example: Send revised quote, Priya, 12 May | Why it matters: stale deals are invisible without it.
Illustrative only, made-up data. Your results will differ and must be reviewed.