account-health
$
npx mdskill add guia-matthieu/clawfu-skills/account-healthEvaluates 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
- aarrr-metricsMeasure and optimize growth using the AARRR (Pirate Metrics) framework with stage-specific KPIs and funnel analysis
- ab-test-stats"Calculate A/B test statistical significance. Use when: determining if test results are significant; calculating required sample size; estimating test duration; analyzing conversion experiments; making data-driven decisions"
- ad-spend-optimizer"Analyze paid advertising performance across channels and recommend budget reallocation to maximize ROAS and minimize CAC. Use when: planning quarterly ad budget allocation, diagnosing underperforming ad channels, deciding whether to scale spend on a channel, calculating marginal ROI across Google Ads, Meta, LinkedIn, or TikTok, rebalancing media mix after performance shifts, or setting up a test-and-scale framework for new channels."
- ai-bot-log-auditUse when analyzing server logs to understand how AI crawlers (GPTBot, ClaudeBot, PerplexityBot) interact with your site. Use when optimizing content placement for LLM retrieval, diagnosing why AI search isn't citing your content, or auditing crawl patterns to find optimization gaps.
- ai-storyboard-2x2"Créez des storyboards visuellement cohérents en utilisant la technique des 2x2 Grid Shots de PJ Ace, garantissant éclairage, personnages et décors uniformes entre les plans. Use when: **Après avoir finalisé un script vidéo** - Transformer le concept en visuels; **Besoin de cohérence visuelle** - Personnages et éclairage constants entre les plans; **Préparer des assets pour animation** - Frames prêtes pour Veo, Runway, Kling; **Présenter un storyboard client** - Visualisation avant production;..."
- ai-video-concept"Développez une idée créative et structurez un script vidéo optimisé pour la génération IA, en suivant la méthode des scènes de 8 secondes de PJ Ace. Use when: **Démarrer une publicité vidéo IA** - Transformer une idée brute en script structuré; **Créer du contenu vidéo pour les réseaux sociaux** - TikTok, Reels, YouTube Shorts; **Développer un concept de campagne** - Avant de passer au storyboard; **Pitcher une idée vidéo** - Présenter un concept à un client ou une équipe; **Adapter un messag..."
- ai-video-prompting"Générez des prompts optimisés pour chaque modèle de génération vidéo IA (Veo 3, Runway Gen-3, Kling 2.6, Pika), en exploitant leurs forces spécifiques. Use when: **Animer des frames de storyboard** - Transformer des images fixes en vidéo; **Choisir le bon modèle** - Sélectionner Veo, Runway, Kling ou Pika selon le besoin; **Optimiser la qualité de génération** - Prompts structurés pour meilleurs résultats; **Créer des transitions fluides** - Scene extension, first/last frame; **Utiliser le mo..."
- ai-video-qa"Validez la qualité de vos vidéos IA avant publication avec une checklist complète couvrant technique, créatif, et positionnement marque. Use when: **Avant publication** - Dernière validation avant mise en ligne; **Revue client** - Préparer les points de feedback anticipés; **Itération qualité** - Identifier les problèmes à corriger; **Go/No-Go decision** - Décider si la vidéo est prête; **Post-mortem** - Analyser pourquoi une vidéo a (ou n'a pas) performé"
- ai-voice-design"Concevez et générez des voix IA pour vos vidéos en utilisant ElevenLabs ou Qwen3-TTS, avec clonage vocal, design par description, et synchronisation lip-sync. Use when: **Créer une voix de marque** - Définir le ton vocal pour une campagne; **Cloner une voix existante** - Reproduire une voix avec autorisation; **Designer une voix originale** - Créer une voix à partir d'une description; **Multi-personnages** - Gérer plusieurs voix dans une même vidéo; **Lip-sync vidéo IA** - Synchroniser voix e..."
- audience-research"Discover where your audience actually pays attention online using Rand Fishkin's behavioral intelligence methodology—beyond demographics to actionable media affinity data. Use when: **Find where to reach your audience** beyond Google and Facebook ads; **Discover podcasts, YouTube channels, and publications** your audience follows; **Identify influencers and accounts** with real audience overlap; **Plan PR and media outreach** with data-backed target lists; **Improve ad targeting** on YouTube,..."