Event Coordinator Productivity Report Overview
Parent Hub: π€ Sales, Groups & Events Reports
Category: π₯ Event Management (EventKey)
Target Roles: Catering & Event Directors, Directors of Sales, Sales Operations Leads, Hotel Controllers, General Managers
Key Value: Monitor individual sales coordinator productivity, evaluate event revenue performance against budget targets, analyze budget variances and percentage realizations, track contract conversions, and benchmark year-over-year sales performance.
Date Parameter: Date Range Selector (Start & End) | Past | Maximum Window: None
Executive Summary
The Event Coordinator Productivity Report is an essential catering sales management, budget variance audit, and sales manager performance document within the π₯ Event Management (EventKey) category of the π€ Sales, Groups & Events Reports hub. Designed to deliver complete financial and operational visibility over individual sales coordinator performance, it itemizes newly confirmed definite revenue, established revenue budgets, pipeline stage distributions, budget variances, and historical year-over-year performance benchmarks.
-
By mapping individual catering leads (
Sales Coordinator) to contractual revenue pipeline categories (New Definite,Net Confirmed,Tentative Event Revenue,Prospect Event Revenue), budget targets (Event Revenue Budget), variance indicators (Event Revenue Budget Variance,Event Revenue Budget Pct Variance), lost/revalued contract adjustments (Lost,Reval), historical comparison metrics (New Definite Last Year,Lost Last Year,Reval Last Year,Net Confirmed Last Year), and cumulative year-to-date tracking (New Definite YTD), this report enables sales directors and hotel controllers to evaluate coordinator revenue production, identify underperforming accounts, optimize pipeline conversion rates, and hold event managers accountable to monthly sales quotas.
Key Capabilities
-
Sales Coordinator Revenue Performance Tracking: Itemizes newly booked definite event revenue (
New Definite) and net confirmed sales (Net Confirmed) per individual sales manager. -
Budget Variance & Goal Realization Audit: Compares actual coordinator revenue against established budget quotas (
Event Revenue Budget) to compute absolute variances (Event Revenue Budget Variance) and percentage realizations (Event Revenue Budget Pct Variance). -
Pipeline Stage Distribution Analysis: Monitors unconfirmed pipeline revenue stages across tentative bookings (
Tentative Event Revenue) and prospect leads (Prospect Event Revenue). -
Lost & Revalued Contract Tracking: Tracks cancelled event revenue (
Lost) and contract revaluations (Reval) to evaluate net pipeline slippage. -
Year-over-Year (YoY) & YTD Benchmarking: Compares current catering production against prior year performance (
New Definite Last Year,Lost Last Year,Reval Last Year,Net Confirmed Last Year) alongside year-to-date totals (New Definite YTD).
Report Views & Functional Breakdown
The Event Coordinator Productivity Report presents catering sales performance data in a unified single-table master matrix supporting three primary operational perspectives:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β EVENT COORDINATOR PRODUCTIVITY REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Unified Matrix View β
ββββββββββββββββββββββββββββ¬βββββββββββββββββββββββββββ¬βββββββββββββββββββ€
β 1. Coordinator Identity β 2. Pipeline Stage β 3. YoY & YTD β
β & Budget Variance β & Loss Analysis β Historical Audit
ββββββββββββββββββββββββββββ΄βββββββββββββββββββββββββββ΄βββββββββββββββββββ
1. Coordinator Identity & Budget Variance
Monitors assigned sales coordinators, newly confirmed definite revenue, established event revenue budgets, net confirmed sales, and calculated budget variance indicators.
-
Primary Use: Evaluating monthly quota achievement per sales manager and identifying coordinators exceeding or falling short of revenue targets.
-
Key Metrics: Sales Coordinator, New Definite, Event Revenue Budget, Net Confirmed, Event Revenue Budget Variance, Event Revenue Budget Pct Variance.
2. Pipeline Stage & Loss Analysis
Tracks active unconfirmed pipeline opportunities across tentative and prospect stages alongside contract cancellations and revaluations.
-
Primary Use: Analyzing coordinator pipeline depth, identifying conversion bottlenecks, and auditing lost catering business.
-
Key Metrics: Tentative Event Revenue, Prospect Event Revenue, Lost, Reval, Sales Coordinator.
3. YoY & YTD Historical Audit
Benchmarks current coordinator production against same-period performance from the previous year and cumulative year-to-date totals.
-
Primary Use: Evaluating long-term sales growth, conducting annual performance reviews, and tracking year-to-date quota progression.
-
Key Metrics: New Definite Last Year, Lost Last Year, Reval Last Year, Net Confirmed Last Year, New Definite YTD, Sales Coordinator.
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 15 exact dynamic columns available in this report, sorted in alphabetical order by column name:
π° Financial Posting Logic: Figures in
New Definite,Event Revenue Budget,Net Confirmed,Tentative Event Revenue,Prospect Event Revenue,Lost,Reval, and historical benchmark columns reflect net catering revenue figures posted or budgeted for event agreements.Event Revenue Budget Varianceis dynamically calculated as (Net Confirmed - Event Revenue Budget) or (Event Revenue Budget - Net Confirmed) depending on display orientation, andEvent Revenue Budget Pct Variancereflects the percentage realization ratio.
|
Column Name |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Event Revenue Budget |
Target event revenue quota assigned to the sales coordinator for the reporting period. |
Sales Budget Setup > Target Budget |
β No |
|
Event Revenue Budget Pct Variance |
Calculated percentage ratio of budget variance achieved by the sales coordinator. |
Calculated: Realization Ratio |
N/A |
|
Event Revenue Budget Variance |
Monetary variance difference between actual confirmed event revenue and budget quota. |
Calculated: Net Variance Amount |
β No |
|
Lost |
Total net event revenue lost due to event cancellations during the reporting window. |
Event Ledger > Cancelled Revenue |
β No |
|
Lost Last Year |
Total net event revenue lost due to event cancellations during the same period in the prior year. |
Historical Ledger > Prior Year Lost |
β No |
|
Net Confirmed |
Net confirmed event revenue achieved by the sales coordinator (New Definite - Lost + Reval). |
Calculated: Net Confirmed Yield |
β No |
|
Net Confirmed Last Year |
Net confirmed event revenue achieved by the sales coordinator during the same period in the prior year. |
Historical Ledger > Prior Year Net Confirmed |
β No |
|
New Definite |
Total new event revenue converted to definite contract status during the reporting window. |
Event Ledger > Definite Converted |
β No |
|
New Definite Last Year |
Total new event revenue converted to definite contract status during the same period in the prior year. |
Historical Ledger > Prior Year Definite |
β No |
|
New Definite YTD |
Cumulative year-to-date total of new definite event revenue booked by the sales coordinator. |
Calculated: YTD Definite Sum |
β No |
|
Prospect Event Revenue |
Projected event revenue for unconfirmed leads currently in prospect status. |
Event Ledger > Prospect Pipeline |
β No |
|
Reval |
Monetary revaluation adjustments to active event contracts (rate changes or scope modifications). |
Event Ledger > Contract Revaluations |
β No |
|
Reval Last Year |
Monetary revaluation adjustments to active event contracts during the same period in the prior year. |
Historical Ledger > Prior Year Reval |
β No |
|
Sales Coordinator |
Full name of the sales manager or event coordinator assigned to the account (e.g., |
Event Master > Sales Lead |
N/A |
|
Tentative Event Revenue |
Projected event revenue for unconfirmed agreements currently in tentative status. |
Event Ledger > Tentative Pipeline |
β No |
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:
-
Sales Coordinator Identity (Col 1):
Sales Coordinator -
Current Period Production & Budget Performance (Cols 2β6):
Net Confirmed|Event Revenue Budget|Event Revenue Budget Variance|Event Revenue Budget Pct Variance|New Definite -
Pipeline Production Stages & Adjustments (Cols 7β10):
Tentative Event Revenue|Prospect Event Revenue|Reval|Lost -
Year-to-Date (YTD) Production Metrics (Cols 11β14):
Net Confirmed YTD|New Definite YTD|REVAL YTD|Lost YTD -
Prior Year Comparative Benchmarks (Cols 15β18):
Net Confirmed Last Year|New Definite Last Year|Reval Last Year|Lost Last Year
-
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
-
Monthly Quota Realization Audits: Review
Event Revenue Budget Pct Variancemonthly to evaluate individual sales manager quota fulfillment and calculate performance-based sales incentives. -
Pipeline Conversion Optimization: Compare
Tentative Event RevenueagainstNew Definiteto identify sales managers with high tentative volume requiring closing assistance. -
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight coordinators exceeding budget (
Event Revenue Budget Variance > $0), underperforming accounts, or high lost revenue figures (Lost > $500).
π 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 Cancellation Reason Code Report β Two-section audit tracking root causes and staff logs for cancelled catering events.
-
Event Commission Report β Travel agency commission audit tracking commissionable event revenues and payouts.
-
Event Contact Summary Report β Two-section client contact summary and lead inquiry channel performance report.
-
Event Contracts Report β Event contract and BEO signature workflow tracking report.
Cross-Pillar Deep Dives:
-
π’ Corporate Accounts: Cross-reference sales coordinator accounts with Company Details Report, Top Accounts Report, and Company Analysis Report to evaluate total B2B client production.
-
π₯ Group Block: Reconcile coordinator event sales with Group Activity Report and Group Reservations Report to align catering production with room block commitments.