Barre Studio KPI Dashboard Setup: A Complete SOP for Your VA

A barre studio KPI dashboard setup gives you instant visibility into the numbers that determine whether your studio thrives or stalls. Without a centralized dashboard, you're guessing - checking Mindbody here, your bank account there, a spreadsheet somewhere else. Your virtual assistant can build and maintain a single source of truth.

This SOP walks your VA through selecting the right metrics, structuring the data sources, and building dashboards in Google Sheets or Looker Studio. Feed dashboard data into your weekly reporting cadence and the quarterly business review pack. McKinsey reports 60% of occupations could automate 30%+ of activities.

Selecting the Right Metrics for Barre Studios

Not every number matters. Your VA should build the dashboard around metrics that directly connect to revenue, retention, and growth.

Attendance Rate

Formula: (Total check-ins / Total spots available) x 100

This tells you how full your classes are. Track it by:

• Individual class (is Tuesday 6pm Barre Sculpt consistently full while Thursday 9am is empty?)
• Instructor (does one instructor fill classes while another struggles?)
• Day of week and time slot
• Class type (classic barre vs. sculpt vs. cardio)

Target: 70-80% average fill rate across all classes. Below 60% signals scheduling problems. Above 85% means you likely need to add classes.

Revenue Per Class

Formula: Total class revenue / Number of classes held

This combines attendance and pricing into one actionable number. It reveals which class slots generate the most revenue and which drain resources. Include all revenue sources: membership allocations, class pack punch cards, and drop-in payments.

Your VA should calculate this weekly and flag any class consistently generating less than your break-even threshold (instructor pay + facility cost allocation for that hour).

Trial Conversion Rate

Formula: (New members from trial / Total trial packages sold) x 100

This is your growth engine metric. Track it monthly with a 60-day lookback (since some trials take time to complete and convert). Segment by:

• Intro offer type (3-class vs. 2-week unlimited vs. first class free)
• Source (Meta ads, Google ads, referral, walk-in, corporate)
• Instructor who taught their first class

Member Retention Rate

Formula: (Members at end of period - New members during period) / Members at start of period x 100

Monthly retention should sit at 92-96% for a healthy barre studio. That means losing 4-8% of members monthly, which compounds to 40-60% annual churn. Track by:

• Membership type (unlimited vs. limited vs. class pack)
• Tenure cohort (first 90 days vs. 3-6 months vs. 6-12 months vs. 12+ months)
• Cancellation reason (coded from exit surveys or cancellation forms)

Lifetime Value (LTV)

Formula: Average monthly revenue per member x Average member lifespan in months

LTV tells you how much you can afford to spend acquiring a new member. If your average member pays $150/month and stays 14 months, LTV is $2,100. You can justify spending $200-400 to acquire them profitably.

Your VA calculates LTV quarterly and segments by acquisition source and membership tier.

Secondary Metrics Worth Tracking

• Revenue per square foot per hour
• Retail revenue (if you sell grip socks, water, apparel)
• Referral rate (percentage of new members from existing member referrals)
• No-show rate (booked but didn't attend)
• Late cancel rate

Google Sheets Dashboard Build

For studios that want a simple, free, collaborative solution, Google Sheets works well as a starting point.

Spreadsheet Architecture

Your VA should structure the workbook with these tabs:

1. Data Import - Raw data pulled from Mindbody/Momence/booking system (weekly export)
2. Calculations - Formulas that process raw data into KPIs
3. Dashboard - Visual summary with charts and current-period numbers
4. Historical - Monthly KPI snapshots for trend analysis
5. Benchmarks - Target values for each metric

Setting Up Data Imports

Your VA pulls data from your booking system weekly. Most platforms offer CSV exports or API connections. For manual workflows:

• Export class attendance reports every Monday covering the prior week
• Export financial reports (revenue by source) on the 1st and 15th
• Export member list with join dates, plan types, and status monthly
• Export cancellation reports with reasons weekly

If your booking platform integrates with Google Sheets via Zapier or native connection, your VA sets up automated data feeds that eliminate manual exports.

Building the Dashboard Tab

Your VA creates a clean dashboard tab showing:

• Header row: Studio name, reporting period, last updated date
• Summary cards: Current month's key numbers in large font (total revenue, active members, average attendance rate, trial conversion rate)
• Trend charts: Line charts showing the past 12 weeks for attendance, revenue, and new members
• Class performance table: Sortable table showing each class slot with fill rate, revenue, and trend indicator (up/down arrow)
• Alerts section: Red/yellow/green indicators for metrics outside acceptable ranges

Formulas Your VA Needs

Key Google Sheets formulas for barre studio dashboards:

• QUERY function to filter and aggregate attendance data
• VLOOKUP or INDEX/MATCH to pull member details
• SPARKLINE for inline trend visualization
• Conditional formatting for red/yellow/green status indicators
• IMPORTRANGE if data lives across multiple sheets

Looker Studio Dashboard Build

For studios ready for a more polished, auto-refreshing dashboard, Looker Studio (formerly Google Data Studio) delivers professional visualization.

Data Source Connections

Your VA connects these sources to Looker Studio:

• Google Sheets (for booking system data your VA maintains)
• Google Analytics (for website traffic and funnel data)
• Google Ads (for ad performance metrics)
• Facebook Ads (via connector like Supermetrics or manual Google Sheets import)

Dashboard Layout

Build a single-page dashboard with these sections:

Top section - Scorecards: Four to six large number cards showing current period KPIs with comparison to prior period. Include: total revenue, active members, average class fill rate, trial conversion rate, new member count, and retention rate.

Middle section - Time series: Two to three line charts showing trends over 12 weeks. Revenue and attendance on one chart (dual axis). New members and cancellations on another.

Bottom section - Detail tables:

• Class performance table (sortable by fill rate or revenue)
• Instructor performance comparison
• Source attribution (where new members came from)

Filters and Date Controls

Your VA adds interactive controls:

• Date range selector (default to current month, expandable to quarter or year)
• Class type filter (show all or filter to specific format)
• Instructor filter
• Location filter (for multi-studio operations)

Refresh Schedule

Configure data sources to refresh daily. Your VA verifies each Monday that fresh data is flowing correctly. If a connection breaks, troubleshoot immediately - stale data defeats the purpose.

Maintenance and Data Quality

A dashboard is only as good as the data feeding it. Your VA owns data quality.

Weekly Data Audit

Every Monday, your VA:

• Verifies data imports completed successfully
• Spot-checks 3-5 data points against the source system
• Identifies and corrects any anomalies (duplicate entries, missing classes, incorrect revenue coding)
• Updates the "last verified" date on the dashboard

Monthly Calibration

First week of each month, your VA:

• Reconciles dashboard revenue against accounting records
• Updates benchmark targets if the business plan changes
• Archives the previous month's snapshot for historical comparison
• Reviews whether current metrics still align with business priorities

Quarterly Review

Each quarter, your VA evaluates whether the dashboard needs evolution:

• Are there metrics we track that nobody uses? Remove them.
• Are there questions the owner keeps asking that the dashboard doesn't answer? Add them.
• Has the business model changed (new membership tiers, new locations, new class types)?
• Do targets need resetting based on recent performance?

When hiring a VA with analytics skills, prioritize candidates experienced with Google Sheets functions, data visualization tools, and fitness industry booking platforms.

Frequently Asked Questions

How long does it take a VA to build a barre studio KPI dashboard from scratch?

A functional Google Sheets dashboard takes 8-12 hours to build from scratch, including data architecture, formulas, and visualization. A Looker Studio version takes 12-20 hours. After initial setup, weekly maintenance requires 1-2 hours.

What data do I need to export from my booking system?

At minimum: class attendance by date/time/instructor, member roster with join dates and plan types, revenue by source (memberships, packs, drop-ins, retail), cancellation records with dates, and intro offer purchase/redemption data.

Should I use Google Sheets or Looker Studio?

Start with Google Sheets if you want simplicity, full formula control, and zero cost. Move to Looker Studio once your data volume grows and you want auto-refreshing visuals, interactive filters, and shareable links that don't expose raw data.

What's the most important KPI for a barre studio to track daily?

Class fill rate - checked daily by time slot. It's the earliest signal of problems (marketing not working, schedule misalignment, instructor issues) and opportunities (classes consistently full indicate demand for additional time slots).

How do I set realistic targets for my KPIs?

Use your own 90-day historical average as baseline, then set targets 10-15% above that. Industry benchmarks help for context (70-80% fill rate, 35% trial conversion, 93% monthly retention), but your specific market and price point determine what's achievable.