Select properties, stay dates and a reservation feed, then read or export daily room-type metrics with the correct meaning for each figure.

## Before you start

If you opened Excel from a single property’s report, use [Read reservation metrics for a property](https://help.channelrush.com/hc/channelrush/articles/reservation-metrics) for that entry path. The spreadsheet and CSV guidance below applies to both entry paths; Org Admin access is needed only for the organization selection described here.

You need access to the properties you want to include. The **Org Admin** menu is available to Org Admin users and users with access to multiple properties. The report lists properties available to your account; the property selected in the application header does not replace the report's **Properties** selection.

**This is a whole-stay report, not revenue limited to the selected nights.** It finds captured active reservations whose stays intersect your date range, then includes their supplied nightly rows—even nights outside that range. It uses mapped room types and skips room stays it cannot map.

**Confirm the currency and price basis before comparing money.** The report does not show currency codes or convert amounts. Rows can combine prices from different feeds. Do not add or compare amounts unless you know they share the same currency and price basis.

Running the report or downloading CSV does not change reservations, update inventory or resend anything.

## Choose the scope and open the report

1. Open **Org Admin → Reports**.
2. Under **Reservations**, select **Reservations - Metrics**.
3. Set **Date Range** using the start and end dates. Alternatively, select a month in **Month / Year** to use that whole month.
4. Choose a **Channel**, or leave **All** to combine captured feeds.
5. Under **Properties**, check each property to include.
6. Check the selected-property count and date summary beneath the controls.
7. Select **List** to open the table in a new tab, or **Excel** to open the spreadsheet view in a new tab.

![Date Range controls with a Month / Year shortcut and separate start and end dates](https://support.channelrush.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBc0VCIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--adba74902a05cef91b783d36766324adaca40e4d/org-reservation-metrics-dates.png)

*Use the month shortcut for a calendar month, or choose your own start and end dates.*

The checkbox beside **Properties** selects the whole list when it is not fully selected; when everything is selected, it clears the list. At least one property must remain selected before you run the report. Changing a selection does not refresh a report tab that is already open—run **List** or **Excel** again.

### Selection field reference

| Control | What it does | Default or requirement |
|---|---|---|
| Date Range | Selects stays intersecting the start/end interval. This is not a booking-created-date filter. | Both dates are required; the end must not precede the start. Without supplied dates, the initial range runs from today through 28 days later, based on the current property's local date. |
| Month / Year | Replaces the date range with the first and last day of the selected month. | Optional shortcut, not a second independent filter. |
| Channel | Restricts the reservation feed used for the report. | **All** combines feeds. A feed is not necessarily the reservation's original sales source. |
| Properties | Selects the properties included in the output. | Initially all available properties are selected unless you arrive with an existing selection. Select at least one. |
| List | Opens the HTML table using the current selections. | Opens a separate tab/window. |
| Excel | Opens an embedded spreadsheet using the current selections. | This opens a view, not an immediate workbook download. |
| CSV | Downloads the report data using the current selections. | Does not require opening List or Excel first. |
| Cancel | Returns to the organization Reports page. | Does not change reservations. |

## Understand the results

The output is headed **Reservations - N**. The number counts the matching captured reservations loaded before room-mapping omissions. It is not the number of table rows, room stays, arrivals or room nights.

In List view, check the statement beginning **Selected stay dates**, the **Properties** IDs and **Reservation feed** above the table. The smaller heading may show the current application property; use the explicit property IDs and row **Property ID / Property Name** columns to confirm the report's scope.

Each row groups one property, one nightly date and one mapped property room type. Rate plans are combined. With **All**, channels are combined too, so **Channel ID** and **Channel Name** are blank. Selecting a specific channel fills those columns.

### Which reservations and nights are included?

- Normal report selections use the latest captured version of each reservation with status **New** or **Modified**, rather than cancellation activity. Archived reservations are not automatically excluded.
- The stay comparison includes both boundaries, including departure day. A reservation departing on the selected start date can qualify.
- Once a reservation qualifies, the report processes its mapped room stays and all supplied nightly price rows. It does not trim the nights to your selected dates, and a multi-room reservation can contribute other room stays as well.
- Missing channel settings or room mappings can leave a reservation out of the metrics even though it contributes to the heading's reservation count.
- The report also supplies zero rows for configured room types on selected dates with no mapped nightly data. Zero does not establish that no bookings exist.

The report does not expose price coverage, its run timestamp or the latest feed update. A freshly opened page is not proof that every channel's reservation data is current.

### On-screen column reference

| Column | Meaning and how to read it |
|---|---|
| Property ID | ChannelRUSH property identifier for the row. |
| Property Name | Name of that property. |
| Channel ID | Selected feed's identifier. Blank when **All** is selected. |
| Channel Name | Selected feed's name. Blank when feeds are combined. |
| Date | Date of the supplied nightly row, or the selected date for a zero-filled row. It can fall outside your chosen interval when it belongs to a matching stay. |
| Room Type ID | Mapped property room-type identifier—not the channel's room code. |
| Room Type Name | Name of that property room type. |
| Total Allocation | Count of mapped nightly price rows. This is not available inventory, an occupancy percentage or a reservation count. |
| Total Arrivals | Room stays counted on their first supplied nightly date. One multi-room reservation can contribute more than one arrival. |
| Total Revenue | Sum of supplied nightly prices. The report does not separately add reservation-level totals, taxes, fees or add-ons; the supplied prices retain their own basis. |
| Total ADR | Total Revenue divided by Total Allocation, rounded to two decimal places. A zero-filled row displays zero; that is not evidence of a zero-price booking. |
| ALOS | Average length of stay: supplied nightly-row count per arriving room stay, rounded to one decimal. It is calculated on arrival rows only. Missing nightly data can make this differ from departure date minus arrival date. Zero can mean no arrivals. |
| ADTA | Average days to arrival: days from the selected reservation version's receipt date to its first supplied night, averaged over arriving room stays and rounded to a whole day. It is not necessarily lead time from the original booking. Zero can mean no arrivals or a rounded zero-day average. |

ADTA does not adjust the receipt date into your selected property's local timezone before this calculation. Use reservation details when you need to investigate an individual booking's timing.

## Use Excel and download files

### Spreadsheet view

**Excel** opens a read-only spreadsheet. Its field names are compact—for example, **TotalAllocation** rather than **Total Allocation**—but the metric meanings are the same.

To change its dates or channel:

1. Open **Filters**.
2. Change the date range or **Channel**.
3. Select **View Report**.
4. Check that the reloaded heading, filters and rows match your choice.

The spreadsheet retains the original property selection. For an organization report, return to the original organization criteria tab to change properties, then run the report again. For a single-property report, select **HTML** to return to that property’s metrics page. Output/download controls use the loaded criteria, not unsubmitted edits in **Filters**.

Use **File → Save As** to download a workbook, or **File → Print** to print the spreadsheet. Saving a workbook does not save changes to reservations. Do not use linked dates in the spreadsheet to open reservation details; use **Reservations → Search** instead.

### CSV download

1. On the organization criteria page, choose the dates, channel and properties.
2. Select **CSV** under **Download**.
3. Open the downloaded file and confirm its property IDs, dates and headers.

You can also use **CSV** under **Download** on an opened result to export that result's loaded selection.

The CSV header order is:

```text
PropertyId,PropertyName,ChannelId,ChannelName,Date,RoomTypeId,RoomTypeName,Total Allocation,Total Arrivals,Total Revenue,Total ADR,ALOS,ADTA
```

CSV dates use `yyyy-MM-dd`; numeric values use a decimal point. Blank ChannelId/ChannelName under **All** and zero-filled metrics have the same meanings as in List view. There is no currency column. The exported dates can extend beyond the selected interval for the same whole-stay reason as the on-screen report.

## Check the result

1. In List view, confirm **Selected stay dates**, **Properties** and **Reservation feed**.
2. Locate a representative property, room type and date in the table.
3. Compare that same row in your CSV or spreadsheet, rather than comparing the reservation heading count with the file's row count.
4. If a known booking is missing or totals look wrong, check the property, captured feed, stay overlap and room mapping before drawing a conclusion.
5. To investigate a booking, open **Reservations → Search** for its property, enter the reservation criteria and select **Search**. Review the correct reservation version and its room/nightly information.

A completed report confirms that ChannelRUSH produced that view of stored data. It does not confirm successful reservation delivery, complete price coverage or agreement with a channel's own financial statement.

## Common problems

| Symptom | Likely explanation | Safe next action |
|---|---|---|
| Org Admin or a property is missing | Your account may not have the required role or property access. | Ask your organization administrator to confirm access. Contact support if the expected access is already assigned. |
| List/Excel/CSV is unavailable | Dates are incomplete or reversed, or no property is selected. | Choose valid dates and check at least one property. If a date error remains, reselect the range with the picker rather than repeatedly submitting malformed text. |
| List or Excel appears to do nothing | The browser may have blocked the new tab, or page scripts did not complete. | Check open tabs and allow popups for ChannelRUSH, then run the report again. If it still fails, capture the non-sensitive error text and contact support. |
| Reservations - 0, or rows contain zeros | No matching captured reservations or no mapped nightly data is represented for that scope. | Recheck dates, feed and properties. Compare a known reservation and its mapping; do not treat zeros as proof of no bookings or successful delivery. |
| A row's date is outside the selected range | Matching reservations contribute whole-stay nightly rows. | Use the date column to identify the nights included. Do not describe the untrimmed export total as revenue only within the selected interval. |
| Reservation count differs from arrivals or allocation | They count different units; unmapped room stays can also be omitted. | Use the column reference before reconciling. Escalate with a representative property, room type, date and non-sensitive discrepancy if the difference remains unexplained. |
| Excel dates look like reservation links | The spreadsheet can display dates as links that do not identify a valid reservation. | Do not use those links for investigation. Use **Reservations → Search**, then **Search**, or use the List/CSV output. |
| Export fails or the dataset is too large | The requested output may exceed what the export can generate. | Reduce the date range or property selection and try again. If a small report also fails, contact support with the selected scope, format, action time/timezone and error text. |

Repeated report runs and downloads are observational. Do not resend or modify a reservation to make this report reconcile. Never send passwords, payment details or unnecessary guest information with a support request.

## Related

- [Review reservation details](https://help.channelrush.com/hc/channelrush/articles/reservations-view)
