Stripe Analytics

Complete Stripe analytics dashboard for SaaS founders (READ-ONLY). CORE METRICS: MRR, churn (revenue/customer), NRR, LTV/CAC CUSTOMER: Top LTV, segments (pla...

SaaS Stripe Analytics (Production-Ready)

🎯 When to Use This Skill

Primary triggers:

• MRR/churn tracking ("Stripe metrics", "business dashboard")
• Customer analysis ("top customers", "LTV ranking")
• Revenue health ("forecast", "payment recovery")
• Alerts ("churn risks", "at-risk customers")

Input Schema (JSON):

{
  "days_back": 90,           // 7-365 days
  "segment_by": "geo",       // plan|geo|industry  
  "forecast_months": 6,      // 1-12 months
  "customer_limit": 15       // 1-50
}

Default: 30 days, plan segments, 3-month forecast, top 10 customers.

📤 Output Format (Always)

SUCCESS:
{
  "status": "success",
  "data": {
    "mrr": {"current": 12450, "growth_pct": 11},
    "churn": {"revenue_pct": 3.2, "at_risk": 7},
    "segments": [{"name": "US", "arpu": 89}],
    "forecast": [13500, 14600, 15800],
    "insights": ["US ARPU 2x EU"],
    "action_items": [{"priority": "high", "impact": "revenue"}]
  },
  "metadata": {"execution_time_ms": 2100, "api_calls": 5}
}

ERROR: 
{
  "status": "error", 
  "error_type": "auth_error"|"rate_limit"|"network_error",
  "message": "Human-readable fix"
}

🛠 Setup & Environment

Required

STRIPE_READ_KEY=sk_read_xxx...

Exact Stripe Setup:

1. Dashboard → Developers → API Keys → Restricted Key
2. Scopes: read: Customer | read: Subscription | read: Invoice
3. Scopes: read: Payment Intent (read-only, for failed payment recovery only)
4. ✅ No write/refund/charge scopes

Optional

STRIPE_CACHE_TTL=3600     # Seconds (default: 1hr)
STRIPE_TIMEOUT=8000       # ms (default: 8s)

⚡ Performance & Limits

• Execution: 2.1s avg (5 parallel calls)
• Pagination: Auto (1000+ customers)
• Rate Limits: Handled (429 → retry logic)
• Data Retention: 365 days max
• Output Size: ~4KB compressed

🔗 Example Workflows

1. Daily Dashboard

User: "Stripe metrics + forecast"
→ Full MRR/churn/customers/forecast in 2s

2. Churn Investigation

"Churn risks + top customers"
→ At-risk list + LTV ranking + recovery $

3. Geo Expansion

"Revenue by country"
→ US: 66% | EU: 22% | "Localize pricing?"

🧪 Test Cases (Verified)

Test	Input	Expected
Happy Path	{"days_back": 30}	{"status": "success", "mrr": {...}}
No Key	{}	{"error_type": "auth_error"}
Invalid Days	{"days_back": 500}	{"days_back": 365} (clamped)
Rate Limit	429	{"error_type": "rate_limit"}

📊 Metrics Explained

Metric	Formula	Good (>80th %)
MRR Growth	(Current - Prev) / Prev	+8% MoM
Revenue Churn	Cancelled MRR / Starting MRR	<5%
NRR	(Ending MRR + Expansion) / Starting	>100%
LTV/CAC	LTV ÷ CAC	>3x

🔒 Security (ClawHub Verified)

✅ READ-ONLY key (read:customers/subscriptions/invoices/payment_intents only)
✅ No data storage/persistence  
✅ No secrets logged/output
✅ Pagination prevents DoS
✅ 8s timeout per call
✅ Error messages safe (no keys)

📈 Composability

saas_stripe_analytics_final → churn_predictor → winback_email_generator
stripe_top_customers → personalized_upsell → send_custom_email
geo_revenue_breakdown → market_expansion_plan → generate_localized_landing

🚀 OpenClaw Integration

Slash Commands:

/stripe-metrics     # Default 30-day dashboard
/stripe-churn       # Churn + recovery focus  
/stripe-forecast    # MRR projection
/stripe-segments    # Plan/geo/industry breakdown

Voice Triggers:

• "Hey, Stripe numbers?"
• "Business dashboard"
• "Revenue this month"

📝 Troubleshooting

Error	Fix
auth_error	Check restricted key scopes
rate_limit	Wait 60s or upgrade plan
network_error	Check internet + Stripe status
Empty data	No subs in time range? Try days_back: 90

🎯 Founder Value Prop

Saves 2h/week manual reporting → Focus on growth

• Instant VC-level dashboards
• Churn prevention alerts
• Expansion opportunities
• Pricing experiment ROI
• Automated forecasting

"Stripe analysis" → Your complete SaaS command center.

---

Tags: saas,stripe,analytics,mrr,churn,lTV,customer,forecast | v1.0.3