Use the STR Global integration to automatically send daily forward and historical performance data from RMS to STR, giving you consistent, comparable market intelligence without manual file creation.
Overview
STR Global provides business intelligence tools that deliver insights into market and competitor trends.
The Revenue Analytics – STR Global interface is available to RMS customers at no additional RMS fee. Once activated, RMS automatically sends two exports to STR each night:
Forward Reservations
Historical Data
These exports are sent at STR’s required times per region.
| Region | Time (UTC) |
|---|---|
Americas |
12:00 PM UTC |
Middle East |
11:00 PM UTC |
Europe |
02:00 AM UTC |
Australasia & India |
07:00 PM UTC |
Important! If at least one Category has Include in STR Global Interface ticked, only active Categories with Include in STR Global Interface ticked and Area Statistics set to Yes are included in the exports. If no active Category at the property has Include in STR Global Interface ticked, RMS sends every active Category with the Accommodation class instead. Area Statistics set to Yes applies either way.
Please Note! Facility Categories selected to be included in the STR Global Interface will only send revenue information (no availability or used rooms).
Export Details
Forward Reservations Export
The Forward Reservations export includes all reservations for the next 365 days, with:
Unique Property Identifier
Forward Date
Property Available Areas
Property Total Areas Booked
Transient Areas Booked
Group Areas Booked
Property Name
Complimentary & House Reservations
Please Note! For some properties, RMS can also send an additional Market Segment Forward file that breaks out forward data by market segment. This is configured by RMS and STR on a case-by-case basis.
Historical Data Export
The Historical Data export is generated for the current date and the previous seven days, with:
Unique Property Identifier
Data Date
Property Areas Available
Property Areas Sold
-
Property Accommodation Revenue
Accommodation Revenue is Operational Revenue and is provided to STR as net figures.
Total Revenue
-
Food & Beverage Revenue
F&B Revenue follows Operational Revenue calculations for charges where the General Ledger Account Code is allocated to a grouping labelled Food & Beverage (or a common variation).
Currency Code
Property Name
Complimentary & House Reservations
Please Note! Where configured, RMS can also send a Market Segment Historical file that segments historical data by market segment in addition to the standard historical export. This is controlled by RMS and STR configuration and is not required for the core interface.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.
How the Area Figures Are Calculated
The Forward Reservations and Historical Data exports use the same calculation for the Area figures. Only the dates differ. Property Available Areas in the Forward export and Property Areas Available in the Historical export are the same figure. In the CSV files, they appear as RoomsAvailable (Forward) and Property_RoomsAvail (Historical).
Property Available Areas
For each Category and each day, RMS counts the Areas that belonged to that Category on that day, then adds the Categories together for the property. An Area is counted when:
- its Category is included in the export (see the Important note above),
- Area Statistics is set to Yes on the Area, and
- the Area does not have an Out of Order Reservation that night, unless the Include Areas with Out of Order Reservations as available for occupancy calculations option is ticked.
An Area only counts in a Category for the days it belonged to that Category, so moving an Area to a different Category changes the figures from the date of the move. An Out of Order Reservation that arrives and departs on the same date does not reduce the available Areas.
The option is on the Options tab of Property Information. See Include Maintenance reservations in occupancy calculations. Its name follows your property's System Labels, so you may see 'Maintenance' instead of 'Out of Order'.
Areas Booked and Areas Sold
- Property Total Areas Booked is Transient Areas Booked plus Group Areas Booked. A reservation is Group when it belongs to a group booking. All other reservations are Transient.
- Property Areas Sold in the Historical export follows the same rules as the Booked figures.
- The booked figures use the same Categories and the same Area Statistics filter as Property Available Areas. Facility Categories are left out of all of them.
- A reservation that has not yet been allocated to an Area still counts as booked.
- Cancelled, No Show, Quote and Pencil reservations, waitlisted reservations, and group master records are not counted. Out of Order Reservations are never counted as booked.
- With Include Day Use in Used for Occupancy ticked, a same-day reservation counts as one booked night. When it is not ticked, same-day reservations are left out, except in Categories set up for day bookings, which always count. This option affects the booked figures only, not Property Available Areas.
- The Occupancy calculated by setting (Category or Property) has no effect on the STR exports.
The Complimentary & House Reservations figure is a separate count of reservations, not nights, on a rate in the Complimentary or House Use rate group.
Enabling STR Global in RMS
Before enabling STR Global in RMS, please contact us and request activation of the Revenue Analytics interface with STR.
Once Sales confirms the module is activated:
- Configure Categories
Navigate to Setup > Category/Area.
Select Edit on an existing Category to open it.
Go to the Category Details tab.
Tick Include in STR Global Interface.
Select Save.
-
Confirm Area Statistics
In the same Category/Area setup screen, go to the Area tab.
For each Area that should be reported to STR, confirm the Area Statistics are set to Yes.
Select Save/Exit.
-
Repeat for All Required Categories
Repeat the above steps for every Category you wish to include in STR reporting.
After configuration is complete:
RMS will begin sending the Forward Reservations and Historical Data exports to STR Global each night at the regional time shown above.
Activation window: It can take 48–72 hours for STR to process and reflect the data after activation.
Sending a One-Time Historical Update to STR (Manual CSV)
In some cases, STR may request a one-time historical data file for past months (for example, when you first enable the interface and STR wants historical performance loaded into their system).
Use the Occupancy report in RMS to generate this historical CSV and email it to STR.
Tip! For steps on accessing and running the report, see: Occupancy Report
Step 1: Set the Date Range
When running the Occupancy Report
-
In Reservation Between, select either:
Last Month, or
A specific historical date range (for example, 1st January to 31st January).
-
Ensure:
Category: all required categories are selected (typically All).
Occupancy by: Category.
Area Stats: On.
Step 2: Configure Report Options
In the More Options section of the Occupancy Report:
Set Group 1 to Property.
Tick Daily breakdown.
Ensure all other parameters remain unticked.
Step 3: Build and Export to CSV
Select Build to generate the Occupancy Report.
-
When the report opens on-screen:
Use the report toolbar to export the report as CSV.
Step 4 – Email the File to STR
Save the exported CSV file and name it clearly, for example: Jan2025.csv or 2025-01.csv.
Repeat the same process for each additional month that STR has requested.
Attach all CSV files to a new email and send to:
data_daily@str.com
STR uses these one-time historical CSV files to backfill their system. Ongoing daily data will continue to be provided automatically via the STR Global interface once activated.
When to Use the Manual One-Time Historical Update
Use the manual one-time historical CSV process when:
STR explicitly requests historical data for past months, and/or
You are newly activating STR Global, and STR wants historical data to align their reporting with your RMS history.
Tip! You do not need to run this every month once the interface is live; the automatic nightly exports handle ongoing data.
Comments
0 comments
Please sign in to leave a comment.