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](https://support.channelrush.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBZ3dDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--db1222e941840b175954d18bc5f7481a25632f7f/rate-plan-performance-filters.png)

*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

- [Analyze cancellation cohorts and canceled booking value](https://help.channelrush.com/hc/channelrush/articles/cancellation-analysis)
- [Choose filters for a rates and availability report](https://help.channelrush.com/hc/channelrush/articles/channels-report-filters)
