This report allows you to look at events, reservations, revenue, upsell, and other data for your organization or hotel. The report can be run for a given month or for year to date, and is provided in Excel format for further analysis.
NOTE: This report is updated on the 1st day of each month by 4 a.m. Eastern Time (ET). Please take this into account when comparing with other real-time Passkey data or reports.
To run the report:
Under the Period, choose one of the following:
One month, to show data for events and reservations created in the selected Year and Month.
Year to month, to show data for events and reservations created from the start of the selected Year up to the Month selected.
Select the Year, noting that only years with actual data for the organization or hotel will be displayed. This list contains the current year and the past 2 calendar years.
Select the Month, noting that only months with actual data for the organization or hotel will be displayed.
Select the Hotel(s), if the report is being run by an Organization with sister properties.
Select the Currency if desired, which defaults to the organization or hotel profile default currency. Note that a historical currency conversion is used to ensure all revenue figures are normalized to the selected currency.
Click Generate Report to display the Excel report.
For clarity, the events included in the report are grouped by their event type. This is shown in the Event Category column as:
For the Hotel User:
HotelDirect (HD) - describing events owned by the Hotel
CityWide (CW) - describing the Hotel's participation in CW events created by third party organizations
Multi-Property (MP) - describing the Hotel's participation in CityWide events created by a Multi-Property (MP) organization related to the hotel
For the Organizer User:
CityWide (CW) - describing events created by the organization
The following table describes the events and reservations that are included when the report is run.
Hotel/Organization Running Report |
Has Sister Properties |
Report Display |
| Hotel | No |
|
| Organization | No |
|
| Organization (with sister properties) | Yes |
|
The following table defines all of the columns shown in the Excel report.
Column Name |
Business Definition |
Participant Id |
The unique Passkey ID of the organization or hotel |
Licensee |
The owner of the event, which may be a Hotel or Organization, as set in the Profile (Name) |
City |
The owner's City, as set in the Profile |
State |
The owner's State/Province, as set in the Profile |
Country |
The owner's Country, as set in the Profile |
Chain |
The hotel's chain name |
Brand |
The hotel's brand name |
Management Co. |
The management company of the hotel |
*Event Category |
For the Hotel User:
For the Organizer User:
|
*Gross Events Created |
All events created during the reporting period, including canceled events |
*Net Events Created |
All active events created during the reporting period, excluding canceled events |
Net Open Events |
Events which were open for reservations at least one day during the reporting period, excluding canceled events |
RegLink Events |
Open events enabled for RegLink (Event Connector), excluding canceled events |
Events With Upsell Rooms |
Open events where at least one premium (Upsell) room type is present, excluding canceled events |
Events With Enabled Campaigns |
Open events where at least one Campaign email was enabled, excluding canceled events |
Gross Res |
All reservations created during the reporting period, including canceled and wait listed reservations |
Net Res |
Active reservations created during the reporting period, excluding "Cancel", "No Show" and "Fully Wait Listed" reservations |
*Gross Rooms |
Number of rooms booked during the reporting period as part of Gross Reservations |
*Net Rooms |
Number of rooms booked during the reporting period as part of Net Reservations |
Gross Room Nights |
Number of rooms nights booked during the reporting period as part of Gross Reservations, excluding pending (Wait Listed) nights |
Net Room Nights |
Number of rooms nights booked during the reporting period as part of Net Reservations |
Gross Revenue |
Total Revenue from reservations booked during the reporting period as part of Gross Reservations, excluding pending (Wait Listed) nights. Gross Revenue includes Gross Add-On revenue |
Net Revenue |
Total Revenue from reservations booked during the reporting period as part of Net Reservations Net Revenue includes Net Add-On revenue |
Gross Room Revenue |
Revenue from rooms (including guest fees) booked during the reporting period as part of Gross Reservations, excluding pending (Wait Listed) nights |
Net Room Revenue |
Revenue from rooms (including guest fees) booked during the reporting period as part of Net Reservations Excludes Net Add-On revenue |
Gross Upsell Revenue |
Room Upgrade revenue generated as part of Gross Room Revenue. Upsell Revenue shows only the difference between an upgraded room rate and a base room rate available for a guest, based on the Upsell Premium set in inventory, or the dynamic upsell |
Net Upsell Revenue |
Room Upgrade revenue generated as part of Net Room Revenue Upsell Revenue shows only the difference between an upgraded room rate and a base room rate available for a guest, based on the Upsell Premium set in inventory, or the dynamic upsell |
Gross Nights With Upsell |
The number of room nights booked for upgraded rooms as part of Gross Room Nights |
Net Nights With Upsell |
The number of room nights booked for upgraded rooms as part of Net Room Nights |
Gross Extended Stay Revenue |
The part of Gross Room Revenue generated from nights booked before or after event dates (outside of contract) |
Net Extended Stay Revenue |
The part of Net Room Revenue generated from nights booked before or after event dates (outside of contract) |
Gross Nights Outside Contract |
The number of room nights booked before or after event dates (outside of contract) as part of Gross Room Nights |
Net Nights Outside Contract |
The number of room nights booked before or after event dates (outside of contract) as part of Net Room Nights |
Gross Add-On Revenue |
Revenue from Add-Ons sold as part of Gross Reservations, excluding revenue from per night Add-Ons booked for pending (Wait Listed) nights |
Net Add-On Revenue |
Revenue from Add-Ons sold as part of Net Reservations |
*Net Room Revenue sold from Primary |
The part of Net Room Revenue generated by nights booked only from the Primary Inventory Pool (Hotel Pool) |
*Net Room Revenue sold from Primary [Upsell Reservations] |
The part of Net Room Revenue generated by nights booked only from the Primary Inventory Pool (Hotel Pool) and only on upsell rooms |
*Net Room Revenue sold from Primary[Non-Upsell Reservations] |
The part of Net Room Revenue generated by nights booked only from Primary Inventory Pool (Hotel Pool) and only on non-upsell rooms |
Gross Web Res |
The part of Gross Reservations booked via the Attendee Website |
Net Web Res |
The part of Net Reservations booked via the Attendee Website |
Gross Web Room Nights |
The part of Gross Room Nights booked via the Attendee Website |
Net Web Room Nights |
The part of Net Room Nights booked via the Attendee Website |
Gross Web Revenue |
The part of Gross Revenue from reservations booked via the Attendee Website |
Net Web Revenue |
The part of Net Revenue from reservations booked via the Attendee Website |
Net Web Upsell |
The part of Net Upsell Revenue generated by reservations booked via the Attendee Website |
Gross True Web % |
(Gross Web Reservations / (Gross Reservations - Gross RLM Reservations - Gross MRB Reservations) )*100. |
Net True Web % |
The definition is similar to Gross True Web %, but the Reservations that have status of "Cancel", "Fully Waitlisted" and "No Show" are ignored. (Net Web Reservations / (Net Reservations - Net RLM Reservations - Net MRB Reservations) )*100. |
Gross Room List Res |
The part of Gross Reservations booked via the Rooming List Manager (RLM) |
Net Room List Res |
The part of Net Reservations booked via the Rooming List Manager (RLM) |
Net Room List Upsell |
The part of Net Upsell Revenue generated by reservations booked via the Rooming List Manager (RLM) |
Gross Room List % |
The percentage of Gross Room List Res to Gross Res |
Net Room List % |
The percentage of Net Room List Res to Net Res |
Gross Call Center Form Res |
The part of Gross Res booked via the Call Center Form, including such sources like "Phone", "Fax", "Mail", "Email" and "Other" |
Net Call Center Form Res |
The part of Net Res booked via the Call Center Form, including such sources like "Phone", "Fax", "Mail", "Email" and "Other" |
Net Call Center Form Upsell |
The part of Net Upsell Revenue generated by reservations booked via the Call Center Form |
Gross Call Center Form % |
The percentage of Gross Call Center Form Res to Gross Res |
Net Call Center Form % |
The percentage of Net Call Center Form Res to Net Res |
Gross MRB Res |
The part of Gross Res booked via the Multi-Room Booking tool (MRB) |
Net MRB Res |
The part of Net Res booked via Multi-Room Booking tool (MRB) |
Net MRB Upsell |
The part of Net Upsell Revenue generated by reservations booked via the Multi-Room Booking tool (MRB) |
Gross Hotel Res |
The part of Gross Res originated in the Hotel and then transferred into Cvent Passkey via API inbound |
Net Hotel Res |
The part of Net Res originated in the Hotel and then transferred into Cvent Passkey via API inbound |
Net Hotel Upsell |
The part of Net Upsell Revenue generated by reservations originated in the Hotel and then transferred into Cvent Passkey via API inbound |
Call Center Res Cost |
Cost Per Call Center Reservation (Per Reservation) in the Hotel Profile under Dashboard Fields |
Re-Key Room List Res Cost |
Cost Per Re-keying Room List Reservation (Per Reservation) in the Hotel Profile under Dashboard Fields |
Custom 1 |
Tract (a field on the Hotel/Organization profile in Passkey Settings, visible only to Passkey users) |
Custom 2 |
Sub-Continent (a field on the Hotel/Organization profile in Passkey Settings, visible only to Passkey users) |
Custom 3 |
Scale (a field on the Hotel/Organization profile in Passkey Settings, visible only to Passkey users) |
Custom 4 |
Class (a field on the Hotel/Organization profile in Passkey Settings, visible only to Passkey users) |
Custom 5 |
Affiliation (a field on the Hotel/Organization profile in Passkey Settings, visible only to Passkey users) |
Custom 6 |
Str # (a field on the Hotel/Organization profile in Passkey Settings, visible only to Passkey users) |
Custom 7 |
Other (a field on the Hotel/Organization profile in Passkey Settings, visible only to Passkey users) |