Sales AI Skill
Crm Management Pipeline
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, auto...
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% ✓ Below2. 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/edit5. 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