Pilates Studio Weekly Reporting Cadence: VA SOP

A Pilates studio owner does not need a 12-page analytics dump every Monday. They need a single, scannable report that answers three questions: Are we growing? Where are we leaking money or clients? What needs my attention this week?

This SOP walks you through building and delivering that report on a strict weekly cadence. If you follow it, the owner spends five minutes reading instead of two hours digging through MindBody dashboards.

Pull headline numbers from your KPI dashboard so weekly reports stay consistent.

Set Your Report Delivery Window

Lock in the delivery time: Monday by 10:00 AM in the studio's local time zone. No exceptions. The owner should be able to open their inbox Monday morning and find the report waiting.

Block 60 to 90 minutes on your Friday afternoon calendar to pull data and draft the report. If Friday is a holiday or you are off, shift the prep window to Thursday. The delivery date stays Monday regardless.

Create a recurring Google Calendar event titled "Weekly Studio Report - Data Pull" for yourself. Add a second event on Monday at 9:30 AM titled "Weekly Studio Report - Final Review and Send." These two anchors keep the cadence tight even during busy weeks.

Collect Data From All Sources

You are pulling from three core systems. Open each one and record the numbers in a pre-built Google Sheets template.

MindBody or Vagaro (booking and membership data):

1. Log in to the studio's MindBody or Vagaro account.
2. Navigate to the reporting section. Pull the following for the Monday-through-Sunday period just ended:
   • New leads added (name, source, date)
   • Trial/intro class bookings
   • Trial-to-membership conversions (how many trial clients purchased a membership)
   • Total active memberships (beginning of week vs. end of week)
   • Cancellations and pauses (churn)
   • Class utilization rate per class type (attendees divided by max capacity)
   • No-shows and late cancels
3. Paste these numbers into the corresponding rows in your Google Sheets template.

QuickBooks (financial data):

1. Open QuickBooks Online.
2. Pull the Profit & Loss report filtered to the prior week.
3. Record total revenue, broken out by membership revenue, drop-in revenue, retail sales, and private session revenue.
4. Note any outstanding invoices or failed payment attempts flagged in the transactions list.

Google Analytics (website and marketing data):

1. Open Google Analytics for the studio's website.
2. Set the date range to the prior week.
3. Record total sessions, new users, top traffic sources, and conversion events (form submissions, class bookings via the website).
4. If the studio runs Google Ads or Meta Ads, pull spend and cost-per-lead from those platforms as well.

Copy every number into the Google Sheets template before you start writing the report. Raw data in the spreadsheet, polished summary in the report doc.

Build the One-Page Report

Open the Google Doc template titled "[Studio Name] Weekly Report - Template." Duplicate it and rename the copy with the week-ending date, for example "Weekly Report - Week Ending May 11, 2026."

The report has seven sections. Keep each section to two or three sentences plus the key number.

1. New Leads State the number of new leads captured this week, the top source (e.g., Google Ads, Instagram, referral), and how it compares to the prior week. Example: "14 new leads this week, up from 9 last week. Google Ads drove 8 of 14."

2. Trial Bookings and Conversions State trials booked, trials attended, and how many converted to a membership. Include the conversion rate as a percentage.

3. Revenue Snapshot Total revenue for the week, broken out by category. Flag any notable changes, such as a drop in retail sales or a spike in private session revenue.

4. Class Utilization Average utilization across all classes. Call out the top-performing class and the lowest-performing class by fill rate. If any class ran below 40% capacity, flag it.

5. Churn Number of cancellations and pauses. List the names of clients who cancelled if the studio is small enough for the owner to recognize them. Note the reason if the client provided one during the cancellation flow in MindBody or Vagaro.

6. Open Issues List anything that needs the owner's decision or attention. Examples: a broken reformer spring reported by an instructor, a client complaint that escalated, a vendor invoice that is past due.

7. Action Items Two to four specific next steps. Assign each one to a person (you, the owner, the studio manager, or an instructor). Include a due date.

Add Week-Over-Week and Year-Over-Year Comparisons

Every number in the report should have context. Next to each metric, include:

• vs. prior week: Show the percentage change. Use green text for improvements and red text for declines in the Google Doc.
• vs. same week last year: If the studio has been operating for more than 12 months, pull the same calendar week from the prior year. This catches seasonal patterns the owner might otherwise miss, like a predictable dip the first week of January.

If the studio is newer than 12 months, skip the year-over-year column and note "YoY data not yet available" at the bottom of the report.

Choose Your Delivery Format

The default format is a one-page Google Doc shared via a direct link in an email. Subject line: "[Studio Name] Weekly Report - Week Ending [Date]."

If the owner prefers video, record a three-to-five minute Loom video walking through the Google Doc on screen. Paste the Loom link at the top of the email and attach the Google Doc link below it for reference.

Ask the owner during your first week which format they prefer. Do not switch formats without confirming.

Distribute the Report

Send the report to the studio owner and the studio manager (if one exists) via email. CC yourself so you have a sent record.

If the studio uses Slack or a team chat tool, post a short summary (three bullet points max) in the designated channel with a link to the full report.

Archive each weekly report in a shared Google Drive folder organized by year and month: "Weekly Reports > 2026 > May." This makes it easy to pull historical data when you prepare the quarterly business review.

Maintain and Improve the Template

At the end of each month, review the last four reports. Ask the owner two questions:

1. Is there a metric you want added or removed?
2. Is the format working, or would you prefer changes?

Update the template based on their feedback. Version the template file name so you can always revert (e.g., "Weekly Report Template v2 - March 2026").

HBR research shows CEOs spend 72% of work time in meetings.

FAQ

How long should the weekly report take to produce?

Plan for 60 to 90 minutes total. About 30 to 40 minutes for data collection across MindBody, QuickBooks, and Google Analytics. Another 20 to 30 minutes for writing the report. The remaining time covers review, formatting, and sending. As you get familiar with the systems, you can often finish in under an hour.

What if the studio uses software other than MindBody or Vagaro?

The process stays the same. Swap in whatever booking platform the studio uses, such as WellnessLiving, Mariana Tek, or ClubReady. The key metrics (leads, trials, conversions, utilization, churn) exist in every major platform. You just need to find the right report screens.

Should the VA include recommendations or just data?

Include brief, specific recommendations in the Action Items section. The owner hired you to think, not just copy numbers. If class utilization on Thursday 7 PM Reformer dropped below 40% for three straight weeks, recommend the owner consider changing the time slot or pausing the class. Back every recommendation with data from the report.

What if the owner never reads the report?

Bring it up directly. Ask whether the format, timing, or length is the issue. Some owners prefer a quick voice memo over a written doc. Others want a 15-minute Monday call where you walk through the numbers live. Adapt the delivery method, but never stop producing the report. The data collection discipline is valuable even if the owner only skims it.

How do you handle weeks with incomplete data?

Note the gap clearly in the report. For example, if QuickBooks data is missing because the bookkeeper has not reconciled yet, write "Revenue data pending - bookkeeper reconciliation expected by Wednesday." Do not guess or estimate. Deliver what you have on time and send a brief update email once the missing data is available.