Sales Manager Production Report

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.

Sales Manager.png
Sales Manager Production Report

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, and Total Revenue reflect net charges posted or contracted for event functions and room blocks. Average Daily Rate is dynamically calculated as Room Revenue Γ· Room Nights, Event Revenue reflects Space Revenue + Package Revenue, and Total Revenue reflects 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., CANCELLED, ENDED, STARTED, TENTATIVE, PROSPECT).

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

Image 9-29-26 at 1.04β€―PM.png

Knowledge Article

Opens the knowledge base article to learn how to interpret this report.

Image 9-29-26 at 12.37β€―PM.png

Saved Views

Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.

Image 9-29-26 at 12.39β€―PM.png

Filter

Opens filter controls to isolate specific data within a column based on your selected criteria.

Image 9-29-26 at 12.40β€―PM.png

Highlight

Highlights column values in a designated color based on selected conditions.

Image 9-29-26 at 12.42β€―PM.png

Export

Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.

Image 9-29-26 at 12.43β€―PM.png

Configure

Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.

Image 9-29-26 at 12.44β€―PM.png

Additional Configuration

Provides advanced report configuration and display formatting options to customize data presentation.

Advanced Controls
  • Sales Incentive & Quota Audits: Filter by Created By and Event Status = ENDED (or CONFIRMED) to audit individual sales production for commission payouts.

  • Closing Velocity Audits: Compare Booked against Last Status Date to 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).

Within 🀝 Sales, Groups & Events Reports & πŸ₯‚ Event Management (EventKey):

Cross-Pillar Deep Dives: