← Back to blogRevenue-Driven Marketing

Gym revenue and marketing dashboard: the 12 numbers that fit on one screen

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:

  1. What I'm scaling. The campaign with the best revenue per euro (not best CPL) gets more budget.
  2. What I'm pausing or changing. Anything that's been below the healthy range for two months with no explanation.
  3. 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.

Stay Ahead of the Game

Weekly AI marketing insights. No spam. Unsubscribe anytime.