Recurring Appointments Report – Zr Ware®

Report Overview 📜

This report provides a comprehensive overview of your recurring appointment or subscription business. It is designed to help you track the entire lifecycle of a recurring service—from sign-up and renewal to completion and cancellation—and analyze its financial impact. This report pulls all recurring appointments with an appointment date within your specified range, giving you a clear picture of your subscription health.

Key Metrics & Columns Explained 📊

The report contains a mix of identifiers, status metrics, and financial data. Here is an explanation of each column:

Appointment & Client Identifiers

Client Name: The name of the customer associated with the recurring appointment.
Recurring Appointment Sign Up Date: The date the client initially subscribed to the recurring service.
Appointment Date: The date of the specific appointment instance included in the report.
Interval: The frequency of the recurring appointment (e.g., 3 Month, 6 Month, 12 Month).

Status & Lifecycle Metrics

These columns typically function as counters or flags (e.g., a '1' in the column indicates that status) to help you track the journey of each subscription.

Recurring Appointment: A general indicator that the job is part of a recurring series.
New Recurring Appointment: Marks the first appointment of a new subscription.
Renewed Recurring Appointment: Indicates an appointment that is part of a renewed subscription term.
Expired Recurring Appointment: Marks a subscription that has reached its end date and has not been renewed.
Confirmed Recurring Appointment: Indicates when a recurring appointment has been successfully scheduled and a booked call record has been created.
Cancelled Recurring Appointment: Marks a recurring appointment that was cancelled by the client or the company.
Completed Recurring Appointment: Indicates that the scheduled service has been successfully completed.

Revenue Metrics

Orig. Pending Recurring Appointment Booked Revenue: The initial revenue value of a recurring appointment before it is officially booked or confirmed.
Orig. Recurring Appointment Booked Revenue: The initial revenue associated with the recurring appointment once it is officially booked or confirmed.
Recurring Appointment Booked Revenue: The current revenue associated with the recurring appointment.
Total Revenue: The final total revenue for the completed appointment, which may include add-ons or adjustments.

Ideas on How to Use This Report 💡

This report is essential for managing and growing your subscription-based revenue. Here are several ways to use it:

Monitor Subscription Health & Churn: Compare the number of New and Renewed appointments against the Expired and Cancelled appointments over a specific period. This ratio is a key indicator of your subscription business's growth and customer churn rate.
Forecast Predictable Revenue: Use the Recurring Appointment Booked Revenue and Interval data to project future income. Understanding this baseline of predictable revenue is crucial for accurate financial planning and budgeting.
Improve Customer Retention: Filter the report for Cancelled Recurring Appointment and Expired Recurring Appointment to generate a list of at-risk or lost customers. Your customer success team can use this list to reach out, gather feedback, or offer incentives to win them back.
Analyze New Subscriber Value: Filter by Recurring Appointment Sign Up Date to track the performance of cohorts of new subscribers. See how many of their initial appointments are Completed versus Cancelled to evaluate the quality and longevity of newly acquired customers.