Compare channel production and booking-source mix

Marcus Cole

Marcus Cole

Last updated on Nov 18, 2026

Use Channel Production & Booking Source Mix to compare captured bookings and room nights by source within one reservation feed, then export the matching totals.

A reservation feed is how ChannelRUSH received a booking. A recorded source is the source attached to that booking, which may itself be an intermediary. This report does not establish the ultimate original sales channel, combine feeds or remove duplicates across feeds.

Before you start

Sign in with access to the property you want to review. You do not need an Org Admin role for this report. Select the property before opening it, and check which reservation feed contains the business you want to analyze.

This is a current captured stay-date report. It is not a report of bookings made during the selected dates, cancellations received during those dates, or a historical snapshot of what you knew on an earlier day. It does not establish total hotel occupancy or complete property revenue.

Run the report

  1. Select the property in Channel Manager.
  2. Open Reports → Channel Analytics → Channel Production & Booking Source Mix.
  3. In Filters, choose Stay dates (through inclusive). Select both dates, or use Month to fill a whole month. The maximum range is 366 days.
  4. Select Reservation feed explicitly. The initial selection is not proof that this feed contains the reservations you need.
  5. If needed, expand Narrow by product or currency and enter an exact Channel room ID, Channel rate-plan ID, or Currency. Leave a field blank to apply no restriction for that field.
  6. Click View report.
  7. Check the property, transport feed and stay-date range above the result.

After a report loads, expand Filters, change the required fields and click Update report. Changing an input alone does not update the result. Each submission reads the captured data again; it does not send inventory or change reservations.

Expanded report filters with stay dates, reservation feed, exact product filters and Update report

The filter form in a narrow window. Wider windows arrange controls side by side. The example uses Booking.com; select the feed appropriate to your property.

Choose the view

The menu opens Booking Source Mix. The two tabs use the same property, feed, dates and product/currency filters. Clicking a tab runs that view.

  • Channel Production separates individual source identities, such as ChannelRUSH Booking Engine, Booking.com and Expedia. An unrecognized recorded identity is labeled Unclassified recorded source with its ID; a missing source can appear as Unknown original source.
  • Booking Source Mix combines those identities into the reporting classes below. These are classification rules, not a guarantee about the original sale behind an intermediary.
Class What it includes
Direct ChannelRUSH Booking Engine source.
OTA Booking.com and Expedia sources.
Other (CRS interface) ChannelRUSH CRS source; the interface alone does not establish a direct booking.
Unknown Other or missing source identities. A known source name or ID is not enough to classify it as Direct, OTA or GDS.

When a booking has a recorded source, the report uses it. Without one, it can recognize the Booking Engine, Booking.com or Expedia feed as the origin. Other feeds remain unknown rather than being assigned an assumed source.

Attribution tells you whether a row uses a recorded source, a recognized feed origin, an unknown original source, or mixed attribution evidence. Expand Source attribution, definitions and coverage to review these qualifications alongside the result.

Check and interpret the result

Check the property, transport feed and dates first. The heading gives distinct captured bookings and currently canceled bookings for the full matching selection. The aggregate table separates source, currency and status.

  • The report uses each booking's latest captured version in the selected feed. Changes or cancellations can therefore change the result of a later run for the same dates.
  • Stay dates include the selected final date; checkout is excluded. Only nights inside the range contribute. A stay can begin before the selected start or end after the selected end.
  • Active and canceled bookings are always included, but shown separately. There is no status selector on this report.
  • Canceled stays use their current captured dates. The report does not recover an earlier stay itinerary to reconstruct cancellation history.
  • Currency totals are separate. There is no currency conversion, and feeds are never pooled.

No captured stays match these filters means no matching captured stays were found for this selection. It does not prove there were no bookings at the property, no channel sales, or successful reservation delivery.

Empty Channel Production result showing the selected feed, date range, coverage section and room-stay detail

An empty demo result in the standalone window. The coverage and detail sections remain available; this is not an example of populated production totals.

Money and price coverage

A priced night has exactly one captured nightly price record with a nonblank amount. A zero price is a valid recorded amount. A missing price, duplicate price records or a blank amount is not converted to zero.

A qualified night must also come from the ChannelRUSH Booking Engine feed and have a recorded currency. Only qualified nights contribute to Known value and ADR. Other feeds can have priced nights while monetary totals remain unavailable.

Known value represents booked room-rate amounts, including tax already embedded in those rates but excluding separately stored fees and taxes. It is not realized revenue, profit, commission-adjusted net revenue or all money collected from a guest.

A dash means unavailable, not zero. Qualified zero-priced nights can produce a known value and ADR of zero. Value share is unavailable when the qualifying denominator is not positive. Missing room mappings do not, by themselves, remove valid captured nights or disqualify an otherwise qualified price.

Shares and cancellation

Booking share, night share and value share compare rows within the same currency and status. Do not read them as shares of all hotel sales or add percentages across currencies or active/canceled groups.

Current cohort cancellation is canceled bookings divided by active plus canceled bookings in the same source bucket and currency, using the currently matching stays. The same percentage can appear on both that bucket's Active and Canceled rows. It is not the percentage of cancellations received during the selected dates.

Coverage exceptions and extraction time

The coverage section reports invalid stays and records without booking identity. Invalid or missing stay dates cannot establish production in a particular stay period. Records without booking identity are a property/feed data-quality count, not necessarily records from your selected dates. These exception counts are not extra nights to add to the report.

Extracted is when the report read the captured records, not when the channel last updated them. A recent extraction does not establish fresh or complete channel data.

Inspect supporting room stays

  1. Expand Selected feed room-stay detail.
  2. Check the matching-stay count and current page.
  3. Use the available previous/next page controls when there are more results.

Detail shows at most 100 room stays per page, ordered by arrival and then reservation/room-stay identity. The aggregate totals above it cover the full matching selection, not only the visible detail page.

The Reservation value here is an internal captured-record reference, not necessarily the channel's booking number. This report does not provide a clickable reservation drilldown. Use Reservations → Search when you need to investigate a booking, choosing that screen's own search criteria and submitting its search.

Inventory and restriction context opens the Channels report for the current property. It does not carry this report's dates, reservation feed or product filters; set the required scope again on that screen. It is contextual navigation, not evidence that inventory caused the booking pattern.

Download or open separately

  • Click CSV in the Download area to export the current view's aggregate rows. The file includes the full aggregate selection, not the paged room-stay detail. It is not an Excel workbook or a guest/reservation-detail export.
  • An empty result exports a metadata row with RowState = No captured rows. Do not count it as a booking or replace its blank measures with assumed zeros.
  • Downloading runs the query again. The CSV can differ from an earlier screen if captured records have changed; compare ExtractedUTC and the scope fields.
  • Click New window to open the report separately while keeping the original page. It removes the ordinary navigation chrome. Subsequent tab, filter or detail-page navigation can return to normal chrome; use New window again if needed.

There is no report-specific Copy to Clipboard or Excel control on this page.

Filter reference

Field Meaning and accepted input
Property selector One property you can access. Check the property printed in the result; the report is not an organization-wide total.
Month Shortcut that fills a whole calendar month into the stay-date range. Submit the report afterward.
Stay dates (through inclusive) Both dates are required by the form. Start must not be after end; maximum 366 inclusive days. Initially covers the property's current date and the following 29 days. Checkout is excluded from occupied nights.
Reservation feed One transport feed at a time. Initially favors the connected Booking Engine feed; otherwise a connected channel is selected. Check it rather than relying on the default.
Channel room ID Exact channel room identifier, not a room name or standard-property room ID. Optional; maximum 200 characters. Blank removes this restriction.
Channel rate-plan ID Exact channel rate-plan identifier. Applied to the captured nightly rate-plan identity, falling back to the room-stay identity when needed. A matching stay can contribute only its matching nights. Optional; maximum 200 characters. Blank removes this restriction.
Currency Exact captured currency code, for example USD or EUR. Leading/trailing spaces are removed and letters normalized to uppercase. Maximum 10 characters; this is a filter, not a currency-conversion setting. A code with no matching captured data returns no rows.

On-screen column reference

Aggregate table

Column Meaning
Source Individual source identity in Channel Production; reporting class in Booking Source Mix.
Class Direct, OTA, Other (CRS interface), or Unknown under the classification rules above.
Attribution Recorded source, recognized feed origin, original source unknown, or mixed evidence. Recorded source may be an intermediary.
Currency Recorded currency, or Unknown when absent. Separate currencies must not be totaled together.
Status Active or Canceled, based on the latest captured booking version.
Bookings Distinct captured bookings represented by this row.
Booking share Percentage of bookings in the same currency/status group.
Room stays Distinct room stays represented by this row. The meter compares the count with the largest row, not property capacity.
Nights Matching stay nights clipped to the selected date range and product filters.
Night share Percentage of nights in the same currency/status group.
Priced / nights Nights with exactly one recorded nonblank price, followed by all matching nights. This is price coverage, not qualified monetary coverage.
Qualified nights Priced nights eligible for monetary totals under the Booking Engine feed/currency rules.
Known value Sum of qualified booked room-rate amounts. Dash means unavailable.
Value share Percentage of known qualified value in the same currency/status group; unavailable without a positive denominator.
ADR Known value divided by qualified nights, not by all nights.
Current cohort cancellation Canceled bookings divided by active plus canceled bookings in the same source bucket and currency.

Selected feed room-stay detail

Column Meaning
Reservation Internal reference for the current captured booking record.
Room-stay ID Internal reference for this room stay.
Channel room ID Room identifier recorded in the selected feed.
Arrival / Checkout Full captured stay boundaries, not clipped to the report dates. Checkout does not count as an occupied night.
Full LOS Full length of stay in nights, even when the selected range includes only part of it.
Clipped nights Matching nights that remain inside the selected range and product filters.
Price rows Despite the label, the count is priced nights within that clipped selection—not the total number of raw price records.
Status Active or Canceled for the current booking version.
Recorded source ID Source identity used by the report. It can be a recognized-feed fallback, not only an explicitly recorded source. Check aggregate Attribution before interpreting it.

CSV field reference

These are the exact export headers, in file order. They differ from the on-screen labels. Dates use yyyy-MM-dd; numbers use a decimal point. A blank amount means unavailable. Fields retained from the shared export format do not imply additional controls on this report.

Header Meaning
Contract Report definition identifier: captured-source-production-v1.
Period Selected for this report.
PropertyId Selected property identity.
FeedId Selected transport feed identity.
Start First selected stay date.
End Last selected stay date, inclusive.
View production or source-mix.
Grouping Shared-format metadata, normally month; it does not make this report a monthly grouped report.
ExtractedUTC Query extraction timestamp in UTC; not the last channel update.
Currency Recorded currency; blank when unknown or when the row has no captured measures.
Status Active or Canceled; blank for an empty-result metadata row.
Bucket Individual source label or source-class bucket.
Bookings Distinct bookings in the bucket/currency/status row.
RoomStays Distinct room stays in that row.
RoomNights Matching clipped nights.
PricedNights Nights with exactly one recorded nonblank nightly price.
QualifiedNights Nights qualifying for monetary totals.
UnmappedNights Matching nights without a recognized current room mapping. These nights can still be counted; this is not a delivery-failure count.
KnownBookedRateValue Sum of qualified booked room-rate values; blank when unavailable.
QualifiedADR KnownBookedRateValue divided by QualifiedNights; blank when unavailable.
KnownValueSharePercent Same-currency/status known-value share; blank when unavailable.
RevenueBasis Explanation of the qualified monetary basis.
Coverage Qualification that captured feed coverage and property-wide completeness are not established.
RoomFilter Applied exact channel room filter; blank means unrestricted.
RatePlanFilter Applied exact channel rate-plan filter; blank means unrestricted.
CurrencyFilter Applied normalized currency filter; blank means unrestricted.
IncludeCanceled True; this report always includes canceled and active business separately.
ComparisonAlignment Shared-format metadata, normally none; this page has no prior-year comparison selector.
UnattributedInvalidStays Invalid-stay exceptions that cannot be assigned to the selected stay period; not extra matching bookings.
UnresolvedSourceIdentityRecords Records without a usable booking identity in the property/feed; not a count of unknown sales channels or a stay-date total.
RowState Captured for an aggregate row; No captured rows for an empty-result metadata row.
BookingSharePercent Booking share within the same currency/status group.
RoomNightSharePercent Night share within the same currency/status group.
RecordedSourceId Source identity when the bucket has one. Can be zero for unknown or blank when a source class combines identities.
SourceClass Reporting class: Direct, OTA, Other (CRS interface), or Unknown.
SourceAttribution Explanation of the source evidence used.
CohortCancellationPercent Current matching cohort cancellation percentage for the same bucket and currency.

Repeated scope and exception metadata belong to the report, not separately to every row. Do not sum those metadata fields across rows. Spreadsheet-sensitive text can carry a protective leading apostrophe in the CSV.

Common problems

No captured stays match these filters → The selected feed, dates or exact product/currency filters may not match retained data. Reopen Filters, verify the feed, clear optional narrowing and click Update report. If expected bookings remain missing, give support the property, feed, stay dates, filters and extraction time. Do not resend bookings or inventory to populate this report.

Prices exist, but Known value or ADR is a dash → Priced nights are not necessarily qualified nights. Check the feed, currency and Qualified nights. Non-Booking Engine feeds do not supply qualified monetary totals here. If Booking Engine values still appear incomplete, ask support to examine the captured price coverage; do not treat missing amounts as zero.

A source is Unknown or appears under an unexpected class → A recorded identity may be missing, unclassified or an intermediary. Compare Channel Production with Booking Source Mix and inspect Attribution. Ask support with the source label/ID and selected feed if the evidence remains unclear; do not relabel it as direct business based only on a name.

“Select an ordered stay-date range of at most 366 days.” → Correct the date order or reduce the range, then submit again. For an incomplete range, supply both dates. The error is not a completed report.

“Invalid product or currency filter.” → Shorten the room/rate-plan identifier to at most 200 characters or the currency filter to at most 10, verify the exact identifier and submit again. Clear the filter if you do not know it.

Populated totals but empty room-stay detail, or “Invalid detail page.” → A copied or old URL may point beyond available detail. Reopen the report from Reports, reapply the filters and run it from the first page. If the mismatch persists, provide support the report URL, scope and extraction time.

CSV and the screen differ → Check view, feed, dates and narrowing first. CSV contains aggregates rather than paged detail and is read again at download time. Run the report again and compare timestamps. If identical scope still produces an unexplained discrepancy, send support the relevant aggregate rows and timestamps, without passwords, payment details or unnecessary guest data.

Related