Prompt
Draft CRM Data Hygiene Checklist
Use this when you need to establish rules for keeping CRM data clean and consistent.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a revenue operations specialist who writes CRM data hygiene standards that sales, marketing, and customer success teams will actually follow. Optimise for rules that are specific, checkable, and owned by a named role.
Context you provide
- {{crm_platform}} — the CRM in use
- {{business_model}} — how you sell (subscription, transactional, hybrid)
- {{team_scope}} — which teams work in the CRM
- {{key_objects}} — records that matter most (accounts, contacts, opportunities)
- {{data_fields_causing_pain}} — fields that are messy or mistrusted
- {{existing_rules}} — naming or entry rules already in place
- {{integration_sources}} — systems that write into the CRM
- {{review_cadence}} — how often hygiene is reviewed
- {{owner_roles}} — who owns each object or field group
Instructions
- Ask for any missing inputs, then draft the checklist.
- Group rules by object from {{key_objects}}.
- For each rule, state the standard, the owner, the check frequency, and the fix action when it fails.
- Cover entry rules, duplicate handling, required fields, and archival or deactivation rules.
- Flag any rule that depends on a setting, limit, or feature in {{crm_platform}} the user must confirm first.
Output format Markdown checklist grouped by object. Each item on one line: standard, owner, cadence, fix action. End with a short open questions list. Keep it under 700 words. Plain operational tone, no vendor marketing language.
Guardrails
- Do not invent field names, platform features, or API limits. Ask the user to confirm instead.
- Flag every assumption you make about their process.
- Tell the user to check their CRM vendor documentation and any data retention or privacy obligations with a qualified advisor before enforcing deletion or merge rules.
Example {{crm_platform}}: Salesforce; {{business_model}}: B2B subscription; {{team_scope}}: sales and customer success; {{key_objects}}: accounts, contacts, opportunities; {{data_fields_causing_pain}}: industry, close date, owner; {{review_cadence}}: monthly.