churn-cohort-builder

Installation
SKILL.md

Churn Cohort Builder

Assembles the retention cohort from Zoho Billing reports. Two types:

  • Pre-churn — non-renewing subscriptions (still active, scheduled to cancel at cycle end).
  • Post-churn — recently cancelled subscriptions (last 7 days, win-back candidates).

Output schema

Field Source
subscription_id, customer_id, customer_name report row
plan_code, plan_name report row
mrr recurring_amount normalized to monthly (annual ÷ 12, quarterly ÷ 3)
currency, country report row; "Unknown" if absent
cancel_reason_raw free-text from report — classifier buckets it later
cancellation_date scheduled end date (pre-churn) or actual cancel date (post-churn)
ltv report field; default 0 + flag ltv_unavailable: true if missing
ltd report field (days); compute from activated_at if absent; 0 + ltd_unavailable: true if both absent
cohort "pre_churn" or "post_churn"
Installs
2
GitHub Stars
2
First Seen
9 days ago
churn-cohort-builder — zoho/zoho-billing-ai