Event Inquiry Source Report Overview
Parent Hub: π€ Sales, Groups & Events Reports
Category: π₯ Event Management (EventKey)
Target Roles: Catering & Event Directors, Directors of Sales, Marketing Managers, Sales Operations Leads, Hotel Controllers, General Managers
Key Value: Evaluate lead generation channel effectiveness, track inquiry pipeline progression across workflow stages, audit lead-to-booking conversion rates, measure channel-wise catering revenue generation, and optimize marketing spend.
Date Parameter: Date Range Selector (Start & End) | Past & Future | Maximum Window: 731 Days
Executive Summary
The Event Inquiry Source Report is an essential catering sales CRM dashboard, lead conversion audit, and marketing channel ROI analysis document within the π₯ Event Management (EventKey) category of the π€ Sales, Groups & Events Reports hub. Designed to deliver complete operational and commercial visibility over incoming event inquiries disaggregated by booking channel, it itemizes lead volumes, workflow status progression, conversion counts, realized catering revenues, and lost revenue potential across specified reporting windows.
-
By mapping lead origin channels (
Source) to pipeline workflow stages (Open,Working,Qualified,Dormant,In Progress,Turn Down,Lost), total volume indicators (No. of Leads), conversion counts (Converted Inquiries), realized commercial earnings (Revenue), and lost business impact (Lost Revenue), this report enables sales directors, marketing managers, and hotel controllers to evaluate lead channel quality, identify sales pipeline bottlenecks, optimize sales team response times, and allocate marketing budgets to the highest-converting booking sources.
Key Capabilities
-
Lead Generation Channel Performance Tracking: Itemizes total incoming lead inquiry volumes (
No. of Leads) disaggregated by booking origin (Source, e.g.,CVent,Hotel Sales Office,Phone). -
Pipeline Workflow Stage Disaggregation: Tracks lead progression across all inquiry workflow stagesβunassigned (
Open), active outreach (Working), vetted criteria (Qualified), inactive (Dormant), contract negotiation (In Progress), property rejection (Turn Down), and client loss (Lost). -
Lead Conversion Rate Audit: Measures exact counts of inquiries that successfully converted into confirmed event agreements (
Converted Inquiries). -
Converted & Lost Revenue Measurement: Quantifies net catering and space rental earnings generated from converted leads (
Revenue) against total potential revenue lost to unbooked or turned-down inquiries (Lost Revenue). -
Turn-Down & Loss Variance Analysis: Evaluates lead rejection causes (
Turn Down,Lost) to differentiate between capacity constraints and client non-selection.
Report Views & Functional Breakdown
The Event Inquiry Source Report presents lead channel and pipeline conversion data in a unified single-table master matrix supporting three primary operational perspectives:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β EVENT INQUIRY SOURCE REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Unified Matrix View β
ββββββββββββββββββββββββββββ¬βββββββββββββββββββββββββββ¬βββββββββββββββββββ€
β 1. Channel Identity & β 2. Pipeline Workflow β 3. Conversion & β
β Lead Volume Trace β Stage Disaggregation β Financial Yieldβ
ββββββββββββββββββββββββββββ΄βββββββββββββββββββββββββββ΄βββββββββββββββββββ
1. Channel Identity & Lead Volume Trace
Monitors lead origin channels and cumulative inquiry volume counts generated over the reporting timeframe.
-
Primary Use: Evaluating lead volume distribution across marketing channels and identifying top lead generation sources.
-
Key Metrics: Source, No. of Leads.
2. Pipeline Workflow Stage Disaggregation
Tracks inquiry volume counts across active, pending, dormant, and unbooked pipeline workflow stages.
-
Primary Use: Analyzing sales team lead processing efficiency, identifying stagnant lead pipelines, and auditing lead turn-downs.
-
Key Metrics: Open, Working, Qualified, Dormant, In Progress, Turn Down, Lost, Source.
3. Conversion & Financial Yield
Audits successful lead conversion counts, realized net catering revenue, and total lost revenue potential.
-
Primary Use: Measuring channel conversion ratios, evaluating marketing channel ROI, and calculating lost revenue impact.
-
Key Metrics: Converted Inquiries, Revenue, Lost Revenue, Source.
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 12 exact dynamic columns available in this report, sorted in alphabetical order by column name:
π° Financial Posting Logic: Figures in
RevenueandLost Revenuereflect net posted or projected charges for catering food, beverage, function space rentals, and packages.No. of Leadsrepresents the sum of inquiries across all status categories (Open + Working + Qualified + Dormant + In Progress + Turn Down + Lost).
|
Column Name |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Converted Inquiries |
Numerical count of lead inquiries generated from the channel that successfully converted into confirmed event agreements. |
Event CRM > Converted Count |
N/A |
|
Dormant |
Numerical count of event inquiries in inactive or dormant status. |
Event CRM > Inactive Count |
N/A |
|
In Progress |
Numerical count of event inquiries currently under active contract negotiation or proposal development. |
Event CRM > Negotiating Count |
N/A |
|
Lost |
Numerical count of event inquiries marked as lost due to client cancellation or non-selection. |
Event CRM > Lost Count |
N/A |
|
Lost Revenue |
Total monetary event revenue lost due to cancelled or lost inquiries. |
Event Ledger > Lost Revenue Sum |
β No |
|
No. of Leads |
Total cumulative count of lead inquiries generated through the specific channel (Open + Working + Qualified + Dormant + In Progress + Turn Down + Lost). |
Calculated: Total Channel Leads |
N/A |
|
Open |
Numerical count of newly received, unassigned, or unworked event inquiries. |
Event CRM > Unassigned Count |
N/A |
|
Qualified |
Numerical count of vetted event inquiries that meet client budget, date, and space availability criteria. |
Event CRM > Qualified Count |
N/A |
|
Revenue |
Total net catering and function space revenue generated from converted event bookings. |
Event Ledger > Converted Revenue Sum |
β No |
|
Source |
Lead origin or booking channel source through which the event inquiry was generated (e.g., |
Event CRM > Channel Source |
N/A |
|
Turn Down |
Numerical count of event inquiries rejected or turned down by the property due to space or date unavailability. |
Event CRM > Turned Down Count |
N/A |
|
Working |
Numerical count of event inquiries currently being actively worked by the sales team. |
Event CRM > Active Working Count |
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:
-
Inquiry Channel Source (Col 1):
Source -
Lead Volume & Conversion KPIs (Cols 2β3):
No. of Leads|Converted Inquiries -
Financial Revenue KPIs (Cols 4β5):
Revenue|Lost Revenue -
Active Lead Pipeline Progression Stages (Cols 6β10):
Open|Working|Qualified|In Progress|Dormant -
Inactive / Unsuccessful Lead Outcomes (Cols 11β12):
Turn Down|Lost
-
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
-
Marketing Channel ROI Analysis: Review
Converted InquiriesagainstNo. of Leadsmonthly to calculate channel conversion percentages and optimize third-party lead portal spend. -
Turn-Down & Capacity Audits: Analyze
Turn Downvolume againstLostvolume to determine if lost business stems from property space constraints or competitive pricing resistance. -
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-revenue channels (
Revenue > $1,000), channels with high open lead bottlenecks (Open > 5), or top lost revenue channels.
π 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 Contact Summary Report β Two-section client contact summary and lead inquiry channel performance report.
-
Event Coordinator Productivity Report β Sales manager revenue performance and budget variance audit.
Cross-Pillar Deep Dives:
-
π’ Corporate Accounts: Cross-reference lead inquiry channels with Company Details Report, Top Accounts Report, and Company Analysis Report to track corporate account sourcing.
-
π Financial & Revenue Management: Reconcile realized catering revenue (
Revenue) with monthly Trial Balance Report and Event Pace Report.