Rehab and Prehab Coach KPI Dashboard Setup

Running a rehab and prehab coaching business without tracking your key performance indicators is like programming a client without assessing them first - you are guessing. A KPI dashboard gives you a single place to see whether your business is healthy, growing, or quietly declining. This guide walks you through selecting the right metrics, connecting your data sources, and building a dashboard in Google Sheets or Looker Studio that you or your VA can update and monitor weekly.

Choosing the Right KPIs for Your Practice

Not every metric matters equally. Tracking too many numbers creates noise. For a rehab and prehab coaching practice, focus on these core KPIs:

New clients per month: The most fundamental growth metric. Track how many new clients start a paid program each month. Break this down by referral source - organic search, paid ads, physician referrals, word of mouth, social media - so you know which channels are actually producing.

Client retention rate: What percentage of clients who start a program complete it? And what percentage re-enroll or transition to a prehab or maintenance program? Rehab coaching naturally has an endpoint (the client recovers), so your retention metric needs context. Track both program completion rate and transition-to-prehab rate separately.

Revenue per client: Calculate the average total revenue per client across their entire engagement. If your average client pays $200 per session and completes 12 sessions, your revenue per client is $2,400. Track this monthly to spot trends - if it is dropping, clients may be leaving programs early.

Session utilization rate: What percentage of your available session slots are booked? If you have capacity for 30 sessions per week and 22 are booked, your utilization rate is 73%. This tells you whether you need more marketing (low utilization) or need to expand capacity (consistently above 85%).

Referral source breakdown: Where are your clients coming from? Track the percentage from each channel: Google Business Profile, paid ads, physician referrals, existing client referrals, social media, and direct/walk-in. This tells you where to invest more and where to stop spending.

Cancellation and no-show rate: Track the percentage of scheduled sessions that are cancelled or no-showed each week. A climbing cancellation rate can signal scheduling friction, pricing issues, or clients who are not seeing enough value to prioritize their sessions.

Cost per acquisition (CPA): Total marketing spend divided by new clients acquired. If you spent $1,200 on ads last month and gained 8 new clients, your CPA is $150. Compare this to your revenue per client to make sure you are profitable.

For a comprehensive view of what metrics a VA can track for you, check out the Fitness VA Tasks List.

Building Your Dashboard in Google Sheets

Google Sheets is the fastest way to get a KPI dashboard running. It requires no additional software costs, your VA can update it from anywhere, and you can share it with business partners or advisors easily.

Tab 1 - Weekly Input Sheet: This is where raw data gets entered each week. Create columns for:

• Week ending date
• New leads (by source)
• New clients started
• Total sessions completed
• Sessions cancelled
• Sessions no-showed
• Total revenue collected
• Ad spend (Google Ads, Meta Ads)
• Number of active clients

Tab 2 - Monthly Summary: Use formulas to aggregate weekly data into monthly totals. Calculate:

• New clients per month (SUM of weekly new clients)
• Retention rate (active clients this month / active clients last month)
• Revenue per client (monthly revenue / active clients)
• Session utilization (sessions completed / available session slots)
• CPA (total ad spend / new clients)
• Cancellation rate (cancelled sessions / total scheduled sessions)

Tab 3 - Dashboard View: Build a visual dashboard using Google Sheets charts. Create:

• A line chart showing new clients per month over the last 12 months
• A bar chart comparing revenue by month
• A pie chart breaking down referral sources
• A trend line for session utilization rate
• A scorecard row at the top with current month values for your five most important KPIs

Use conditional formatting to highlight KPIs that fall outside your target ranges. For example, turn the utilization rate cell red if it drops below 60% and green if it is above 80%.

Upgrading to Looker Studio

Once your practice grows or you want automated data connections, Looker Studio (formerly Google Data Studio) is the next step. It is free, connects directly to Google Sheets, and creates interactive dashboards that update automatically.

Setting up Looker Studio for your rehab practice:

1. Open Looker Studio and create a new report
2. Add Google Sheets as your data source - connect to the Weekly Input Sheet you already maintain
3. Build report pages that mirror your Google Sheets dashboard but with richer visualizations

Recommended Looker Studio layout:

• Page 1 - Executive Summary: Scorecards across the top showing current month KPIs. Below that, a 12-month trend chart for revenue and new clients. This is the page you glance at daily.
• Page 2 - Marketing Performance: Referral source breakdown, CPA by channel, ad spend vs. new clients correlation, and lead-to-client conversion rate. This page tells you whether your marketing dollars are working.
• Page 3 - Operations: Session utilization heat map by day of week (shows which days are underbooked), cancellation trends, no-show rates, and client retention cohort analysis.

Connecting additional data sources: Looker Studio can pull directly from Google Ads and Google Analytics, eliminating manual data entry for those metrics. For payment processor data (Stripe, Square) and scheduling tools (Acuity, Calendly, Jane App), you typically need to export data to Google Sheets and connect Sheets as an intermediary.

If you use GoHighLevel as your CRM, export pipeline data weekly or use a Zapier integration to push new contact and deal data into a Google Sheet that feeds your dashboard.

Setting Alert Thresholds

A dashboard is only useful if someone is watching it. Set clear thresholds that trigger action:

• New clients per month drops below your target: If your target is 8 new clients per month and you are tracking at 4 by mid-month, that is an alert. Increase ad spend, push referral outreach, or run a limited-time offer.
• Utilization rate drops below 65%: You have too many open slots. Either your marketing is underperforming or you have availability that clients cannot easily access (bad scheduling hours, for example).
• Cancellation rate exceeds 15%: Something is off. Survey recent cancellers, review your reminder sequence, and check if a scheduling change coincided with the spike.
• CPA exceeds revenue per client divided by 3: A rough rule - if it costs more than one-third of the client's value to acquire them, your marketing efficiency needs attention.
• Retention rate drops below 70%: Clients are leaving before completing their programs. Review your programming, communication cadence, and progress tracking.

Your VA should check the dashboard every Monday and flag any metric that has crossed a threshold. This turns the dashboard from a passive report into an active management tool.

Weekly Versus Monthly Dashboard Reviews

Not all KPIs need weekly attention. Structure your reviews like this:

Weekly review (10 minutes):

• Sessions completed vs. scheduled
• Cancellation and no-show count
• New leads received
• Revenue collected
• Any threshold alerts

Monthly review (30-45 minutes):

• Full KPI comparison to previous month and same month last year
• Referral source analysis - which channels are trending up or down
• Client retention cohort review - are clients from three months ago still active?
• CPA by channel - where should next month's budget go?
• Session utilization by day and time - should you adjust your schedule?

The weekly review keeps you from being surprised. The monthly review drives strategic decisions. Both are essential, and a trained VA can prepare the data and preliminary analysis for each one. For hiring details, see How to Hire a Fitness Virtual Assistant.

Frequently Asked Questions

Do I need Looker Studio or is Google Sheets enough?

Google Sheets is enough for most solo rehab and prehab coaches. It is simple, flexible, and requires no learning curve beyond basic formulas. Move to Looker Studio when you want automated data connections (especially from Google Ads), interactive filtering, or you need to share a polished read-only dashboard with a business partner or investor.

How often should I update my KPI dashboard?

Enter data weekly at minimum. Revenue and session data should be updated every Monday for the previous week. Monthly summary calculations should be reviewed on the first business day of each month. If your VA handles the data entry, all you need to do is review the finished dashboard.

What is a good session utilization rate for a rehab coach?

Aim for 75-85% utilization of your available slots. Below 70% means you have significant unused capacity and need more marketing or scheduling optimization. Above 90% consistently means you are at risk of burnout and should consider raising prices, hiring a second coach, or expanding hours strategically.

How do I track referral sources accurately?

Ask every new client "How did you find us?" during intake and log it in your CRM or intake form. For online leads, use UTM parameters on your ads and landing page links so Google Analytics can attribute each lead to a specific source. Cross-reference both data points for accuracy - sometimes a client says "Google" but actually clicked a Facebook ad that appeared in a Google search.

Can a virtual assistant build and maintain my KPI dashboard?

Yes. A VA with experience in Google Sheets and Looker Studio can build your initial dashboard, set up the formulas and data connections, enter weekly data, and prepare your review reports. You define the KPIs and thresholds - they handle the operational side.