Sales Manager Production Report Overview
Parent Hub: π€ Sales, Groups & Events Reports
Category: π₯ Event Management (EventKey)
Target Roles: Directors of Sales, Catering & Event Directors, Sales Operations Leads, Hotel Controllers, General Managers
Key Value: Monitor individual sales manager production, audit event-level commercial performance across guest rooms and catering functions, track contract status progression timelines, evaluate room night and ADR contributions, and benchmark sales team revenue yield.
Date Parameter: Date Range Selector (Start & End) | Past & Future | Maximum Window: None
Executive Summary
The Sales Manager Production Report is an essential commercial auditing, sales team performance, and account production document within the π₯ Event Management (EventKey) category of the π€ Sales, Groups & Events Reports hub. Designed to provide complete visibility over individual sales manager contracting output, it itemizes event bookings, attached guest room blocks, catering food and beverage packages, function space rentals, and status lifecycle milestones across specified reporting periods.
-
By mapping sales creator credentials (
Created By) and master event identification details (Event Name,Event Confirmation Number,Event Status,Company Name,Travel Agent) to contractual event execution timelines (Arrival,Departure,Booked,Last Status Date), lodging production metrics (Room Nights,Room Revenue,Average Daily Rate), and multi-category catering revenues (Space Revenue,Package Revenue,Event Revenue,Total Revenue), this report enables commercial leadership to evaluate individual sales production, track pipeline closing velocities, verify account ownership, and analyze total customer value across rooms and banquets.
Key Capabilities
-
Individual Sales Production Auditing: Consolidates all event agreements, corporate accounts, and agency bookings attributed to each sales creator (
Created By) into a unified master view. -
Multi-Revenue Stream Disaggregation: Separates lodging revenue (
Room Revenue) from function room rentals (Space Revenue) and catering packages (Package Revenue) while computing total catering earnings (Event Revenue) and comprehensive contract yield (Total Revenue). -
Attached Group Room Block Realization: Monitors guest room night commitments (
Room Nights), realized lodging earnings (Room Revenue), and group rate yield (Average Daily Rate) attached to event contracts. -
Sales Velocity & Status Milestone Tracking: Captures initial booking timestamps (
Booked) alongside status change milestones (Last Status Date) to analyze contract negotiation velocity across lifecycle stages (Event Status, e.g.,CANCELLED,ENDED,STARTED,TENTATIVE,PROSPECT). -
Account & Intermediary Attribution: Connects commercial event production directly to corporate profiles (
Company Name) and third-party planning agencies (Travel Agent).
Report Views & Functional Breakdown
The Sales Manager Production Report presents sales contracting performance in a unified single-table master matrix supporting three primary operational perspectives:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SALES MANAGER PRODUCTION REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Unified Matrix View β
ββββββββββββββββββββββββββββ¬βββββββββββββββββββββββββββ¬βββββββββββββββββββ€
β 1. Sales Ownership & β 2. Stay Window & β 3. Multi-Stream β
β Account Profile β Status Milestones β Revenue Yield β
ββββββββββββββββββββββββββββ΄βββββββββββββββββββββββββββ΄βββββββββββββββββββ
1. Sales Ownership & Account Profile
Monitors the designated sales manager lead, event descriptive title, confirmation ID, lifecycle status, corporate client name, and booking agency.
-
Primary Use: Verifying sales creator attribution, reviewing corporate client affiliations, and auditing third-party intermediary representation.
-
Key Metrics: Created By, Event Name, Event Confirmation Number, Event Status, Company Name, Travel Agent.
2. Stay Window & Status Milestones
Tracks operational execution timeframes, booking creation timestamps, and the most recent status transition dates.
-
Primary Use: Measuring lead-to-booking conversion intervals, auditing decision timelines, and confirming upcoming arrival schedules.
-
Key Metrics: Arrival, Departure, Booked, Last Status Date, Event Status.
3. Multi-Stream Revenue Yield
Audits financial performance across attached room blocks, space rental charges, catering packages, cumulative event earnings, and grand total revenues.
-
Primary Use: Sizing individual manager commercial production, evaluating group lodging ADR contributions, and auditing total contract revenue yield.
-
Key Metrics: Room Nights, Room Revenue, Average Daily Rate, Space Revenue, Package Revenue, Event Revenue, Total Revenue.
Data Dictionary (Dynamic View Columns)
Customize your default view using the Configure (βοΈ) icon on the report page. Below is the full data dictionary representing all 17 exact dynamic columns available in this report, sorted in alphabetical order by column name:
π° Financial Posting Logic: Figures in
Room Revenue,Space Revenue,Package Revenue,Event Revenue, andTotal Revenuereflect net charges posted or contracted for event functions and room blocks.Average Daily Rateis dynamically calculated as Room Revenue Γ· Room Nights,Event Revenuereflects Space Revenue + Package Revenue, andTotal Revenuereflects Room Revenue + Event Revenue.
|
Column Name |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Arrival |
Scheduled start date and time (commencement timestamp) of the catering event or attached group stay window. |
Event Master > Arrival Timestamp |
N/A |
|
Average Daily Rate |
Calculated Average Daily Rate realized across attached group room nights (Room Revenue Γ· Room Nights). |
Calculated: Net Group ADR |
β No |
|
Booked |
Original date and time stamp recording when the event booking was created in the system. |
System Audit Trail > Booking Timestamp |
N/A |
|
Company Name |
Official business name of the corporate account or company profile hosting the event. |
Account Master > Profile Name |
N/A |
|
Created By |
Full name or system username of the sales manager or staff member who created and owns the event record. |
Security Master > Username |
N/A |
|
Departure |
Scheduled completion date and time (concluding timestamp) of the catering event or attached group stay window. |
Event Master > Departure Timestamp |
N/A |
|
Event Confirmation Number |
Primary unique alphanumeric confirmation ID assigned to the master event in EventKey. |
Event Master > Confirmation ID |
N/A |
|
Event Name |
Official title or descriptive commercial name of the catering event, meeting, or group function. |
Event Master > Event Title |
N/A |
|
Event Revenue |
Total gross catering revenue generated combining function space rental and package revenues (Space Revenue + Package Revenue). |
Calculated: Total Catering Yield |
β No |
|
Event Status |
Operational lifecycle state of the master event record (e.g., |
Event Master > Status Code |
N/A |
|
Last Status Date |
Most recent date and time stamp recording when the event lifecycle status was updated or changed. |
System Audit Trail > Status Change Timestamp |
N/A |
|
Package Revenue |
Total net revenue generated from bundled catering packages and food/beverage menus. |
Event Ledger > Package Revenue |
β No |
|
Room Nights |
Total cumulative guest room nights picked up or occupied under attached group blocks. |
Group Block Engine > Occupied Nights |
N/A |
|
Room Revenue |
Total net lodging room rental revenue generated from attached group room blocks. |
Group Ledger > Room Revenue |
β No |
|
Space Revenue |
Total net rental revenue generated from function room and meeting space rentals. |
Event Ledger > Space Rental |
β No |
|
Total Revenue |
Total cumulative gross revenue generated across all lodging, space rental, and catering package streams (Room Revenue + Space Revenue + Package Revenue). |
Calculated: Grand Total Production |
β No |
|
Travel Agent |
Official business name of the travel agency or intermediary booking profile associated with the event. |
Profile Master > Agency Name |
N/A |
Customization & Platform Features
User & Property Preferences
-
Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.
-
Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks:
-
Manager Accountability & Event Identifiers (Cols 1β3):
Created By|Event Name|Event Confirmation Number -
Lifecycle State & Account Profiles (Cols 4β6):
Event Status|Company Name|Travel Agent -
Stay Schedule & Booking Timelines (Cols 7β10):
Arrival|Departure|Booked|Last Status Date -
Guest Room Production & Rate Yield (Cols 11β13):
Room Nights|Room Revenue|Average Daily Rate -
Catering Revenue Streams & Financial Totals (Cols 14β17):
Total Revenue|Event Revenue|Space Revenue|Package Revenue
-
Report Toolbar & Quick Actions
Use the top-right toolbar icons on the report page to manage and export your data view:
|
Icon |
Action / Feature |
Description |
|
Knowledge Article |
Opens the knowledge base article to learn how to interpret this report. |
|
Saved Views |
Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report. |
|
Filter |
Opens filter controls to isolate specific data within a column based on your selected criteria. |
|
Highlight |
Highlights column values in a designated color based on selected conditions. |
|
Export |
Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing. |
|
Configure |
Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros. |
|
Additional Configuration |
Provides advanced report configuration and display formatting options to customize data presentation. |
Advanced Controls
-
Sales Incentive & Quota Audits: Filter by
Created ByandEvent Status = ENDED(orCONFIRMED) to audit individual sales production for commission payouts. -
Closing Velocity Audits: Compare
BookedagainstLast Status Dateto measure average sales cycle turnaround times per coordinator. -
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-yield contracts (
Total Revenue > $5,000), cancelled bookings with lost revenue, or bookings with attached room nights (Room Nights > 0).
π Related Reports & Next Steps
Within π€ Sales, Groups & Events Reports & π₯ Event Management (EventKey):
-
All Events Report β Two-section master event summary and sub-event execution log.
-
Event Books Report β Three-section catering sales audit tracking status-based yields, sub-event revenues, and attached room blocks.
-
Event Contracts Report β Event contract and BEO signature workflow tracking report.
-
Event Coordinator Productivity Report β Sales manager revenue performance and budget variance audit.
-
Event Deposit Schedules Report β Advance deposit schedule and payment compliance report.
-
Event Group Blocks Report β Master event and attached PMS group room block integration report.
-
Event Tasks Report β Automated and manual event milestone action items and operational task tracking report.
Cross-Pillar Deep Dives:
-
π’ Corporate Accounts: Cross-reference sales production with Company Details Report, Top Accounts Report, and Company Analysis Report to evaluate total account production across corporate lodging and banquets.
-
π₯ Group Block: Align sales manager production (
Room Nights,Room Revenue,Average Daily Rate) with Group Pickup Details Report and Group Activity Report to audit group block pickup realization.