Block Conversion (rep_block_conversion.rep)

Prerequisite for Block Conversion

The Booking Conversion Report calculates the booking conversion to an Actual status for any date range in absolute figures as well as conversion percentages.

For the selected date range, all bookings that reach a final status will print subject to status selection. The bookings are summarized into Actual bookings (considered Converted) and bookings on other final statuses. These other final statuses are commonly Lost or Canceled status types. You can specify one additional non-final status to include in the actual total. Typically, this status would be a Definite or equivalent status that has not yet turned to actual, but is highly expected to do so.

The report summary then calculates the ratio of all bookings on a final status in the selected date range versus those bookings that have turned ACTUAL (or are highly likely to do so).

The report summary then calculates the ratio of all bookings on a final status in the selected date range versus bookings that have turned Actual (or are highly likely to do so).

SELECTION CRITERIA

Property.
  1. When logged into a Property:

    1. The Property filter should be Visible, Required, and displayed at the top of the Parameter.

    2. b. The logged in property passes (defaulted) to the Property filter.

    3. No other Properties are available for selection.

  2. When logged into a HUB:

    1. a. The Property filter should be Visible, Required, Multi-Select, and displayed at the top of the Parameter.

    2. The Property selected in the Report Property search filter should pass (defaulted) to the Property filter.
    3. All Properties in the HUB are available for selection.
  3. Mandatory when visible.

Start Date From/Start Date To. The start date range of the blocks you wish to review on this report, such as arrivals between 09/01/2007 and 09/30/2007).

Account. Select accounts to review on this report.

Current Status. Use this option to select bookings by their current status. The LOV for Current Status on this report shows only Final statuses, meaning statuses that do not have any further follow-on status assigned to them in configuration (e.g., actual, lost, canceled).

Note: When the Block status is Actual, the Net Rate, Gross Rate and Net Room Revenues are calculated based on Picked-up figures.

Status not turned. Allows selection of one other status that is configured directly prior to the Actual status (e.g., definite). This allows inclusion of blocks that are highly likely to turn Actual in the near future into the Converted statistics. The LOV shows only statuses that have the actual status configured as a follow-on status in the status flow configuration.

Market Segment. Use this filter to select blocks in a particular market segment, for example, nationwide or corporate local.

Revenue Types 1-5. Use this option to select the catering revenue types to use for calculating the catering revenue figures from and in what order these revenue types print on the report.

Note: Each revenue type field is multi-select and allows for multiple selections of revenue types per field. When revenue types are combined, for instance Food and Beverage, the revenue type values are subtotaled. As well, the filters for Revenue Types are mutually exclusive; after you select one, it is not available for selection in another Revenue Type column.

Currency. Select the currency type in which to display revenue values on this report.

REPORT DATA

The first part of the report prints the block details in two lines per booking record. The details shown for each booking include: booking status, catering status, booking name, booking id, arrival date, departure date, catering revenue types 1 -5 (as selected in filter), initial number of rooms booked, total number of rooms booked, net room rate, gross room rate, breakfast included flag, market segment, net room revenue, total catering revenue, total revenue and the reason lost, canceled or turned down for those bookings on a cancel status.

Note:

The Initial room night figure is taken from the Initial block snapshot, not from the original block figures. Therefore, you must use block snapshots to have this figure appear on the report.

Catering Revenue prints per the regular principle: if an event is actual, the Actual/Billed revenue prints. If no Actual/Billed revenue exists (and when the event is not yet actual), the Guaranteed/Expected revenues are checked. If Guaranteed Revenue is higher than Expected Revenue, Guaranteed Revenue prints. Otherwise, Expected Revenue prints. If Expected/Guaranteed Revenues do not exist, Forecast Revenues prints.

An exception to the above rule is made when the OPERA Controls parameter Events>Use Forecast Value Onlyis active. In this case, all events are created with the flag Use Forecast Revenue Only checked. While this flag is checked, all catering revenue in this report come only from the forecast figures, even if expected or guaranteed figures exist. The flag is unchecked automatically when the event turns actual, but can also be manually unchecked earlier in the life of the event.

The report summary that prints at the end is composed of four lines:
  • Line1: Summarizes all bookings listed on the report including their room nights and revenues.

  • Line2: Summarizes all bookings, their room nights, and revenues, on actual status plus those bookings on the status defined in filter “Status not turned.” This line represents the Converted business.

  • Line3: Calculates conversion percentages and factors of actual / converted bookings (line2) versus all bookings (line1) (this is, the percentage of all bookings turned actual as opposed to lost or canceled).

  • Line4: Splits out the number of bookings, revenues, and room nights of bookings that are on the status, “Status not turned” to get a clearer picture of the business that might turn actual, but still has a chance of getting canceled.