Gym revenue and marketing dashboard: the 12 numbers that fit on one screen
A gym runs on 12 numbers on a screen, reviewed once a month. Not with the Meta panel open every day, not with a 40-page agency report, and not with the feeling of "this month went well" based on how busy Tuesday at 7pm looked. Twelve numbers that connect what you spend on acquisition to what you bill, because separately both sides lie: the ads panel shows you leads without telling you whether they pay, and the management software shows you memberships without telling you where those members came from.
This article is the full template: the 12 numbers in 3 blocks, where each one comes from, what a healthy range looks like, why the review is monthly and not daily, and three setup levels depending on how much complexity you want.
The three blocks
The structure follows business funnel logic. The first block measures the acquisition machine. The second, the health of the business. The third connects the two, and it's the one missing from 95% of gyms: without it, you can have good marketing metrics and good business metrics and still have no idea whether marketing is actually building the business.
Block 1: acquisition (5 numbers)
Ad spend, leads, CPL, new members from marketing, and CAC. This is the block you're probably already looking at, though you may be missing the last one: acquisition cost calculated by dividing spend by actual new members, not by leads. CPL is only half the story, if you lose track between the lead and the signup, the metrics for each funnel stage show you where.
Block 2: business (4 numbers)
Monthly recurring revenue, average membership fee, net new members, and churn. This is where the truth lives: you can have a record month for signups and still be shrinking, if cancellations outnumbered them. Net new members (signups minus cancellations) is the number that reveals it, and almost nobody has it calculated because signups get celebrated at the front desk while cancellations get processed in admin, quietly.
Block 3: the connection (3 numbers)
New revenue by campaign, payback period, and LTV:CAC ratio. All three answer the one question that justifies marketing spend: how much money does each euro invested return, and how long does it take? It's the core idea behind the whole approach of measuring marketing with billing data, condensed into three cells.
The full table
| # | Metric | Definition | Where it comes from | Healthy range |
|---|---|---|---|---|
| 1 | Ad spend | Total invested in Meta + Google for the month | Ads panels | 5-10% of revenue |
| 2 | Leads | Forms/contacts generated | Ads panels or CRM | Depends on the model; the trend matters more than the number |
| 3 | CPL | Spend ÷ leads | Calculation | 3-8€ low-cost, 8-20€ boutique |
| 4 | New members from marketing | New members whose origin is a campaign | Management software (source field) or phone cross-reference | 50-80% of total signups |
| 5 | CAC | Spend ÷ new members from marketing | Calculation | Less than 2× average fee; less than 1.5× is already very good |
| 6 | Recurring revenue | Sum of active memberships for the month (excluding enrollment fees and extras) | Management software | Growing; flat for 3 consecutive months is a warning sign |
| 7 | Average fee | Recurring revenue ÷ active members | Calculation | Stable or rising; if it drops, you're buying members with discounts |
| 8 | Net new members | Signups − cancellations for the month | Management software | Positive; 0 is stagnation, negative is urgent |
| 9 | Churn | Cancellations ÷ active members at start of month | Management software | 2-4% monthly; above 5% is the first fire to put out |
| 10 | New revenue by campaign | First-month fees from new members, grouped by source campaign | Ads + management cross-reference | The campaign that billed most, not the one with the best CPL |
| 11 | Payback | CAC ÷ monthly margin per member = months to recover the investment | Calculation | Under 3 months is good, under 2 is very good |
| 12 | LTV:CAC | Member lifetime value ÷ cost to acquire them | Calculation using LTV from your software | 3:1 or more; below 2:1, review your offer or retention |
The ranges are guidelines for gyms with average fees in Spain (35-70€); a 19€ low-cost and a 120€ premium studio operate in completely different worlds. What doesn't change is the structure: if block 3 is empty, the other two can't be interpreted.
On the two block-3 metrics that deserve their own deep dive: payback is worth understanding thoroughly because it determines how much you can afford to scale (it's developed with scenarios here), and the LTV:CAC ratio is the number a bank or a buyer would look at first if you ever sell (the ratio guide, with its pitfalls).
Why monthly and not daily
Checking campaigns every day is one of the most expensive habits a gym owner can have, and not because of the time it takes.
The problem is statistical. With €500/month in spend and a €10 CPL, you generate 50 leads a month: fewer than 2 a day. At that volume, a Tuesday with 0 leads and a Wednesday with 4 are the same campaign performing the same way; the difference is pure noise. But the brain doesn't process it that way: it sees Tuesday at zero, decides "the campaign is dead," touches the audience or the budget, and in doing so resets the learning phase of Meta's algorithm, which is the single most effective way to break a campaign that was working. Then Thursday produces 5 leads, you attribute the improvement to your change, and the cycle of tweaking on noise reinforces itself.
Business decisions (scale, pause, change the offer) need a sample, and the minimum reasonable sample for a gym is one month. The operational exception: actual failures do get monitored daily, but through alerts, not panel sessions. Rejected campaign, spend at zero, broken form: an automated notification handles that, not half your morning.
The monthly dashboard protects you from yourself. You convert 30 days of noise into 12 numbers comparable to the previous month, and decisions come from trends, not from scares.
How to build it: three levels
Level 1: spreadsheet, 30 minutes a month, €0
A sheet with one row per month and 12 columns. On the 1st of each month you fill in the row: three numbers come from the ads panels (spend, leads, then CPL), four from your management software (recurring revenue, signups, cancellations, active members), and the rest are formulas. The only real work is the source field for new members: cross-referencing new members' phone numbers with leads in the panel, which with 10-25 signups a month takes 15 minutes.
This version gives you 80% of the value and is where you should start even if you plan to automate later, because it forces you to understand each number before you delegate it to a formula.
Level 2: management software + automated sheet
If your software exports data or has an API, the four business numbers flow automatically into a connected spreadsheet, and the ad numbers come in through Google Sheets' native connectors or similar. The lead-to-member cross-reference semi-automates with phone number as the key. Setting it up takes an afternoon; maintaining it takes almost nothing. The requirement is that your billing data is clean and accessible, which is less common than it sounds: unprocessed cancellations, frozen memberships counted as active, and duplicate members will break block 2 entirely.
Level 3: integrated tool
Platforms that connect campaigns, leads, and signups in the same flow and serve you block 3 without manual cross-referencing, with revenue by campaign updating automatically. This is the level where the dashboard stops being a monthly snapshot and stays current at all times (Pilotium works exactly this layer). The honest criterion for making the jump: when level 1 or 2 breaks two months in a row because of time constraints, automate, because an unfilled dashboard protects you just as well as no dashboard.
Start at level 1 this month even if level 3 is your destination. You need to know the numbers by hand at least once.
If you could only look at three
If you had to choose, these three sustain the business on their own:
Net new members. The gym's ECG. Positive means you're growing; negative means you're shrinking; everything else is nuance. It's also the number that detects retention problems fastest, the ones that marketing is covering up.
CAC. What a new member actually costs you. If it rises three months in a row, something is running out (the audience, the creative, the offer) and you want to know that before the payback period stretches to 5 months.
Payback. The bridge between the other two: it tells you whether you can afford to accelerate. With a 2-month payback, scaling budget is almost free; with a 6-month payback, scaling means financing members with your own cash for half a year.
Notice that none of these three is CPL, CTR, or reach. Platform metrics are for diagnosis when something breaks, not for the dashboard. The full KPI list with ranges is a useful reference, but the day-to-day runs on less.
The habit that makes it work
A dashboard without a routine is decoration. The routine that works: first Monday of the month, 30 minutes blocked in the calendar, and three decisions written down before you close the sheet:
- What I'm scaling. The campaign with the best revenue per euro (not best CPL) gets more budget.
- What I'm pausing or changing. Anything that's been below the healthy range for two months with no explanation.
- What I'm testing. One experiment a month, one only, with its hypothesis written down so you can judge it the following month.
Writing it down matters more than it seems. The October note ("scaling the transparent-pricing campaign because its payback is 1.8 months") is what lets you know in December whether you were right, and it's what turns 12 numbers into a decision system rather than a ritual of staring at cells.
The first session is the most uncomfortable: you'll be missing half the numbers and you'll discover that some of them you can't pull from your software without a fight. That discomfort is the free diagnosis. Every empty cell in the row is something your business is currently deciding blind, and filling them in, one per month if needed, is probably the best-paid hour of your year.