Multi-Location Studio Reporting: The Dashboard That Reveals Which Location Is Underperforming

Studios reviewing aggregate multi-location revenue miss site-level problems until they're severe. Location-level KPI dashboards surface issues 6–8 weeks earlier than aggregate reporting (Zatrovo benchmark, 2026). By the time a problem shows up in total revenue, it's been developing at the location level for two months. The reporting structure you build determines how much time you have to respond.

Why Aggregate Revenue Reporting Fails Multi-Location Operators

Aggregate reporting tells you that revenue is up or down. It doesn't tell you which location is driving the change or why.

A three-location studio with total monthly revenue of $85,000 looks healthy. But if Location 1 is generating $48,000, Location 2 is generating $30,000, and Location 3 has dropped from $18,000 to $7,000 over three months — the aggregate $85,000 is masking a crisis at Location 3.

By the time Location 3's problem becomes visible in total revenue (when the decline can no longer be offset by the other locations), you've lost potentially $33,000 in revenue and likely 3–4 months of recovery time.

What Are the Five KPIs to Track Per Location?

The Location KPI Stack — five metrics that, taken together, give you a complete operational picture of each site.

1. Revenue per available class slot (RevPACS). Total location revenue divided by total available class slots. This normalizes revenue for schedule size differences between locations. A location with 20 classes per week looks different from one with 35 — RevPACS puts them on the same scale.

2. Membership revenue percentage. Membership revenue as a share of total location revenue. The higher this number, the more predictable the location's cash flow. Below 40% at a location that's been open more than 18 months is a flag.

3. Class utilization rate. Average attendance as a percentage of class capacity. Location-level utilization tells you whether the problem is fill rates (demand) or pricing (revenue per filled seat).

4. Staff retention and instructor fill rates. Instructor turnover is the fastest way to destroy location performance — regular clients follow instructors when they leave. Track instructor tenure per location and class fill rates by instructor.

5. New member 30-day retention. What percentage of new members at each location attend at least 4 times in their first 30 days? Below 55% at any location means the onboarding experience is failing there specifically.

How Do You Build the Cross-Location Comparison Dashboard?

The dashboard structure that works: location-level rows, KPI columns, trend indicators.

Each row is a location. Each column is a KPI. Color coding (green/yellow/red) makes outliers visible in under 10 seconds. A trend indicator (arrow up/down vs prior month) shows direction without requiring comparison of numbers.

The dashboard is reviewed weekly at a 15-minute level (scan for red indicators, investigate if found) and monthly at a 45-minute level (trend analysis, comparison to targets, decision on any locations requiring intervention).

The weekly scan is the value add. Most studio groups review location performance monthly or quarterly — by which point, issues are already compounded. A weekly scan takes 15 minutes and catches revenue divergence 3–4 weeks earlier.

How Do You Use the Dashboard to Diagnose a Struggling Location?

When a location shows red on two or more KPIs, run the diagnostic sequence:

Step 1: Isolate the revenue driver. Is total revenue down because utilization is down, or because RevPACS is down? Lower utilization means fewer clients or worse fill rates. Lower RevPACS means the same clients are spending less per visit — likely a pricing or pack mix problem.

Step 2: Compare by time slot. A location with declining overall utilization often has a specific problem: weekday mornings dropped 20% but evenings are fine. That's an instructor or schedule problem in a specific window, not a location-wide issue.

Step 3: Check new member flow. If new member volume is stable but 30-day retention dropped, the onboarding experience changed — new instructor, schedule disruption, or service quality issue. If both volume and retention dropped, the acquisition funnel is broken.

Step 4: Benchmark against peer locations. What is the equivalent time slot doing at your highest-performing location? A Tuesday 6pm class with 35% fill rate at Location 3 vs 78% fill rate at Location 1 is telling you something about the specific instructor, the neighborhood, or the marketing reach of that location.

What Software Options Support Multi-Location Reporting?

The options differ on integration depth and reporting flexibility.

Purpose-built studio platforms with multi-location support (Zatrovo, Mindbody, Mariana Tek) give you the cleanest reporting because all location data flows through the same engine. Location-level filtering is native. The trade-off is that migrating all locations to one platform takes operational effort.

Business intelligence tools (Looker Studio, Power BI, Tableau) work when locations run different platforms. They pull data via export or API, normalize it, and let you build custom dashboards. More flexible, more setup required.

For the full multi-location playbook including pricing and operational standards, see our multi-location studio playbook and studio analytics dashboards guide.