# Pipeline Progression

<p class="doc-lead">Lead Pipeline Progression shows how leads created in the selected date range are distributed across configured pipeline statuses, with conversion KPIs. Status rows follow the lead-status hierarchy order.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/crm/reports/pipeline-progression?id=overview">Overview</a>
<a href="#/crm/reports/pipeline-progression?id=use-cases">Use Cases</a>
<a href="#/crm/reports/pipeline-progression?id=filters">Filters</a>
<a href="#/crm/reports/pipeline-progression?id=kpi-cards">KPI Cards</a>
<a href="#/crm/reports/pipeline-progression?id=columns">Columns</a>
<a href="#/crm/reports/pipeline-progression?id=actions">Actions</a>
<a href="#/crm/reports/pipeline-progression?id=faq">FAQ</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Open from <b>CRM → Reports → Pipeline Progression</b>.

Page title in ERP: <b>Lead Pipeline Progression</b>

Shows lead counts per <a href="#/crm/lead-status">Lead Status</a> stage for leads <b>created</b> in the date range. Status rows appear in pipeline tree order (parent → child).

Empty state: <b>No pipeline data for the selected filters.</b>

There is no kanban or pipeline board view in Freespace — this report is the primary funnel analysis tool.

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>Pipeline health check</b> — See where leads accumulate in the funnel.</li>
<li><b>Monthly review</b> — Compare stage distribution month over month using date range presets.</li>
<li><b>Conversion tracking</b> — Use Converted and Conversion rate KPIs alongside stage counts.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

| **Filter** | **Location** | **Notes** |
|------------|--------------|-----------|
| Date range | Header | Lead Created date. Converted count uses customer Created date in same range. Default: current month. |
| Branch | Advanced Filter | Hidden for single-branch companies. |
| Route | Advanced Filter | Autocomplete. |
| Lead owner | Advanced Filter | Employee autocomplete. |
| Lead source | Advanced Filter | Active sources only. |

Toolbar: <b>Generate</b>, <b>Advanced Filter</b>, clear.

<hr class="doc-section-divider">

<h2 id="kpi-cards">KPI Cards</h2>

| **Card** | **Shows** |
|----------|-----------|
| Total leads | Sum of all stage counts |
| Converted | Customers with a linked lead, created in range |
| Conversion rate | (Converted ÷ Total leads) × 100, with % suffix |

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

| **Column** | **Shows** |
|------------|-----------|
| Status | Lead status name. |
| Count | Leads in that status. |
| Distribution | Progress bar relative to the highest stage count (hidden on extra-small screens). |

No grand total row in the table — use the Total leads KPI card.

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<b>Generate</b>, <b>Advanced Filter</b>, clear — no export, print, or drill-down.

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<p><b>Is this the same as an Opportunity pipeline board?</b><br>
No. This report counts leads by Lead Status. Opportunities use a separate list with Draft/Approved status, not a visual pipeline board.</p>

<p><b>Why don't stage counts add up to Total leads?</b><br>
Each lead has one current status; Total leads is the sum of counts across all stages for leads created in the range.</p>

<p><b>How is Converted KPI calculated?</b><br>
Converted counts leads that became customers in the period — it may differ from Won stage counts when conversion date and status change timing differ.</p>

<p><b>What does the distribution bar show?</b><br>
Visual share of leads in each status row relative to total leads created in the filtered Created date range.</p>

<p><b>Does filter by Lead Owner affect KPI cards?</b><br>
Yes. Owner and source filters on the report narrow both KPI cards and stage rows to matching leads.</p>

<p><b>Why is my custom status missing from the funnel?</b><br>
Statuses with zero leads in the date range are omitted. Confirm leads were created in the range and assigned to that status.</p>

<p><b>Is this a substitute for opportunity tracking?</b><br>
No. Opportunities are separate documents with item lines and sale quotation conversion — this report tracks lead pipeline status only.</p>

<hr class="doc-section-divider">

<h2 id="related">Related</h2>

<ul>
<li><a href="#/crm/lead-status">Lead Status</a></li>
<li><a href="#/crm/reports/lead-owner-report">Lead Owner Report</a></li>
<li><a href="#/crm/reports/lead-source-performance">Lead Source Performance</a></li>
<li><a href="#/crm/crm-dashboard">CRM Dashboard</a></li>
</ul>
