Build the dashboard around owner decisions
A gym kpi dashboard is not a decoration for the reception wall. It is a work sheet for decisions. If a number does not change what you do at the front desk, on the floor, in sales or with expenses, keep it out of the weekly review.
Start with a simple sheet. Use one tab for sales, one for renewals, one for attendance, one for dues, one for PT and one for costs. The dashboard view should pull only the headline numbers from those tabs. Detail stays in the tabs; action stays on the dashboard.
Your Monday review should answer a plain question: where did money come from, where did it leak, and what will the team do before the next review? Gym owners often get stuck because every team member has a different version of the truth. Front desk says leads are fine, trainers say attendance is weak, and accounts says dues are pending. Put it in one place.
If you are still deciding what should be handled by software, staff and SOPs, read this gym management system guide and map your own gym against it.
- Lead source: walk-in, call, WhatsApp, referral, ad, social, old member.
- Lead stage: new, contacted, trial session booked, visited, joined, lost.
- Conversion view: leads received, visits completed, joins completed.
- Renewal view: due soon, spoken to, promised, renewed, lost.
- Attendance view: active members, absent members, returning members.
- Dues view: pending amount, owner of follow-up, next call date.
- PT view: assessment done, pitch done, plan selected, payment collected.
- Cost view: fixed cost, variable cost, paid, pending, avoidable spend.
Lead and conversion sheet
Your lead sheet should show the journey from enquiry to paid member. Do not stop at lead count. A large lead list with poor visits is not a win. A small lead list with clean follow-up and better joining can still be useful for the week.
Mark every lead source clearly. If you run ads, do not mix ad enquiries with walk-ins or old member referrals. You need to know which source brings serious prospects and which source only creates phone work. For campaign structure and measurement, keep the gym ads guide next to your dashboard.
The front desk should not write random notes like interested or will call. Use fixed stages. That makes the review faster. If a lead is lost, write the reason in a fixed format: price issue, timing issue, location issue, no response, joined elsewhere, not fit for current plan.
Example: If leads are 80 and paid joins are 20, the joining ratio is 20 ÷ 80 = 25%.
Use a simple call script so the number has action behind it. Lead review script: Hi [Name], you had enquired about [Gym]. You can visit on [Date] for a trial session and plan discussion. I will block your slot. Please confirm your preferred time.
For front desk scripts, missed-call handling and visit booking habits, use this pre-sales enquiry handling guide. The dashboard will only work if the team follows the same language every day.
- Owner question: which source brought leads who actually visited?
- Owner question: which staff member has pending follow-ups?
- Owner question: which offer created enquiries but weak joining?
- Owner question: which lost reason appears again and again?
- Owner action: call the warm lost leads yourself before changing pricing.
- Owner action: remove vague stages from the sheet and force clean status updates.
Renewal and attendance sheet
Renewals should not be reviewed only after the member has already left. Your dashboard should show members due soon, members spoken to, members who promised to renew, and members who need owner intervention. The weekly review is where you stop renewal leakage before it becomes a cash problem.
Attendance is the early warning signal for renewal risk. If a member is absent for long enough to forget the gym routine, the renewal conversation becomes harder. Track absent members and returning members separately. A returning member needs encouragement; an absent member needs contact.
Do not let trainers say, I know my members. Put attendance risk into the dashboard. If you use check-in records, review them as part of the meeting. If your gym uses a check-in device or wants to set one up, this biometric check-in guide will help you plan the process.
Renewal message template: Hi [Name], your [Gym] membership is coming up for renewal on [Date]. Your attendance and progress are important to us. Please reply with a good time today so we can help you continue without a break.
Owner call script: Hi [Name], I noticed your renewal is pending. Tell me honestly, what should we improve for you? I want to solve it before we discuss payment.
For deeper renewal work, use this gym renewal guide. In the dashboard, keep the renewal list visible until money is collected or the member is marked lost with a reason.
- Mark members due soon by status, not by memory.
- Keep a separate list of members who stopped attending.
- Ask trainers for member feedback before the owner call.
- Record the exact objection in the renewal sheet.
- Do not close a renewal task because the member said later.
- Move promised renewals into the dues tracker if payment is not collected.
Dues, PT and add-on revenue
Dues are not just an accounts issue. They are an owner issue because unpaid money affects salaries, rent, vendor payments and marketing decisions. The dashboard should show pending dues by member, follow-up owner, promise date and next action. If nobody owns the follow-up, the due will sit quietly until it becomes uncomfortable.
The dues sheet should separate payment promised from payment collected. A promise is not cash. During the weekly review, ask for proof of collection, receipt entry and next call status. If your team struggles with collection discipline, this gym payment collection guide gives a clean operating flow.
PT should also sit in the dashboard. Do not treat PT as a random trainer sale. Track who completed assessment, who was offered PT, who said yes, who is pending payment, and which trainer owns the follow-up. This tells you whether the issue is demand, pitch quality, trainer confidence or payment closure.
PT follow-up template: Hi [Name], based on your assessment at [Gym], we recommend personal training for your goal. Your trainer can explain the plan on [Date]. Please confirm your slot so we can prepare your workout discussion.
Trainer review prompt: Show me the members you assessed, the plan you suggested, the objection you heard, and the next follow-up. If the trainer cannot answer, the dashboard is not the problem. The sales habit is the problem.
For building PT as a proper internal business, keep this PT business guide with your dashboard. For add-on offers beyond PT, this upselling add-on plans guide can help you structure the conversation.
- Dues action: assign one person to every pending payment.
- Dues action: write the next call date, not just pending.
- Dues action: move repeated excuses to owner call.
- PT action: review assessments done, pitches made and payments collected.
- PT action: listen to trainer objections, not just member objections.
- PT action: check whether the same members are being pitched again without progress.
Cost review that owners can act on
Cost review should not become a blame meeting. It should show what was planned, what was paid, what is pending and what can be avoided. Put rent, salaries, utilities, repairs, cleaning, consumables, marketing and vendor payments into clear buckets. Your CA can advise how you should classify items for accounts and tax.
The useful question is not, why is cost high? The useful question is, which cost helped revenue, retention, safety or member experience, and which cost happened because the gym had no control process? A repair caused by ignored maintenance needs a different action from a planned upgrade.
Keep marketing spend in the cost sheet, but link it back to the lead sheet. If spend happened and no lead source was marked, you have no learning. If leads came but visits did not happen, the cost issue may be follow-up, not advertising. If visits happened but joins did not happen, review pricing, offer and sales conversation.
For expense categories and owner checks, use this gym expense management guide. For overall profit review, compare your dashboard inputs with the gym profit guide and use the ROI calculator when you want to test a planned change.
Do not cut costs blindly. Cutting cleaning, staff support or member communication can create a service issue. Instead, mark every cost with an action: continue, renegotiate, delay, stop, verify, or move to planned budget.
- Check whether the cost was planned or surprise.
- Check whether the bill is verified before payment.
- Check whether a cost links to revenue, retention or safety.
- Check whether a recurring cost still has a clear owner.
- Check whether marketing cost is tied to lead source and conversion.
- Check whether repair cost points to a missing SOP.
Run the weekly review without drama
A dashboard fails when the meeting becomes emotional. Keep the review calm and repetitive. Same agenda, same sheet, same owners, same closing action list. The owner should not spend the meeting searching for data. Data must be filled before the review starts.
Ask every department for action, not excuses. Front desk owns lead status and renewal follow-up. Trainers own attendance risk, member experience and PT movement. Accounts owns dues and receipts. The owner owns decisions that need pricing, staffing, cost or policy changes.
Use a simple agenda. Start with sales. Move to renewals. Move to attendance. Move to dues. Move to PT. Move to costs. End with an action list. Every action needs a person, a date and a visible status. If an action has no owner, it is only a wish.
Connect the dashboard to SOPs. If a number is weak, write the process that should prevent the same issue next week. Missed lead calls need a calling SOP. Weak renewals need a renewal SOP. Dirty cost data needs an expense entry SOP. Use this gym SOPs checklist and the broader gym management guide to turn numbers into operating habits.
Dashboard closing format: What changed this week? What is stuck? Who owns the stuck item? What will be checked in the next review? Keep this format on the sheet so the team learns that every number needs action.
If you want the WTF Powered team to review your dashboard and gym gaps with you, book the free gym audit; the team calls the same day.
- Do the review on a fixed weekday.
- Lock data entry before the meeting starts.
- Do not accept blank status fields.
- Do not discuss new offers before checking conversion and renewal numbers.
- Do not approve spend without source and outcome tracking.
- Close every meeting with a written action list.
