Roomzilla provides a reporting feature that enables you to gain insights into your booking history.

Raw data report

Learn here how to download a Raw data report containing details of all reservations linked to your user account. This includes past, future, deleted, auto-canceled, and rejected bookings.

1. Head to the “Reports” tab [1] on your Roomzilla page.

2. Select a date range for the report [2].

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

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/auto-canceled/future booking displayed on the timeline;
  • deleted – not displayed on the timeline due to removal by a user;
  • auto-canceled – automatically ended by the system due to a lack of check-in;
  • rejected (time limit) – reservation auto-removed due to the new time limit set by an admin (e.g., business hours, business days)
  • rejected (overlap) – refers to occurrences of series that have been rejected (upon series creation) due to overlaps with existing reservations;
• Created via:
  • desktop – reservation created through the Roomzilla full web application or mobile version;
  • QR – impromptu reservation made via the Resource’s QR code;
• Resource Name – the name of the resource a reservation is hosted in;
• Reservation Title – the purpose you provided or default title;
• 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 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;
• Deleted By – who has deleted the reservation; apart from the owner, admins can also delete reservations.