Lost Business Report

Lost Business Report

Report Overview

The Lost Business report provides a summary of bookings that have been lost, canceled, or turned down. 


Report Uses 

The sales team can use the report … 

  • To evaluate the reason why the business was lost

  • To leverage this data to direct investments to prevent future lost business

    • For example, if you can show the owners that you lose $1M of business due to not having a specific service or amenity, they may approve the budget to add the service or amenity to the property.


How to Run the Report

To run the report, follow these steps: 

  1. Click on the 'Reports' tab

Click on the 'Reports' tab

  1. Click on 'All Reports'

Click on 'All Reports'

  1. In the 'search' field, type the first few letters of the report "Lost busi"


  1. Click on ‘Lost Business Report’

Click on Lost Business Report

  1. The report runs by itself based on a default arrival date of ‘Current Year'. If you want to change the date, click on the 'funnel' and change the 'Arrival date'…  You can also filter by Sales Manager, date the business was lost, and lost reason. 

  1. The report shows you all the lost business grouped by property (and sorted in ascending order). Remember, you can always drill down into the booking by clicking into the blue booking. If you want to just see totals by property, go to the bottom of the page and click on the switch 'Check Detail Rows'…

  1. Uncheck 'Detail Rows' to go back to your detailed view.

Uncheck 'Detail Rows' to go back to your detailed view.



Information Displayed on the Report 

 


The following information appears on your report: 

  1. The top part of the report shows a summary: Total room nights lost, total average daily rate, total revenue lost, total event revenue lost, total products, and a grand total on the right side.  



  1. Below this, the columns start with the 'Property', followed by ‘Date Lost’ which is the date the booking was lost.

  2.  ‘Booking Name’, where you can click on the link to open this booking if needed.

  3. ‘Close Reason’ shows the booking’s lost status. 

  4. 'Lost' Reason' showing you the reason the booking was canceled or lost.

  5. ‘Total Room Nights’ - total number of guest rooms lost. 

  6. ‘Average Rate’ - The average daily rate for the booking's guest rooms.

  7. The next four columns show Guest Room Revenue, Events Revenue, Products Revenue, and  Total Revenue.

  8. As you keep scrolling down you will see the next property.



Resources

  1. Overview of Standard Reports & Dashboards - Knowledge base article

  2. How to Edit Reports and Dashboards - Knowledge base article


    • Related Articles

    • Business on the Books Report - Coming Soon!

      Learning Objectives In this lesson you will learn… How to look at how much business you have on the books compared to last year, and same time last year. How to view your business on the books from various perspectives (e.g. by segment, by rate code, ...
    • Kitchen Report

      Kitchen Report Report Overview The Kitchen report lists all menus and items needed on a specific date. Report Uses The kitchen staff uses it to inform purchasing and monitor product inventory for upcoming events. How to Run the Kitchen Report To run ...
    • Corporate Business Segments

      Learning Objectives This article will teach you... The difference between 'Business Segment' and 'Corporate 'Business Segment' The purpose of 'Corporate 'Business Segment' How to create a 'Corporate 'Business Segment’ and a property-level 'Business ...
    • How to use Thynk to Prospect Accounts

      Learning Objectives At the end of this lesson you will know …. Which tools you can use to prospect accounts Where to record your prospecting calls Using the System to Prospect Accounts and find New Business One of your sales activities as a sales ...
    • Event Forecast Report

      Report Overview The Event Forecast Report is a standard report that is used by the catering team. It allows catering managers to analyse total revenue by event type and status for a specified date range. Report Uses This report is used by catering ...