CrossFit box KPI dashboard setup is one of the most valuable and most overlooked tasks a VA can own. Most box owners know something is wrong (memberships are flat, revenue is soft) but can't pinpoint why because they're not tracking the right numbers consistently. A VA who builds and maintains a functional KPI dashboard gives you the visibility to run the business on data, not gut feel. This SOP covers exactly how to build that dashboard.
Choosing the Right KPIs for a CrossFit Box
Not every metric matters. A 20-row spreadsheet full of numbers you don't act on is clutter. The goal is a concise dashboard (10 to 15 KPIs) that flags problems before they compound and confirms what's working before you change it.
The core KPIs for a CrossFit box break into four categories:
Revenue and membership.
- Monthly Recurring Revenue (MRR): Total billable membership revenue for the month
- Average Revenue Per Member (ARPM): MRR divided by active member count
- Active member count: Total paying members on any membership type
- New memberships sold: Count and dollar value of memberships activated this month
- Churned memberships: Count and dollar value of memberships cancelled this month
- Net membership change: New minus churned
Retention and attendance.
- Monthly churn rate: Churned members divided by prior month's active member count
- Average visits per active member per week: Key retention predictor. Members visiting 3+ times per week churn at dramatically lower rates
- Class utilization rate: Average spots filled divided by total capacity across all classes
- No-show rate for intro/trial classes
Sales funnel.
- New leads generated (total and by source)
- Lead-to-trial-booking rate
- Trial attendance rate
- Trial-to-membership conversion rate
- Cost per lead (if running paid ads)
Operations.
- Delinquent/failed payment rate
- Outstanding account balances
- Coach utilization rate (if paying coaches per class, total classes coached vs. total available)
Your VA configures the dashboard to show this month's values, last month's values, and the percentage change for each KPI. Context matters as much as the number.
Pulling Data from Wodify, SugarWOD, and Mindbody
CrossFit boxes use different software combinations. The most common setups:
- Wodify for both gym management and programming
- Mindbody for gym management with SugarWOD for programming
- Wodify with a separate CRM like GoHighLevel for leads
Your VA's first task is identifying which system is the source of truth for each KPI category. Membership and revenue data comes from the gym management platform (Wodify or Mindbody). Attendance and class data comes from either the gym management platform or SugarWOD if that's where classes are tracked. Lead data comes from the CRM.
Wodify data extraction. Wodify's Reports section covers most financial and membership KPIs. Your VA runs and exports these reports weekly or monthly depending on the KPI:
- Revenue Summary report: MRR, new membership revenue, add-on revenue
- Membership Summary report: Active count, new, cancelled, net change
- Attendance report: Visits by member, class utilization by time slot
Wodify doesn't have a single "dashboard" export. Your VA pulls individual reports and pastes the relevant figures into the master KPI spreadsheet. This takes 20 to 30 minutes weekly once the spreadsheet template is set up.
Mindbody data extraction. Mindbody's Report Builder in MINDBODY Online allows custom report configurations. Your VA saves report configurations for each KPI category so they can pull them in one click rather than rebuilding the filters each time. Key saved reports: Membership Revenue by Period, Net Membership Changes, Visit Count by Member, Class Utilization.
SugarWOD data. SugarWOD tracks workout performance and attendance. Your VA exports the attendance log weekly to calculate visits-per-member. SugarWOD's admin dashboard shows this natively for top-level views, but the per-member export is needed for identifying at-risk members with declining visit frequency.
Building the KPI Dashboard in Google Sheets
A Google Sheet is the right tool for a CrossFit box KPI dashboard. It's accessible, shareable, and flexible enough to accommodate the non-standard data exports from gym management platforms. Avoid overbuilding in a BI tool like Tableau or Looker Studio unless the box is operating at a scale that justifies the complexity.
Dashboard structure. Your VA builds the dashboard as a multi-tab workbook:
- Tab 1: Summary Dashboard: The 10 to 15 core KPIs, current month vs. prior month, with conditional formatting (green if on target, yellow if within 10% of threshold, red if below threshold)
- Tab 2: Revenue Detail: MRR breakdown by membership type, month-by-month trend for the trailing 12 months
- Tab 3: Membership Detail: Active count, new, churned, and net change with month-by-month trend
- Tab 4: Funnel Detail: Lead volume, conversion rates by stage, CPL by source
- Tab 5: Attendance Detail: Class utilization by time slot, visits per member distribution, at-risk member list (members with less than 1 visit in the past 14 days)
- Tab 6: Raw Data: Paste-destination for weekly/monthly data exports from gym software
Conditional formatting rules. Your VA sets conditional formatting on every KPI cell in the Summary Dashboard. Define the target and the floor for each KPI upfront. Example: Active member count target = 120, floor = 100. If the cell shows 100 or below, it turns red. Between 100 and 112, yellow. Above 112, green. The owner opens the dashboard and can read the health of the business in 30 seconds from color alone.
Automation where possible. Some data points can be auto-refreshed rather than manually pasted. If Wodify or Mindbody has a Zapier integration, your VA can automate the transfer of new membership and revenue data into the sheet, reducing manual data entry time. This is worth setting up if the box can justify the Zapier cost. It saves 30 to 60 minutes of weekly admin time and eliminates manual entry errors.
Weekly and Monthly Dashboard Update Workflow
The dashboard is only useful if it's current. Your VA maintains a strict update schedule.
Weekly update (every Monday by 9am). Your VA pulls and pastes:
- Week's new leads by source (from CRM)
- Week's trial classes booked and attended
- Week's new memberships and cancellations (from gym management platform)
- Week's failed payments
- Current at-risk member list (members with no visits in 14+ days)
The weekly update takes 20 to 30 minutes. The owner receives a Slack or email notification that it's complete and reviews the Summary Dashboard tab.
Monthly update (first Monday of each month). Your VA pulls full monthly exports for all KPI categories, updates the trailing 12-month trend charts, recalculates month-over-month percentage changes, and flags any KPI that crossed a threshold (green to yellow, or yellow to red).
The monthly update also includes a one-paragraph written interpretation: what moved, what changed from the prior month, and one recommendation based on the data (e.g., "Trial attendance rate dropped from 68% to 52%. The confirmation reminder sequence may need review").
Using the Dashboard to Drive Decisions
A dashboard that only gets read is still just a report. The value comes from using the data to trigger action.
Your VA maintains a "Threshold Alert" protocol: any KPI that enters red status triggers a same-day Slack message to the owner with the KPI, the current value, the threshold, and a suggested next step. This removes the reliance on the owner remembering to check the dashboard. The VA acts as the monitoring layer.
Common threshold alerts for CrossFit boxes:
- Monthly churn rate above 5%: Flag for a retention outreach campaign
- Average visits per member below 2.5 per week: Flag for a re-engagement sequence
- Trial-to-membership conversion below 45%: Flag for a follow-up sequence audit
- CPL above target for the market: Flag for ad creative review
The dashboard doesn't replace judgment. It informs it. Your VA surfaces the numbers; you and your coaching team decide the response.
For help connecting your dashboard data to upstream marketing, see ad campaign management. Plug the same data into your weekly reporting cadence so trends stay visible. McKinsey reports 60% of occupations could automate 30%+ of activities.
Frequently Asked Questions
How long does it take a VA to build the initial CrossFit box KPI dashboard?
The initial build (mapping KPIs, building the Google Sheet template, configuring conditional formatting, setting up data sources, and pulling the first month of baseline data) takes 6 to 10 hours. After that, the weekly update takes 20 to 30 minutes and the monthly update takes 60 to 90 minutes.
Does the VA need access to the gym management platform to pull reports?
Yes. Your VA needs read-only reporting access to Wodify, Mindbody, or whichever platform the box uses. In Wodify, this is a Staff role with Reports access. In Mindbody, it's a Staff level with Revenue reports and Client reports permissions enabled. They should not have access to billing settings, staff payroll, or the ability to modify memberships.
What if the gym management platform doesn't export clean data?
This is common. Mindbody in particular produces reports that need cleanup before they're dashboard-ready. Your VA builds a simple data-cleaning step into the update workflow: paste the raw export into a cleaning tab, apply consistent formatting, then paste normalized values into the dashboard. Document this step in the SOP so it survives VA turnover.
Should the KPI dashboard include personal training or retail revenue?
Include it as a separate line in the Revenue Detail tab, but don't mix it with MRR. Membership revenue is predictable and recurring. That's the core business. PT and retail revenue is variable. Mixing them in the headline MRR figure masks membership performance trends. Track both, but track them separately.
How does a VA keep the dashboard useful as the business grows?
Review the dashboard structure quarterly. KPIs that made sense at 80 members may need refinement at 200. Add new KPIs only when there's a clear decision they'll inform. Remove KPIs that have been green for six consecutive months without any intervention. They're healthy and don't need monitoring bandwidth. The dashboard should stay lean and decision-focused, not grow into a vanity metrics collection.