Event Inquiry Source Report

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.

Source Report.png
Event Inquiry Source 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 12 exact dynamic columns available in this report, sorted in alphabetical order by column name:

πŸ’° Financial Posting Logic: Figures in Revenue and Lost Revenue reflect net posted or projected charges for catering food, beverage, function space rentals, and packages. No. of Leads represents 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., CVent, Hotel Sales Office, Phone).

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

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
  • Marketing Channel ROI Analysis: Review Converted Inquiries against No. of Leads monthly to calculate channel conversion percentages and optimize third-party lead portal spend.

  • Turn-Down & Capacity Audits: Analyze Turn Down volume against Lost volume 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.

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

Cross-Pillar Deep Dives: