The 7 numbers every online coach should track. With the formulas, the benchmarks, and the ChatGPT prompts that do the arithmetic.
A coach on r/personaltraining described using ChatGPT to "track renewal/redemption rates, client life cycles, average spend per client per lead source" instead of "having to do all the math manually in a spreadsheet". This page is that setup: seven numbers, what each one is, the benchmark from the Coachway platform where one exists, a one-tab sheet, and three prompts that compute, explain and model.
By Markus Evers · Published 6 September 2026 · Updated September 2026
the short version
An online coach should track seven numbers every month: active clients, revenue per client per month, months per client, churn or renewal, client lifetime value, revenue per lead source, and hours per client per week. Coachway's platform medians are 5 clients, EUR 181 per month and 4.3 months of tenure; three prompts below compute all seven from an export.
Which numbers should an online coach track every month?
Seven, and no more until these are stable: active clients, revenue per client per month, months per client, churn or renewal, client lifetime value, revenue per lead source, and hours per client per week. Four of them have a first-party benchmark from the online fitness coaching statistics (5,666 clients and 1,563 pricing records, August 2026); the other three are yours to set. Each row links the calculator that answers the what-if question. Four of them have a first-party benchmark from the online fitness coaching statistics (201 coaches, 5,666 clients, 1,563 pricing records, August 2026); the other three are yours to set. Each row links the calculator that answers the what-if question. The monthly numbers are one of twelve day-to-day jobs a small coaching business hands to ChatGPT; the other eleven are tabled on the AI hub.
| Number | Formula | Benchmark | Calculator |
|---|---|---|---|
| 1.Active clients | Count of clients with an active package on the last day of the month | Median 5, average 17.2 (Coachway platform data, Aug 2026) | Client capacity calculator |
| 2.Revenue per client per month | Monthly client revenue divided by active clients | Median EUR 181, middle half EUR 134 to 255 (Coachway, 1,563 pricing records) | Coaching rate calculator |
| 3.Months per client (tenure) | Average of (end date minus start date) for clients who left, in months | Average 4.3, median 3.2 (Coachway, 5,666 clients) | Client LTV calculator |
| 4.Churn or renewal | Clients lost in the month divided by clients at the start, as a percentage; or renewals divided by packages ending | 45 percent of clients active at month 12 (Coachway); one coach on r/personaltraining reports 90 percent annual renewal | Client churn rate calculator |
| 5.Client lifetime value | Revenue per client per month times months per client | About EUR 780 at the platform medians | Client LTV calculator |
| 6.Revenue per lead source | Revenue from clients who came from each source (referral, Instagram, Google, ads) divided by leads from that source | No platform benchmark; coaches report referrals as the highest | Referral value calculator |
| 7.Hours per client per week | Coaching hours in the week divided by active clients | Raise prices past 25 to 30 coaching hours a week (coaches on r/personaltraining) | Coaching profit calculator |
Separate the money first. The most-upvoted advice in the r/personaltraining thread on the money side of online coaching was to open a separate business account the day the first client pays, because mixed accounts make every number below a guess. The LLC or sole proprietor guide covers the setup.
How do you lay out a coaching business spreadsheet?
Two tabs: one row per client with an ID instead of a name, and one row per month. Eleven columns cover all seven numbers. Coaches who shared their own spreadsheet systems on r/personaltraining run exactly this shape; the export from your platform's client list fills the first tab, and the second is five numbers you type once a month. The monthly run of this is the one job a scheduled ChatGPT task does well, because no client is in it; the six-job sort is in the tasks-and-agents table on the AI hub.
Sheet layout and CSV header
When to use it: Once, when you set the sheet up.
What to paste in: Nothing: copy the header row into a new sheet, then export your client list into it with names replaced by IDs.
One tab, one row per client, anonymised (client ID, not name): client_id | start_date | end_date (blank if active) | package | price_per_month | lead_source | sessions_planned_month | sessions_done_month | checkins_planned | checkins_sent | coach_minutes_week Second tab, one row per month: month | active_clients | revenue | clients_lost | clients_started | coaching_hours CSV header to paste into a new sheet: client_id,start_date,end_date,package,price_per_month,lead_source,sessions_planned_month,sessions_done_month,checkins_planned,checkins_sent,coach_minutes_week
How do you get ChatGPT to compute the numbers from an export?
Paste the two tabs as CSV into prompt 1 and it returns the seven numbers with the formula and inputs beside each, so you can verify one by hand; do that every time, because models make arithmetic errors without flagging them. Prompt 2 explains the change since last month in three sentences. Prompt 3 models a 10 percent improvement in each number and ranks them. Client IDs only, never names, health data or card details; the client data guide has the rule set.
Compute the seven numbers, formulas shown
When to use it: Once a month, after the export.
What to paste in: The two tabs as CSV, client IDs only.
I am an online fitness coach. Below is an anonymised export of my client list (client IDs, no names, no health data) and a monthly summary tab. Compute these seven numbers for [MONTH] and show the formula and the inputs next to each result so I can check them: 1. Active clients on the last day of the month. 2. Revenue per client per month (monthly revenue / active clients). 3. Months per client: average of (end_date minus start_date) in months for clients with an end_date, plus the current tenure of active clients as a separate figure. 4. Monthly churn: clients_lost / active clients at the start of the month, as a percentage. Also annual renewal if package end dates exist. 5. Client lifetime value: number 2 times number 3. 6. Revenue per lead source: for each lead_source, total price_per_month of active clients from that source, and the count. 7. Hours per client per week: coaching_hours / active clients. Rules: use only the data pasted; if a field is missing, say so rather than assuming; round to one decimal; output a table with columns Number, Result, Formula, Inputs used; then list any rows you could not use and why. Do not give advice. Export: [PASTE THE TWO TABS AS CSV]
What changed since last month, in three sentences
When to use it: Right after prompt 1, with last month's table to hand.
What to paste in: Both months' seven-number tables.
Here are the seven numbers for [LAST MONTH] and [THIS MONTH] for my coaching business: [PASTE BOTH TABLES]. In three sentences, tell me what changed and the single most likely cause visible in the numbers themselves (for example, churn up because two six-month packages ended, or revenue per client up because new clients came in at the new price). Mark any inference that the numbers do not prove with "(unsure)". No recommendations, no praise.
What a 10 percent improvement in each number is worth
When to use it: Quarterly, or when deciding what to work on next.
What to paste in: This month's seven numbers.
Using these seven numbers: [PASTE], build a table that shows what a 10 percent improvement in each one, on its own, would do to annual client revenue, holding the others constant. Columns: Number, Current, Improved by 10 percent, Annual revenue now, Annual revenue after, Difference. Show the formula for annual revenue you used (active clients times revenue per client per month times 12, adjusted for churn where relevant) and state your assumptions in one line. Then rank the seven by difference. Numbers only; I decide what to work on.
What do the numbers say about what to do next?
Three rules cover most months. If hours per client per week puts you past 25 to 30 coaching hours, raise prices before adding clients, the rule coaches on r/personaltraining give each other at that ceiling ("when you hit 25-30hrs a week as an online coach; put your prices up"). If months per client sits under three, fix the package and the check-in cadence before spending on marketing, because every new client leaks out the same hole. If revenue per lead source shows referrals earning the most per lead, which most coaches find, put the next hour into the referral ask, not the ad account. Prompt 3 puts the numbers on each of those choices.
What is a good retention rate for online coaching?
On the Coachway platform, 45 percent of online coaching clients are still active at month 12 and the average client stays 4.3 months, median 3.2, measured across 5,666 clients in August 2026. Individual coaches report higher: one on r/personaltraining gives a 90 percent annual renewal rate and an average tenure of 2.6 years. That is one coach's number, not a benchmark, but it shows the ceiling. The growth guide shows why a month of extra tenure grows revenue faster than a month of new clients.
Where do the numbers come from?
From the client list and the payment records, exported once a month. On Coachway the client list carries start dates, packages and prices and exports as CSV, and payments run through the coach's own Stripe account, so the first tab is an export and the second is five figures. If you run on spreadsheets and messaging apps, the same eleven columns work; they just take an evening to fill the first time. Twenty minutes a month after that.
Frequently asked questions about coaching business numbers.
What KPIs should a personal trainer or online coach track?
Seven numbers cover a coaching business: active clients, revenue per client per month, months per client (tenure), monthly churn or annual renewal rate, client lifetime value, revenue per lead source, and hours per client per week. Track them once a month from your platform export; anything beyond those seven is a nice-to-have until the seven are stable.
How do I calculate client churn rate?
Clients lost in the month divided by clients at the start of the month, as a percentage. Ten clients on the first, one cancels by the thirtieth: 10 percent monthly churn. Its mirror is the annual renewal rate; one coach on r/personaltraining reports a 90 percent annual renewal rate and an average client tenure of 2.6 years, which is what a low churn number looks like in practice.
What is a good client retention rate for online coaching?
On the Coachway platform, 45 percent of online coaching clients are still active at month 12, and the average client stays 4.3 months (median 3.2), from 5,666 clients measured in August 2026. A coach whose clients average six months or more is above the platform average; a coach below three months has a package or cadence problem before a marketing one.
How do I calculate client lifetime value?
Revenue per client per month multiplied by the average months a client stays. At the Coachway medians, EUR 181 a month times 4.3 months is about EUR 780 per client; at EUR 255 and eight months it is about EUR 2,040. Lifetime value is the number that tells you what a lead is worth and how much retention work pays.
Can ChatGPT analyse my coaching spreadsheet?
Yes, for arithmetic on an anonymised export with client IDs instead of names: it can compute the seven numbers, show the formulas, and explain the change since last month. Verify one figure by hand every time, because models make arithmetic errors and never flag them, and never paste names, health data or payment details.
How often should I review my coaching business numbers?
Monthly, in a fixed 20-minute slot: export, run the numbers, compare with last month, decide one thing. Weekly is noise; quarterly hides a bad month until it is two. The four calculators on this site are for the what-if questions between reviews.
Seven numbers, one sheet, twenty minutes a month. The model does the arithmetic; you check one figure and make one decision.
Keep reading
all guidesOnline fitness coaching statistics 2026: first-party benchmarks and market data
First-party benchmarks from 201 Nordic online fitness coaches on the Coachway platform (median 5 active clients, EUR 181 per client per month, 4.3-month average client tenure, 45% retention at month 12) plus sourced market-size, growth and earnings figures, each with its sample size and source.
Read the guideHow to grow an online coaching business
The stage-by-stage playbook: the three levers that actually move revenue, the content funnel, and what to focus on at each stage from your first client to a full client base.
Read the guideHow to retain online coaching clients and reduce churn (2026 guide)
Most coaches chase new clients while quietly losing the ones they already have. This guide covers why retention beats acquisition economically, the real churn signals (missed check-ins, going quiet, slowing logins), early-warning alerts on an inactivity threshold, a consistent weekly check-in cadence, making progress visible with charts and photos, re-engagement and plateau plans, and the honest truth that some churn is healthy.
Read the guideFree tools for this: Client Churn Rate Calculator · Client LTV Calculator · Coaching Profit Calculator
Ready-made template: AI Prompt Pack for Online Coaches
Where the export comes from
Client list, packages, check-ins and payments through your own Stripe on one platform, with CSV export. Start the 14-day free trial and run this month's numbers: cancel any time under Billing.
