Excel for Customer Success Managers: Health Scores, Renewals, Churn & NRR
20 hands-on labs for CSMs at a small B2B software company: account list and ARR, health scores and their trend, renewal calendar and price uplifts, seat true-ups, multi-year deals, logo and revenue churn, churn reasons, NRR, adoption and feature breadth, support tickets and SLA backlog, NPS, expansion pipeline, at-risk accounts, a QBR one-pager, a CS dashboard and a renewal readiness board.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course gives customer success managers 20 practical Excel labs built around one small B2B software company. You build the book of business with ARR per account, weighted health scores and their monthly trend, and a renewal calendar. You apply renewal price uplifts with contract caps, bill seat true-ups pro rata and price multi-year deals with ramps and total contract value. You measure logo and revenue churn, group churn reasons by lost ARR, calculate net and gross revenue retention, and track adoption by seats and by feature. Support labs cover first response time, CSAT and an SLA backlog in business days, followed by NPS, the expansion pipeline and at-risk accounts. You finish with a QBR one-pager, a CS dashboard and a renewal readiness board for the next quarter.
Lessons
- Your Book of Business: Plan Lookup and ARR per AccountFree
- Customer Health Score: Weighted Signals and Green, Yellow, Red Locked
- Renewal Calendar: Renewal Dates, Days Left and Flags Locked
- Logo Churn vs Revenue Churn: Two Rates, Two Stories Locked
- Net Revenue Retention: Expansion, Contraction and Churn Locked
- Product Adoption: Active Users as a Share of Seats Locked
- Support Ticket Metrics: First Response Time and CSAT Locked
- NPS from Survey Scores: Promoters, Detractors and the Score Locked
- Expansion Pipeline: Upsells Weighted by Stage Locked
- At-Risk Accounts: Flags, ARR at Risk and a Live List Locked
- QBR One-Pager: The Numbers for a Quarterly Business Review Locked
- CS Dashboard: ARR Bridge, Chart and Churn Highlights Locked
- Renewal Price Uplifts: Contract Caps, Red Accounts and the ARR Effect Locked
- Seat True-Ups: Free Buffer, Billable Extra Seats and the Pro-Rata Invoice Locked
- Multi-Year Deals: Discounts, Price Ramps and Total Contract Value Locked
- Feature Adoption Matrix: Breadth per Account, Adoption per Feature & Core Gaps Locked
- Ticket Backlog & SLAs: Business-Day Age, Breaches and the Accounts That Wait Longest Locked
- Health Score Trends: Monthly Change, Slope and the Green Accounts That Are Sliding Locked
- Churn Reasons: Lost ARR by Reason, Controllable Share and a Sorted Bar Chart Locked
- Final Project – Renewal Readiness Board for Next Quarter Locked
Learner reviews
Be the first to review this course.