Compare rate-plan production and value

Marcus Cole

Marcus Cole

Last updated on Nov 18, 2026

Use Rate Plan Performance to compare captured bookings, room nights and qualified booked room-rate value by channel rate plan, inspect the supporting stays and download the aggregate results.

The dates select nights of stay—not booking dates or cancellation dates. This report shows the current captured booking state. It is not a historical on-the-books snapshot, posted revenue or proof of complete property production.

Before you start

  • Select the intended property. You need access to that property and its reports.
  • Choose the reservation feed you want to analyze. A feed is the channel through which ChannelRUSH received a reservation; it is not necessarily the original selling source.
  • Have the exact channel product IDs if you want to narrow the report. Standard hotel rate-plan names and IDs are not substitutes for channel rate-plan IDs.

Viewing, updating and downloading this report do not change reservations, send inventory or repair missing history.

Run the report

  1. Select your property in the property selector.
  2. Open Reports → Revenue Analytics → Rate Plan Performance.
  3. Set Stay dates (through inclusive). Use Month to fill a whole calendar month, or choose your own date range. Both endpoints are included; the range can contain at most 366 days.
  4. Choose a Reservation feed.
  5. Leave Comparison feed (kept separate) at No comparison, or select a different feed.
  6. If needed, expand Narrow by product or currency. Enter a Channel room ID, Channel rate-plan ID or Currency. Leave these blank to include all matching products and currencies in the selected feed.
  7. Select View report.
  8. Check the property, feed and stay dates above the results before interpreting the figures.

Rate Plan Performance filters with stay dates, reservation feed, a separate comparison feed and optional product and currency filters

Use the filters to define one property's captured stay-night selection. A comparison feed remains separate.

The Filters panel collapses after a successful run. Reopen it to change your selection, then select Update report. Changing a field alone does not update the displayed results. Apply your changes before downloading or opening a new window.

A new report normally starts with a 30-day period beginning on the property's current local date. An existing report link can carry explicit dates and filters, so check the displayed selection rather than assuming the default.

Check and interpret the result

The report shows the selected feed first. If you requested a comparison, a separate Comparison feed section follows. Each section has its own full-selection distinct booking count, canceled booking count and current-cohort cancellation rate.

The table separates rows by channel rate-plan identity, currency and current status. Active and canceled business are always included and shown separately. There is no active-only switch on this report.

Stay nights, bookings and room stays are different measures

  • Clipped nights are the room nights inside your selected date range. The arrival night counts; the checkout date does not. A stay can contribute even if it arrived before the first selected date.
  • Full LOS is the length of the whole room stay, including nights outside your selection.
  • Bookings counts distinct bookings within a row. A booking with multiple rooms or multiple nightly rate plans can contribute to several rows.
  • Room stays counts the separate room stays represented in a row. One multi-room booking can contain several room stays.

Do not sum the table's booking counts to reconstruct the full-selection distinct booking count. The latter counts each matching booking once. Room-stay counts and stay-based averages can also overlap across rate plans when a room stay uses more than one plan.

Money is qualified, not assumed

This report qualifies monetary totals from ChannelRUSH Booking Engine nightly room rates when a currency is recorded and exactly one nightly price record with a nonblank price is available for the stay night. Booked room-rate value includes any tax already embedded in that rate. Separately stored fees and taxes are excluded.

Other feeds can contribute bookings, room stays, nights and price coverage without qualifying for monetary totals. A price being present does not make it comparable revenue.

  • Qualified ADR is known qualified booked room-rate value divided by qualified nights—not by all clipped nights.
  • Night share uses the selected feed's matching nights within the same currency and status.
  • Known value share uses the selected feed's qualified known value within the same currency and status. It excludes unknown amounts and is unavailable when the qualifying total is not positive.
  • Currencies remain separate. There is no currency conversion or combined currency total.
  • A dash means unavailable, not zero. A recorded zero price is different from a missing price and can qualify when the other conditions are met.

These values are not settled revenue, profit, refunds, commissions or proven lost revenue. A small priced or qualified subset can produce an ADR or value share that does not represent all captured nights.

Rate-plan identities and mappings

The report attributes each night to its recorded nightly channel rate-plan ID. If there is no nightly ID, it falls back to the room stay's rate-plan ID. Conflicting nightly IDs remain Unknown rate plan rather than being assigned to a guessed plan.

Current hotel rate-plan mapping shows the current standard hotel rate-plan target for each contributing channel room. It can show a target ID and name, No current target or Ambiguous current targets. A missing or ambiguous target is a finding to investigate, not automatically a setup fault.

Mappings reflect current settings. Editing a mapping can change this explanation on a later run; it does not establish which mapping existed when the booking was made. Rate-plan mapping and room-mapping coverage are separate measures.

Cancellation rates and receipt timing

The Cohort cancellation rate is currently canceled bookings divided by all active and canceled bookings with matching stay nights in the same rate-plan and currency bucket. It is repeated on that bucket's active and canceled rows. The full-selection cancellation rate uses independently distinct bookings across the whole selection.

These are current stay-cohort rates, not the percentage of cancellations that occurred during your selected dates. Reinstated bookings are active. Removing one room from an otherwise active booking does not make it a canceled booking.

Rate Plan Performance uses the current captured reservation version. A canceled version without usable stay dates cannot enter its dated rate-plan totals. Cancellation Analysis is a separate report that can use retained pre-cancellation stays; its totals need not match this report.

Mean receipt lead days measures the first retained ChannelRUSH receipt to arrival in the property's local time. It is not the original booking lead time. Imports and missing earlier history can shorten this interval. Missing receipts, receipts after arrival and timestamps without a verified UTC offset are unknown. The mean includes only timed room stays; use Timed / room stays to check coverage.

Compare two feeds safely

Choose a different Comparison feed (kept separate) and select Update report. Both sections use the same stay dates and the same raw room, rate-plan and currency filters.

The same product ID is applied independently to each feed. It does not establish that the products are equivalent. If one feed has no matching ID, that section can be empty. Clear product filters for a broad comparison, or run each feed separately using its own IDs.

The report does not deduplicate overlapping bookings across feeds, combine their totals or calculate matched-product uplift. Treat each section as its own captured scope. Do not add feed totals without separately reconciling overlap.

To see the other feed's supporting stays, select Open the comparison feed's room-stay detail and export. This changes that feed into the selected Reservation feed, retains the dates and product/currency filters, removes the comparison and starts at the first detail page. It does not download a detail file. Use Download CSV afterward if you want that feed's aggregate export. Re-select a comparison if you want to return to a two-feed view.

Inspect the supporting room stays

Expand Selected feed room-stay detail beneath the results. Its heading gives the full count of matching room stays. The table shows at most 100 room stays per page, ordered by arrival and then reservation and room-stay identifiers.

Use Next page or Previous page when available. These controls change the detail page, not the full aggregate scope. The supported detail page range is 1–10,000. If a copied link opens a page without detail rows, rerun the filters to return to the first page.

The detail covers the full selected-feed selection, not a clicked rate-plan row. It can show Mixed nightly plans where the included nights use different plans. If you narrow by a rate-plan ID, its clipped nights and known value cover only the matching nights; full LOS still describes the whole room stay.

Download or open another view

  • Download CSV downloads the full aggregate table, not only the current detail page. With a comparison selected, the file contains both feeds, identified by Period and FeedId. It does not export the room-stay detail table.
  • New window opens another copy of the report with the applied selection. It is not an Excel view or a saved historical snapshot.
  • Definitions and coverage expands the report's formulas, timing and monetary qualifications, current filters and coverage limits.
  • Inventory and restriction context opens the property's Rates & Availability Report. It carries the property, not this report's dates, feed or product/currency filters. Set and check that report's own selection before comparing results. Inventory or restrictions alone do not establish why a rate plan did or did not sell.

Each report request or download reads current captured data. A later download or page can differ if reservations or mappings have changed. The extraction timestamp tells you when that result was read; it does not prove that the feed is complete or recently received every booking.

Filter reference

Field or control What it does and accepted values
Filters Opens or collapses the filter form. The collapsed summary shows the stay range and selected feed; “narrowed” means a product or currency filter is in use. Open the panel to check the exact filters and comparison feed.
Month Shortcut that fills both date endpoints for one calendar month. It does not group the results by month or run the report. A custom range need not have a month selected.
Stay dates (through inclusive) Required start and end dates for the on-screen form, in the displayed date format. The end cannot precede the start. Maximum 366 inclusive days. These select stay nights, excluding checkout. If the enhanced date picker is unavailable, the form uses Start date and End date instead.
Reservation feed One feed for the selected property. The initial choice uses an available connected feed when possible; check it before running. An existing link can retain a previously selected feed even if it is no longer connected.
Comparison feed (kept separate) No comparison, or a different feed. The same feed cannot be selected for both roles. The comparison uses the same dates and raw product/currency filters, without cross-feed matching or deduplication.
Narrow by product or currency Expands the optional filters. It opens automatically when one of those filters is in use.
Channel room ID Exact recorded channel room ID, up to 200 characters. Blank means all rooms within the other filters. It is not a room-name search; case and spaces in the supplied ID matter.
Channel rate-plan ID Exact attributed nightly channel rate-plan ID, up to 200 characters. Blank means all plans, including unknown identities. It is not a standard hotel rate-plan name or mapping filter. Case and spaces in the supplied ID matter.
Currency Recorded currency code, such as USD, up to 10 characters. Surrounding spaces are removed and letters are converted to uppercase for matching. Blank includes all currencies, including unknown currency; it does not combine or convert them.
View report / Update report Applies the filters and reads the current report. Use View report initially and Update report after a result has loaded. Active and canceled bookings remain included.

Aggregate column reference

The following columns appear for both the selected-feed and comparison-feed tables when rows are available.

On-screen column Meaning
Channel rate-plan identity Rate plan … for a recorded attributed channel ID, or Unknown rate plan. This is the grouping identity, not a standard hotel plan name.
Current hotel rate-plan mapping Current target ID/name per contributing channel room, or No current target / Ambiguous current targets. It is not historical mapping evidence.
Currency Recorded currency for the row; Unknown when missing.
Status Active or Canceled, based on the current captured booking status.
Bookings Distinct matching bookings in this rate-plan, currency and status row. Non-additive across plans.
Room stays Distinct matching room stays in this row. A multi-plan stay can appear in more than one plan row.
Clipped nights Matching room nights inside the selected dates, excluding checkout.
Priced / nights Nights with exactly one nightly price record with a nonblank price, followed by all clipped nights. Duplicate or missing nightly price rows do not qualify as priced.
Qualified nights Priced nights eligible for monetary totals: booking-engine feed, known currency and a usable nightly price. Mapping gaps do not by themselves remove a night from this monetary count.
Known booked room-rate value Sum of qualified nightly booked room rates for this row. A dash means unavailable.
Qualified ADR Qualified known value divided by qualified nights. A dash means no qualifying denominator.
Night share Percentage of matching nights in the same feed, currency and status contributed by this row.
Known value share Percentage of qualified known value in the same feed, currency and status contributed by this row. Unknown prices are excluded; an unavailable share is not zero.
Mean full LOS Average whole-stay length, counting each room stay once within this row rather than once per night. Includes nights outside the selected dates.
Mean receipt lead days Average first-retained-receipt-to-arrival interval among this row's timed room stays, using the property timezone.
Timed / room stays Room stays with a usable receipt interval, followed by all room stays in the row.
Cohort cancellation rate Canceled booking count divided by active plus canceled booking count for the same rate plan and currency. The same rate appears on both status rows.

The distinct booking count, canceled booking count and cancellation rate above each table apply to the full filtered feed selection. The extraction line identifies that feed, the read time and the report definition version.

If a Source exceptions outside dated totals message appears, inspect it separately from production totals:

  • Invalid room stays have missing or invalid arrival/checkout dates and cannot produce valid nights. The count follows the applicable room/currency selection, not a reliable stay-date cohort or rate-plan attribution.
  • Bookings without any usable stay dates cannot be assigned to the period. This is a feed-level exception count, not the selected rate-plan's canceled booking count.
  • Records without a booking identity cannot be safely grouped into distinct bookings. This feed-level count is records, not distinct bookings, and can include retained versions.

These exceptions can overlap. Do not add them to dated totals or treat them as a count of missing sales in the selected period.

Room-stay detail column reference

On-screen column Meaning
Reservation ChannelRUSH identifier for the current captured reservation version represented by the stay. Do not confuse it with a channel confirmation number.
Room-stay ID Identifier for the individual captured room stay. Separate rooms in a booking can have separate rows.
Channel room ID Recorded channel room identity, or Unknown.
Arrival Full stay's arrival date, displayed as yyyy-MM-dd.
Checkout Full stay's checkout date, displayed as yyyy-MM-dd; checkout does not contribute a night.
Full LOS Whole room-stay length, not just the nights within the report period.
Clipped nights Matching nights inside the selected dates and product filters.
Price rows Count of clipped nights with exactly one nightly price record with a nonblank price. Despite the label, it is not the count of all underlying price records.
Status Current Active or Canceled booking status.
Rate-plan ID Attributed plan for the included nights, Mixed nightly plans when those nights have more than one identity, or Unknown when the identity is blank.
Receipt lead days First retained receipt to arrival in the property timezone, or Unknown.
Value/date source version Reservation version supplying the stay dates and known value. Rate Plan Performance uses the (current) version; it does not recover a pre-cancellation version.
Currency Recorded currency, or Unknown.
Known value Qualified booked room-rate value for the matching nights of this stay. A dash means unavailable, not zero.

CSV field reference

The CSV uses a shared aggregate schema. It contains metadata and coverage fields in addition to the visible table columns. Dates use yyyy-MM-dd; ExtractedUTC includes its UTC offset. Monetary fields are numbers, with currency in a separate column. Percentage fields contain percentage values rather than fractions.

A normal row has RowState = Captured. If a feed has no aggregate rows, the file still contains a metadata row with RowState = No captured rows; row-level counts and measures are blank. Full-scope counts can be zero, while percentages with no denominator remain blank. This is not a zero-valued rate-plan row.

Scope and metadata headers

Exact CSV header Meaning
Contract Report definition identifier: captured-focused-production-v1 for this report.
Period Selected or Comparison. Here “Comparison” means another feed for the same dates, not a prior-year period.
PropertyId Property identifier for the result.
FeedId Reservation-feed identifier for this row's section.
Start First included stay date.
End Last included stay date. Checkout remains excluded from each stay.
View rateplan for Rate Plan Performance.
Grouping Shared-schema setting, normally month. Unused for this report's grouping: rows are grouped by rate-plan identity, currency and status, not month.
ExtractedUTC Time the feed's result was read, not reservation receipt time or a completeness watermark.
RevenueBasis Explanation of which booked room-rate amounts qualify and which taxes/fees are excluded.
Coverage Captured-feed coverage warning; property-wide completeness and historical coverage are unverified.
RoomFilter Applied channel room ID; blank means no room narrowing.
RatePlanFilter Applied channel rate-plan ID; blank means no plan narrowing.
CurrencyFilter Applied normalized currency filter; blank means all currencies.
IncludeCanceled True for this report. Active and canceled rows remain separate.
ComparisonAlignment Shared-schema period-alignment setting, normally none. Unused for the feed comparison here: it does not describe matched products, prior-year alignment or source overlap.
RowState Captured or No captured rows. Check this before interpreting blank row measures.
PropertyTimeZone Property timezone used for receipt-to-arrival timing.
TimingBasis Written qualification of the first-retained-receipt interval and unknown timing.

Row identity and measure headers

Exact CSV header Meaning
Currency Row currency; blank means unknown on a captured row.
Status Active or Canceled.
Bucket Displayed channel rate-plan identity, such as Rate plan … or Unknown rate plan.
Bookings Distinct bookings in this row, not an additive full-report total.
RoomStays Distinct room stays in this row.
RoomNights Clipped matching room nights.
PricedNights Nights with exactly one nightly price record with a nonblank price.
QualifiedNights Nights qualifying for monetary totals.
UnmappedNights Nights whose channel room does not resolve to exactly one current standard room target. This measures room mapping, not the rate-plan target shown in CurrentHotelRatePlanMapping. It is not a count of unsent bookings.
KnownBookedRateValue Qualified known booked room-rate value; blank if unavailable.
QualifiedADR Qualified value divided by qualified nights; blank without a qualifying denominator.
KnownValueSharePercent Row share of qualified known value within the same feed, currency and status; blank when unavailable.
MeanFullStayLOS Average full room-stay length, counted once per stay within this row.
TimedRoomStays Room stays with a usable first-receipt interval.
MeanFirstReceiptLeadDays Average receipt-to-arrival days for timed room stays only.
RoomNightSharePercent Row share of nights within the same feed, currency and status.
CohortCancellationPercent Current canceled-booking share for the same rate-plan and currency bucket, combining its active and canceled counts.
RecoveredBookings Shared recovery field. Unused here: zero on captured rate-plan rows because this report uses current versions, and blank on an empty metadata row. It does not prove that cancellation history is complete.
CanceledBookingValue Shared Cancellation Analysis field. Unused here and blank, including canceled rate-plan rows. Read KnownBookedRateValue for this report's qualified current-version amounts; do not fill this placeholder with a guessed loss.
CurrentHotelRatePlanMapping Current hotel rate-plan target explanation per contributing channel room, including missing or ambiguous targets.

Full-scope and exception headers

These values repeat on aggregate rows for the relevant feed. Do not sum the repeated values down the CSV.

Exact CSV header Meaning
UnattributedInvalidStays Invalid room-stay date count described under source exceptions. Not dated production and not necessarily attributable to the requested rate plan.
UnresolvedSourceIdentityRecords Feed-level records without a usable booking identity; not distinct bookings or a period-specific count.
FullScopeDistinctBookings Independently distinct bookings across this feed's full filtered selection.
FullScopeCanceledBookings Independently distinct canceled bookings in that full selection.
UnattributedBookings Feed-level current bookings without any usable stay dates. They cannot be assigned to the selected period; this count is not narrowed into a reliable product/date cohort.
FullScopeCancellationPercent Full-selection distinct canceled bookings divided by full-selection distinct bookings. Blank if there are no matching bookings.

Common problems

Symptom What to check and what to do
No captured stays match these filters Confirm the property and feed. Widen stay dates within the 366-day limit, clear product/currency filters and select Update report. Missing captured history does not establish zero property business. If you expect known captured stays to match, ask support to check the scope.
Comparison is empty while the selected feed has rows Raw product IDs are applied independently. Clear those filters or inspect the other feed using its own IDs. Do not assume that matching text identifies equivalent products.
Select a different comparison feed, or none. Choose another comparison feed or No comparison, then run the report again.
Dates are rejected, or only one endpoint is present Set both dates, put the end on or after the start, and keep the inclusive range at 366 days or fewer. Rerun the form rather than editing a copied report URL.
Invalid product or currency filter. Keep room and rate-plan IDs within 200 characters and currency within 10. Use the exact recorded IDs; remove unintended spaces from product IDs.
Counts are present but value or ADR is a dash Check the feed, currency and Priced / nights / Qualified nights coverage. Other feeds' amounts do not qualify for monetary totals here. Do not replace unknown amounts with zero.
A rate plan is unknown or has no clear current target Inspect the recorded nightly IDs, channel room and current mapping. Do not edit a mapping solely to make an analytical row disappear. Ask support if the identity or target cannot be reconciled.
Booking counts do not add up to the headline total A booking can span rate plans. Use the independently distinct full-selection count; do not sum per-plan booking counts.
Cancellation Analysis shows different canceled business Rate Plan Performance uses current versions; Cancellation Analysis can recover retained pre-cancellation stays. Check report definitions, dates, filters and extraction times before treating the difference as an error.
Receipt lead days are unknown or unexpectedly short Check timing coverage. Missing history, imports or post-arrival receipts can prevent a usable original-length interval. Do not treat receipt timing as the original sale date.
Property timezone is required for receipt timing. or Property timezone is not recognized. Ask your administrator or support to verify the property's timezone. Repeated report runs cannot repair that setting.
Detail is empty on a later page Reopen Filters and select Update report to return to page one. The current matching stays may have changed since the earlier request.
The CSV contains blank measures or repeated totals Check RowState and the shared unused fields above. A metadata-only empty row is not a captured zero-value row, and full-scope/exception figures must not be summed across rows.

For unresolved issues, provide the property, feed, stay-date range, applied filters, extraction time with its offset and exact warning. Avoid guest names, contact details, payment information and passwords in screenshots or messages.

Related