Enterprise Report - Event Books
Report Description: The Enterprise Event Books report offers the sales team a comprehensive overview of total revenues (space revenue + package revenue) generated by property Events (canceled, prospect, tentative, confirmed and end) within a specific date range.
Date Range: This report can render the data for up to 365 days in the past or future.
Revenue by Status section: The Revenue by Status section provides a quick snapshot of event revenue by event status and event date.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Property Code |
Unique identifier for the property |
NO |
Not Applicable |
|
Start Date |
The first day of the event |
Not Applicable |
Not Applicable |
|
Event Status |
Current status of the event (e.g. canceled, prospect, tentative, confirmed, ended) |
Not Applicable |
Not Applicable |
|
Space Revenue |
Total amount generated from renting out meeting rooms
*total amount excludes sleeping room revenue |
NO |
=sum(space revenue) |
|
Package Revenue |
Total amount generated from packages added onto events / spaces |
NO |
=sum(package revenue) |
|
Event Revenue |
Total amount generated by the event
*total amount excludes sleeping room revenue |
NO |
=sum(space revenue) + (package revenue) |
|
Event Count |
Total number of events by status on the defined start date |
NO |
Not Applicable |
Revenue by Sub Event section: The Revenue by Sub Event section provides a comprehensive overview of event revenues by sub event for a defined period.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Property Code |
Unique identifier for the property |
Not Applicable |
Not Applicable |
|
Start Date |
The first day of the event |
Not Applicable |
Not Applicable |
|
Event Status |
Current status of the event (e.g. canceled, prospect, tentative, confirmed, ended) |
Not Applicable |
Not Applicable |
|
Sub Event Name |
Name of the event (meeting) occupying the individual space (meeting room) |
Not Applicable |
Not Applicable |
|
Event Confirmation Number |
Unique identifier for the event confirmation |
Not Applicable |
Not Applicable |
|
Create By |
The associate at the property who created the event |
Not Applicable |
Not Applicable |
|
Market Segment |
Market segment associated with the event |
Not Applicable |
Not Applicable |
|
Source |
Information on the source of the reservation (e.g. direct booking, email, MeetingBroker, etc.) |
Not Applicable |
Not Applicable |
|
Event Manager |
The associate at the property responsible for the entire process of planning and executing an event |
Not Applicable |
Not Applicable |
|
Catering Manager |
The associate at the property responsible for all aspects of catering services for events and conferences |
Not Applicable |
Not Applicable |
|
Service Manager |
The associate at the property responsible for planning the layout and setup of an event, along with handling the staff that will cater to the guests |
Not Applicable |
Not Applicable |
|
Conference Coordinator |
The associate at the property who acts like a liaison directly with the client to manage the event from the venue, food, and beverage perspective |
Not Applicable |
Not Applicable |
|
Group Sales Administrator |
The associate at the property who provides end-to-end service, developing leads, making sales presentations, coordinating events, and following up with clients |
Not Applicable |
Not Applicable |
|
Group Sales Representative |
The associate at the property who manages the group block end to end process |
Not Applicable |
Not Applicable |
|
Event Type |
This value further describes the potential business (for example, Social, Wedding, or Conference). |
Not Applicable |
Not Applicable |
|
Space Revenue |
Total amount generated from renting out meeting rooms
*total amount excludes sleeping room revenue |
NO |
=sum(space revenue) |
|
Package Revenue |
Total amount generated from packages added onto events / spaces |
NO |
=sum(package revenue) |
|
Event Revenue |
Total amount generated by the event
*total amount excludes sleeping room revenue |
NO |
=sum(space revenue) + (package revenue) |
Revenue by Rooms section: The Revenue by Rooms section provides a comprehensive overview of event sleeping room revenues by event for a defined period.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Property Code |
Unique identifier for the property |
Not Applicable |
Not Applicable |
|
Start Date |
The first day of the event |
Not Applicable |
Not Applicable |
|
End Date |
The last day of the event |
Not Applicable |
Not Applicable |
|
Event Status |
Current status of the event (e.g. canceled, prospect, tentative, confirmed, ended) |
Not Applicable |
Not Applicable |
|
Event Name |
Name of the event |
Not Applicable |
Not Applicable |
|
Confirmation Number |
Unique identifier for the event confirmation |
Not Applicable |
Not Applicable |
|
Created By |
The associate at the property who created the event |
Not Applicable |
Not Applicable |
|
Market Segment |
Market segment associated with the event |
Not Applicable |
Not Applicable |
|
Source |
Information on the source of the reservation (e.g. direct booking, email, MeetingBroker, etc.) |
Not Applicable |
Not Applicable |
|
Event Type |
This value further describes the potential business (for example, Social, Wedding, or Conference). |
Not Applicable |
Not Applicable |
|
Event Manager |
The associate at the property responsible for the entire process of planning and executing an event |
Not Applicable |
Not Applicable |
|
Catering Manager |
The associate at the property responsible for all aspects of catering services for events and conferences |
Not Applicable |
Not Applicable |
|
Service Manager |
The associate at the property responsible for planning the layout and setup of an event, along with handling the staff that will cater to the guests |
Not Applicable |
Not Applicable |
|
Conference Coordinator |
The associate at the property who acts like a liaison directly with the client to manage the event from the venue, food, and beverage perspective |
Not Applicable |
Not Applicable |
|
Group Sales Administrator |
The associate at the property who provides end-to-end service, developing leads, making sales presentations, coordinating events, and following up with clients |
Not Applicable |
Not Applicable |
|
Group Sales Representative |
The associate at the property who manages the group block end to end process |
Not Applicable |
Not Applicable |
|
ADR |
Average Daily Rate for the sleeping room block |
Not Applicable |
Not Applicable |
|
Room Nights |
Number of nights in the group reservation |
Not Applicable |
=sum(nights) |
|
Room Revenue |
Total revenue generated from the member reservations for the entire event |
NO |
=sum(room rent) |
|
Group Number |
Unique identifier for the group master reservation |
Not Applicable |
Not Applicable |
|
Contracted (CT) |
The number of sleeping rooms which can be booked if transient rooms are available at time of booking |
Not Applicable |
Not Applicable |
|
Authorized (AT) |
The number of allocated rooms deducted from inventory and guaranteed to the group |
Not Applicable |
Not Applicable |
Misc Report Information:
Available Features:
-
Export: ability to download and save the file into an alternate format.
-
Filter: filter a range of data based on criteria defined by the user.
-
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
Available Configuration:
-
User Preferences: allows the user to customize their report view by repositioning or removing columns.
-
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
-
Property Preferences Settings:
-
Following columns to be disabled for initial deployment:
-
Not Applicable
-
-