Lead Report
Lead Summary Report - User Guide
1. Introduction đ
The CRM Lead Summary Report provides an executive-level analytical audit of your entire customer acquisition funnel. Exported as a professionally formatted, multi-worksheet Excel workbook (Lead_Summary_Report.xlsx), this report consolidates lead origin channels, individual sales representative conversion ratios, and detailed pipeline aging metrics.
Strategic Value:
- Acquisition Audit: Identify which marketing platforms and campaign channels generate the highest ratio of won deals.
- Sales Rep Benchmarking: Compare team productivity, status breakdowns, and closing percentages side-by-side.
- Pipeline Health & Velocity: Uncover dormant or neglected accounts using dual Pre-Aging and Post-Aging time diagnostics.
2. Getting Started đ
Accessing the Report Option
Navigate to CRM > Reports > Lead Report (/crmleadreportoption).
The Filter Interface
The report options screen prompts for your desired inquiry span:
- From Date: Defaults to the start of the active financial year.
- To Date: Defaults to today’s date (or the end of the fiscal year).
- Print Button: Validates dates and initiates report generation.
3. The 3-in-1 Multi-Worksheet Excel Architecture đ
The generated workbook contains three distinct worksheets tailored for strategic and operational analysis:
graph TD
ReportOptions["Lead Report Filter (Date Range)"] --> Generator["Report Generation Engine"]
Generator --> Sheet1["Platform Summary Sheet (Channel Volume and Conversions)"]
Generator --> Sheet2["Salesmen Performance Sheet (Rep Productivity and Status Ratios)"]
Generator --> Sheet3["Aging Sheet (Pre-Aging Cadence and Post-Aging Inactivity)"]
style ReportOptions fill:#e0f2fe,stroke:#0284c7,stroke-width:2px
style Generator fill:#fef3c7,stroke:#d97706,stroke-width:2px
style Sheet1 fill:#dcfce7,stroke:#16a34a,stroke-width:2px
style Sheet2 fill:#f3e8ff,stroke:#9333ea,stroke-width:2px
style Sheet3 fill:#fed7aa,stroke:#ea580c,stroke-width:2pxSheet 1: Platform_Summary (Channel Breakdown)
Analyzes lead acquisition sources against every configured pipeline milestone:
- Source / Platform Name: Cataloged acquisition channels (e.g., Website, Google Ads, Trade Fair Expo, LinkedIn).
- Dynamic Status Columns: The system dynamically generates count columns for each Lead Status present in your database (e.g.,
Interested Leads,Demo Scheduled Leads,Converted Leads,Dropped Leads). - Total Leads: Cumulative prospects registered from that platform.
- Dynamic Percentage Breakdown: Displays exact percentage shares (e.g.,
Converted %,Dropped %) formatted to two decimal places.
Sheet 2: Salesmen_Performance (Representative Breakdown)
Evaluates individual sales team productivity and conversion effectiveness:
- Salesmen Name: Sales personnel directory.
- Dynamic Status Columns: Exact volume of leads managed by each representative in each pipeline stage.
- Total Leads Handled: Overall pipeline volume assigned to the executive.
- Status Percentage Metrics: Shows personal conversion rates and stage distribution for objective KPI appraisals.
Sheet 3: Aging (Pipeline Velocity Diagnostics)
Provides a line-by-line itemized audit of every opportunity within the period:
- Lead Metadata: Lead Number, Company Name, Contact Person, Salesperson, and Current Status.
- Key Milestone Dates: Lead Created Date and Last Activity Date.
- đ Missed / Power Feature: Pre-Aging vs Post-Aging Metrics:
- Pre-Aging (Cadence Days): The number of days elapsed between the initial Lead Creation Date and the Last Recorded Activity Date. Indicates how long sales reps actively engaged the client before reaching the current stage.
- Post-Aging (Stagnation Days): The number of idle days elapsed between the Last Recorded Activity Date and today. Identifies stalled opportunities that have gone “cold” and urgently require renewed follow-up!
4. Dual Processing Modes: Direct vs Background Queue âĄ
To guarantee fast response times without straining server resources, the system automatically selects an execution mode based on inquiry data volume:
- Direct Download Mode (
D):- For standard or focused date ranges, the server compiles the spreadsheet instantaneously and triggers an immediate browser file download.
- Asynchronous Background Queue (
Q):- For heavy historical queries across long timeframes, the request is automatically routed to a background queue.
- A notification dialog confirms the job is queued.
- Once rendering finishes, the completed Excel report is automatically dispatched directly to the user’s registered corporate email.
5. Validations and Error Handling â ī¸
The report generator enforces data and performance safeguards:
| Validation Scenario | What is checked? | Error Message / System Behavior |
|---|---|---|
| Chronological Sequence | Ensures To Date is not earlier than From Date. | “Invalid Date Range” |
| Future Date Prohibition | Prevents generating reports for future dates beyond today. | “Future Dates are not allowed” |
| Maximum 2-Year Query Cap | Enforces a strict maximum date range span of two years to prevent database exhaustion. | “Gap between Date Range may not exceed 2 years” |
| High Queue Load Guard | If 15 or more background report tasks are currently awaiting execution on the server. | “The system is currently handling a high number of report requests. Please try again in a few minutes.” |
6. Tools / Smart Features đ§
- âī¸ Frozen Header Rows: Excel worksheets feature frozen header rows (Row 5), keeping column headings visible while scrolling through thousands of records.
- đ¨ Conditional Number Styling: Percentages and numeric days are formatted with dedicated styling, displaying negative or zero balances cleanly.
- đ Auto-Adjusted Column Widths: Every column automatically sizes to fit its longest content string, ensuring print-ready presentation upon opening.
7. Configuration Requirements âī¸
- Permissions: Access to configure and generate lead reports requires the
CrmReportsecurity role.
8. Best Practices đĄ
- Weekly Stagnation Audits: Open the Aging sheet every Monday and sort by Post-Aging in descending order. Any active lead with a Post-Aging value greater than 14 days should immediately be assigned a follow-up call.
- Channel Investment Reviews: Compare the Platform Summary worksheet against your quarterly marketing advertising expenses to calculate true cost-per-lead and cost-per-acquisition.