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:
Created
Started
Completed
Not Started and Incomplete
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.












