Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Your Book of Business: Plan Lookup and ARR per AccountLabFree
  2. Customer Health Score: Weighted Signals and Green, Yellow, RedLab Locked
  3. Renewal Calendar: Renewal Dates, Days Left and FlagsLab Locked
  4. Logo Churn vs Revenue Churn: Two Rates, Two StoriesLab Locked
  5. Net Revenue Retention: Expansion, Contraction and ChurnLab Locked
  6. Product Adoption: Active Users as a Share of SeatsLab Locked
  7. Support Ticket Metrics: First Response Time and CSATLab Locked
  8. NPS from Survey Scores: Promoters, Detractors and the ScoreLab Locked
  9. Expansion Pipeline: Upsells Weighted by StageLab Locked
  10. At-Risk Accounts: Flags, ARR at Risk and a Live ListLab Locked
  11. QBR One-Pager: The Numbers for a Quarterly Business ReviewLab Locked
  12. CS Dashboard: ARR Bridge, Chart and Churn HighlightsLab Locked
  13. Renewal Price Uplifts: Contract Caps, Red Accounts and the ARR EffectLab Locked
  14. Seat True-Ups: Free Buffer, Billable Extra Seats and the Pro-Rata InvoiceLab Locked
  15. Multi-Year Deals: Discounts, Price Ramps and Total Contract ValueLab Locked
  16. Feature Adoption Matrix: Breadth per Account, Adoption per Feature & Core GapsLab Locked
  17. Ticket Backlog & SLAs: Business-Day Age, Breaches and the Accounts That Wait LongestLab Locked
  18. Health Score Trends: Monthly Change, Slope and the Green Accounts That Are SlidingLab Locked
  19. Churn Reasons: Lost ARR by Reason, Controllable Share and a Sorted Bar ChartLab Locked
  20. Final Project – Renewal Readiness Board for Next QuarterLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy