Health Score Monitor

---
name: health-score-monitor
description: Design and maintain customer health scoring systems with automated alerts and trending analysis
license: MIT
metadata:
  author: ClawFu
  version: 1.0.0
  mcp-server: "@clawfu/mcp-skills"
---

# Health Score Monitor

> Build systematic customer health monitoring with composite scores, trend tracking, and automated alerting for proactive customer success.

## When to Use This Skill

- Designing health score frameworks
- Setting up monitoring dashboards
- Creating alert thresholds
- Analyzing health trends across portfolio
- Optimizing existing health models

## Methodology Foundation

Based on **Gainsight Health Score Design** and **Totango Customer Success metrics**, focusing on:
- Multi-dimensional scoring
- Leading vs lagging indicators
- Score normalization
- Trend analysis
- Alert prioritization

## What Claude Does vs What You Decide

| Claude Does | You Decide |
|-------------|------------|
| Designs scoring framework | Dimension weights |
| Calculates composite scores | Alert thresholds |
| Identifies trending patterns | Intervention triggers |
| Suggests monitoring cadence | Resource allocation |
| Recommends improvements | Business rule exceptions |

## What This Skill Does

1. **Framework design** - Multi-factor health model
2. **Score calculation** - Weighted composite scores
3. **Trend analysis** - Direction and velocity
4. **Alert rules** - When to notify teams
5. **Portfolio view** - Aggregate health visibility

## How to Use

```
Design a health score monitor for my customer portfolio:

Business Context:
- Product type: [SaaS/Platform/Service]
- Contract model: [Annual/Monthly/Multi-year]
- Key value metric: [What shows customer success?]
- CSM:Account ratio: [1:X]

Available Data Points:
- Product: [List usage metrics available]
- Support: [List support metrics available]
- Financial: [List financial signals]
- Relationship: [List engagement data]

Current Challenges:
- [What's not working with current approach?]
```

## Instructions

### Step 1: Define Health Dimensions

**Standard 4-Pillar Model:**

| Dimension | Weight | What It Answers |
|-----------|--------|-----------------|
| **Product** | 30-40% | Are they using it? |
| **Support** | 15-25% | Are they happy? |
| **Financial** | 20-25% | Are they paying/growing? |
| **Relationship** | 20-25% | Are we connected? |

Adjust weights based on your business:
- High-touch: Increase Relationship
- Usage-based pricing: Increase Product
- Support-intensive: Increase Support

### Step 2: Select Metrics per Dimension

**Product Health Metrics:**
| Metric | Type | Scoring |
|--------|------|---------|
| DAU/MAU | Leading | % of benchmark |
| Feature adoption | Leading | % features used |
| Time in product | Leading | Minutes vs avg |
| Key feature usage | Leading | Yes/No or frequency |
| Usage trend | Leading | Up/Flat/Down |

**Support Health Metrics:**
| Metric | Type | Scoring |
|--------|------|---------|
| CSAT score | Lagging | 1-5 scale |
| Ticket volume | Leading | vs baseline |
| Escalations | Leading | Count (negative) |
| Response sentiment | Leading | Positive/Neutral/Negative |
| Time to resolution | Lagging | vs SLA |

**Financial Health Metrics:**
| Metric | Type | Scoring |
|--------|------|---------|
| Payment status | Lagging | Current/Late |
| Expansion | Leading | Pipeline/Discussion |
| Contract type | Lagging | Multi-year bonus |
| Renewal date | Context | Days remaining |
| ARR trend | Lagging | Growth/Flat/Decline |

**Relationship Health Metrics:**
| Metric | Type | Scoring |
|--------|------|---------|
| Champion engaged | Leading | Active/Passive/None |
| Exec sponsor | Leading | Yes/No |
| NPS/CSAT | Lagging | Score |
| QBR attendance | Leading | Regular/Sporadic/None |
| Last touch | Leading | Days since contact |

### Step 3: Create Scoring Rules

**Example Scoring Matrix:**

```
Product Score (0-100):
+30: DAU/MAU > 70%
+20: DAU/MAU 50-70%
+10: DAU/MAU 30-50%
+0:  DAU/MAU < 30%

+25: Feature adoption > 60%
+15: Feature adoption 40-60%
+5:  Feature adoption < 40%

+20: Usage trending up
+10: Usage stable
-10: Usage trending down

+15: Key feature used weekly
+5:  Key feature used monthly
-10: Key feature abandoned

Max: 100 (or normalize)
```

### Step 4: Set Alert Thresholds

| Condition | Alert Level | Action |
|-----------|-------------|--------|
| Score drops >15 pts | 🔴 Critical | Immediate CSM review |
| Score below 40 | 🟠 High | Intervention required |
| Score 40-60 | 🟡 Medium | Proactive outreach |
| Renewal <60 days + <60 score | 🔴 Critical | Save plan |
| Usage drop >30% WoW | 🟡 Medium | Check-in call |

### Step 5: Define Monitoring Cadence

| Activity | Frequency | Owner |
|----------|-----------|-------|
| Score refresh | Daily/Weekly | Automated |
| Alert review | Daily | CSM |
| Portfolio review | Weekly | CS Manager |
| Model calibration | Quarterly | CS Ops |

## Examples

### Example 1: SaaS Health Score Design

**Input:**
```
Design health score for our B2B SaaS platform:

Business Context:
- Product: Project management software
- Contract: Annual, avg $50K
- Value metric: Projects completed, team adoption
- CSM ratio: 1:40

Available Data:
- Product: Logins, projects created, tasks completed, integrations used
- Support: Zendesk tickets, CSAT, NPS
- Financial: ARR, payment status, expansion pipeline
- Relationship: Meeting attendance, email engagement

Challenges:
- Too many "yellow" accounts, can't prioritize
- Alerts are noisy, CSMs ignoring them
```

**Output:**
```
## Health Score Framework: Project Management SaaS

### Design Principles

Given 1:40 ratio and "alert fatigue" issue:
1. **Prioritize leading indicators** - Catch issues early
2. **Reduce noise** - Tighter alert thresholds
3. **Enable triage** - Clear Red/Yellow/Green actions

---

### Scoring Model

#### Dimension Weights
| Dimension | Weight | Rationale |
|-----------|--------|-----------|
| Product | 40% | Usage = value realization |
| Support | 15% | Lower touch model |
| Financial | 25% | Contract health critical |
| Relationship | 20% | Moderate touch needed |

---

#### Product Score (40 points max)

| Metric | Criteria | Points |
|--------|----------|--------|
| **Weekly Active Users** | | |
| | >70% of seats | 12 |
| | 50-70% | 8 |
| | 30-50% | 4 |
| | <30% | 0 |
| **Projects Created (monthly)** | | |
| | >5 per user | 10 |
| | 2-5 per user | 6 |
| | <2 per user | 2 |
| **Tasks Completed** | | |
| | >80% completion rate | 8 |
| | 50-80% | 5 |
| | <50% | 0 |
| **Integrations** | | |
| | 2+ active | 6 |
| | 1 active | 3 |
| | None | 0 |
| **Usage Trend** | | |
| | Increasing | 4 |
| | Stable | 2 |
| | Declining | -4 |

---

#### Support Score (15 points max)

| Metric | Criteria | Points |
|--------|----------|--------|
| **CSAT** | | |
| | >4.5 | 6 |
| | 4.0-4.5 | 4 |
| | 3.5-4.0 | 2 |
| | <3.5 | 0 |
| **Ticket Volume** | | |
| | Below baseline | 5 |
| | At baseline | 3 |
| | 2x+ baseline | 0 |
| **Escalations** | | |
| | None (90 days) | 4 |
| | Resolved | 2 |
| | Open | -4 |

---

#### Financial Score (25 points max)

| Metric | Criteria | Points |
|--------|----------|--------|
| **Payment Status** | | |
| | Current | 10 |
| | 30 days late | 5 |
| | 60+ days | 0 |
| **Expansion** | | |
| | Closed this year | 8 |
| | In discussion | 5 |
| | No opportunity | 2 |
| **Contract Type** | | |
| | Multi-year | 7 |
| | Annual | 4 |
| | Month-to-month | 0 |

---

#### Relationship Score (20 points max)

| Metric | Criteria | Points |
|--------|----------|--------|
| **Champion Status** | | |
| | Active advocate | 8 |
| | Engaged | 5 |
| | Passive | 2 |
| | Gone/None | 0 |
| **NPS** | | |
| | 9-10 (Promoter) | 6 |
| | 7-8 (Passive) | 4 |
| | 0-6 (Detractor) | 0 |
| **Last Touch** | | |
| | <30 days | 6 |
| | 30-60 days | 4 |
| | 60-90 days | 2 |
| | >90 days | 0 |

---

### Health Bands

| Score | Status | Count Target | CSM Action |
|-------|--------|--------------|------------|
| 80-100 | 🟢 Healthy | 60% | Quarterly touch, expansion |
| 60-79 | 🟡 Monitor | 25% | Monthly touch, watch trends |
| 40-59 | 🟠 At Risk | 12% | Bi-weekly, intervention plan |
| 0-39 | 🔴 Critical | 3% | Weekly, executive escalation |

**Target Distribution** at 1:40 ratio:
- 24 Healthy (quarterly = 8 touches/month)
- 10 Monitor (monthly = 10 touches)
- 5 At Risk (bi-weekly = 10 touches)
- 1 Critical (weekly = 4 touches)
- **Total: 32 touch points/month** (manageable)

---

### Alert Rules (Noise Reduction)

**Only Alert When:**

| Alert | Condition | Frequency |
|-------|-----------|-----------|
| 🔴 Critical New | Score drops below 40 | Immediate |
| 🔴 Renewal Risk | Score <60 AND renewal <60 days | Immediate |
| 🟠 Score Drop | Drops >15 points in 7 days | Daily digest |
| 🟡 Watch | Usage down >30% WoW | Weekly digest |

**Suppress Alerts For:**
- Accounts <30 days old (onboarding)
- Accounts in active implementation
- Known seasonal low periods
- Manual "snooze" by CSM

---

### Dashboard Views

**Portfolio Summary:**
```
┌─────────────────────────────────────┐
│ My Portfolio: 40 accounts           │
├─────────────────────────────────────┤
│ 🟢 24 (60%)  │ 🟡 10 (25%)         │
│ 🟠  5 (12%)  │ 🔴  1 (3%)          │
├─────────────────────────────────────┤
│ ⚠️ 3 accounts dropped this week    │
│ 📈 5 accounts improved             │
└─────────────────────────────────────┘
```

**Account Drill-Down:**
```
┌─────────────────────────────────────┐
│ Account: TechCorp | Score: 62 🟡    │
├─────────────────────────────────────┤
│ Product:      28/40  ████████░░    │
│ Support:      12/15  █████████░    │
│ Financial:    14/25  ██████░░░░    │
│ Relationship: 8/20   ████░░░░░░    │
├─────────────────────────────────────┤
│ Trend: ↘️ -8 pts (30 days)          │
│ Renewal: 90 days                    │
│ Action: Schedule check-in          │
└─────────────────────────────────────┘
```
```

### Example 2: Health Trend Analysis

**Input:**
```
Analyze health trends for my portfolio:

Q4 Scores:
- Oct: 23 Green, 12 Yellow, 4 Orange, 1 Red
- Nov: 20 Green, 14 Yellow, 5 Orange, 1 Red
- Dec: 18 Green, 13 Yellow, 7 Orange, 2 Red

Also:
- 3 accounts churned in Q4
- 2 expansions closed
- NPS survey: 42 average (was 48)
```

**Output:**
```
## Q4 Health Trend Analysis

### Portfolio Drift Summary

| Status | Oct | Nov | Dec | Change |
|--------|-----|-----|-----|--------|
| 🟢 Green | 23 (58%) | 20 (50%) | 18 (45%) | ↘️ -13% |
| 🟡 Yellow | 12 (30%) | 14 (35%) | 13 (33%) | → +3% |
| 🟠 Orange | 4 (10%) | 5 (13%) | 7 (18%) | ↗️ +8% |
| 🔴 Red | 1 (2%) | 1 (2%) | 2 (5%) | ↗️ +3% |

**Trend: ⚠️ Deteriorating**
- 5 accounts moved from Green to lower status
- Orange/Red grew from 12% to 23%
- Portfolio health declining month-over-month

---

### Churn Correlation

| Churned Account | Last Score | Days at Red |
|-----------------|------------|-------------|
| Account A | 28 | 45 days |
| Account B | 35 | 30 days |
| Account C | 41 | 22 days |

**Insight**: All churned accounts were Red/Orange for 20+ days
**Action**: Accounts at Orange >14 days need intervention

---

### Key Drivers of Decline

**Analyzing accounts that dropped:**

| Factor | Accounts Affected | Avg Point Drop |
|--------|-------------------|----------------|
| Usage decline | 8 | -12 pts |
| Champion change | 3 | -18 pts |
| Support issues | 4 | -8 pts |
| Payment delays | 2 | -6 pts |

**Primary Driver**: Usage decline (likely seasonal + holiday)

---

### NPS Correlation

| NPS Segment | Avg Health Score | Q4 Change |
|-------------|------------------|-----------|
| Promoters (9-10) | 78 | -3 |
| Passives (7-8) | 58 | -6 |
| Detractors (0-6) | 38 | -10 |

**Insight**: Detractor scores dropping fastest
**Action**: Prioritize intervention for Detractors

---

### Q1 Recommendations

**Immediate (Week 1):**
1. Save plan for 2 Red accounts
2. Intervention for 7 Orange accounts
3. Outreach to 3 champion-change accounts

**Short-term (Month 1):**
1. Re-engagement campaign for low-usage accounts
2. Proactive support reach-out to ticket-heavy accounts
3. NPS follow-up calls with Detractors

**Strategic (Quarter):**
1. Investigate seasonal patterns (plan for Q4 2026)
2. Champion backup program implementation
3. Revisit Orange threshold (too many?)

---

### Target for Q1

| Status | Dec | Q1 Target | Delta |
|--------|-----|-----------|-------|
| 🟢 Green | 18 | 22 | +4 |
| 🟡 Yellow | 13 | 14 | +1 |
| 🟠 Orange | 7 | 3 | -4 |
| 🔴 Red | 2 | 1 | -1 |

**Success = Move 5 accounts up at least one tier**
```

## Skill Boundaries

### What This Skill Does Well
- Designing health frameworks
- Calculating composite scores
- Identifying trends and patterns
- Setting alert thresholds

### What This Skill Cannot Do
- Access your actual data
- Implement in your systems
- Know your specific business rules
- Replace data engineering

### When to Escalate to Human
- Threshold decisions
- Weight calibration based on churn data
- Alert rule tuning
- Cross-functional alignment

## Iteration Guide

### Follow-up Prompts
- "How should I weight these dimensions differently for enterprise vs SMB?"
- "What metrics should I add for a usage-based pricing model?"
- "Create alert rules that reduce noise by 50%."
- "Design a health score for a high-touch services business."

## References

- Gainsight Health Score Best Practices
- Totango Customer Health Methodology
- ChurnZero Scoring Framework
- Customer Success Benchmarks

## Related Skills

- `churn-prediction` - Deeper churn analysis
- `account-health` - RevOps perspective
- `expansion-signals` - Growth focus

## Skill Metadata

- **Domain**: Customer Success
- **Complexity**: Advanced
- **Mode**: centaur
- **Time to Value**: 2-4 hours for framework design
- **Prerequisites**: Data availability assessment