Build the customer health & churn-risk reportProduct usage + Zendesk + Salesforce → Sheets → Slack
The at-risk list, assembled before Monday — not after the cancel.
- Pull usage from the product analytics tool.
- Check open tickets per account in Zendesk.
- Look up renewal dates and ARR in Salesforce.
- Eyeball a health score in a spreadsheet.
- Message CSMs about the worrying ones.
- Pull usage, tickets, and renewal/ARR per account.
- Compute a health score from usage trend, support load, and renewal proximity.
- Write a weekly snapshot and tag green/yellow/red.
- Post every red or newly-downgraded account to #customer-success and @the CSM.
Trigger · Schedule, every Monday 06:00. 1. Analytics API · per-account usage: active users, key-feature adoption, last login. 2. Zendesk · open + recent ticket counts and escalations per account. 3. Salesforce · renewal date, ARR, and CSM owner per account. 4. Formula · health score from usage trend + support load + renewal proximity; tag green / yellow / red. 5. Google Sheets · write this week's snapshot to "Customer Health". 6. Slack · post every red or newly-downgraded account to #customer-success and @mention its CSM.