Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMAccounts & CustomersCustomer Health Scorecard

SpreadsheetAccounts & CustomersFree

Customer Health Scorecard

Score each account on usage, support, relationship and payments to spot churn risk early.

Shown with sample data

Colour

Customer Health Scorecard

Score each account on usage, support, relationship and payments to spot churn risk early.

Accounts
6
At risk
2
Revenue at risk
$134,000
Average health score
68
Out of 100
Annual revenue by segment
  • Enterprise$204,000
  • Mid-market$116,000
  • Small business$32,000
Share of annual revenue by segment
  • Enterprise$204,00058%
  • Mid-market$116,00033%
  • Small business$32,0009%

How to use it

  1. 1Rate each factor from 1 (poor) to 5 (excellent).
  2. 2Update the ratings monthly or after a notable event.
  3. 3Open a save plan for every At risk account.
  4. 4Check the weights against the customers who actually churned.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Customers rarely leave without warning. Rate each account on product usage, support experience, relationship strength and payment behaviour; the weighted score sorts accounts into Healthy, Watch and At risk and totals the revenue that needs attention before renewal.

Who it’s for

  • Weekly customer success stand-ups
  • Prioritising check-in calls
  • Forecasting renewals realistically

What’s included

  • Accounts sheet: One row per customer. Weights: usage 40%, relationship 25%, support 20%, payments 15%.
  • Summary by Segment sheet: Annual revenue and Revenue at risk and the number of entries for each segment, calculated from the Accounts sheet.

How to use it

  1. 1Rate each factor from 1 (poor) to 5 (excellent).
  2. 2Update the ratings monthly or after a notable event.
  3. 3Open a save plan for every At risk account.
  4. 4Check the weights against the customers who actually churned.
Related searchescustomer health scorechurn riskcustomer successaccount healthretention

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounts & CustomersFree

Customer Health Scorecard

Score each account on usage, support, relationship and payments to spot churn risk early.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More accounts & customers templates

View all
RFM Customer Segmentation3 sheets

Customers

14

Champions’ share of revenue

48%

Revenue from at-risk customers

$4,600

ABCD
1CustomerLast orderOrdersTotal spend
2Amelia TurnerNov 914$2,860
3Noah BennettOct 287$1,240
4Isla FraserNov 121$85.00
5Leo HughesApr 211$2,310
Customers
SpreadsheetAccounts & Customers

RFM Customer Segmentation

Score every customer on recency, frequency and spend, label them Champions to Lost and see where your revenue is at risk.

10 min setupPreview
Customer Contact List3 sheets

Customers

9

Lifetime revenue

$187,400

Revenue at risk

$37,100

ABCD
1CustomerContact personCityOwner
2Northwind RetailSara AliSeattleDana
3Blue Harbor CafeHana KimPortlandMia
4Oak & Pine StudioWill GrantDenverLeo
5Delta FoodsBen ColeChicagoLeo
Customers
SpreadsheetAccounts & Customers

Customer Contact List

A light CRM: every customer with owner, value, order history and an automatic segment, health and next contact.

10 min setupPreview

Customer Feedback Survey

Measure satisfaction and NPS, and learn what to improve.

Overall, how satisfied are you? *

Very satisfiedSatisfiedNeutral

How likely are you to recommend us to a friend or colleague (0–10)? *

012345678910

What did we do best?

Send feedback
FormAccounts & Customers

Customer Feedback Survey

Measure satisfaction and NPS, and learn what to improve.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ