The Reservations report surfaces detailed information on a customer's reservation. All reservations, including migrated, third-party, and reservations booked in Mariana Tek are listed.
This report is useful for:
Analyzing which memberships and credit packages are used the most to reserve classes.
Analyzing which spots (if using PAS layouts) are the most popular
Viewing the total number of waitlist and standby reservations
Viewing the number of guests booked over a period
Viewing the number of converted and unconverted guests
Viewing a list of cancelled classes within a timeframe
Pulling up the Report
Navigate to Reports from the left panel > Utilization > Reservations > View.
Specify the date range from the date picker.
Apply any additional filters.
Select Generate Report and, if necessary, export the data.
Understanding the Report
The Reservations report includes:
Reservation ID: Reservation ID generated by the system.
Reservation Type:
Standard
Waitlist
Standby
Status:
Pending
Check in
Standard cancel
Penalty cancel
Graced cancel
Penalty no show
Graced no show
Removed
Class cancelled
Penalty removed
Creation Date: Date of reservation.
Cancelled Date: If applicable, date of cancelled reservation.
Unconverted Guest: If applicable, the guest's account was not converted into a Mariana Tek Account.
True = Yes
False = No
Converted Guest: If applicable, the guest's account was converted into a Mariana Tek Account.
True = Yes
False = No
Guest: If the customer listed is a guest.
True = Yes
False = No
Guest Email: If applicable, the guest's email.
Credit Payment Origin:
Purchase: The credit package to book the reservation was purchased by the customer.
Blank: The reservation was made with a membership or a third-party vendor (ie. ClassPass).
Credit: Credit type name.
Package: Credit package name.
Membership: Membership type.
Contract: Membership contract name.
Class ID: Class ID generated by the system.
Class Start Date: Date of class.
Class Start Time: Start time of class.
Class Day of Week: Monday - Sunday.
Class Custom Name: Custom name, if applicable.
Class Is Public?:
True = Yes
False = No
Class Tags: Class tag(s) configured to the class.
Class Type: Type of class (ie. bootcamp, cycling, etc.).
Class Duration (Minutes)
Layout: Lists the layout name, layout format (FCFS or PAS), and layout capacity.
Layout Format:
first-come-first-serve
pick-a-spot
Layout Capacity: Capacity of the layout.
Class Capacity: Layout capacity - number of unavailable spots.
Classroom: Name of the classroom that the layout is in.
Location: Studio's location.
Region: Studio's region.
Instructor ID(s): Instructor's ID generated by the system.
Instructor Employee ID(s): The Instructor's employee ID generated by the system.
Instructors have three IDS (customer ID, employee ID, and instructor ID).
Instructor Names: Name of instructor.
Instructor Schedule Names: Display the name of the instructor as noted in the "Profile Name" field
Class Has Substitute?:
True = Yes
False = No
Customer ID: Customer's ID generated by the system.
Customer Email: Customer's email.
Customer Name: Name of customer for the reservation.
Company Name: Name of customer's company (if included in their profile).
Payer ID: Payer (customer who owns the credit/membership) ID generated by the system.
Payer Email: Payer's email.
Payer Name: Payer's name.
Broker ID: ID of the person who made the reservation.
If this information is different from the Customer ID, the broker is an employee.
Broker Email: Email of the person who made the reservation.
Broker Name: Name of the person who made the reservation.
Spot: Spot number associated with the reservation.
FCFS layouts will still populate a spot number and spot type, though it's irrelevant for the class.
Spot Type: Spot type associated with the reservation.