Understanding how each of your rooms is performing helps you identify your top earners and make smart decisions about your pricing and property setup. By generating a simple Excel PivotTable from your NightsBridge Booking Summary report, you can easily get a clear visual breakdown of individual room performance for any date range you choose.This report gives you a quick snapshot of key room metrics, including:
- Total revenue
- Average revenue per booking
- Average daily rate (ADR) per booking
- Average number of nights guests stay
- Average adult occupancy per booking
Here is a friendly, step-by-step guide to setting up your room performance view in Excel:
Step 1: Generate your Booking Summary report
First, run your Booking Summary report in NightsBridge for the specific dates you would like to review. If you'd like extra guidance on pulling this report, take a look at our tutorial called "How to generate a report".
Step 2: Create your PivotTable
- Open your exported Excel sheet and click on any single cell that contains text.
- Click on the Insert tab at the top of Excel.
- Select PivotTable.
- Click OK on the pop-up window. Excel will automatically create a fresh PivotTable worksheet for you.
Step 3: Organise your rows and values
- In the PivotTable field list on the right, select Room Name and drag it into the Rows section.
- Drag the Revenue category into the Values block. This will default to displaying Sum of Revenue.
- Drag Revenue into the Values block a second time to create a new field called Sum of Revenue2.
Step 4: Change to average revenue
- Click the drop-down menu next to Sum of Revenue2 in the Values block and select Value Field Settings.
- Click on Average in the pop-up window.
- Click OK.
You will now see Sum of Revenue2 change to Average of Revenue2!
Step 5: Add your other room averages
Follow those exact same steps to add and adjust the remaining fields to show averages:
- Drag Avg rate, Nights, and Adults into the Values block.
- Click Value Field Settings for each one and select Average to change them from totals to averages.
Step 6: Format your numbers and view your results
- Highlight the cells with numbers on your PivotTable.
- Format the cells to a clean number or currency format.
Once you have followed these steps, you will have a clear, visual breakdown showing exactly how each of your rooms is performing per booking!
Video guidance on how to format numbers in cells on Microsoft Excel
Click here for more guidance on PivotTables on Excel.