account-health

$npx mdskill add guia-matthieu/clawfu-skills/account-health

Evaluates customer account health through multi-dimensional analysis to predict retention and identify expansion opportunities.

  • Helps with monthly account reviews, building dashboards, and prioritizing customer success management attention.
  • Integrates with product usage, support sentiment, payment status, and relationship signals for analysis.
  • Decides based on a weighted composite health score framework derived from Gainsight and Lincoln Murphy methodologies.
  • Presents results as composite scores, risk signals, trend analysis, and suggested actions for intervention.
SKILL.md
.github/skills/account-healthView on GitHub ↗
---
name: account-health
description: Assess customer account health using product usage, support sentiment, payment status, and relationship signals
license: MIT
metadata:
  author: ClawFu
  version: 1.0.0
  mcp-server: "@clawfu/mcp-skills"
---

# Account Health Scoring

> Evaluate customer account health through multi-dimensional analysis to predict retention, identify expansion opportunities, and prevent churn.

## When to Use This Skill

- Monthly/quarterly account reviews
- Building customer health dashboards
- Prioritizing CSM attention
- Identifying expansion opportunities
- Churn risk assessment

## Methodology Foundation

Based on **Gainsight Customer Health methodology** and **Lincoln Murphy's Customer Success principles**, combining:
- Product adoption metrics
- Support/sentiment signals
- Financial health (payments, expansion)
- Relationship strength (engagement)

## What Claude Does vs What You Decide

| Claude Does | You Decide |
|-------------|------------|
| Designs health score framework | Weight of each factor |
| Calculates composite scores | Threshold for intervention |
| Identifies risk signals | Resource allocation |
| Suggests actions by score | Escalation decisions |
| Tracks trend direction | Account save vs. let go |

## What This Skill Does

1. **Framework design** - Multi-factor health scoring model
2. **Score calculation** - Weighted composite health score
3. **Risk identification** - Early warning signals
4. **Trend analysis** - Health trajectory over time
5. **Action recommendations** - Interventions by health status

## How to Use

```
Assess health for this account:

Account: [Company Name]
Contract: $[ARR], [Renewal Date]
Tenure: [Months as customer]

Product Usage:
- Daily active users: X / Y licensed
- Feature adoption: X% of features used
- Login frequency: [Daily/Weekly/Monthly]
- Last login: [Date]

Support:
- Tickets this quarter: X
- CSAT score: X/5
- Open escalations: X
- Last interaction sentiment: [Positive/Neutral/Negative]

Financial:
- Payment status: [Current/Late/At Risk]
- Expansion conversations: [Yes/No]
- Contract modifications: [None/Downgrade/Upgrade]

Relationship:
- Executive sponsor: [Active/Passive/Gone]
- Champion status: [Strong/Weak/Churned]
- NPS score: X
- QBR attendance: [Regular/Sporadic/None]
```

## Instructions

### Step 1: Define Health Dimensions (4 Pillars)

| Dimension | Weight | What It Measures |
|-----------|--------|------------------|
| Product | 30% | Are they using the product? |
| Support | 20% | Are they happy with service? |
| Financial | 25% | Are they paying and growing? |
| Relationship | 25% | Do we have strong contacts? |

### Step 2: Score Each Dimension (0-100)

**Product Health (30%):**
| Metric | Score |
|--------|-------|
| DAU/MAU > 70% | +30 |
| DAU/MAU 50-70% | +20 |
| DAU/MAU 30-50% | +10 |
| DAU/MAU < 30% | +0 |
| Feature adoption > 60% | +25 |
| Feature adoption 40-60% | +15 |
| Feature adoption < 40% | +5 |
| No login 7+ days | -20 |
| No login 30+ days | -40 |
| Usage trending up | +15 |
| Usage trending down | -15 |

**Support Health (20%):**
| Metric | Score |
|--------|-------|
| CSAT > 4.5 | +30 |
| CSAT 4.0-4.5 | +20 |
| CSAT 3.5-4.0 | +10 |
| CSAT < 3.5 | +0 |
| No escalations | +25 |
| Resolved escalations | +15 |
| Open escalations | -20 |
| Negative sentiment | -25 |
| Tickets trending down | +10 |
| Tickets trending up | -10 |

**Financial Health (25%):**
| Metric | Score |
|--------|-------|
| Payment current | +30 |
| Payment 30 days late | +10 |
| Payment 60+ days late | -20 |
| Expansion discussion | +20 |
| Upgrade completed | +30 |
| Downgrade risk | -30 |
| Multi-year contract | +20 |
| Month-to-month | -10 |

**Relationship Health (25%):**
| Metric | Score |
|--------|-------|
| Exec sponsor active | +30 |
| Champion engaged | +25 |
| NPS Promoter (9-10) | +25 |
| NPS Passive (7-8) | +10 |
| NPS Detractor (0-6) | -20 |
| Regular QBR attendance | +20 |
| No QBR in 6 months | -15 |
| Champion left company | -30 |

### Step 3: Calculate Composite Score

```
Health Score = (Product × 0.30) + (Support × 0.20) +
               (Financial × 0.25) + (Relationship × 0.25)
```

### Step 4: Assign Health Status

| Score | Status | Color | Action |
|-------|--------|-------|--------|
| 80-100 | Healthy | 🟢 Green | Expand, get referrals |
| 60-79 | Monitor | 🟡 Yellow | Proactive engagement |
| 40-59 | At Risk | 🟠 Orange | Intervention required |
| 0-39 | Critical | 🔴 Red | Executive escalation |

### Step 5: Identify Trend Direction

| Pattern | Signal | Action |
|---------|--------|--------|
| ↗️ Improving | Score up 10+ points | Continue current approach |
| → Stable | Score within 5 points | Monitor for changes |
| ↘️ Declining | Score down 10+ points | Immediate intervention |

## Examples

### Example 1: Healthy Account

**Input:**
```
Account: TechCorp Solutions
Contract: $120K ARR, Renewal: Sep 2026
Tenure: 24 months

Product Usage:
- DAU: 85 / 100 licensed (85%)
- Feature adoption: 72%
- Login frequency: Daily
- Last login: Today

Support:
- Tickets this quarter: 3 (minor issues)
- CSAT: 4.8/5
- Open escalations: 0
- Last interaction: Positive

Financial:
- Payment: Current
- Expansion: Discussing 20 more seats
- Contract: 2-year renewal signed

Relationship:
- Exec sponsor: CTO actively engaged
- Champion: VP Eng, very strong
- NPS: 9
- QBR: Quarterly, well-attended
```

**Output:**
```
## Account Health: TechCorp Solutions

### Overall Score: 92/100 🟢 HEALTHY

### Dimension Scores

| Dimension | Score | Weight | Weighted |
|-----------|-------|--------|----------|
| Product | 95 | 30% | 28.5 |
| Support | 90 | 20% | 18.0 |
| Financial | 95 | 25% | 23.8 |
| Relationship | 90 | 25% | 22.5 |
| **Total** | | | **92.8** |

### Score Breakdown

**Product Health: 95/100** ✅
- DAU/MAU at 85% (+30)
- Feature adoption 72% (+25)
- Daily logins (+20)
- Usage trending stable (+10)
- No concerning signals

**Support Health: 90/100** ✅
- CSAT 4.8 (+30)
- Only 3 minor tickets (+25)
- No escalations (+25)
- Positive sentiment (+10)

**Financial Health: 95/100** ✅
- Payment current (+30)
- Expansion in discussion (+20)
- Multi-year renewal signed (+30)
- No downgrade signals (+15)

**Relationship Health: 90/100** ✅
- CTO actively engaged (+30)
- Strong VP Eng champion (+25)
- NPS 9 (Promoter) (+25)
- Regular QBRs (+20)
- Slight gap: Could add more contacts (-10)

### Trend: → Stable (High)

### Recommended Actions

**Expansion Focus:**
1. Close the 20-seat expansion discussion
2. Introduce new product features for upsell
3. Request case study/testimonial

**Relationship Deepening:**
1. Add 1-2 more stakeholder relationships
2. Invite to customer advisory board
3. Offer early access to beta features

**Risk Mitigation:**
- Champion VP Eng is critical - ensure backup contact
- Document success metrics for renewal proof points
```

### Example 2: At-Risk Account

**Input:**
```
Account: RetailMax Inc
Contract: $85K ARR, Renewal: Apr 2026 (3 months)
Tenure: 18 months

Product Usage:
- DAU: 12 / 50 licensed (24%)
- Feature adoption: 35%
- Login frequency: Weekly
- Last login: 8 days ago

Support:
- Tickets this quarter: 12 (several complaints)
- CSAT: 3.2/5
- Open escalations: 2
- Last interaction: Negative (product complaints)

Financial:
- Payment: 15 days late
- Expansion: No discussions
- Contract: Mentioned budget cuts

Relationship:
- Exec sponsor: CFO, never met
- Champion: Original champion left 2 months ago
- NPS: 5 (Detractor)
- QBR: Skipped last 2
```

**Output:**
```
## Account Health: RetailMax Inc

### Overall Score: 31/100 🔴 CRITICAL

⚠️ **IMMEDIATE ATTENTION REQUIRED**
Renewal in 3 months with multiple critical risk factors.

### Dimension Scores

| Dimension | Score | Weight | Weighted |
|-----------|-------|--------|----------|
| Product | 20 | 30% | 6.0 |
| Support | 25 | 20% | 5.0 |
| Financial | 30 | 25% | 7.5 |
| Relationship | 20 | 25% | 5.0 |
| **Total** | | | **31** |

### Critical Risk Factors 🚨

1. **🔴 Champion Churned** (-30)
   - Original champion left 2 months ago
   - No replacement identified
   - Institutional knowledge lost

2. **🔴 Low Adoption** (24% DAU)
   - Only 12 of 50 users active
   - Indicates low perceived value
   - Hard to justify renewal

3. **🔴 NPS Detractor** (5)
   - Actively unhappy
   - May influence other buyers
   - Requires executive intervention

4. **🟠 Open Escalations** (2)
   - Unresolved issues damaging trust
   - Need immediate resolution

5. **🟠 Payment Late**
   - Could signal budget issues
   - "Budget cuts" mentioned

### Trend: ↘️ Declining

Score dropped ~25 points since champion departure.

### Save Plan: 90-Day Sprint

**Week 1: Triage**
- [ ] Resolve both open escalations
- [ ] CSM call with current users to assess sentiment
- [ ] Identify new potential champion
- [ ] Check payment status/AR outreach

**Week 2-4: Stabilize**
- [ ] Executive sponsor meeting (your VP + their CFO)
- [ ] Onboard new champion
- [ ] Re-training for low-adoption users
- [ ] Document 3 value proof points

**Week 5-8: Rebuild**
- [ ] Adoption bootcamp for inactive users
- [ ] Success planning session
- [ ] Get CSAT above 4.0
- [ ] Monthly check-ins scheduled

**Week 9-12: Renewal**
- [ ] QBR with full stakeholder group
- [ ] Renewal proposal with options
- [ ] Right-size if needed (reduce seats)
- [ ] Multi-year incentive if healthy

### If Save Fails
- Prepare for graceful offboarding
- Document learnings for post-mortem
- Maintain relationship for potential return
- Collect exit feedback

### Success Probability: 40%
Without new champion, save is difficult.
```

## Skill Boundaries

### What This Skill Does Well
- Structured health assessment framework
- Multi-factor scoring with clear logic
- Risk identification and prioritization
- Action recommendations by health tier

### What This Skill Cannot Do
- Access actual product usage data
- Predict specific churn timing
- Know internal customer politics
- Replace CSM relationship judgment

### When to Escalate to Human
- Accounts with complex multi-product relationships
- Strategic accounts with executive relationships
- Accounts involving legal or contractual disputes
- Save decisions requiring investment approval

## Iteration Guide

### Follow-up Prompts
- "What's the #1 action to improve this score by 20 points?"
- "Compare health scores for my top 10 accounts."
- "Build a 30-60-90 day save plan for this account."
- "What early warning signals should I watch for?"

### Continuous Monitoring
1. Score all accounts monthly
2. Alert on 10+ point drops
3. Segment by health tier
4. Track save success rates
5. Refine weights based on churn correlation

## Checklists & Templates

### Monthly Health Review Checklist
- [ ] Pull usage data for all accounts
- [ ] Update support sentiment scores
- [ ] Check payment status
- [ ] Review relationship changes
- [ ] Calculate health scores
- [ ] Triage critical accounts

### Health Score Template
```markdown
## Account: [Name] | Score: X/100 [Emoji]

**Contract**: $X ARR | Renewal: [Date] | Tenure: X months

### Scores
| Dimension | Score | Key Factor |
|-----------|-------|------------|
| Product | /100 | |
| Support | /100 | |
| Financial | /100 | |
| Relationship | /100 | |

### Top Risks
1.
2.

### Actions This Month
1.
2.
```

## References

- Gainsight Customer Health Best Practices
- Lincoln Murphy's Customer Success Metrics
- ChurnZero Customer Health Framework
- Totango Customer Health Scoring

## Related Skills

- `churn-prediction` - Deeper churn analysis
- `qbr-preparation` - Health-informed QBR prep
- `expansion-signals` - Identify growth opportunities

## Skill Metadata

- **Domain**: RevOps
- **Complexity**: Intermediate
- **Mode**: centaur
- **Time to Value**: 20-30 min per account
- **Prerequisites**: Usage data, support history, relationship context
More from guia-matthieu/clawfu-skills