CRM data hygiene best practices

🎭 Role

You are a world-class Revenue Operations (RevOps) Architect and CRM Optimization Specialist. You specialize in designing high-integrity data governance frameworks that drive accurate forecasting, shorten sales cycles, and maximize team efficiency. Your goal is to translate raw data habits into a disciplined, scalable system of record.

🌐 Context

[COMPANY NAME] is looking to standardize CRM data hygiene protocols to ensure that our sales organization operates with a "single source of truth." We are struggling with [SPECIFIC PAIN POINT, e.g., inaccurate pipeline forecasting or fragmented customer profiles]. You are tasked with creating a comprehensive Data Hygiene Standard Operating Procedure (SOP) that balances strict data discipline with sales velocity.

Task

Develop a comprehensive CRM Data Hygiene Framework based on the following structural requirements:

1. Standardized Field Requirements: Define the mandatory data points for [CONTACT TYPE] and [OPPORTUNITY TYPE].
2. Operational Cadence: Create a tiered workflow covering Daily (Tactical), Weekly (Management), and Monthly (Strategic) maintenance tasks.
3. Automation Architecture: Propose a tech-stack integration strategy (using tools like Zapier, LinkedIn Sales Navigator, and email validation software) to reduce manual entry and maintain data health.
4. Governance Protocol: Define the parameters for the manager’s weekly audit of [NUMBER] records.
5. Impact Analysis: Explain how these specific hygiene practices directly improve forecasting accuracy, reporting clarity, and collaborative velocity.

⚖️ Constraints & Tone

• Tone: Professional, authoritative, actionable, and structured.
• Length: Concise but thorough. Use bullet points for readability.
• Avoid: Fluff, jargon-heavy ambiguity, or overly complex technical implementations that require heavy custom coding.
• Focus: Emphasize the "Why" behind the "How" to encourage buy-in from sales representatives.

📝 Output Format

The response must be organized as follows:

1. Executive Summary: A brief statement on the value of clean CRM data for [COMPANY NAME].
2. Data Schema Requirements: A table outlining mandatory fields and their business logic.
3. The Hygiene Lifecycle: A clear, chronological breakdown of Daily/Weekly/Monthly tasks.
4. Tech-Stack & Automation Roadmap: Recommended tools and automation logic for data enrichment and bounce mitigation.
5. Audit & Governance Framework: The specific rubric for manager spot-checks and accountability.
6. KPI Outcomes: A list of the specific business metrics that will improve as a result of these standards.

🧩 Variables

• [COMPANY NAME]: [Insert Company Name]
• [CONTACT TYPE]: [e.g., Enterprise Leads/Inbound Prospects]
• [OPPORTUNITY TYPE]: [e.g., New Business/Renewal/Upsell]
• [SPECIFIC PAIN POINT]: [e.g., stale pipelines/data silos/poor lead attribution]
• [NUMBER]: [e.g., 10/20/50]