--- name: crm-management-pipeline description: Manage CRM system including pipeline management, deal staging, forecasting, activity tracking, data hygiene, sales process automation, and CRM analytics. Use when managing sales pipeline, setting up CRM workflows, creating forecasts, cleaning CRM data, automating sales processes, or analyzing sales metrics. Triggers on phrases like "CRM management", "sales pipeline", "pipeline management", "deal stages", "sales forecasting", "pipeline health", "CRM data hygiene", "sales process", "sales automation", "activity tracking", "lead management", "opportunity management", "sales metrics", "win rate", "sales velocity", "pipeline coverage", "quota attainment". --- # CRM Management & Pipeline Manage CRM system including pipeline management, deal staging, forecasting, activity tracking, data hygiene, and sales process automation. ## Workflow ### 1. Sales Pipeline Configuration ``` SALES PIPELINE STAGES ═══════════════════════════════════════ Stage Definition Exit Criteria Probability ───────────────────────────────────────────────────────────────────────────────────────── 1. Lead New contact, not qualified Contact info complete 0% 2. Qualified Meets ICP, has need BANT/SNAP completed 10% 3. Discovery Needs assessed, pain confirmed Discovery call completed 25% 4. Demo/Presentation Solution presented Demo completed 40% 5. Proposal Proposal sent Proposal delivered 60% 6. Negotiation Terms being discussed Legal/security review 75% 7. Closed Won Deal closed Contract signed 100% 8. Closed Lost Deal lost Reason recorded 0% SALES PROCESS RULES: ═══════════════════════════════════════ → Stage advancement: Must meet exit criteria → No skipping stages (enforced in CRM) → Staleness: Alert if no activity for 14 days → Aging: Auto-close if no activity for 90 days → Deal size: Minimum $5,000 (below = disqualify) → Next step: Required before stage change → Close date: Must be in future, review if >60 days out PIPELINE HEALTH METRICS: ═══════════════════════════════════════ Metric Target Current Status ─────────────────────────────────────────────────────────────── Pipeline coverage ≥ 3x quota 3.2x ✓ Good Weighted pipeline ≥ 2x quota 2.4x ✓ Good Average deal size ≥ $25K $28K ✓ Above Sales cycle ≤ 60 days 52 days ✓ Below Win rate ≥ 25% 28% ✓ Above Pipeline velocity ≥ $50K/month $62K/month ✓ Above Stale deals ≤ 10% 8% ✓ Below ``` ### 2. Deal Management ``` DEAL TRACKING FRAMEWORK ═══════════════════════════════════════ Deal Card (CRM Record): ═══════════════════════════════════════ Basic Info: → Deal name: [Company] — [Product/Service] → Account: [Account record linked] → Primary contact: [Name, title, email, phone] → Other contacts: [Champion, economic buyer, technical] → Deal value: $[amount] → Expected close date: [Date] → Stage: [Current stage] → Probability: [Auto-calculated] Qualification: → Budget: Confirmed ($[amount]) → Authority: Identified (Economic buyer: [Name]) → Need: Documented ([specific pain point]) → Timeline: [Close date, urgency level] → Competition: [Competitor names, status] → MEDDIC: [Metrics, Economic buyer, Decision process, Decision criteria, Identify pain, Champion] Activity History: → Calls: [Count, dates, notes] → Emails: [Count, dates, subjects] → Meetings: [Count, dates, attendees] → Demos: [Count, dates, feedback] → Last activity: [Date, type, summary] Next Steps: → Action: [Specific next action] → Owner: [Rep name] → Due date: [Date] → Dependencies: [Any blockers] OPPORTUNITY SCORING: ═══════════════════════════════════════ Scoring Model (0-100): ═══════════════════════════════════════ Factor Weight Score Criteria Score ──────────────────────────────────────────────────────────────────────────────── Fit (ICP match) 20% Industry, size, geography match 0-20 Engagement 20% Meeting count, email response rate 0-20 Timeline 15% Close date within 90 days 0-15 Budget 15% Budget confirmed and adequate 0-15 Champion 15% Internal champion identified 0-15 Competition 10% No competition / strong differentiator 0-10 Pain urgency 5% Urgent need expressed 0-5 Score Interpretation: → 80-100: Hot (focus here) → 60-79: Warm (nurture) → 40-59: Lukewarm (evaluate) → <40: Cold (consider disqualifying) ``` ### 3. Sales Forecasting ``` SALES FORECASTING ═══════════════════════════════════════ Forecast Methodology: ═══════════════════════════════════════ Pipeline-based Forecast: → Sum of (deal value × probability) per stage → Weighted by historical win rates per stage Rep-based Forecast: → Each rep provides commitment (committed, best case, pipeline) → Manager adjusts based on deal assessment Commitment Levels: ═══════════════════════════════════════ Level Meaning Criteria ──────────────────────────────────────────────────────────────────────── Committed Will close this quarter Contract in legal, verbal agreement Best Case Likely to close Negotiation stage, strong signals Pipeline Possible but uncertain Early stages, multiple variables Omitted Not expected to close Weak signals, long timeline FORECAST REPORT (Q1 2025): ═══════════════════════════════════════ Rep Committed Best Case Pipeline Total Quota Attainment ────────────────────────────────────────────────────────────────────────────────────────── Rep A $180,000 $50,000 $120,000 $350,000 $300,000 117% Rep B $150,000 $80,000 $150,000 $380,000 $300,000 127% Rep C $120,000 $40,000 $80,000 $240,000 $300,000 80% Rep D $200,000 $60,000 $100,000 $360,000 $300,000 120% Rep E $90,000 $30,000 $60,000 $180,000 $300,000 60% ────────────────────────────────────────────────────────────────────────────────────────── Total $740,000 $260,000 $510,000 $1,510,000 $1,500,000 101% Forecast Summary: → Committed: $740,000 (49% of quota) → Best case: $1,000,000 (67% of quota) → Full pipeline: $1,510,000 (101% of quota) → Confidence level: HIGH (committed + strong best case) ``` ### 4. CRM Data Hygiene ``` CRM DATA HYGIENE ═══════════════════════════════════════ Data Quality Rules: ═══════════════════════════════════════ Required Fields: ═══════════════════════════════════════ Stage Required Fields ──────────────────────────────────────────────────────────────────────── Lead Company, email, source Qualified Industry, employee count, revenue Discovery Pain point, budget range, timeline Demo Decision process, competitors Proposal Deal value, expected close date Negotiation Legal contact, procurement process Validation Rules: → Email: Valid format (automated check) → Phone: Valid format (E.164) → Website: Valid URL format → Deal value: > $0, < $10M → Close date: In future → Industry: From picklist → Employee count: > 0 DATA CLEANUP PROCESS: ═══════════════════════════════════════ → Monthly: Duplicate detection and merge → Quarterly: Stale deal review and cleanup → Semi-annual: Full data audit → Ongoing: Automated validation rules Current Data Quality: ═══════════════════════════════════════ Metric Target Current Status ──────────────────────────────────────────────────────────────── Complete records ≥ 95% 92% ⚠️ Below Duplicate rate ≤ 1% 0.8% ✓ Good Email valid ≥ 98% 97% ⚠️ Below Phone valid ≥ 95% 94% ⚠️ Below Industry populated ≥ 90% 88% ⚠️ Below Next step set ≥ 95% 91% ⚠️ Below DUPLICATE DETECTION: ═══════════════════════════════════════ → Match rules: Company name + email, phone + name → Fuzzy matching: Similar names (fuzzy logic) → Auto-merge: Low confidence → manual review → Prevention: Duplicate check on create/edit ``` ### 5. Sales Analytics ``` SALES ANALYTICS DASHBOARD ═══════════════════════════════════════ Revenue Metrics: ═══════════════════════════════════════ Metric This Quarter Last Quarter YoY Status ──────────────────────────────────────────────────────────────────────── Revenue $890,000 $820,000 +23% ✓ Growth New logos 45 38 +18% ✓ Growth Expansion revenue $120,000 $95,000 +26% ✓ Growth Churned revenue -$35,000 -$42,000 -17% ✓ Better Net revenue $975,000 $873,000 +24% ✓ Growth Pipeline Metrics: ════════─────────────────────────────────────────────────────────────── Metric Value Target Status ──────────────────────────────────────────────────────────────── Total pipeline $1,510,000 $1,200,000 ✓ Above Pipeline coverage 3.2x 3x ✓ Above Weighted pipeline $1,000,000 $600,000 ✓ Above Average deal size $28,000 $25,000 ✓ Above Sales cycle 52 days 60 days ✓ Below Win rate 28% 25% ✓ Above ACTIVITY METRICS (per rep, monthly): ═══════════════════════════════════════ Rep Calls Emails Meetings Demos New Leads Deals Won ──────────────────────────────────────────────────────────────────────────────────── Rep A 280 450 35 12 45 4 Rep B 250 420 32 10 40 3 Rep C 220 380 28 8 35 2 Rep D 300 500 40 15 50 5 Rep E 180 320 22 6 28 1 Activity-to-deal ratio: 60 activities → 1 deal won (average) Top performer: Rep D (167 activities → 1 deal won) ``` ## Edge Cases - **Enterprise sales**: Long cycles, complex deals, multi-threading - **Transactional**: High volume, low touch, automated - **Subscription**: Renewal pipeline, expansion tracking - **Channel**: Partner deals, co-sell tracking - **Multi-currency**: International deals, FX handling ## Integration Points - **CRM**: Salesforce, HubSpot, Pipedrive, Zoho - **CPQ**: Salesforce CPQ, HubSpot CPQ - **Analytics**: Tableau, Power BI, Looker, Databox - **Automation**: Zapier, Make, Salesforce Flow - **Email**: Gmail, Outlook, Outreach, SalesLoft - **Communication**: Slack, Microsoft Teams ## Output ### CRM & Pipeline Status ``` CRM & PIPELINE — Q4 2024 ═══════════════════════════════════════ Total pipeline: $1,510,000 (3.2x quota) Forecast (committed): $740,000 (49% of quota) Win rate: 28% (target: ≥25%) ✓ Sales cycle: 52 days (target: ≤60 days) ✓ Data quality: 92% complete (target: ≥95%) ⚠️ Duplicate rate: 0.8% (target: ≤1%) ✓ Active deals: 54 (32 in progress, 8 negotiated, 14 early) Revenue: $890,000 (↑ 23% YoY) Next priority: Improve data quality to 95%, clean stale deals ```