Customer Churn Prediction Analyst
Overview
The Customer Churn Prediction Analyst is a production-grade intelligence tool that identifies at-risk customers before they leave. By analyzing multi-dimensional behavioral signals—purchase frequency trends, support ticket sentiment, feature adoption rates, engagement decay, and payment friction—this skill surfaces customers most likely to churn within 30/60/90 days.
Beyond prediction, it generates actionable intervention playbooks: personalized discount strategies, feature education campaigns, re-engagement email templates, and VIP outreach scripts. The skill integrates with Stripe (payment history, subscription metrics), Shopify (order patterns, product affinity), SaaS platforms (API usage logs, login frequency), and Slack (automated alerts for high-risk segments).
Why it matters: Research shows that acquiring a new customer costs 5-25x more than retaining an existing one. A 5% improvement in retention can increase profitability by 25-95%. This skill automates the intelligence layer that turns data into revenue protection.
Quick Start
Try these prompts immediately:
Example 1: Analyze Stripe Subscription Churn Risk
CODEBLOCK0
Example 2: Shopify E-commerce Customer Retention
CODEBLOCK1
Example 3: SaaS Feature Adoption & Engagement Churn
Analyze our SaaS platform for churn signals.
Our customers are: 120 paid accounts,
avg contract value $5,000/month.
Track: API call volume (declining usage = risk),
feature adoption (low-feature users churn 3x faster),
support ticket sentiment (negative = escalation risk),
and last login recency.
Flag accounts with <10 API calls/week or
no logins in 14+ days as critical intervention targets.
Generate retention playbooks for each.
Capabilities
1. Multi-Source Behavioral Analysis
Aggregates signals from multiple platforms into a unified churn risk model:
- - Stripe Integration: Payment decline frequency, subscription downgrades, MRR trajectory, failed payment recovery attempts, dunning email effectiveness
- Shopify Integration: Purchase frequency (RFM: Recency, Frequency, Monetary), product category affinity, cart abandonment rate, average order value trends, customer lifetime value (CLV) projections
- SaaS/API Platforms: Daily active users (DAU), feature adoption rates, API call volume patterns, session duration trends, support ticket volume/sentiment, last-activity timestamps
- Email/CRM Data: Open rates, click-through rates, unsubscribe trends, email bounce rates, campaign engagement decay
- Support Systems: Ticket volume, resolution time, sentiment analysis (negative sentiment = 4x higher churn risk), escalation frequency
2. Predictive Risk Scoring
Generates 30/60/90-day churn probability scores using:
- - Recency Decay: How long since last transaction/login (exponential weighting)
- Frequency Trends: Purchase/usage slope analysis (declining = risk signal)
- Monetary Value: Revenue-at-risk calculations; high-value customers flagged separately
- Engagement Velocity: Rate of engagement decline vs. historical baseline
- Cohort Benchmarking: Compare customer behavior to cohort norms (e.g., customers acquired in same month)
- Seasonal Adjustment: Account for industry seasonality (e.g., retail Q4 spikes)
Output: Risk tiers (Critical, High, Medium, Low) with confidence intervals.
3. Personalized Intervention Recommendations
Generates tailored win-back strategies:
- - Segment-Specific Offers: High-value customers get VIP treatment (white-glove support, exclusive features); price-sensitive get discounts; feature-poor get education
- Email Campaign Templates: Pre-written re-engagement sequences with A/B test variants, personalized product recommendations, and dynamic subject lines
- Feature Education Playbooks: For SaaS: identify underutilized features that correlate with churn; generate feature demo videos, webinar invites, or one-on-one training offers
- Support Escalation Triggers: Route customers with 3+ negative support interactions to dedicated success managers
- Win-Back Incentive Suggestions: Recommend discount depth (5%, 10%, 20%) based on customer LTV, willingness-to-pay analysis, and competitive benchmarking
4. Retention Campaign Orchestration
Generates ready-to-deploy campaigns:
- - Multi-Channel Sequences: Email → SMS → In-App Push → Slack notification → Phone outreach (for high-value accounts)
- Timing Optimization: Send interventions at peak engagement windows (e.g., Tuesday 10am for B2B SaaS)
- Dynamic Content: Personalized product recommendations, usage statistics, and social proof ("3 customers like you upgraded to Pro this month")
- A/B Test Frameworks: Generate variant subject lines, offer amounts, and CTA copy for testing
5. Win-Back Success Tracking
Monitors intervention effectiveness:
- - Conversion Metrics: % of at-risk customers who re-engage, upgrade, or extend contracts post-intervention
- ROI Calculation: Cost per intervention vs. revenue recovered; payback period
- Cohort Analysis: Which intervention types work best for which customer segments?
- Feedback Loop: Continuous model refinement based on what interventions actually prevent churn
Configuration
Environment Variables (Required)
CODEBLOCK3
Setup Instructions
- 1. Authenticate with data sources:
CODEBLOCK4
- 2. Initialize the analysis:
CODEBLOCK5
- 3. Set up recurring analysis:
CODEBLOCK6
Configuration Options
- -
risk-threshold: Churn probability threshold (default: 0.5 = 50%) - INLINECODE1 : Historical analysis window (default: 180 days)
- INLINECODE2 : Predict churn within X days (default: 30, 60, 90)
- INLINECODE3 : Revenue amount that triggers VIP intervention (default: $5,000 MRR)
- INLINECODE4 : Maximum discount/incentive per customer (default: 15% of CLV)
Example Outputs
Output 1: Churn Risk Report (JSON)
CODEBLOCK7
Output 2: Intervention Campaign Template
CODEBLOCK8
Output 3: Win-Back Success Dashboard
Churn Prevention Dashboard (Last 30 Days)
At-Risk Customers Identified: 156
Interventions Deployed: 143 (92%)
Re-Engaged (logged in post-email): 89 (62%)
Converted to Upgrade: 34 (24%)
Revenue Recovered: $47,300
Intervention Cost: $3,200
ROI: 14.8x
Top Performing Interventions:
1. VIP Phone Call (67% re-engagement rate)
2. Feature Education Webinar (58%)
3. Discount Offer (35%)
4. Email Sequence (28%)
Tips & Best Practices
1. Segment Before Intervening
Don't use one-size-fits-all offers. High-value customers respond better to white-glove service; price-sensitive segments respond to discounts. This skill auto-segments—use it.
2. Timing is Everything
Send interventions during peak engagement windows. For B2B SaaS, that's usually Tuesday-Thursday, 9-11am. For e-commerce, Friday evening often works best. Test and adjust.
3. Feature Education Beats Discounts
Customers who adopt 3+ core features have 10x lower churn. Before offering discounts, try feature education. It's cheaper and builds stronger retention.
4. Track the Tracking
Set up UTM parameters and unique promo codes for each intervention so you can measure ROI. Example: INLINECODE5
5. Weekly Monitoring Over Batch Processing
Run churn analysis weekly, not monthly. Early intervention (when churn probability hits 40%) is 3x more effective than waiting until it hits 80%.
6. Validate Risk Signals Manually
If the skill flags a high-value customer as high-risk, spot-check the data manually before sending a "we're losing you" message. False positives damage trust.
7. Personalize at Scale
Use dynamic content blocks in emails. Instead of "Here's a discount," say "We noticed you use our Reports feature heavily—here's a 20% upgrade to Pro Reports."
8. Combine with Product Changes
If the skill identifies that low feature adoption = churn, talk to product. Maybe the feature is hard to discover. Fix the product, not just the customer.
Safety & Guardrails
What This Skill Will NOT Do
- 1. Discriminatory Targeting: This skill will NOT use protected characteristics (age, race, gender, location) as churn risk factors. All recommendations are based on behavioral and transactional signals only.
- 2. Aggressive Dark Patterns: This skill will NOT generate deceptive subject lines, fake urgency ("Only 2 left!"), or manipulative CTAs. All messaging is honest and customer-centric.
- 3. Unlimited Discounting: Intervention budgets are capped per customer (default: 15% of CLV). The skill will NOT recommend discounts that would make the customer unprofitable.
- 4. Automatic Execution: This skill generates recommendations; you must approve all interventions before sending. It will not auto-send emails or modify customer accounts without explicit approval.
- 5. Privacy Violations: This skill respects GDPR, CCPA, and CAN-SPAM regulations. It will NOT:
- Segment based on sensitive personal data
- Send emails to unsubscribed users
- Retain PII longer than necessary
- Share customer data with third parties
- 6. Over-Reliance on Predictions: Churn prediction models are probabilistic, not deterministic. A 89% churn probability doesn't mean the customer will churn. Use it as a signal, not gospel.
Limitations
- - Data Quality Dependency: Garbage in, garbage out. If your data is incomplete or inaccurate, predictions suffer. Ensure Stripe/Shopify/SaaS data is clean and current.
- Cold Start Problem: New customers (< 30 days) don't have enough historical data for reliable churn prediction. The skill will flag these as "insufficient data."
- Industry Variance: Churn models are trained on general patterns. Your industry may have unique dynamics. Validate predictions against your domain knowledge.
- External Factors: Skill can't account for macroeconomic shocks, competitor actions, or
客户流失预测分析师
概述
客户流失预测分析师是一款生产级智能工具,能够在客户离开前识别出高风险客户。通过分析多维行为信号——购买频率趋势、客服工单情感分析、功能采用率、参与度衰减和支付摩擦——该技能可识别出最可能在30/60/90天内流失的客户。
除了预测功能外,它还能生成可执行的干预方案:个性化折扣策略、功能教育推广活动、重新参与邮件模板和VIP客户外联脚本。该技能可与Stripe(支付历史、订阅指标)、Shopify(订单模式、产品偏好)、SaaS平台(API使用日志、登录频率)和Slack(高风险客户群自动预警)集成。
重要性: 研究表明,获取新客户的成本是保留现有客户的5-25倍。留存率提升5%可使盈利能力提高25-95%。该技能自动化了将数据转化为收入保护的智能层。
快速入门
立即尝试以下提示:
示例1:分析Stripe订阅流失风险
分析我的Stripe客户群的流失风险。
我有1,200个活跃订阅,价格从$29-$299/月不等。
关注:过去90天的支付失败情况、
MRR下降趋势,以及超过30天未登录的客户。
生成我前50个高风险账户的风险排名列表,
并为每个账户提供具体的干预建议。
示例2:Shopify电商客户留存
我经营一家拥有8,500名客户的Shopify店铺。
识别可能不再返回的客户。
分析:购买频率下降、
平均订单价值趋势、购物车放弃模式、
以及邮件参与度(退信/退订)。
为三个风险等级创建赢回活动模板:
高风险(80%+流失概率)、中风险(50-79%)、低风险(25-49%)。
包含个性化折扣优惠和邮件主题行。
示例3:SaaS功能采用与参与度流失
分析我们的SaaS平台的流失信号。
我们的客户:120个付费账户,
平均合同价值$5,000/月。
追踪:API调用量(使用量下降=风险)、
功能采用率(低功能用户流失速度快3倍)、
客服工单情感分析(负面=升级风险)、
以及最近登录时间。
标记每周API调用<10次或
超过14天未登录的账户为关键干预目标。
为每个账户生成留存方案。
功能
1. 多源行为分析
将来自多个平台的信号聚合到统一的流失风险模型中:
- - Stripe集成: 支付拒绝频率、订阅降级、MRR轨迹、失败支付恢复尝试、催款邮件有效性
- Shopify集成: 购买频率(RFM:最近一次购买时间、频率、金额)、产品类别偏好、购物车放弃率、平均订单价值趋势、客户生命周期价值(CLV)预测
- SaaS/API平台: 日活跃用户(DAU)、功能采用率、API调用量模式、会话时长趋势、客服工单量/情感分析、最后活动时间戳
- 邮件/CRM数据: 打开率、点击率、退订趋势、邮件退信率、活动参与度衰减
- 客服系统: 工单量、解决时间、情感分析(负面情感=流失风险高4倍)、升级频率
2. 预测性风险评分
使用以下指标生成30/60/90天流失概率分数:
- - 最近衰减: 自上次交易/登录以来的时间(指数加权)
- 频率趋势: 购买/使用斜率分析(下降=风险信号)
- 金额价值: 风险收入计算;高价值客户单独标记
- 参与速度: 参与度下降率与历史基线对比
- 同期群基准: 将客户行为与同期群标准对比(如同月获取的客户)
- 季节性调整: 考虑行业季节性(如零售Q4高峰)
输出: 风险等级(关键、高、中、低)及置信区间。
3. 个性化干预建议
生成量身定制的赢回策略:
- - 细分特定优惠: 高价值客户享受VIP待遇(白手套支持、独家功能);价格敏感客户获得折扣;功能使用不足客户接受教育
- 邮件活动模板: 预写的重新参与序列,含A/B测试变体、个性化产品推荐和动态主题行
- 功能教育方案: 针对SaaS:识别与流失相关的未充分利用功能;生成功能演示视频、网络研讨会邀请或一对一培训优惠
- 客服升级触发: 将有3次以上负面客服互动的客户路由至专属客户成功经理
- 赢回激励建议: 根据客户LTV、支付意愿分析和竞争基准,推荐折扣深度(5%、10%、20%)
4. 留存活动编排
生成可立即部署的活动:
- - 多渠道序列: 邮件→短信→应用内推送→Slack通知→电话外联(针对高价值账户)
- 时机优化: 在参与高峰窗口发送干预(如B2B SaaS周二上午10点)
- 动态内容: 个性化产品推荐、使用统计和社交证明(本月有3位像您一样的客户升级到Pro)
- A/B测试框架: 生成变体主题行、优惠金额和CTA文案供测试
5. 赢回成功追踪
监控干预效果:
- - 转化指标: 干预后重新参与、升级或延长合同的高风险客户百分比
- ROI计算: 每次干预成本与回收收入对比;回本周期
- 同期群分析: 哪些干预类型对哪些客户细分效果最佳?
- 反馈循环: 基于实际防止流失的干预措施持续优化模型
配置
环境变量(必需)
bash
Stripe集成
export STRIPE
APIKEY=sk
live...
Shopify集成
export SHOPIFY
APITOKEN=shppa_...
export SHOPIFY
STORENAME=your-store.myshopify.com
SaaS/自定义平台
export SAAS
APIKEY=your
saasapi_key
export SAAS
APIENDPOINT=https://api.yourplatform.com/v1
OpenAI(用于建议生成)
export OPENAI
APIKEY=sk-...
Slack通知(可选)
export SLACK
WEBHOOKURL=https://hooks.slack.com/services/...
数据库(用于追踪历史干预)
export DATABASE
URL=postgresql://user:pass@localhost/churndb
设置说明
- 1. 认证数据源:
bash
# Stripe:从仪表板>开发者>API密钥生成API密钥
# Shopify:管理>应用和集成>开发应用>创建API凭证
# SaaS:使用您平台的API文档
- 2. 初始化分析:
bash
# 首次运行:完整历史分析(大数据集可能需要5-10分钟)
openclaw run customer-churn-prediction-analyst \
--mode=full-analysis \
--lookback-days=180 \
--data-sources=stripe,shopify,saas
- 3. 设置定期分析:
bash
# 安排每周流失分析
openclaw schedule customer-churn-prediction-analyst \
--frequency=weekly \
--day=monday \
--time=08:00 \
--notify-slack=true
配置选项
- - risk-threshold:流失概率阈值(默认:0.5 = 50%)
- lookback-days:历史分析窗口(默认:180天)
- prediction-horizon:预测X天内流失(默认:30、60、90)
- high-value-threshold:触发VIP干预的收入金额(默认:$5,000 MRR)
- intervention-budget:每位客户最大折扣/激励(默认:CLV的15%)
示例输出
输出1:流失风险报告(JSON)
json
{
analysis_date: 2025-01-15T10:30:00Z,
total
customersanalyzed: 1247,
churn
riskdistribution: {
critical: 23,
high: 87,
medium: 156,
low: 981
},
at
riskaccounts: [
{
customer
id: cust8x9y2z,
name: Acme Corp,
mrr: 12500,
churn
probability30d: 0.89,
churn
probability60d: 0.76,
primary
risksignals: [
API usage declined 65% in last 30 days,
Payment failed 2x (recovered 1x),
Support ticket sentiment: negative (3 tickets),
No login in 18 days
],
recommended_intervention: {
type: VIP_SAVE,
tactics: [
Schedule executive business review call,