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:

  1. Acquisition Audit: Identify which marketing platforms and campaign channels generate the highest ratio of won deals.
  2. Sales Rep Benchmarking: Compare team productivity, status breakdowns, and closing percentages side-by-side.
  3. 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:2px

Sheet 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:

  1. Direct Download Mode (D):
    • For standard or focused date ranges, the server compiles the spreadsheet instantaneously and triggers an immediate browser file download.
  2. 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 ScenarioWhat is checked?Error Message / System Behavior
Chronological SequenceEnsures To Date is not earlier than From Date.“Invalid Date Range”
Future Date ProhibitionPrevents generating reports for future dates beyond today.“Future Dates are not allowed”
Maximum 2-Year Query CapEnforces 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 GuardIf 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 CrmReport security 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.