Pilates Studio KPI Dashboard Setup: VA SOP
A Pilates studio owner who does not see their numbers weekly is flying blind. They might feel like business is "good" or "slow," but feelings do not reveal that churn spiked 4% last month or that Tuesday evening classes run at 35% capacity. This SOP walks your VA through building a KPI dashboard, connecting data sources, and maintaining it weekly.
For help connecting your dashboard data to upstream marketing, see ad campaign management. McKinsey reports 60% of occupations could automate 30%+ of activities.
Step 1: Choose the Right KPIs and Data Sources
Track the metrics that connect directly to revenue, retention, and operational efficiency. Ten to twelve KPIs is the maximum before the dashboard becomes noise.
Revenue and growth: New leads (weekly/monthly) from GoHighLevel or your CRM. Trial conversions from MindBody or Vagaro attendance reports. Trial-to-member conversion rate calculated from your CRM pipeline. Monthly recurring revenue from MindBody, Vagaro, or Stripe. Revenue per member (MRR divided by active members).
Retention: Active member count at month end from MindBody or Vagaro. Churn rate, calculated as members lost divided by members at start of month, times 100. Target under 5% monthly. Average member lifespan in months.
Operations: Class utilization rate (average percentage of spots filled) from MindBody or Vagaro. Target 70-85%. Below 70% means too many classes or not enough demand. Above 85% means you may need to add sessions. Instructor hours from staff schedule reports.
Marketing: Cost per lead by channel from Meta Ads Manager and Google Ads. Website traffic from Google Analytics. Google Business Profile interactions from GBP Insights.
Before building anything, confirm your VA has login credentials or API access to every source tool. Store credentials in the studio's password manager.
Step 2: Pick a Dashboard Tool and Build It
Three options fit most studios. Google Sheets (free, manual refresh) works for tight budgets. Looker Studio (free, semi-automated) connects to Google Analytics, Google Ads, and Google Sheets, delivering a visual, shareable dashboard. Databox (paid, starts around $47/month) connects to 70+ sources including MindBody and automates data refresh entirely.
For most single-location studios, Looker Studio with a Google Sheets data layer is the best balance of cost and functionality.
Build process with Looker Studio:
Create a Google Sheet called "[Studio Name] KPI Data" with three tabs. The Weekly Data tab tracks: week ending date, new leads, trial bookings, trial attendance, new members, cancellations, active members, MRR, classes held, total spots available, total spots filled, ad spend by platform, and website sessions. The Monthly Summary tab aggregates these plus churn rate, revenue per member, and GBP metrics. The Instructor Hours tab tracks weekly teaching hours per instructor.
In Looker Studio, connect the Google Sheet as a data source. Build scorecard widgets across the top row showing Active Members, MRR, Churn Rate, and New Leads with comparison to the previous period. Add trend line charts for MRR and lead/member counts over 12 months. Include a class utilization bar chart by day of week. Add a marketing performance table with channel, leads, spend, and CPL. Finish with a churn rate line chart with a 5% target line.
Add a date range filter so the owner can toggle between weekly, monthly, and quarterly views. Share via link with view-only permissions.
Step 3: Automate Data Pulls and Apply Traffic-Light Formatting
Automate where possible. Google Analytics and Google Ads connect directly to Looker Studio. For Meta Ads, use Supermetrics ($19/month) or export CSV weekly. For MindBody and Vagaro, your VA pulls reports manually each Monday and enters data into the Google Sheet.
Apply traffic-light formatting so the owner can scan results in 30 seconds:
| KPI | Green | Yellow | Red |
|---|---|---|---|
| Churn rate | Below 3% | 3-5% | Above 5% |
| Class utilization | 70-85% | 60-70% or 85-95% | Below 60% or above 95% |
| Trial-to-member rate | Above 40% | 30-40% | Below 30% |
| Cost per lead | Below $12 | $12-$20 | Above $20 |
| MRR | Growing | Flat | Declining |
Set thresholds with the studio owner during initial setup. Review and adjust them quarterly as the business evolves.
Step 4: Weekly Refresh Cadence
Set a recurring calendar event every Monday morning. The refresh takes about 1 hour:
- Log into MindBody/Vagaro. Export class attendance, memberships, cancellations, and revenue for the previous week. (15 minutes)
- Log into Meta Ads Manager and Google Ads. Record spend and leads. (10 minutes)
- Log into GoHighLevel. Record new leads and pipeline movement. (10 minutes)
- Check Google Analytics sessions. (5 minutes)
- Enter all data into the Google Sheet. Verify formulas calculate correctly. (10 minutes)
- Open Looker Studio. Confirm visualizations render and spot-check 2-3 numbers against source data. (5 minutes)
- Send the owner a brief summary: "Dashboard updated for week ending [date]. Key highlights: [2-3 bullets]." (5 minutes)
Document the entire process step by step so a backup person can run the refresh if your VA is unavailable.
Plug the same data into your weekly reporting cadence so trends stay visible.
FAQ
How long does it take to build the initial KPI dashboard?
Plan for 4-6 hours of setup: creating the data layer, connecting sources, building visualizations, and populating the first week. With Databox and automated connectors, setup drops to 2-3 hours. Weekly maintenance takes about 1 hour after that.
What if we do not have historical data?
Start from the current week and build forward. The dashboard becomes more valuable as you accumulate trend data. If MindBody or Vagaro has historical reports available, your VA can backfill up to 12 months during initial setup.
Should the dashboard be shared with the whole team?
Share different views with different audiences. The owner sees the full dashboard with financial metrics. Instructors see class utilization and attendance for their classes. Front desk staff see leads, trial bookings, and conversion metrics. Looker Studio supports filtered views and separate pages within the same report.
What is the most important KPI for a Pilates studio?
Churn rate. A studio can survive slow lead flow if retention is strong. It cannot survive high churn even with excellent marketing. If members stay an average of 12 months vs. 6 months, you double the lifetime value of every client acquired.
Can I use this dashboard for multiple locations?
Yes. Create a separate data tab for each location. In Looker Studio, add a location filter. With Databox, the multi-source dashboard feature handles this natively. The weekly refresh takes roughly 30 additional minutes per location.