CRM Hygiene Audit Process Prompt
Prompt
Design a CRM data hygiene audit. CRM: [HubSpot / Salesforce / Pipedrive] Reps: [number] Common data problems: [stale dates / no next steps / missing contacts / duplicates] Audit frequency: [weekly / monthly / quarterly] Please create: 1. The 10 most important fields for accurate forecasting 2. Rules: what does 'good' vs 'bad' data look like for each? 3. A query or filter to find problem records 4. A process for reps to clean their own pipeline 5. Metrics to track data quality improvement over time
Why it works
Defining the 10 most important fields for accurate forecasting forces the team to agree on what data actually matters before enforcing it — most CRM hygiene failures are caused by enforcing fields that don't serve a clear purpose. The 'good vs. bad' definition per field creates an objective standard that managers can use in pipeline reviews without it feeling like a personal criticism of the rep. Building the audit into pipeline review meetings makes hygiene a weekly conversation rather than a monthly cleanup.
Watch out for
CRM hygiene audits that are enforced punitively will cause reps to game the data rather than improve it — entering fake activity dates or optimistic close dates to pass the audit. Build the process as a coaching conversation rather than a compliance check. Also start with 3-4 critical fields rather than auditing all 10 simultaneously; hygiene improvement is most sustainable when implemented incrementally.
Used by