Studio Attendance Reports: The Weekly View That Spots Schedule Problems Before Members Notice

Weekly class-level attendance reports surface instructor performance problems and schedule mismatches 4–6 weeks before they appear in membership cancellation data. By the time members cancel over a bad class or underperforming time slot, the problem has been running for months and affecting revenue that can't be recovered. Weekly reporting catches it while there's still time to act.

Why Weekly Attendance Reviews Beat Monthly Reporting

Monthly reporting feels sufficient — it's a full data set, not a sample. But it hides trend breaks that happen mid-month.

A class that was running at 70% fill in week one drops to 55% in week two, then 40% in week three. Monthly, you see a 55% average and nothing unusual. Weekly, you see the drop at week two and investigate before week three.

The cause might be: a schedule conflict with a competing event, a popular instructor on vacation with a sub who doesn't draw the same crowd, a class time that worked in summer but conflicts with school dropoff in fall, or a programming change that reduced perceived value. None of these require monthly data to catch — they're visible in week two's attendance number if you're looking.

What Should a Class-Level Attendance Report Show?

The class-level report is the most important view for schedule optimization. It shows fill rate per class slot per week with enough context to drive decisions.

Essential fields:

• Class name and time slot
• Scheduled capacity
• Booked count
• Show-up count (actual attendees vs booked)
• Fill rate (booked / capacity)
• Show rate (shown / booked)
• 4-week rolling fill rate (to distinguish a one-week blip from a trend)
• 4-week fill rate change (vs prior 4-week average)

Alert triggers built into the view:

• Classes with rolling 4-week fill rate below 40%: flag red
• Classes with fill rate drop >15 points from prior 4-week average: flag yellow
• Classes with fill rate above 90%: flag for capacity review (good problem to have)

Review this report every Monday for the prior week's data. Flag anomalies and assign investigation owners before the week begins.

What Should an Instructor-Level Attendance Report Show?

The instructor-level report rolls up class-level data to show each instructor's average fill rate across their schedule — and how it trends over time.

Essential fields:

• Instructor name
• Classes taught this week
• Total bookings across all classes
• Average fill rate across all classes
• 4-week rolling average fill rate
• Top-performing class (by fill rate)
• Lowest-performing class (by fill rate)
• Student count change (vs prior period)

This report serves two purposes: performance visibility for management decisions and coaching inputs for the instructor.

For management: an instructor whose rolling average fill rate drops from 72% to 55% over three weeks needs a conversation. The drop might be legitimate (a new format rollout, a temporary community disruption) or a signal of a coaching quality or community issue. Either way, you catch it at three weeks, not at six.

For instructors: share their own fill rate data as a tool for self-improvement. Instructors who see their own trends are more likely to promote their classes, engage their regulars between sessions, and address attendance directly — without being told to.

What Should a Member-Level Attendance Report Show?

The member-level report is the input to your at-risk detection workflow. It surfaces attendance drops at the individual member level before they result in cancellation.

Essential fields:

• Member name
• Visit count this week
• Visit count last week
• Rolling 4-week average visits per week
• Visit count change vs 4-week average (%)
• Last visit date
• Days since last visit
• At-risk flag (Y/N based on your trigger rule)

The at-risk flag is the action trigger. Any member flagged at-risk should receive a personal outreach within 48 hours. See the at-risk member detection guide for the specific intervention framework.

Review this report weekly — not monthly. The 4–6 week intervention window from the primary at-risk signal to cancellation means monthly review discovers the problem after the intervention window has closed.

How Do You Build These Reports?

Most studio management software has built-in reporting that covers the class-level and member-level views described here. The question is whether the default reports are configured correctly and whether you have a weekly review habit.

Steps to implement:

1. Identify the attendance report in your software (usually under "Reports" → "Attendance" or "Classes")
2. Configure the date range to show the prior 7 days plus a rolling average
3. Set up a recurring calendar reminder every Monday morning to review the report
4. Create a simple spreadsheet or note where you track the flagged classes and members each week and the actions taken

The report itself is trivial to generate in any modern booking platform. The review discipline is the actual work.

For the analytics infrastructure, see the studio analytics dashboards guide and the studio KPIs dashboard guide. For instructor performance management beyond attendance, see instructor performance metrics and the class utilization rate guide.