Productivity report

The Productivity report shows guestroom and event production by Sales Manager and compares it to a previous year's figures and this year's goals. Here are some things to keep in mind when you're reviewing the report details:

You can run the Productivity report monthly to do the following:

To run the report

  1. Click All Tabs (+), and then click Amadeus Reports.
  2. Under Pace & Productivity, click Productivity Report.
  3. Complete the report criteria.
    Beginning/Ending Activity DateAny bookings that were created or modified during the activity date range will be included in the report.
    Beginning/Ending Consumption DateAny 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.
    PropertiesIf you sell multiple properties, you can include them in the report. Only those properties you have access to are shown.
    Revenue TypesOnly bookings classified as Banquet are included by default. If needed, select to include bookings classified as Catering and/or In-House.
    IncludeSelect the type of information you want to include in the report: Guestroom Revenue, Event Revenue, Goal Comparison, and/or Sales Manager Total.
    GuestroomsSelect 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 ClassificationsAll 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.
    UsersBooking changes made by these users during the activity date range will be included in the report.
    User RoleActivity from users in this booking role will be included in the report: Booked By (default), Catering Manager, or Service Manager.
    Show Event Revenue DetailWhen you select Yes, the event revenue for each month in the consumption date range 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 TypesBy default, all are included.
    Goal ClassificationSelect one or more goal classifications (for example, 2020 Food & Beverage Goal or 2020 Rooms Goal). A goal comparison will be displayed at the end of the report for each goal classification you select.
    Compare ToBased on the date parameters selected for Beginning/Ending Activity Date or Beginning/Ending Consumption Date the report will display the data for the same date range from last year, 2 years ago, or 3 years ago.

    For example:

    • If consumption dates are 1st June 2019 to 31st May 2020 then last year would be 1st June 2018 to 31st May 2019.
    • If consumption dates are 1st Jan 2019 to 31st Dec 2019 then 2 years ago would be 1st Jan 2017 to 31st Dec 2017.
  1. Click View Report.

    The following information is displayed for each selected property, year, and Sales Manager, grouped into the following time periods:

    • Report Activity - totals for the activity date range you entered in the criteria.
    • Same Time - totals for the same consumption date range and activity date range the previous year, two years or three years ago.
    • Year To Date - totals for the specified consumption date range, using an activity date range from the start of this year to the end activity date specified in the criteria.
      Report Activity
      New DefiniteGuestrooms, guestroom revenue, and event revenue that turned definite during the activity date range.
      Lost/DowngradeThe 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.
      RevalAn increase or decrease in definite guestrooms, guestroom revenue, or event revenue during the activity date range. For example, a welcome dinner is added to a definite booking, resulting in a positive reval. Or, the expected attendance for an event drops by 10%, resulting in a negative reval.
      SlippageFor 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)

      Net DefiniteThe 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

      On the Books
      ProspectTotal prospect guestrooms, guestroom revenue, and event revenue on the books at the end of the activity date range.
      TentativeTotal tentative guestrooms, guestroom revenue, and event revenue on the books at the end of the activity date range.

      Goal Classification

      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 separately under its associated classification, along with its start and end dates and the types of revenue it applies to.

      GoalTotal goal amount. For 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 related list on the Property page.

      Net Definite(New Definites) - (Lost/Downgrade) +/- (Reval) +/- (Slippage)
      Variance to GoalNet Definite - Budget Amount
      % Variance to GoalBudget / Net Definite

Here are a few additional things you can do after you've run the report: