Dance Studio KPI Dashboard Setup: A VA's Complete Guide

A dance studio KPI dashboard setup gives studio owners instant clarity on what is working and what is not. Without one, decisions rely on gut feeling. With one, you see exactly which styles fill fastest, which age groups churn, and where revenue leaks hide. This SOP walks your VA through building a dashboard that tracks every metric that matters.

Choosing the Right Dashboard Platform

Your VA needs a tool that balances power with simplicity. Studio owners are not data analysts. They need clean visuals they can check in under 5 minutes.

Recommended platforms:

• Google Looker Studio (free): Best for studios already using Google Sheets as their data source. Connects directly to Sheets, Google Analytics, and Google Ads. Strong visualization options. Zero cost.
• Databox (free tier available): Good for pulling data from multiple sources (Stripe, GoHighLevel, Google Analytics) into one view. Mobile app for on-the-go checks.
• Notion + Notion Charts: If the studio already runs operations in Notion, keep reporting there. Limited visualization but reduces tool sprawl.
• Google Sheets with conditional formatting: The simplest option. No integrations to break. Your VA updates it manually weekly. Works for studios under 200 students.

For most single-location studios, Google Looker Studio connected to a master Google Sheet delivers the best balance of power and maintenance effort. Your VA updates the Sheet weekly and the dashboard refreshes automatically.

Core KPIs Every Dance Studio Must Track

Enrollment Metrics

Active students by style:

Track total active (currently enrolled and attending) students broken down by style. This reveals which programs grow, plateau, or decline.

• Ballet: [count]
• Hip hop: [count]
• Contemporary: [count]
• Tap: [count]
• Jazz: [count]
• Lyrical: [count]
• Creative movement/toddler: [count]
• Adult programs: [count]

Update weekly. Display as a bar chart with month-over-month comparison.

Active students by age group:

• Ages 2-4 (pre-dance)
• Ages 5-7 (beginner)
• Ages 8-12 (intermediate)
• Ages 13-17 (teen/advanced)
• Ages 18+ (adult)

This identifies demographic gaps. If your teen numbers are declining while your toddler numbers grow, you have a retention problem at the transition age. Address it before the pipeline dries up.

New enrollments per month:

Track gross new students added each month. Break down by:

• Source (ads, organic search, referral, walk-in, social media)
• Style enrolled
• Age group

This tells you which acquisition channels work. If 60% of new students come from referrals but you spend 80% of marketing budget on ads, reallocate.

Retention Metrics

Monthly retention rate:

Formula: (Students at end of month - new students added) / students at start of month x 100

Target: 92-96% monthly retention for semester-committed students. Below 90% signals a problem.

Semester-over-semester retention:

What percentage of fall students re-enroll for spring? What percentage of spring students return for fall?

• Fall to spring target: 80-85%
• Spring to fall target: 70-75% (natural summer drop expected)
• Year-over-year target: 65-70%

Churn reasons:

When students leave, record why. Categories:

• Schedule conflict
• Financial (tuition cost)
• Lost interest / child quit
• Moved away
• Instructor dissatisfaction
• Competitive team conflict
• Graduated / aged out

Report the top three churn reasons monthly. If "schedule conflict" dominates, the studio may need to add class times. If "lost interest" leads, the programming needs attention.

Revenue Metrics

Revenue per student (monthly):

Formula: Total monthly tuition revenue / active students

Track this over time. If revenue per student declines, it means you are adding lower-tier (fewer classes per week) students or discounting too heavily.

Revenue by style:

Which styles generate the most revenue? Factor in:

• Tuition per class
• Average classes per student per week
• Costume and recital fees
• Competition fees
• Private lesson revenue

A style with fewer students but higher revenue per student (like competitive contemporary) may deserve more studio time than a popular but low-revenue toddler program.

Revenue per square foot per hour:

Formula: Class revenue / (studio square footage x class hours used)

This reveals which time slots and rooms are most profitable. A Saturday morning hip hop class with 25 students in a small studio generates more per square foot than a Tuesday evening adult ballet with 6 students in the large studio.

Class Fill Rate Metrics

Fill rate by class:

Formula: Enrolled students / class capacity x 100

Display as a heat map. Green (80-100%), yellow (50-79%), red (below 50%).

Classes consistently below 50% fill rate for two months need action: change the time slot, merge with another section, or invest in targeted promotion.

Waitlist tracking:

Track classes at 100% capacity with a waitlist. This signals demand for additional sections. If your Tuesday 4:30 PM ballet class has 8 students on the waitlist, open a Thursday 4:30 PM section.

Recital and Competition Metrics

Recital participation rate:

Formula: Students performing in recital / total active students x 100

Target: 85-95%. Students who do not participate in recital are 3x more likely to drop out the following semester. Flag non-participants for instructor outreach.

Competition results tracking:

For competitive teams, track:

• Events attended
• Placements by routine (first, second, third, high gold, gold, etc.)
• Overall studio ranking at each event
• Scores by category (technique, choreography, showmanship)

Display trends over the season. Are scores improving? Which categories need choreographic attention?

Costume and fee collection rate:

Formula: Fees collected on time / total fees invoiced x 100

Target: 95%+ collected within 30 days of invoice. Below 90% means your billing process or payment reminders need fixing.

Building the Dashboard - Step by Step

Step 1: Create the Master Data Sheet

Your VA builds a Google Sheet with these tabs:

• Student Roster: Student name, parent name, age, styles enrolled, start date, status (active/inactive/paused), source
• Monthly Enrollment: Date, new students, churned students, net change, by style
• Revenue: Month, tuition revenue, costume revenue, competition revenue, private lesson revenue, misc revenue
• Class Schedule: Class name, style, instructor, day/time, capacity, enrolled count
• Retention Log: Student name, drop date, reason, notes
• Competition Results: Event, date, routine, category, placement, score

Step 2: Connect Data Sources

Pull data weekly from:

• Studio management software (Jackrabbit Dance, DanceStudio-Pro, or ClassJuggler)
• Payment processor (Stripe, Square, or studio software billing)
• GoHighLevel CRM (lead and enrollment pipeline data)
• Google Analytics (website traffic to trial pages)
• Ad platforms (spend and lead data)

Your VA exports reports every Monday morning and pastes clean data into the master sheet. Automate with Zapier or Make.com where possible.

Step 3: Build Looker Studio Visualizations

Create these dashboard pages:

Page 1 - Executive Summary:

• Total active students (big number)
• Monthly revenue (big number)
• Retention rate (gauge chart)
• New enrollments this month (big number with trend arrow)
• Top 3 fill rate concerns (table)

Page 2 - Enrollment Detail:

• Students by style (bar chart)
• Students by age group (pie chart)
• New enrollment trend (line chart, 12 months)
• Source attribution (pie chart)

Page 3 - Financial:

• Revenue trend (line chart, 12 months)
• Revenue per student (line chart)
• Revenue by style (stacked bar)
• Outstanding fees (table)

Page 4 - Class Operations:

• Fill rate heat map (all classes)
• Waitlisted classes (table)
• Instructor utilization (hours taught / available hours)

Page 5 - Retention and Churn:

• Monthly retention rate (line chart)
• Churn reasons (pie chart)
• At-risk students (table - flagged by attendance drops)

Step 4: Set Up Automated Alerts

Configure email or Slack alerts when:

• Any class fill rate drops below 50% for two consecutive weeks
• Monthly retention drops below 90%
• Revenue per student declines more than 10% month-over-month
• A competitive team has fewer than minimum students enrolled

Your VA monitors alerts daily and escalates to the studio owner with context and recommended action.

Weekly Dashboard Maintenance Checklist

Your VA completes these tasks every Monday:

• Export data from studio management software
• Update master Google Sheet with current week's numbers
• Verify all Looker Studio charts display correctly (no broken data connections)
• Flag any KPIs outside target range
• Write 3-5 sentence weekly summary for studio owner
• Identify one optimization opportunity based on data trends
• Archive previous week's raw data exports

Feed your dashboard data into a weekly reporting cadence and use the retention numbers to inform your client retention sequence. HBR research shows a 5% retention lift boosts profits 25-95%, making retention rate the single most valuable KPI your dashboard tracks.

Frequently Asked Questions

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

Expect 15-20 hours for initial setup: data source audit, master sheet creation, Looker Studio configuration, and documentation. After that, weekly maintenance takes 2-3 hours. The first dashboard iteration should be live within two weeks of starting.

What if our studio management software does not integrate with Google Sheets?

Most studio software allows CSV exports. Your VA downloads reports weekly and pastes data into the master sheet. For studios processing over 300 students, invest in a Zapier or Make.com automation to reduce manual work. Budget $30-50 per month for integration tools.

Which KPI matters most for a dance studio owner?

Retention rate. A 5% improvement in monthly retention compounds dramatically over a year. A studio retaining 95% monthly keeps 54% of students year-over-year. A studio retaining 90% monthly keeps only 28%. Retention is the single metric most correlated with long-term revenue growth.

Should the dashboard track individual instructor performance?

Yes, but handle it carefully. Track class fill rates and retention by instructor without making it punitive. Use the data to identify which instructors drive enrollment and which classes need support. Share instructor-level data only with the studio owner, not publicly.

How often should the studio owner review the dashboard?

Weekly for the executive summary page. Monthly for detailed breakdowns. Quarterly for strategic planning sessions where you compare current KPIs against annual goals and adjust programming, pricing, or marketing accordingly.