Understanding which booking channels drive the most value for your property helps you make smart decisions about where to focus your efforts. By generating a simple Excel PivotTable from your NightsBridge Booking Summary report, you can easily see a clear performance breakdown for any date range you choose.This report gives you a quick snapshot of key channel metrics, including:
- Total revenue generated by each channel
- 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 channel performance view in Excel:
Step 1: Generate your Booking Summary report
First, run your Booking Summary report in NightsBridge for the specific date range you would like to analyze. 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, search or scroll to find Source.
- Click and hold Source, then drag and drop it into the Rows block. This will neatly list all your booking channels.
- Search for Revenue.
- Then drag and drop Revenue into the Values block below.
- Drag Revenue into the Values block a second time. This will automatically create a second field called Sum of Revenue2.
Step 4: Change to average revenue
- Click the drop-down menu next to Sum of Revenue2 in your Values list.
- Select Value Field Settings from the list.
- In the window that opens, select Average from the available list.
- Click OK.
You will now see Sum of Revenue2 change to Average of Revenue2 on your table!
Step 5: Add your other channel averages
Follow those exact same steps to add and adjust the remaining fields to show averages:
- Search for and 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
To make your table super easy to read, highlight the cells with numbers on your PivotTable and format them into clean number or currency formats.
Video guidance on how to format numbers in cells on Microsoft Excel
Once you have followed these steps, you will have a clear, visual breakdown showing exactly how your booking channels are performing!
Click here for more guidance on PivotTables on Excel.