Productivity report

The content of this page is specific to the Delphi product type only. If you are using the Delphi Core product type and want to learn more about the Delphi product type, contact your sales representative.

The Productivity report displays guestroom and event production by sales manager and compares it to last year's figures and this year's goals.

Additional information:

You can run the Productivity report monthly to:

To run the report

  1. Navigate to Amadeus Reports.
  2. Under To Be Discontinued, click Productivity Report.

    This report is due to be replaced by the new version of the report in the Pace & Productivity section of the Amadeus Reports page. With the new report, you can export to Excel, PDF, or another format. The new report has also been enhanced for better performance. Start using the new report and email support if you have concerns, or to tell us why you prefer this original version.

  3. Complete the report criteria. You can select multiple values for some criteria fields. To do so, press the CTRL key while selecting each value you want to include.
    FieldDescription
    Beginning and Ending Activity DateAny bookings that were created or modified during the activity date range are included in the report. The most common activity date range is last month.
    Beginning and Ending Consumption DateAny roomnights or events that are in-house during this date range are included in the report. The most common consumption date range is the first day of last month 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–31, only those guestrooms and events on December 29-31 are included.

    Here are two examples of how to 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 future groups, set the activity date range to last month and the consumption date range to the end of booking time.

    PropertiesSelect which properties to include in the report. By default, all properties you have access to are included.
    Sales ManagersSelect which sales managers to include in the report. By default, booking changes made by all sales managers are included.
    GuestroomSelect to report on Blocked or Forecasted guestroom values when picked up figures are not available.

    When picked up figures are available, those values are used whether the booking is marked complete or not.

    Sales Manager RoleSelect which sales manager role to include in the report. By default, Booked by is selected.
    Include Guestroom/Event RevenueSelect which type of information you want to include in the report. By default, both Guestroom and Event Revenue are selected.
    Show Event Revenue DetailWhen selected, the event revenue for each month in the consumption date range is sorted by the individual parent revenue classifications. This includes Food, Beverage, Resource, Audio Visual, Administrative Charge, Other, Function Room Rental, and any other custom parent classifications.

    This checkbox becomes available when Event Revenue is selected in the Include Guestroom/Event Revenue section.

    Sales Manager TotalsWhen selected, grand totals are shown for each Sales Manager at each property. This section displays at the end of the report and includes grand totals for guestrooms, guestroom revenue, and event revenue during the consumption date range.
    Goal ClassificationsSelect which goal classifications to include in the report. A goal comparison displays at the end of the report for each selected goal classification.
    Event Revenue ClassificationsSelect the corporate revenue classifications to display when Show Event Revenue Detail is selected. By default, all revenue classifications are selected.
  4. Click Generate Report to view the report on-screen or Generate PDF to view the report as a PDF file that you can save or print.
  5. Review the report data.

    The following information displays for each selected Sales Manager during the consumption date range. Grand totals also display for each Sales Manager at each property.

    FieldDescription
    Activity for <<activity date range>>
    New DefiniteThis is the number of guestrooms, guestroom revenue, and event revenue that turned definite during the activity date range.
    Lost / DowngradeThis is the decrease in definite guestrooms, guestroom revenue, and event revenue from bookings whose status changed to Lost, Cancelled, or Turned Down.
    RevalThis is an increase or decrease in definite guestrooms, guestroom revenue, and event revenue. For example, an event is added to a booking during the activity date range, resulting in a positive reval. If the expected attendance for an event drops during the activity date range, a negative reval displays.
    SlippageThis is used for bookings that remained definite and were marked pickup complete during the activity period.

    Slippage applies to guestrooms and guestroom revenue only. The following formulas are used to calculate these fields, and are based on your Guestroom report criteria:

    • (Final picked up guestrooms) - (Blocked or forecasted guestrooms)

    • (Final picked up guestroom revenue) - (Blocked or forecasted guestroom revenue)

    If any room block on the booking has not been marked pickup complete during the activity date range, the booking is not included.

    Net DefiniteThis is the final change in guestrooms, guestroom revenue, and event revenue during the activity date range. Slippage is only included for guestrooms and guestroom revenue. The following formula is used to calculate this field:

    (New Definite) - (Lost / Downgrade) +/- (Reval) +/- Slippage

    Same Time Last Year
    Net DefiniteThis is the total net definite guestrooms, guestroom revenue, and event revenue for the same activity date range last year. Slippage is only included for guestrooms and guestroom revenue. The following formula is used to calculate this field:

    (New Definite) - (Lost / Downgrade) +/- (Reval) +/- Slippage

    Year To Date as of <<activity end date>>
    New DefiniteThis is the number of new definite guestrooms, guestroom revenue, and event revenue at the end of the activity date range. The following formulas are used to calculate these fields:
    • Guestrooms = (Definite guestrooms at the start of the activity date range) +/- (Net Change)
    • Guestroom/Event Revenue = (Definite revenue at the start of the activity date range) +/- (Net Change)
    Lost / DowngradeThis is the decrease in definite guestrooms, guestroom revenue, and event revenue from bookings whose status changed to Lost, Cancelled, or Turned Down by the end activity date range.
    RevalThis is an increase or decrease in definite guestrooms, guestroom revenue, and event revenue by the end of the activity date range. For example, an event is added to a booking during the activity date range, resulting in a positive reval. If the expected attendance for an event drops during the activity date range, a negative reval displays.
    SlippageThis is an increase or decrease in definite guestrooms and guestroom revenue, due to pickup, by the end of the activity date range. The following calculations use blocked or forecasted numbers based on your Guestroom report criteria:
    • (Final picked up guestrooms) - (Blocked or forecasted guestrooms)

    • (Final picked up guestroom revenue) - (Blocked or forecasted 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 DefiniteThis is the total number of definite guestrooms, guestroom revenue, and event revenue by the end of the activity date range. The following formula is used to calculate this field:

    (New Definite) - (Lost / Downgrade) +/- (Reval) +/- (Slippage)

    On the Books as of <<activity end date>>
    ProspectThis is the total number of prospect guestrooms, guestroom revenue, and event revenue at the end of the activity date range. Blocked or forecasted values are used depending on the Guestroom selection.
    TentativeThis is the total number of tentative guestrooms, guestroom revenue, and event revenue at the end of the activity date range. Blocked or forecasted values are used depending on the Guestroom selection.
     Goal Classification

    This section compares guestroom and event production to the sales manager's goals. This data is only available if you selected at least one goal classification in the report criteria. Each user goal is listed under its associated classification, along with its start and end dates and the type of revenue it applies to.

    GoalThis is the total goal amount. The following formula is used to calculate each sales goal:
    • Guestroom Revenue Budget = Definite Roomnights x Definite Average Rate
    • Event Revenue Budget = Definite Event Revenue

    User goals are specified using the Sales Goals section of the Property page.

    Net DefiniteThe following formula is used to calculate this field: (New Definites) - (Lost / Downgrade) +/- (Reval) +/- (Slippage)
    Variance to GoalThis is the variance between the Net Definite value and the Budget amount.
    % Variance to GoalThis is the variance percentage between the Net Definite value and the Budget amount.
Learn more...

Overview: Reports

Print and email reports on the Amadeus Reports tab