Roomzilla provides a reporting feature that enables you to gain insights into the usage of your space.

Learn here how to download a Raw data report showing all reservation activity within your space. This includes past, future, deleted, and auto-canceled bookings.

1. Log in to your admin account and head to the “Reports” tab [1] > All Reservation Data [2]

2. Select a date range for the report [3] and hit “Apply” [4].

3. Download your report by hitting the “EXPORT TO CSV” button [5].

4. Done! You can import downloaded data into a spreadsheet program like Google Sheets, Excel, or Numbers for further analysis.

Below, we have listed the column headers and their explanations:

• Reservation ID and Recurring Reservation ID – parameters allowing identification of the reservation in the database
• The status of a reservation can indicate:
  • current – past/future booking displayed on the timeline (If the ‘start time’ is in the past, the booking has already occurred. If the ‘start time’ is in the future, the booking is scheduled to take place);
  • deleted – a reservation that was created but then removed from the timeline.
  • auto-canceled – reservation automatically terminated by the system due to a lack of check-in;
• Created via:
  • desktop – a logged-in user or Guest created the reservation;
  • local – reservation made via a connected tablet, no host is assigned
  • QR – impromptu reservation made via the resource’s QR code
• Resource Name – the name of the resource a reservation is hosted in; If empty, the resource has been removed.
• Reservation Title – the default title or purpose provided by a host; for reservations created via tablet, the title is “Local Reservation” always
• Start Time – refers to the beginning time of the reservation, indicating when the booking begins;
• End Time – signifies the termination time of the reservation, denoting when the booking concludes;
• Created At – indicates the timestamp when the reservation was initially made or created;
• Duration – how long the reservation has lasted or will last; for auto-canceled bookings, it equals “minutes until canceling non checked-in reservation” parameter value
• Checkin Time – the time at which a check-in was completed for a particular reservation;
• Checked In By – refers to the user that performed the check-in or the device if it indicates ‘tablet (local)’; besides the owner, admins can also pre-check-in reservations;
  • If the fields ‘Checkin Time’ and ‘Checked In By’ are empty, it indicates that either a check-in is not required for that resource or the reservation has been deleted or auto-canceled before any check-in was performed.
• User Email, User First Name, User Last Name – reservation’s host details; if empty, the user has been deleted
• Deleted By, Deletion Time – who has deleted the reservation; apart from the owner, admins can also delete reservations
• Any additional columns are from Custom Fields that were set up by an admin. You can read more about this feature [here].