Use Booking Patterns to compare captured room stays by full stay length, seasonal stay dates or the interval between first receipt and arrival, then export the selected aggregates.
Before you start
Select the intended property. You need access to that property and its reports. This report reads reservations already captured by ChannelRUSH; it does not change reservations, rates or availability.
Each run covers one property and one Reservation feed. A feed identifies the channel through which ChannelRUSH received the reservation, not necessarily the original selling source. Do not add separate feeds together without checking for overlapping bookings.
These are current captured booking results—not physical occupancy, realized accounting revenue, complete hotel production or a historical on-the-books snapshot.
Open and run the report
- Select your property in the property selector.
- Open Reports → Revenue Analytics → Booking Patterns. This entry opens Booking Window × LOS × Weekday. The Length of Stay and Seasonal Trends menu entries open the other views of the same report.
- Choose the view you want using the tabs above Filters.
- Set Stay dates (through inclusive). You can choose Month to fill a whole month, or enter a start and end date. Use an ordered range of at most 366 days.
- Select Reservation feed. Check it explicitly rather than assuming the default is the feed you want.
- If needed, enter Channel room ID, Channel rate-plan ID or Currency. Leave these blank to avoid that restriction.
- Select Booking status: Active only or Active and canceled, kept separate.
- For Seasonal Trends, choose Group by and Compare with prior-year production.
- Click View report. After a report has loaded, expand Filters, make your changes and click Update report.
Changing a filter is not the same as running the report. Check the loaded dates and feed after submitting. Switching view tabs retains the current report selection and returns supporting detail to its first page. Submit changed filters before switching tabs.
Reset report clears the selection while keeping the named view. The initial date range runs from today in the property's time zone through the following 29 days; it is not a lookback period.
Check the result
Confirm the property, feed, dates and active view before comparing figures. In Seasonal Trends, also check the actual comparison dates shown above the results.
- The aggregate tables cover the full matching selection. Paging the supporting stays does not narrow those totals.
- No captured stays match these filters means the query found no matching captured stays. It does not establish zero bookings or complete data coverage for the property.
- Extracted is the report extraction time, not the latest reservation update or proof that the feed is current. Downloads rerun the query, so an export and an earlier screen can differ if reservations changed.
- A dash (—) means unavailable, not zero. A recorded zero price can be valid data; it is different from a missing price.
- Currency and current booking status stay separate. Do not add different currencies together or treat canceled value as active production.
Expand How to read this report in Length of Stay or Seasonal Trends, or Definitions and coverage in the booking-window view, for the report's coverage qualifications.
Choose the right view
Length of Stay
This view groups each room stay by its whole stay length, including nights outside your selected interval. Buckets are 1, 2, 3, 4–6, 7–13 and 14+ nights.
Room nights and monetary values include only the nights inside your selected dates. Checkout is excluded. A multi-room reservation contributes separate room stays; it does not become one longer stay. The small bars beside Room stays show relative stay counts, not revenue.
A booking with rooms in different buckets can appear in more than one row. Do not sum row booking counts and call the result a distinct-booking total.
Seasonal Trends
Use this view to group stay nights, rather than arrivals, by:
- Calendar month: each calendar month touched by the interval.
- Day of week: the weekday on which the stay night falls.
- Weekday or weekend: Monday–Friday versus Saturday–Sunday.
Under Compare with prior-year production:
- No comparison shows only the selected interval.
- Same calendar alignment starts one calendar year before the selected start and preserves the selected interval's length.
- Aligned weekdays adjusts the prior-year start to the nearest matching weekday and preserves the interval's length.
Read the displayed dates, especially around leap years. Selected and comparison periods appear separately and are extracted separately. This is current captured production for those periods, not the amount that was on the books at the same time last year. No percentage uplift is calculated for you.
Edge months can be partial. Future stay dates contain current on-the-books business. Compare like-for-like intervals, currencies and statuses, and check coverage before drawing conclusions.
Booking Window × LOS × Weekday
This view crosses three dimensions:
- Receipt window: days from the first retained receipt in ChannelRUSH to arrival, calculated using the property's local dates.
- Full LOS: the entire room stay's length, not only the selected nights.
- Arrival weekday: the weekday the guest arrives—not the weekday of every occupied night.
Receipt bands are 0–3, 4–7, 8–14, 15–30 and 31+ days, plus Unknown receipt interval. Read the band labels; their displayed order is not necessarily chronological.
First retained receipt is not the original sale time. Imports and missing retained history can shorten the measured interval. Missing timing, a first receipt after arrival, or timing without a verified UTC offset remains unknown. Do not turn unknown intervals into same-day bookings.
Mean receipt lead days uses only timed room stays. Mean full LOS counts each room stay once within its dimension row, not once per selected night. The headline distinct bookings is calculated across the full selection; row booking counts can overlap.
Understand counts, prices and coverage
The report uses the current captured reservation version. Active includes current new or modified reservations; a reinstated booking is active. When canceled business is included, its available current-version stay dates are used. Booking Patterns does not recover missing pre-cancellation dates for you.
A stay contributes nights only where its dates overlap the selected interval, excluding checkout. Valid nights remain included even when prices or current room mappings are missing.
A priced night has exactly one recorded nightly price with a nonblank amount. Missing prices, null amounts and duplicate price records do not qualify as priced nights. A recorded zero amount does qualify.
Monetary totals are more restrictive: qualified nights require a booking-engine feed price and a known currency. Other reservation feeds can show counts and priced-night coverage without qualified value or ADR. Booking-engine room-rate value includes any tax already embedded in the room rate and excludes separately stored fees and taxes. It is not collected revenue or profit.
ADR divides known qualified room-rate value by qualified nights, not by every captured room night. A high ADR with low price coverage should not be treated as a complete average for the property.
Unmapped room nights have no single resolved current standard room target. Missing or ambiguous current mappings do not remove otherwise valid nights. They also do not prove what the mapping was when the booking arrived.
Known-value and night shares are calculated within the selected feed, currency and status. Known-value shares exclude unavailable amounts; a share is unavailable when its applicable value total is not positive.
Source-exception messages describe records without booking identities, invalid room-stay dates or bookings without usable dates. These diagnostics cannot all be assigned to the selected stay period, can overlap and must not be added to dated totals as lost bookings.
Inspect supporting room stays
- Expand Selected feed room-stay detail below the aggregate report.
- Review the dates, full stay length, clipped nights and recorded identifiers.
- Use the pager when more matching stays are available. Each page contains at most 100 room stays; the aggregates above still cover the full selection.
- Where a Reservation link is available, open it to inspect the supporting current reservation version.
Supporting stays cover the entire selected report, not one LOS bucket or cross-analysis cell. The reservation screen shows the whole booking; the report counts only matching stay nights. Reconcile those different scopes before treating differing totals as an error.
The detail is ordered by arrival and then its recorded identifiers. It is not an editable inventory grid, and this report does not provide configurable detail sorting, search or page size.
Export or open a separate view
After the report has loaded:
- Choose CSV under Download for the full aggregate table. This is not a download of the supporting room-stay pages. Seasonal exports include both selected and comparison periods when comparison is enabled.
- Choose New window for the same selection without the application's normal navigation. Check the dates and feed in that view too.
An empty period still exports a row with RowState = No captured rows. Its blank aggregate fields are not measured zero values. The extraction timestamp belongs to that export run, not to a fresh vendor response.
CSV uses invariant numeric formatting and ISO-style dates. Unavailable numeric values are blank. Text that could be interpreted as a spreadsheet formula can have a protective leading apostrophe. This report's download is CSV; it does not offer a dedicated Excel workbook, PDF or Copy to Clipboard control.
Filter reference
| Field or control | Meaning and accepted selection |
|---|---|
| Property selector | One property you are authorized to access. Verify it before opening the report. |
| View tabs | Booking Window × LOS × Weekday, Length of Stay or Seasonal Trends. |
| Month | Shortcut that fills a whole calendar month; run or update the report afterward. |
| Stay dates (through inclusive) | Start and end stay dates, including both bounds but excluding each reservation's checkout. Maximum 366 days; supported years are 2000–2100. Provide both dates. |
| Reservation feed | One recorded delivery feed. The report does not combine feeds. |
| Channel room ID | Exact channel-side room identifier, up to 200 characters. This is not the standard room name. Blank means all matching room IDs. Spaces are significant. |
| Channel rate-plan ID | Exact channel-side rate-plan identifier, up to 200 characters. Blank means no rate-plan restriction. Recorded nightly IDs can differ from the room's fallback plan; conflicting nightly identities remain unknown. |
| Currency | Recognized currency code, such as USD. Leading/trailing spaces are removed and letters are uppercased. Blank means no currency restriction; it does not convert currencies. |
| Booking status | Active only, or Active and canceled kept separate. No canceled-only option on this report. |
| Group by | Seasonal only: Calendar month, Day of week, Weekday or weekend. Initial choice is Calendar month. |
| Compare with prior-year production | Seasonal only: No comparison, Same calendar alignment or Aligned weekdays. Initial choice is No comparison. A retained comparison selection on another tab does not create a comparison table there. |
| View report / Update report | Applies the displayed criteria and reads the report. |
| Reset report | Clears the selection and retains the named view. |
On-screen column reference
Length of Stay and Seasonal Trends aggregates
| Column | What it measures |
|---|---|
| Full-stay LOS / Stay-date period | Whole-stay bucket for LOS; selected seasonal grouping for Seasonal Trends. |
| Currency | Recorded currency, or Unknown. If every row has the same currency, it appears above the table instead. |
| Status | Active or Canceled. If every row has the same status, it appears above the table instead. |
| Bookings | Distinct captured bookings in that row; counts across rows can overlap. |
| Room stays | Distinct room stays in that row. The adjacent bar represents this count. |
| Room nights | Nights inside the selected interval, excluding checkout. |
| Priced nights / nights | Nights with one recorded non-null price, beside all matching nights. |
| Qualified priced nights | Priced booking-engine nights with a known currency, used for monetary calculations. |
| Unmapped room nights | Matching nights without one resolved current standard room target. |
| Known booked room-rate value | Sum of qualified nightly prices, separated by currency and status. |
| ADR on qualified nights | Qualified value divided by qualified nights. |
| Known value share | LOS only: this row's percentage of qualified value within its currency/status group. |
Booking-window cross-analysis aggregates
| Column | What it measures |
|---|---|
| Receipt window × full LOS × arrival weekday | First-retained-receipt band, whole-stay bucket and arrival weekday. |
| Currency / Status | Recorded currency and current booking status; these remain explicit columns. |
| Bookings / Room stays | Distinct bookings and room stays within the row. |
| Clipped nights | Matching nights inside the selected interval. |
| Priced / nights | Priced nights beside all matching nights. |
| Qualified nights | Nights eligible for monetary totals. |
| Known booked room-rate value / Qualified ADR | Qualified value and value divided by qualified nights. |
| Night share | Row's share of clipped nights within the same currency and status. |
| Known value share | Row's share of qualified value within the same currency and status. |
| Mean full LOS | Mean whole-stay length, counting each room stay once per row. |
| Mean receipt lead days | Mean receipt-to-arrival interval among timed stays only. |
| Timed / room stays | Stays with usable receipt timing beside all room stays in the row. |
Supporting detail
| Column | What it identifies |
|---|---|
| Reservation | ChannelRUSH reservation-version identifier; where linked, opens its supporting reservation. |
| Room-stay ID | Recorded room stay within the reservation. |
| Channel room ID | Recorded channel-side room identifier, or Unknown. |
| Arrival / Checkout | Whole-stay dates, not the clipped interval. |
| Full LOS | Whole-stay night count. |
| Clipped nights | Nights matching the selected interval and product filters. |
| Price rows | Despite the label, this is the count of qualifying priced nights, not a raw count of stored price records. |
| Status | Current Active or Canceled state. |
| Rate-plan ID | Cross-analysis only: matching nightly plan identity, Unknown, or Mixed nightly plans. |
| Receipt lead days | Cross-analysis only: usable first-retained-receipt interval, or Unknown. |
| Value/date source version | Cross-analysis only: current reservation version supplying dates and value. |
| Currency / Known value | Cross-analysis only: recorded currency and the stay's qualified value for matching nights. |
CSV field reference
These are export headers, not additional editable controls. Fields can be combined below for explanation, but their names are shown exactly.
Fields in every Booking Patterns CSV
| Header | Meaning |
|---|---|
| Contract | Export definition identifier; useful when comparing files or contacting support. |
| Period | Selected or Comparison. |
| PropertyId / FeedId | Property and reservation-feed identities for that period. |
| Start / End | Inclusive stay-date bounds for that period. |
| View | los, seasonal or crossanalysis. |
| Grouping | month, weekday or weekend; seasonal grouping setting, not an extra dimension on other views. |
| ExtractedUTC | UTC extraction instant for this period's query. Not feed freshness. |
| Currency / Status / Bucket | Aggregate row's recorded currency, current status and grouping label. Missing currency can be an empty field. |
| Bookings / RoomStays / RoomNights | Row booking, room-stay and clipped-night counts. |
| PricedNights / QualifiedNights / UnmappedNights | Price-record coverage, monetary-qualified nights and current room-mapping gaps. UnmappedNights is also exported for cross-analysis although its visible aggregate table omits it. |
| KnownBookedRateValue / QualifiedADR | Qualified value and value per qualified night; blank when unavailable. |
| KnownValueSharePercent | Qualified value share for LOS and cross-analysis. Blank for Seasonal Trends. |
| RevenueBasis / Coverage | Explanations of amount qualification and capture limitations. |
| RoomFilter / RatePlanFilter / CurrencyFilter | Applied optional filters; blank means that filter is unrestricted. |
| IncludeCanceled | True includes canceled business separately; False means active-only. |
| ComparisonAlignment | none, calendar or weekday. A setting retained on LOS or cross-analysis does not mean a comparison was run. |
| UnattributedInvalidStays | Diagnostic invalid-date room-stay count, not a dated production measure. |
| UnresolvedSourceIdentityRecords | Feed records lacking booking identity; not necessarily distinct bookings or records from this stay period. |
| RowState | Captured for an aggregate row, or No captured rows for an empty-period metadata row. |
Additional fields in cross-analysis CSV
| Header | Meaning |
|---|---|
| PropertyTimeZone | Property time-zone identifier used for receipt-to-arrival dates. |
| TimingBasis | Qualification text explaining first retained receipt, missing timing and original-sale limits. |
| MeanFullStayLOS / TimedRoomStays / MeanFirstReceiptLeadDays | Row's mean full LOS, timed stay count and mean usable receipt lead. |
| RoomNightSharePercent | Clipped-night share within the same currency and status. |
| FullScopeDistinctBookings / FullScopeCanceledBookings | Distinct bookings and canceled bookings across the entire selected scope. These totals repeat on rows; do not sum them. |
| UnattributedBookings | Diagnostic bookings without usable stay dates; not an additional dated total. |
| RecoveredBookings | Zero on captured cross-analysis rows: this view does not recover pre-cancellation versions. Blank on an empty-period metadata row. Zero is not proof that cancellation history is complete. |
| CohortCancellationPercent / FullScopeCancellationPercent | Unused here and blank; shared with other reports' export schemas. |
| CanceledBookingValue / CurrentHotelRatePlanMapping | Unused here and blank. These fields do not establish recovered canceled value or current rate-plan mapping. |
On an empty-period metadata row, row-specific counts, labels and amounts are blank. Scope-level diagnostics and cross-analysis distinct-booking totals can still be zero. Read RowState before interpreting either.
Common problems
- No captured stays: the dates, feed or exact product filters may exclude the records you expected. Expand Filters, verify the feed, clear optional filters and choose a relevant stay interval; click Update report. If expected bookings remain absent, contact support with the property, feed, date range and report URL. Do not assume the property had no business.
- Nights appear but value or ADR is a dash: the feed may not qualify for monetary totals, or price/currency coverage is missing. Inspect priced and qualified nights. Do not replace unavailable values with zero or use another currency as a substitute. Ask support to investigate unexpected missing booking-engine coverage.
- Unknown receipt interval or unexpectedly short lead time: retained receipt timing is missing, invalid or later than the original sale. Imports can also shorten it. Inspect the supporting stay; use a qualified original-sale source for decisions requiring original booking lead time. Escalate unexplained timing with the property, feed and relevant reservation reference, not guest/payment details.
- Selected dates differ from a reservation's dates: the report clips nights to its selection, while LOS and Reservation show the whole stay. Compare the same units and check the product filters before escalating.
- Prior-year dates or figures look different: inspect the actual comparison bounds, alignment, partial months and retained coverage. Equal-length prior-year production is not a historical pace comparison. Repeated runs cannot manufacture missing history.
- Dates, currency or another filter is rejected: correct the identified field and run again. Supply both dates, keep the end on or after the start, stay within 366 days and use a recognized currency code. If a copied URL contains unsupported controls, reopen the report through its menu or use Reset report rather than editing unfamiliar query options.
- CSV and screen disagree: check property, feed, dates, view, status, currency and extraction times. CSV includes the complete aggregate selection; the supporting detail is paged. If equivalent runs still disagree, provide both selections and their extraction times to support.
Rerunning this report is a read operation, not an inventory resend or a reservation correction. Do not change operational data merely to make a report warning disappear.