Use Portfolio Overview to compare captured room nights, booked room-rate value and qualified ADR across selected properties, keeping currencies and active or canceled business separate.

## Before you start

- Open **Channel Manager > Reports > Portfolio Overview** in the organization you want to review.
- You can select active properties in the current organization. Organization administrators can select the organization's available properties; other users can select properties assigned to them. You must also have access to the property you are currently viewing.
- Choose one reservation feed for each report. A feed offered in the list may serve only some of the available properties.

**This is a captured-business report, not a complete hotel-performance statement.** It includes reservations received through the selected feed. It does not establish total property occupancy, RevPAR, settled revenue, profit or feed completeness. A property with no captured stays is not necessarily an empty hotel.

## Run a comparison

1. Open **Channel Manager > Reports > Portfolio Overview**.
2. In **Filters**, choose **Stay dates (through inclusive)**. Use **Month** for a whole calendar month, or choose a custom start and end date.
3. Choose the **Reservation feed**. For booked room-rate value and ADR, select **ChannelRUSH Booking Engine**. Other feeds can provide counts, but their monetary value is not qualified in this report.
4. Choose **Currency** and **Business status**. Leave currency at **All currencies, kept separate** if you want separate totals for each captured currency.
5. Under **Properties**, tick the properties to compare. Review the selected count. You must select at least one and no more than 200.
6. Optionally enter a **Country code**, **City (exact)** or a different **Opportunity creation window (days)**.
7. Click **View report**.

The **Filters** panel collapses after the report loads. Reopen it to change the selection, then click **Update report**. Editing a date, feed or property checkbox alone does not update the results. Existing table searches and filters remain when you update the report; use **Reset table** if you want to remove them.

![Portfolio Overview Filters with stay dates, reservation feed and three selected demo properties](https://support.channelrush.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBZzhDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--336036c9a6572e222b0d4a37d912848d4396b28c/portfolio-overview-filters.png)

*Reopen Filters to review or change the report selection.*

### Check the result

Check the displayed stay dates, reservation feed, business status and property selection before comparing figures. The property name in the report card header is your current property context, not the full list of properties included in the report.

You should see:

- Summary cards with **Room nights**, **Qualified nights**, **Known booked value** and **Weighted ADR**, separated by currency, status and value basis.
- A **Properties** table with the matching property rows.
- **Matching table totals**, which reflect the table's search and column filters.
- **Feed-wide exceptions** and an expandable **Recent opportunity records** section.

After an update, check that the results reflect your selection. While an update is in progress, the previous results remain visible. If an update fails, those previous results are retained; do not treat them as the new selection.

**Extracted** is when ChannelRUSH read the report data. It is not the time of the last reservation-feed update. Opening a report or downloading it again can produce different values if the underlying records have changed.

## Understand the figures

### Stay dates, bookings and nights

The report uses each property's local stay dates. The start and end dates are inclusive, but checkout is excluded. Only nights that fall inside the selected period count; a reservation can contribute even if its arrival is before the start date.

- **Bookings** counts distinct captured reservations contributing nights to a property/currency/status row.
- **Room stays** counts the reservation's individual room-stay records contributing those nights. One booking can contain several room stays.
- **Room nights** counts those room stays' nights inside the selected period.

The report uses the latest captured reservation version for each source booking identity. It is a current view of the selected stay dates, not a historical snapshot of what was on the books on an earlier date.

**Active** includes new and modified, noncanceled business. **Canceled** is reported separately and is not subtracted from Active. When both are selected, do not combine them as a net active total.

### Known value and ADR

For **ChannelRUSH Booking Engine**, a night contributes to **Known value** only when it has exactly one recorded, nonblank nightly price and a recorded currency. The amount is booked room-rate value, including tax embedded in that rate and excluding separately recorded fees or taxes.

- **Priced nights** have exactly one recorded, nonblank nightly price.
- **Qualified nights** additionally meet the report's feed and currency requirements for monetary value.
- **Known value** sums only qualified nightly prices. It can be a partial amount if other nights lack qualified prices.
- **Qualified ADR** divides known value by qualified nights, not by all room nights.
- **Weighted ADR** uses the combined known value divided by combined qualified nights within the same currency, status and basis. It is not an average of property ADRs.

For other feeds, **Counts only; monetary basis unqualified** means that counts may be available but this report does not use their recorded prices for known value or ADR.

An em dash (**—**) on screen or a blank monetary cell in an export means unavailable or unqualified, not zero. A recorded price of zero can be a valid known value. No currency conversion takes place: compare like currencies and value bases.

### Exceptions and coverage

- **Unmapped nights** have no single unambiguous room-type mapping under the property's current mappings. The report uses current mappings, not historical ones. An unmapped night is not automatically excluded from the room-night count or from otherwise qualified value.
- **Invalid stays** have missing arrival or departure dates, or checkout on or before arrival. They cannot contribute valid stay nights. This count follows the selected feed, status and currency, but cannot be limited to the selected stay dates.
- **Missing identity rows** are captured reservation rows without a usable source booking identity. They are excluded from the booking/night calculation. This count is feed-wide for the property, not limited to the selected stay dates, status or currency, and is not a count of distinct bookings.

Property exceptions can repeat on several currency/status rows. Do not add those repeated counts. The summary exception line counts each property's exception figures once.

A **No captured stays** row preserves the property in the comparison when it has no valid matching nights. Its booking, room-stay and night counts are zero and its monetary values are unavailable. Invalid-stay and missing-identity exception counts can still be present. Check the feed, dates and filters before interpreting it.

## Refine the property table

**Report filters and table filters have different scopes.** The report's summary cards and **Download report** files use the report selection. Searching or filtering the Properties table changes the matching rows, matching table totals and matching-table downloads only. It does not change the report totals or recent opportunity records.

1. In the table's **Search** box, enter part of a property name, country or city and press **Enter**. Search is case-insensitive and checks those three fields, not property IDs.
2. Use a column's filter menu to add a condition. All conditions must match. Use the **Property ID** column filter to find a specific ID.
3. Click a supported column heading to sort. You can use up to three sort fields.
4. Drag **Country** or **City** into the grouping area to group properties. These are the only grouping fields; both can be used. Group totals still keep currencies, statuses and value bases separate.
5. Choose **25**, **50** or **100** rows per page and use the page controls. The default is 50. Totals and matching-table downloads include all matching rows, not only the visible page.

Use **Columns** to show or hide columns. You can also resize or reorder them and choose **Comfortable** or **Compact** under **Density**. These presentation choices are remembered in the same browser for your user, organization and report. Hiding a column does not remove its data from the standard download.

**Reset table** clears table searches, filters, sorts and grouping and restores the default page size without changing the report selection. **Reset report** starts a fresh report selection. **New window** opens the current report selection separately. A bookmarked report restores its selection, not a frozen copy of its data.

### If the interactive table is unavailable

Use the full-page table and **Property table controls**:

1. Enter **Find property, country or city**, choose **Rows per page** and optionally **Group properties**.
2. Choose **Sort by** and up to two **Then by** fields.
3. Expand **Filter matching rows** to enter up to ten conditions. Leave unused conditions blank.
4. Click **Update table**.

Text fields support equals, does not equal and contains. Numeric fields support equals, does not equal, at least and at most. IDs, currency and status support equals and does not equal. Enter positive whole-number IDs, a decimal point for amounts, and **Active** or **Canceled** for a status condition. **Value basis** cannot be sorted or filtered. Unknown monetary values do not match numeric conditions, including “does not equal.”

The full-page table also shows bookings, room stays, priced nights and property exceptions under its combined column headings. **Selected scope total** covers the report selection; **Matching table total** covers the table selection; **Full matching group total** covers the entire matching group across pages.

## Open supporting detail

### Review a property's stay production

Click the linked property name in the Properties table. In the full-page table, use **View stay production** or **View related stay production**.

The link opens **Daily Revenue / OTB** for that property with the same stay dates and reservation feed. For a populated row with a recognized currency and Active or Canceled status, it also carries that row's currency and status.

**View related stay production** indicates a broader related view rather than an exact row match, such as a row with no captured stays or an unsupported currency. Check the destination's filters before reconciling figures. Use **Return to report** when available to return to the comparison.

### Review recent opportunities

Expand **Recent opportunity records**. Each row identifies the property, source channel, type/level and record count. Click the property's link to open the matching selection in **Opportunity Center**.

These records use a separate creation-time window:

- They belong to the selected properties after the report's country/city restrictions.
- They are unarchived opportunity records created within the selected number of days before extraction.
- They match your report language or have no language specified.
- They include all property channels. Stay dates, reservation feed, business status, currency and property-table searches do not narrow them.

Counts are message records, not necessarily independent incidents. The destination retains the originating channel, type, level, language and creation cutoff, but records can change after extraction. No recent records does not prove healthy distribution.

## Filter reference

| Control | What it does and accepted values |
|---|---|
| **Month** | Sets the stay-date range to a whole calendar month. It is a shortcut for the date range, not an additional filter. |
| **Stay dates (through inclusive)** | Both dates are required together, or both can be blank. Choose an ordered range of at most 366 days, within years 2000–2100. If separate **Start date** and **End date** controls appear, enter both there instead. |
| **Days when both dates are blank** | Uses a period starting today in the current property's local date and continuing for this many days, including today. Default 30; accepted 1–366. It does not mean the previous 30 days. Ignored for the range when both explicit dates are supplied. Clearing this number restores the default. |
| **Reservation feed** | One source of captured reservations. The initial default is ChannelRUSH Booking Engine. The list includes feeds connected to available properties; a previously selected feed can remain named even if no longer connected. A listed feed is not proof that every selected property receives bookings through it. |
| **Currency** | **All currencies, kept separate**, or one recognized currency code. A single currency restricts captured business, not opportunities. Properties without matching nights can still appear as **No captured stays**. |
| **Business status** | **Active** by default, **Canceled**, or **Active and canceled, kept separate**. |
| **Country code** | Exact match against the property's recorded country code, ignoring case and surrounding spaces; for example, `DE`. Blank means no country restriction. Maximum 10 characters. This filters property geography, not guest nationality. |
| **City (exact)** | Exact match against the property's recorded city, ignoring case and surrounding spaces; for example, `Berlin`. Blank means no city restriction. Maximum 100 characters. Use table Search for a partial city match. |
| **Opportunity creation window (days)** | Independent recent-record window. Default 30; accepted 1–90. Clearing the number restores 30. Does not change stay-production dates. |
| **Properties** | Initially selects available properties. Tick individual properties or use the checkbox beside **Properties** to select or clear the list. If more than 200 are available, selecting all takes the first 200; check the count and desired properties before running. No selection is not “all”: the report requires 1–200 authorized properties. |
| **View report / Update report** | Runs the report selection. The button is disabled when no property is selected. Changing report filters is read-only: it does not alter reservations, inventory or channel settings. |

## On-screen field reference

### Summary cards and Properties columns

| Field | Meaning |
|---|---|
| **Property ID** | ChannelRUSH property identifier. |
| **Property** | Property name. A link opens its supporting stay-production view. |
| **Country**, **City** | Geography recorded on the property; blanks mean no recorded value. |
| **Currency** | Currency on the captured reservation. A blank or **Unknown currency** is not a default currency. |
| **Status** | **Active**, **Canceled** or **No captured stays**. A property can have several rows when currency or status differs. |
| **Value basis** | **Booking-engine booked room-rate value** or **Counts only; monetary basis unqualified**. This explains whether amounts are usable in this report. |
| **Room nights** | Captured nights inside the selected stay dates, excluding checkout. |
| **Qualified nights** | Nights eligible to contribute monetary value and ADR. |
| **Known value / Known booked value** | Sum of qualified booked room-rate prices; not necessarily the value of all counted nights. |
| **Qualified ADR / Weighted ADR** | Known value divided by qualified nights within the applicable row or separate total. |
| **Feed-wide exceptions** | Missing identity rows and invalid stays. See the exception rules above before adding or comparing them. |
| **Extracted** | Report data-read timestamp, not source freshness. |

### Recent opportunity records

| Field | Meaning |
|---|---|
| **Property** | Property ID; its link opens the corresponding Opportunity Center selection. |
| **Channel / Source channel** | Source channel ID; `-1` means no source channel was recorded. It can differ from the selected reservation feed. |
| **Type / level** | Opportunity classification. Numeric type `1` means Opportunity; `2` means OpportunityChannel. Level `0` means Success, `1` Info, `3` Warn and `4` Error. Some views show names instead of codes. |
| **Records** | Number of matching message records in that property/channel/type/level group. |
| **Latest creation (stored)** | Latest recorded creation timestamp in the group, shown in the full-page table and exports. It is not a resolution or delivery timestamp. |

## Download the right scope

Wait for any report update to finish before downloading.

| Action | Contents and scope |
|---|---|
| **Download report > Portfolio workbook** | XLSX with **Context**, **Properties** and **Opportunities** worksheets. Properties and opportunities use the full report selection, not property-table filters. Context explains the selection and coverage. There is no separate worksheet of summary-card totals. |
| **Download report > Properties CSV** | All property/currency/status rows in the report selection, with the property headers below. No opportunity rows or added total rows. |
| **Download report > Opportunities XLSX / Opportunities CSV** | All matching opportunity groups for the report selection and independent creation window. XLSX also includes Context. A CSV with only its header means no matching groups were found. |
| **Download matching table CSV / Download matching table XLSX** | Every matching property row across all pages, applying table search, filters and sort order. XLSX also includes Context. These are property rows, not group-heading or total rows. |

For example, if your report selects three properties and table Search leaves one matching property, **Properties CSV** still includes the report's property rows, while **Download matching table CSV** includes only the match.

Downloads read the selection again. If data changes between viewing and downloading, compare the extraction timestamps and refresh before reconciling. An export is not a guarantee that the reservation feed is complete or current.

### Export headers: property and opportunity downloads

Headers are case-sensitive as shown. Dates in CSV use `YYYY-MM-DD`. Unknown monetary values are blank, not zero.

**Properties CSV**, the workbook's **Properties** sheet and standard matching-table downloads use this complete header sequence:

```text
contract,propertyId,feedId,start,end,extractedUtc,propertyName,country,city,currency,status,basis,bookings,roomStays,roomNights,pricedNights,qualifiedNights,knownValue,adr,unmappedNights,invalidStays,missingIdentities,qualification
```

**Opportunities CSV** and the **Opportunities** sheet use:

```text
contract,propertyId,feedId,start,end,extractedUtc,channelId,type,level,count,latestCreated,language,createdSince,archived
```

| Header | Meaning |
|---|---|
| `contract` | Export format identifier, currently `report-pilot-v1`. Useful when identifying a file for support. |
| `propertyId` | Property represented by the row. |
| `feedId` | Selected reservation-feed ID. On opportunity rows this is report context, not the opportunity's channel; use `channelId` for that. |
| `start`, `end` | Selected inclusive stay-date boundaries. On opportunity rows these are report context only; `createdSince` defines their creation window. |
| `extractedUtc` | Data extraction timestamp in UTC. Not the latest source update. |
| `propertyName` | Property name. |
| `country`, `city` | Property geography. |
| `currency` | Captured reservation currency; blank when unknown or when the property has no matching captured stays. |
| `status` | Active, Canceled or No captured stays. |
| `basis` | Explanation of the monetary basis. |
| `bookings` | Distinct captured bookings contributing nights to the row. |
| `roomStays` | Distinct room-stay records contributing nights to the row. |
| `roomNights` | Nights clipped to the selected stay period. |
| `pricedNights` | Nights with exactly one recorded, nonblank nightly price. |
| `qualifiedNights` | Nights that qualify for monetary value. |
| `knownValue` | Sum of qualified nightly prices; blank if none qualify. |
| `adr` | Known value divided by qualified nights; blank if unavailable. |
| `unmappedNights` | Nights without a single unambiguous current room mapping. |
| `invalidStays` | Property's invalid-stay count for the selected feed/status/currency, outside a usable stay-date scope. Repeated across property rows; do not sum repetitions. |
| `missingIdentities` | Feed-wide captured rows without usable source booking identity, repeated across the property's rows. Not a distinct-booking count. |
| `qualification` | `Known qualified booked room-rate value; captured feed only` when the row has known value; otherwise `Unknown or unqualified monetary value`. The first label does not mean every counted night qualifies. |
| `channelId` | Opportunity's source channel ID, or `-1` when not recorded. |
| `type`, `level` | Opportunity type and level codes listed in the on-screen reference. |
| `count` | Matching opportunity message-record count. |
| `latestCreated` | Latest stored creation timestamp in the opportunity group. Preserve the timestamp/offset as supplied; do not assume it has the same display format as `extractedUtc`. |
| `language` | Report language used to select opportunities. Language-neutral records are also included; this is not necessarily the language of every individual message. |
| `createdSince` | Extraction time minus the opportunity-window days. It is the inclusive creation-time cutoff, independent of stay dates. |
| `archived` | Always false in this download because only unarchived records are included. It does not mean that an opportunity is resolved. |

The **Context** worksheet contains key/value notes rather than property data. Its keys are **Title**, **Contract**, **Generated UTC**, **Extracted UTC**, **Scope**, **Dataset**, **Selection**, **Basis**, **Coverage**, **Values**, **Counts** and **Opportunities**. `Scope` distinguishes `report` from `table`; `Dataset` identifies the requested download. `summary` is the Portfolio workbook selection, not a separate Summary worksheet. **Selection** records the report link; **Generated UTC** is file-generation time, distinct from **Extracted UTC**.

### Older combined CSV files

An older report link may download a combined `portfolio.csv` instead of the separate datasets above. Identify it by its capitalized headers and `RowKind` column. It includes **Property**, **Total** and **Opportunity** rows; when there are neither property nor opportunity rows, it includes a **No matching rows** marker. It covers the report selection, not the table search.

Do not sum Property and Total rows together. Total rows are already grouped by currency, status and basis. Opportunity rows do not contain property-production metrics.

The complete header sequence is:

```text
Contract,ScopePropertyIds,FeedId,StartDate,EndDate,IncludeCanceled,CurrencyFilter,CountryFilter,CityFilter,OpportunityDays,OpportunityLanguage,ExtractedUTC,RowKind,PropertyId,PropertyName,Country,City,Currency,CommissionCurrency,Status,Basis,Bookings,RoomStays,RoomNights,PricedNights,QualifiedNights,UnmappedNights,KnownValue,ADR,RecordedCommission,BookingsWithCostAmount,QualifiedNetBookings,QualifiedBookingValue,QualifiedNetValue,QualifiedNetCoveragePct,InvalidRoomStays,MissingIdentityRowsFeedWide,OpportunitySource,OpportunityType,OpportunityLevel,OpportunityCount,LatestOpportunityCreated
```

| Header or headers | Meaning in a Portfolio file |
|---|---|
| `Contract` | `captured-portfolio-production-v1`, identifying this combined report format. |
| `ScopePropertyIds` | Requested property IDs, separated by semicolons. Geography filters can narrow the properties represented by the rows. |
| `FeedId`, `StartDate`, `EndDate` | Selected reservation feed and inclusive stay dates. |
| `IncludeCanceled` | Whether canceled business is included. Both canceled-only and active-and-canceled selections can be true; use row `Status` to distinguish them. |
| `CurrencyFilter`, `CountryFilter`, `CityFilter` | Report restrictions; blanks mean no restriction for that field. |
| `OpportunityDays`, `OpportunityLanguage` | Separate opportunity creation-window length and report-language selection. Language-neutral records are also included. |
| `ExtractedUTC` | Report extraction timestamp, not source freshness. |
| `RowKind` | Property, Total, Opportunity or No matching rows. |
| `PropertyId`, `PropertyName` | Property identity for property rows. Opportunity rows carry a property ID but no property name. Total rows use ID `0` and name `Selected scope total`; `0` is not a property to look up. |
| `Country`, `City`, `Currency`, `Status`, `Basis` | Same geography, currency, business status and value-basis meanings as the property export. Geography is blank on totals. |
| `Bookings`, `RoomStays`, `RoomNights`, `PricedNights`, `QualifiedNights`, `UnmappedNights` | The corresponding counts described above. Blank on opportunity rows. |
| `KnownValue`, `ADR` | Qualified booked room-rate value and ADR; blank when unavailable. |
| `CommissionCurrency`, `RecordedCommission` | Shared fields not populated by Portfolio Overview. Blank does not establish no commission or zero cost. |
| `BookingsWithCostAmount`, `QualifiedNetBookings` | Shared cost/net fields, not calculated by Portfolio Overview. Property and Total rows contain default zero values; these are not measured cost-coverage or net-booking counts. |
| `QualifiedBookingValue`, `QualifiedNetValue`, `QualifiedNetCoveragePct` | Shared net-revenue fields, not calculated by Portfolio Overview; blank. Do not use them to infer net revenue or profitability. |
| `InvalidRoomStays`, `MissingIdentityRowsFeedWide` | Property exception counts, repeated across currency/status rows and deliberately blank on Total rows. Not additive across repeated property rows. |
| `OpportunitySource`, `OpportunityType`, `OpportunityLevel`, `OpportunityCount`, `LatestOpportunityCreated` | Opportunity channel ID, type code, level code, record count and latest stored creation timestamp. Populated only on Opportunity rows. |

## Common problems

| Symptom | Likely explanation and safe next action |
|---|---|
| A property is missing from the picker, or **Select only currently authorized properties** appears | The property may be inactive, outside the current organization or no longer assigned to you. Check your organization and ask your organization administrator to verify access. Rebuild old bookmarked selections from the current picker. |
| **View report** or **Update report** is disabled | No property is selected. Tick at least one property and check the selected count. |
| The date range is rejected | Supply both dates or clear both. Keep the end on or after the start and the range within 366 days and years 2000–2100. Keep fallback days within 1–366 and opportunity days within 1–90. |
| No property rows match, but summary cards still have values | A table search or condition excluded the rows. Click **Reset table**. Report totals intentionally remain unchanged. |
| A selected property is absent from the results | Check **Country code** and **City (exact)** first, then table search/filters. Property geography restrictions can remove a selected property entirely. |
| **No captured stays**, or zero nights with blank value | Check the feed, stay dates, currency and business status. The property may have no matching valid nights in captured data. Do not interpret this as zero total hotel business. |
| Nights are present but value or ADR is blank | The feed's monetary basis may be unqualified, or nightly prices/currency may be missing or conflicting. Review **Value basis**, qualified nights and supporting stay production. Do not replace blanks with zero. |
| Exception counts appear several times | They repeat on the property's currency/status rows. Use the summary exception figures, not a sum of the repeated export values. |
| No recent opportunity records | Check the independent creation window, property geography and language context. Empty results do not establish healthy channels or resolved issues. |
| **Update failed. Previous results retained.** | The displayed results are still the earlier selection. For a temporary failure, use **Retry update** to retry the same selection. If you change or correct filters, click **Update report** to submit those changes. Retrying this report reads data; it does not resend reservations or inventory. |
| **Interactive table unavailable. Use the full-page table below.** | Use **Property table controls** and **Update table**. If the problem persists, report the browser and visible message to support. |
| A table condition is rejected | Use a supported field/operator, positive ID, decimal-point amount or Active/Canceled status. Keep within three sorts, two geography groups and ten conditions. Use **Reset table** to remove an invalid saved table selection. |
| **Too many result groups; narrow the selection** or an overly long report-link warning | Reduce selected properties, narrow report criteria, or remove table conditions/return steps. A report supports at most 200 selected properties and 10,000 result groups. |
| A download differs from the table | Check whether you chose **Download report** or **Download matching table**, then compare report criteria and extraction timestamps. Table pagination does not limit either export. |

If a discrepancy remains after checking the selection, contact support with the organization/property IDs, reservation feed, stay dates, currency/status, relevant table filters, extraction time and visible error text. Include whether the file came from **Download report** or **Download matching table**. Do not send passwords, payment details or unnecessary guest information.
