Get the FREE Ultimate OpenClaw Setup Guide →

customer-health-analyst

npx machina-cli add skill ncklrs/startup-os-skills/customer-health-analyst --openclaw
Files (1)
SKILL.md
8.7 KB

Customer Health Analyst

Expert guidance for customer health scoring, predictive analytics, and data-driven customer success strategies. Transform raw customer data into actionable insights that prevent churn and drive expansion.

Philosophy

Customer health is not a single metric — it's a predictive system:

  1. Measure what matters — Health scores should predict outcomes, not just track activity
  2. Lead, don't lag — Focus on indicators that predict churn before it's too late
  3. Segment for action — Different customers need different interventions
  4. Automate detection — Scale health monitoring across your entire customer base
  5. Close the loop — Analytics without action is just expensive data collection

How This Skill Works

When invoked, apply the guidelines in rules/ organized by:

  • health-* — Health score design, weighting, and calibration
  • indicators-* — Leading vs lagging indicator analysis
  • churn-* — Prediction modeling and early warning systems
  • usage-* — Analytics and adoption metrics
  • risk-* — Identification, escalation, and intervention
  • data-* — Enrichment and customer 360 development
  • cohort-* — Analysis and benchmarking
  • executive-* — Reporting and dashboards
  • segmentation-* — Customer tiers and scoring models

Core Frameworks

The Health Score Hierarchy

┌─────────────────────────────────────────────────────────────────┐
│                    COMPOSITE HEALTH SCORE                       │
│                         (0-100)                                 │
├─────────────────────────────────────────────────────────────────┤
│                                                                 │
│  ┌──────────┐  ┌──────────┐  ┌──────────┐  ┌──────────┐       │
│  │ PRODUCT  │  │ENGAGEMENT│  │ GROWTH   │  │ SUPPORT  │       │
│  │  USAGE   │  │          │  │ SIGNALS  │  │ HEALTH   │       │
│  │  (35%)   │  │  (25%)   │  │  (20%)   │  │  (20%)   │       │
│  └──────────┘  └──────────┘  └──────────┘  └──────────┘       │
│                                                                 │
├─────────────────────────────────────────────────────────────────┤
│                    COMPONENT METRICS                            │
│                                                                 │
│  Usage:        Engagement:    Growth:        Support:          │
│  - DAU/MAU     - NPS score    - Seat trend   - Ticket volume   │
│  - Features    - CSM meetings - Usage trend  - Resolution time │
│  - Depth       - Email opens  - Expansion    - Sentiment       │
│  - Breadth     - Logins       - Contract     - Escalations     │
│                                                                 │
└─────────────────────────────────────────────────────────────────┘

Leading vs Lagging Indicators

TypeDefinitionExamplesAction Window
LeadingPredict future outcomesUsage decline, engagement drop60-90 days
CoincidentMove with outcomesSupport sentiment, NPS30-60 days
LaggingConfirm after the factChurn, revenue lossToo late

Customer Health States

┌─────────────────────────────────────────────────────────────────┐
│                                                                 │
│  THRIVING ──→ HEALTHY ──→ NEUTRAL ──→ AT-RISK ──→ CRITICAL    │
│    (85+)      (70-84)     (50-69)     (30-49)      (<30)       │
│                                                                 │
│  Expand       Monitor     Engage      Intervene    Escalate    │
│                                                                 │
└─────────────────────────────────────────────────────────────────┘

Health Score Components

ComponentWeightKey MetricsWhy It Matters
Product Usage30-40%DAU/MAU, feature adoption, depthUsage predicts value realization
Engagement20-25%NPS, CSM contact, responsivenessRelationship strength indicator
Growth Signals15-20%Seat expansion, usage trendInvestment signals commitment
Support Health15-20%Ticket volume, sentiment, resolutionFrustration predicts churn
Financial5-10%Payment history, contract lengthFinancial commitment level

Churn Risk Factors

FactorRisk WeightDetection Method
Champion departureCriticalContact tracking, LinkedIn
Usage decline >30%HighProduct analytics
Negative NPS (0-6)HighSurvey responses
Support escalationsHighTicket analysis
Missed renewal meetingHighCSM activity tracking
Contract downgradeVery HighBilling data
Competitor mentionsHighCall transcripts, tickets
Budget review mentionsMediumCSM notes

The Analytics Stack

LayerPurposeTools/Methods
CollectionGather raw dataProduct events, CRM, support
ProcessingClean and transformETL, data pipelines
CalculationCompute scoresScoring algorithms
StorageHistorical trackingData warehouse
VisualizationPresent insightsDashboards, reports
ActionTrigger interventionsAlerting, automation

Key Metrics

MetricFormulaTarget
Health Score AccuracyChurn predicted / Actual churn>70%
Leading Indicator CorrelationCorrelation to outcomes>0.6
Score Distribution% in each health tierBell curve
Intervention Success RateSaved / Intervened>40%
Time to DetectionDays before risk → action<14 days
False Positive RateFalse alerts / Total alerts<20%

Executive Dashboard KPIs

KPIDefinitionBenchmark
Gross Revenue RetentionRetained ARR / Starting ARR85-95%
Net Revenue Retention(Retained + Expansion) / Starting100-130%
Logo RetentionRetained customers / Starting90-95%
Health Score AverageMean across customer base65-75
At-Risk RevenueARR with health <50<15%
Expansion RateCustomers expanded / Total15-30%

Cohort Analysis Framework

Cohort TypeSegments ByUse Case
Time-basedSign-up month/quarterRetention trends
BehavioralFeature usage patternsActivation success
Value-basedARR tierSegment economics
IndustryVerticalProduct-market fit
AcquisitionChannel/sourceMarketing efficiency

Anti-Patterns

  • Vanity health scores — Scores that look good but don't predict outcomes
  • Over-weighted product usage — Ignoring relationship and sentiment signals
  • Lagging indicator focus — Measuring what already happened
  • One-size-fits-all thresholds — Same scores mean different things for different segments
  • Manual-only health tracking — Can't scale without automation
  • Score without action — Calculating risk without intervention playbooks
  • Annual calibration only — Health models need continuous refinement
  • Ignoring data quality — Garbage in, garbage out

Source

git clone https://github.com/ncklrs/startup-os-skills/blob/main/skills/customer-health-analyst/SKILL.mdView on GitHub

Overview

Customer Health Analyst provides guidance on health scoring, predictive analytics, and data-driven CS strategies. It helps transform raw customer data into actionable insights that prevent churn and drive expansion.

How This Skill Works

The skill applies guidelines organized by categories (health-*, indicators-*, churn-*, usage-*, risk-*, data-*, cohort-*, executive-*, segmentation-*). It guides building a composite health score (0-100) from components like Product Usage, Engagement, Growth Signals, and Support Health, with leading indicators to forecast outcomes and trigger proactive actions.

When to Use It

  • Design and calibrate a composite health score (0-100)
  • Build churn prediction models and early warning systems
  • Analyze usage metrics to understand adoption and expansion opportunities
  • Identify at-risk accounts for targeted interventions
  • Create executive dashboards and cohort analyses to monitor health trends

Quick Start

  1. Step 1: Define health-score components (usage, engagement, growth, support) and assign initial weights.
  2. Step 2: Identify leading indicators and calibrate thresholds for early detection.
  3. Step 3: Automate scoring, monitoring, and publish dashboards to execs and CS teams.

Best Practices

  • Define a transparent 0-100 composite health score with clear weighting
  • Combine leading indicators with lagging outcomes for early detection
  • Segment customers to tailor interventions by tier and risk
  • Automate health monitoring and alerting across the customer base
  • Benchmark with cohorts and track changes over time using dashboards

Example Use Cases

  • Design a composite health score using product usage, engagement, and support signals across customers
  • Implement churn prediction and alerting to trigger proactive outreach with CSMs
  • Launch executive dashboards by segment showing health trend and at-risk counts
  • Run cohort analysis to compare health trajectories by acquisition channel
  • Enrich data with customer 360 to improve accuracy of risk flags

Frequently Asked Questions

Add this skill to your agents
Sponsor this space

Reach thousands of developers