Skip to main content

Treatment Plan Pipeline View

Track treatment plan conversion and performance using cohort-based analysis

Written by Stefan Cataldo
Updated over a month ago

Pipeline View helps you understand what happened to the treatment plans created in a specific period, even if they were started or completed later. If Snapshot View shows you what exists today, Pipeline View shows you what happened to the plans you created during that period.

This makes it ideal for measuring acceptance rates. performance over time. and how effectively treatment plans progress through your workflow.


Pipeline View vs Snapshot View

Snapshot View

Shows the current state of treatment plans.

Use Snapshot when you want to know:

  • How many plans exist right now or in a historical period.

  • Current active value

  • Outstanding work

  • Appointment booking status

Snapshot includes all plans that existed during the date range, regardless of creation date.


Pipeline View

Shows the full journey of treatment plans created in the selected date range.

Use Pipeline when you want to know:

  • How many plans were accepted

  • How many were completed

  • What was the associated value of the plans at each stage

  • What were my conversion rates (overall - or broken down by Practice, Provider, Treatment category and more)

  • Where plans dropped off

  • How long plans took to progress

Pipeline always uses Created Date as the anchor.

It tracks everything that happens afterwards—even if events occur outside the chosen date range.


How Pipeline View Works

First select the Pipeline View toggle in the top left corner:

Pipeline View follows three steps:

1. Identify the cohort

All plans created within your selected date range, including any filters applied.

2. Track the lifecycle

For that cohort, Explorer measures:

  • How many started

  • How many completed

  • How many remained incomplete

  • How many became inactive or were deleted

3. Calculate lifecycle metrics

Including conversion and velocity.


Understanding the Funnel

The Pipeline funnel shows the 5 critical lifecycle stages:

  1. Created

  2. Started

  3. Completed

  4. Not Started and Incomplete

  5. Deleted

Each stage displays:

  • Plan volume

  • The create £ plan value, as well as the invoice value

  • What percentage of total value has been invoiced

  • Where plans dropped off (Incomplete, Inactive, Deleted)

Progress Bars

Each stage of the funnel has a progress bar indicating the Total Value of those plans. The Green segment indicates what has been Invoiced and Blue segment of the progress bar indicates the Outstanding Plan Value.

On the right hand side of each progress bar, you can also see what percentage of the total amount has been inoviced, along with the total count of plans in that segment.

Blue Pill Conversion Metrics

At the top of Pipeline View you’ll see blue conversion pills. These show the primary conversion rate: the percentage of plans that progressed from Plans Created → Plans Started.

This gives you an immediate view of patient acceptance of treatment recommendations.

Additional conversion information is displayed directly in the funnel for each stage.


Key Metrics in Pipeline View

1. Conversion (Created → Started)

This is the most important metric in Pipeline View.

It tells you what proportion of newly created plans were accepted and progressed into treatment.

The blue conversion pill displays this value clearly.


2. Status Distribution

See where plans in the cohort ended up:

  • Started

  • Completed

  • Not Started and Incomplete

  • Inactive

  • Deleted

This helps highlight operational issues or value leakage.


3. Conversion (Created → Started)

Below the funnel in the Pipeline Metrics section, Pipeline View includes tiles summarising the conversion rates and the financial outcome of the cohort:

Completed Value

• Total £ value of plans that were fully completed and invoiced

• Includes the number of completed plans

→ Shows revenue already realised

Outstanding Value

• £ value of plans started but not yet completed or invoiced

• Includes number of outstanding plans

→ Indicates future revenue still in progress

Lost Value

• £ value of plans that became inactive or deleted

• Includes number of lost plans

→ Highlights potential revenue leakage


4. Velocity (Time)

Velocity metrics are shown below the Financial Summary under Pipeline Velocity - these show how long treatment plans take to progress.

  • Avg Days to Start – creation → first appointment

  • Avg Days to Complete – start → completion

  • Avg Total Cycle Time – creation → completion

Velocity helps you identify bottlenecks. Longer times often indicate scheduling delays or patient disengagement.


Using Breakdowns in Pipeline View

You can break down the funnel by:

  • Practice

  • Provider

  • Payor

  • Treatment Category

  • Value Band

Each breakdown creates its own funnel segment, showing:

  • Stage volumes and values

  • Conversion rate from Created → Started

  • Financial metrics

  • Velocity metrics

You can quickly sort by Conversion Rate, Total Value or Plan Count the funnels for the breakdown applied using the sort buttons in the top right corner

You can also add any of the Treatment Plan Pipeline funnels to your Dashboard for later use by clicking on the 'Add to Dashboard' button in the top right corner:

💡 TopTip: Breakdowns are a powerful way to compare performance across locations, clinicians, or treatment types.

Breakdown Tables (Detailed Segment View)

When you add a Breakdown in Pipeline View—such as Practice. Provider. Payor. Treatment Category. or Value Band—Explorer automatically generates a detailed breakdown table beneath the funnels and Pipeline Metrics.

This table shows the full set of lifecycle metrics for each segment, including:

Created. Started. Completed. Incomplete. Inactive. Deleted

Financial values (£) for each stage

Plan counts shown underneath each £ value (e.g. “£10,467 / 25 plans”)

Conversion % for that segment (Completed / Created)

Velocity metrics where applicable (Avg Days to Start. Avg Days to Complete. Avg Total Cycle Time)

This makes it easy to compare segments side-by-side and quickly spot patterns—for example. which treatment categories have high acceptance. or which providers have high incomplete plan value.

All figures in the breakdown table are included when you export the report. ensuring you can analyse or share the segmented data outside of Explorer.


Drill-Down

Click any stage or segment for details such as:

  • COT ID

  • Patient ID

  • Created / Started / Completed dates

  • Plan value and outstanding value

  • Status

  • Practice / Provider / Payor / Category

You can filter, sort, and export these records to Excel.


Exporting Pipeline Analysis

PDF (Visual Export)

Includes:

  • Funnel graphic

  • Blue-pill conversion

  • Velocity metrics

  • Breakdown tables

  • Comparison period results

Excel (Data Export)

Includes:

  • Summary metrics

  • Breakdown metrics

  • Drill-down records


Top Tips for Pipeline Analysis

  • Use full months for consistent cohort comparisons

  • Focus first on Created → Started to measure acceptance

  • Watch velocity metrics for early signs of bottlenecks

  • Use breakdowns to find outliers across Practices, Providers or Treatment Types

  • Track incomplete, inactive, and deleted plans to find value leakage


Common Questions

Why don’t Pipeline and Snapshot match?

They measure different things. Pipeline tracks a cohort created during the period. Snapshot shows all plans existing during the period.

Why does Pipeline track events outside the date range?

Because the cohort lifecycle continues beyond creation.

Why Created Date only?

To keep cohort analysis simple and consistent.

Did this answer your question?