Productivity Verification report
Run the Productivity Verification report for a detailed list of each booking that was included in the Productivity report (as long as you run it using the same criteria). If you see an anomaly in the Productivity report, run this report to identify any potential data entry issues that could be affecting the report totals.
Here are some things to keep in mind:
- The report uses the most current event revenue available: forecast revenue before the event is marked done, and actual revenue after it is marked done.
- You must have R31 or higher installed to access this report.
- The data in the report may be delayed by up to 15 minutes. If the data doesn't match what you'd expect to see, please run the report again in a few minutes.
To run the report
- Click All Tabs (+), and then click Amadeus Reports.
Under Preview Reports, click Productivity Verification Report.
Complete the report criteria.
When selecting criteria, inactive values are preceded by an asterisk (*).
Beginning/Ending Activity Date Any bookings that were created or modified during the activity date range will be included in the report. Beginning/Ending Consumption Date Any roomnights or events that are in house during this date range will be included in the report. Consumption date range is typically the first day of this year through the end of booking time.
Consumption refers to the actual dates that revenue is generated, regardless of the booking's arrival and departure dates. For example, if a booking is in house December 29 – January 2, and you run the report using a consumption date range of December 1 – December 31, only those guestrooms and events on Dec. 29, Dec. 30, and Dec. 31 will be included.
Here are a few examples of how you might set the activity and consumption date ranges for the Productivity report:
- To see activity that took place in the month for the month, set both date ranges the same.
- To see activity that took place last month for groups that will be in house anytime in the future, set the activity date range to last month and the consumption date range to the end of booking time.
Properties By default, all properties you have access to will be included in the report. If needed, select specific properties instead. Revenue Types By default, bookings with a revenue type of Banquet will be included in the report. If needed, select to include Banquet, Catering, and/or In-House. Include By default, all options are included. If needed, adjust the selections for Guestroom Revenue or Event Revenue. Guestrooms Select to report on Agreed, Blocked, Forecasted, or Picked Up guestroom values.
If you select Agreed, Blocked, or Forecasted, guestroom information is based on pickup figures when the entire booking is marked pickup complete (not its individual room blocks).
If you select Picked Up, guestroom information is always based on pickup figures whether marked complete or not.
Revenue Classifications All revenue classifications are selected by default. If needed, select the corporate revenue classifications you want to display in the report when Show Event Revenue Detail is selected. Custom revenue classifications (for example, Golf and Spa) are combined into the "Additional" classification. Users Booking changes made by these users during the activity date range will be included in the report. User Role Activity from users in this booking role will be included in the report: Booked By (default), Catering Manager, or Service Manager. Show Event Revenue Detail When you select Yes, the event revenue will be broken down into individual parent revenue classifications (Food, Beverage, Resource, Audio Visual, Administrative Charge, Other, Function Room Rental, and Additional). Booking Market Segments, Booking Types By default, all are included. Show Details Select Expanded if you want each section to be open, or Collapsed if you want them to be closed. You can adjust each section after you run the report.
- Click View Report.
The following information is displayed for each property, and each selected user during the consumption date range.
| Report Activity as of <<activity end date>>
<<Year>>: Totals for all selected users at this property
<<User Name>>: Totals for this user at this property
Post As: Totals for each booking at this property
|New Definite||Guestrooms, average rate, guestroom revenue, and event revenue that turned definite during the activity date range.|
|Lost/Downgraded||The decrease in definite guestrooms, guestroom revenue, and event revenue from bookings whose status changed to Lost, Cancelled, or Turned Down during the activity date range.|
|Reval||An increase or decrease in definite guestrooms, guestroom revenue, and event revenue during the activity date range. For example, a welcome dinner is added to a booking during the activity date range, resulting in a positive reval. Or, the expected attendance for an event drops by 10% during the activity date range, resulting in a negative reval.|
|Slippage||For bookings that remained definite and were marked pickup complete during the activity period. Slippage applies to guestrooms and guestroom revenue only. The following calculations use agreed, blocked, or forecasted numbers based on your Guestrooms report criteria:
(Final picked up guestrooms) - (Beginning agreed, blocked, forecasted, or picked up guestrooms)
(Final picked up guestroom revenue) - (Beginning agreed, blocked, forecasted, or picked up guestroom revenue)
Slippage is only calculated for bookings that have been marked pickup complete during the activity date range. If any room block on the booking has not been marked pickup complete during that period, the booking is not included.
|Net Definite||The final change in guestrooms, guestroom revenue, and event revenue during the activity date range. Slippage is only included for guestrooms and guestroom revenue.
(New Definite) - (Lost/Downgrade) +/- (Reval) +/- Slippage
Here are a few additional things you can do after you've run the report:
- To export the report data to Excel, PDF, CSV, or another supported file format, use the Export picklist.
- To scroll through a multi-page report, use the First Page , Previous Page , Next Page , and Last Page buttons.
- To change the report zoom, use the Zoom picklist.
- To print the report as a PDF, use the Print button.
- To use the search field, enter the first few characters of the word you want to find (for example, the booking post as) and press Enter or click Find. Click Next to view all instances that match your search criteria.