How to calculate average length of stay

Front Office OperationsMews Business IntelligenceReservation ManagementMews OperationsReports

You can calculate the average length of time that guests stay at your property with the Reservation report.

In this article you can learn how to calculate the length of our guest's stay in the following steps:

 

 

Step 1: Export the Reservation report to Excel

  1. On your Mews dashboard:
  • Click on image.png or,
  • Go to the main menu Screenshot_2.png > Reservations > Reservation report.
  1. In the filters menu, under Start and End, choose the interval you want to calculate the average length of stay for.
  2. Under Mode, select Totals.
  3. Click Export, then Export to Excel.
  4. Download the export file. Note: You receive a notification when the file is ready for download.
 

Step 2: Calculate the average length of stay

  1. Open the Excel spreadsheet.
  2. Find the total number of nights and reservations. You can view the totals under All, next to the Nights and Reservations columns.
  3. Divide the number of nights by the number of reservations to find the average length of stay. For example, if you have 100 nights and 25 reservations, 100/25 = 4, so your average length of stay is 4 nights.

You can learn more about the Reservation report here.
Was this article helpful?
10



Feedback