HIIT Studio KPI Dashboard Setup SOP

A HIIT studio KPI dashboard setup gives you a single view of how the business is performing without digging through five different platforms every week. Most studio owners check metrics reactively - someone asks about retention, so they log into Mindbody and run a report. A dashboard flips that to proactive. Your VA builds it, populates it weekly, and flags anything that moves outside your target ranges. You open one page and know where you stand.

This SOP covers which KPIs to track, where to source the data, how to build the dashboard, and the weekly update process.

Selecting the Right KPIs

A HIIT studio KPI dashboard should track 10-15 metrics across four categories. More than that creates noise. Your VA sets up these core metrics:

Revenue and financial:

• Monthly recurring revenue (MRR) - total membership revenue from active members
• Average revenue per member (ARPM) - MRR divided by active member count
• Revenue by source - memberships, class packs, retail, events, personal training

Membership and retention:

• Total active members
• New members this month
• Cancellations this month
• Net member change (new minus cancelled)
• Monthly churn rate - cancellations divided by total members at the start of the month
• Average member tenure - how long the typical member has been active

Operations and utilization:

• Average class attendance rate - total attendance divided by total capacity across all classes
• Classes at 80%+ capacity - identifies your most popular time slots
• No-show rate - booked but did not attend, as a percentage of total bookings
• Trial-to-member conversion rate

Marketing and acquisition:

• New leads this month
• Cost per lead (by channel)
• Cost per acquisition (total marketing spend divided by new members)

Your VA confirms data sources for each metric before building the dashboard.

Sourcing the Data

Your VA pulls data from these systems:

• Studio management software (Mindbody, Pike13, Zen Planner, Wodify): membership counts, attendance, class utilization, revenue, cancellations
• Payment processor (Stripe, Square, or the billing module in your studio software): revenue breakdowns, failed payments, refunds
• CRM or lead tracker (GoHighLevel, HubSpot, or your manual spreadsheet): lead counts, conversion rates, lead source attribution
• Ad platforms (Meta Ads Manager, Google Ads): spend, leads, cost per lead
• Google Analytics and Search Console: website traffic, top landing pages, organic search performance

Not all of these will be relevant to every studio. Your VA starts with what you have and adds sources as you grow.

For each data source, your VA documents where to find the specific number, which report to run, and any filters needed. This documentation ensures the process works if the VA is out or if you transition to a new VA.

Building the Dashboard

Your VA builds the dashboard in one of these tools, depending on your preference and budget:

Google Sheets (free, simple):

• One tab per category (revenue, membership, operations, marketing)
• A summary tab with the top 10 KPIs and traffic light indicators (green = on target, yellow = within 10% of target, red = outside target)
• Charts for trending metrics (MRR, active members, class utilization) showing the last 12 months

Notion (free or low-cost):

• A single page with database views for each KPI category
• Rollups and formulas for calculated metrics
• Visual progress bars for target-based KPIs

Google Looker Studio (free, more advanced):

• Connects directly to Google Sheets, Google Analytics, and some ad platforms
• Auto-refreshes certain data sources
• More polished visualizations for sharing with investors or partners

For most single-location studios, Google Sheets is the right starting point. Your VA can build it in a day and the learning curve is minimal.

For a comprehensive view of what a fitness VA handles, see Fitness Virtual Assistant Tasks List.

The Weekly Update Process

Every Monday morning, your VA updates the dashboard:

1. Log into each data source and pull the prior week's numbers
2. Enter them into the dashboard in the correct fields
3. Check all calculated fields (rates, averages, trends) for accuracy
4. Update traffic light indicators based on your target ranges
5. Write a 3-5 bullet summary at the top of the dashboard: what improved, what declined, and anything that needs your attention

The weekly update takes 30-45 minutes once the dashboard is built and the data sources are documented. Monthly metrics (churn rate, MRR, ARPM) get updated on the first Monday of each month.

Your VA sends you the dashboard link every Monday with a brief message highlighting the key takeaways. No attachment - just a link so you always see the most current version.

Setting Targets and Alert Thresholds

Each KPI needs a target and a threshold that triggers a flag:

• MRR: Target based on your business plan. Flag if it drops more than 5% month-over-month.
• Churn rate: Target under 5% monthly for a healthy studio. Flag if it exceeds 7%.
• Class utilization: Target 70-85% average across all classes. Flag if it drops below 60%.
• No-show rate: Target under 15%. Flag above 20%.
• Lead response time: Target under 5 minutes. Flag if average exceeds 30 minutes.
• Cost per acquisition: Target based on your average member lifetime value. Flag if CPA exceeds one month's membership revenue.

Your VA monitors these thresholds weekly and alerts you immediately - not in the Monday report - if a metric crosses a critical threshold mid-week.

If you are exploring whether to bring a VA into your studio, What Is a Fitness Virtual Assistant covers the role.

FAQ

How long does it take to build the initial dashboard?

A Google Sheets dashboard takes 4-8 hours to build from scratch, including data source documentation. A Looker Studio version takes longer because of the integration setup. Plan for the first version to be live within one week of starting the project.

What if we do not have historical data for some metrics?

Start tracking from today. Your VA begins populating the dashboard with current data and builds the historical baseline over the next 3-6 months. Do not delay the dashboard because you lack history - the sooner you start, the sooner you have trend data.

Should the dashboard be shared with the whole team?

Share a read-only version with coaches and managers who need visibility into their area. Revenue and financial metrics may stay restricted to you and your operations lead. Your VA sets up appropriate sharing permissions based on your direction.

Can the VA automate the data pull?

Partially. Google Looker Studio auto-pulls from connected sources. For platforms without direct integration, your VA pulls data manually. Zapier or Make can automate some transfers (Mindbody to Google Sheets, for example), but the setup cost is only worth it if your VA spends more than 30 minutes per week on manual data entry.