xiaohongshu
xiaohongshu
Predict customer churn risk using behavioral signals, engagement data, and predictive analytics
Full skill instructions
Expert churn prediction system that identifies at-risk customers before they leave using behavioral signals, engagement patterns, and predictive analytics. This skill provides structured workflows for building churn models, monitoring risk signals, and executing retention interventions.
Churn is the silent killer of growth. By the time a customer announces they're leaving, it's often too late. This skill helps you identify churn risk early when intervention can still make a difference, prioritize retention efforts, and systematically reduce churn.
Built on data science best practices and customer success methodologies, this skill combines leading indicator analysis, risk scoring, and intervention playbooks to predict and prevent churn before it happens.
Map the behaviors that predict churn
Behavioral Signals
| Signal Type | Examples | Risk Level |
|---|---|---|
| Usage Decline | 30%+ drop in logins, sessions, actions | High |
| Feature Abandonment | Stopped using key features | Medium-High |
| Engagement Drop | No response to emails, missed meetings | Medium |
| Support Patterns | Spike in tickets, negative sentiment | High |
| Billing Issues | Failed payments, downgrade requests | High |
Account Signals
Relationship Signals
Time-Based Signals
Build a composite churn risk score
Score Components
Churn Risk Score =
(Usage Score × 0.30) +
(Engagement Score × 0.25) +
(Support Score × 0.20) +
(Relationship Score × 0.15) +
(Account Score × 0.10)
Scale: 0-100 (higher = more at risk)
Usage Score Factors
Engagement Score Factors
Risk Categories
| Score | Risk Level | Action |
|---|---|---|
| 0-20 | Low | Standard monitoring |
| 21-40 | Moderate | Proactive outreach |
| 41-60 | Elevated | Intervention needed |
| 61-80 | High | Urgent save attempt |
| 81-100 | Critical | Executive escalation |
Understand churn patterns across customer segments
Cohort Analysis
Segment Analysis
Churn Timing Patterns
Leading Indicator Validation
Surface risk at the right time to the right people
Alert Triggers
Escalation Matrix
| Risk Level | Owner | Escalation | Response SLA |
|---|---|---|---|
| Moderate | CSM | None | 5 days |
| Elevated | CSM | Manager copy | 48 hours |
| High | CSM + Manager | VP briefed | 24 hours |
| Critical | Manager | VP/Exec sponsor | Same day |
Alert Content
Alert Channels
Systematic approaches to save at-risk customers
Intervention Matching
| Root Cause | Intervention |
|---|---|
| Low adoption | Training, onboarding redo |
| Technical issues | Engineering escalation, workarounds |
| Value unclear | ROI analysis, executive alignment |
| Champion left | Relationship rebuild with new stakeholders |
| Pricing concerns | Discount, plan adjustment, payment terms |
| Competitive | Feature comparison, roadmap preview |
Save Play Execution
Intervention Tactics
Outcome Tracking
| Action | Command/Trigger |
|---|---|
| Check risk score | "Show churn risk for [Customer]" |
| List at-risk accounts | "Show accounts above [X] risk score" |
| Analyze churn patterns | "Analyze churn patterns by [segment]" |
| Review alerts | "Show churn alerts this week" |
| Create save plan | "Create intervention plan for [Customer]" |
| Score validation | "Validate churn model accuracy" |
| Cohort analysis | "Analyze retention by cohort" |
| Signal analysis | "Find leading churn indicators" |
| Trend report | "Show risk score trends" |
| Intervention report | "Report on save play outcomes" |
| Signal | Calculation | Warning Threshold |
|---|---|---|
| Login decline | % change week-over-week | -30% for 2+ weeks |
| DAU/MAU ratio | Daily active / Monthly active | Below 0.2 |
| Feature breadth | # features used / available | Below 30% |
| Seat utilization | Active users / licensed seats | Below 50% |
| Session depth | Actions per session | Below baseline by 40% |
| Signal | Calculation | Warning Threshold |
|---|---|---|
| Email engagement | Open rate × Click rate | Below 5% |
| Meeting attendance | Attended / Scheduled | Below 60% |
| Response time | Avg days to respond | Above 5 days |
| QBR participation | Attended / Scheduled | Miss 2+ in row |
| Training completion | Completed / Available | Below 25% |
| Signal | Calculation | Warning Threshold |
|---|---|---|
| Ticket volume | Tickets / month | 3× baseline |
| Sentiment score | Negative / Total | Above 30% |
| Escalation rate | Escalated / Total | Above 20% |
| Resolution satisfaction | CSAT on resolved | Below 3/5 |
| Open ticket age | Avg days open | Above 7 days |
| Signal | Calculation | Warning Threshold |
|---|---|---|
| NPS change | Current - Previous | Drop of 3+ points |
| Health score | Composite score | Below 60 |
| Champion risk | Champion activity decline | Below 50% of baseline |
| Executive access | Exec meetings / quarter | 0 in 2+ quarters |
| Renewal confidence | CSM assessment | Below 70% |
# Churn Risk Report: Week of [Date]
## Summary
- Accounts at elevated risk or above: [X]
- Total ARR at risk: $[Amount]
- New alerts this week: [X]
- Risk trending up: [X accounts]
- Risk trending down: [X accounts]
## Critical Risk (81-100)
| Account | ARR | Score | Key Signals | Owner | Action |
|---------|-----|-------|-------------|-------|--------|
| [Name] | $X | 87 | [Signals] | [CSM] | [Status] |
## High Risk (61-80)
[Same format]
## Elevated Risk (41-60)
[Same format]
## Interventions in Progress
| Account | Started | Intervention | Progress |
|---------|---------|--------------|----------|
| [Name] | [Date] | [Type] | [Status] |
## Outcomes This Week
- Saved: [X accounts, $ARR]
- Lost: [X accounts, $ARR, reasons]
- De-escalated: [X accounts]
| Metric | What It Measures | Target |
|---|---|---|
| Accuracy | Overall correct predictions | 80%+ |
| Precision | True positives / All predicted positives | 70%+ |
| Recall | True positives / All actual churns | 85%+ |
| Lead Time | Days from high risk to actual churn | 60+ days |
| False Positive Rate | False alarms / All high-risk alerts | < 30% |
| Save Rate | Saved / Attempted saves | 40%+ |
| AUC-ROC | Model discrimination ability | 0.75+ |
xiaohongshu
technical spec
product ux expert
database patterns
Conduct multi-agent task orchestration and workflow coordination.
Initialize project with Conductor artifacts (product definition,
Expert in web animations, transitions, and motion design using Framer Motion and CSS
Creates Mermaid and ASCII diagrams for flowcharts, architecture, ERDs, state machines, mindmaps, and more. Use when user mentions diagram, flowchart, mermaid, ASCII diagram, text diagram, terminal diagram, visualize, C4, mindmap, architecture diagram, sequence diagram, ERD, or needs visual docume...
PostgreSQL bindings for H3 hexagonal grid system. Use when working with H3 cells in Postgres, including spatial indexing, geometry/geography integration, and raster analysis.
Context-Driven Development skill for projects using Conductor. Use this skill when you detect a `conductor/` directory in the project, when working on tasks defined in a `plan.md` file, or when the user asks about tracks, specs, or plans. Automatically applies TDD workflow, tracks task completion...
Display project status, active tracks, and next actions
Official Stakpak application containerization standard operating procedure, a step-by-step guidline to properly dockerize applications. This is a rule book curated by the Stakpak Team.
Generate, edit, and beat-sync AI video with leading models in one workspace.
The world's fastest calendar for remote work
Transform Your Design with AI Designer by ImgCreator.ai
Revolutionizing Video Production with AI-Powered Creativity
Extend an image past the frame and let AI fill the new aspect ratio.
Discover your celebrity doppelgänger with StarByFace!
ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.
Opus.ai: Revolutionize Your Web Experience