The resupply funnel measures a single cycle; this report measures the health of the whole base over time. A resupply program is a recurring relationship, and its value depends on keeping patients engaged, on-cycle, and compliant year after year — not just converting one order. Lapsed patients are silent revenue erosion: each one was a recurring stream that stopped, usually without anyone noticing until the base shrinks. This dashboard puts engagement, compliance, and lifetime value on one screen.
What this report answers
Is the resupply base healthy and growing, or quietly eroding? The engagement page shows active patients, on-cycle order rate, lapsed-patient count, and auto-enroll coverage, then breaks patients down by engagement tier (engaged / at-risk / lapsed), on-cycle rate by contact channel, and lapsed count by payer so you can see where attrition concentrates. The compliance & value page adds PAP compliance rate and annualized patient value, with compliance by payer and annualized value by product line, plus a tier table tying patient count, compliance, and dollar value together.
The metrics that matter
On-cycle order rate is the heartbeat — the share of eligible patients ordering inside their window, which is what keeps recurring revenue predictable. Lapsed patients is the erosion signal: patients who've missed two-plus cycles and need win-back. Auto-enroll coverage rate is the leading indicator of future on-cycle performance, since automated outreach keeps patients on schedule without manual effort. PAP compliance rate ties the program back to clinical reality, and annual patient resupply value quantifies what each engaged patient is actually worth.
Why the data is trapped
Engagement state, compliance status, and order history live in different layers — the resupply engine, the PAP compliance feed, and the billing ledger — inside Brightree, NikoHealth, Bonafide, or Fastrack. A platform can list patients due this cycle, but classifying the base into engaged / at-risk / lapsed, joining it to compliance and annualized value, and showing where lapse concentrates by payer and channel is a modeling job that almost never ships as a canned report. So programs react to this cycle's list instead of managing the base's trajectory.
How to read it
Watch the lapsed and at-risk tiers first — that's the win-back list, and each lapsed patient is recurring revenue you've already stopped earning. Read on-cycle rate by channel to see which outreach keeps patients on schedule, and auto-enroll coverage as the lever that raises it. Compliance by payer flags populations where therapy adherence (and therefore future resupply) is at risk. Annualized value by product line tells you which lines anchor the program's revenue. The sample uses synthetic patients only — no PHI.
Metrics it tracks
| Metric | What it means |
|---|---|
| Active Resupply Patients | Count of patients in the active program — rows where ActiveProgramFlag = 1. |
| PAP Compliance Rate | Active patients meeting usage compliance — SUM(CompliantFlag) ÷ SUM(ActiveProgramFlag). |
| On-Cycle Order Rate | Orders placed within the eligible resupply window — SUM(OnCycleFlag) ÷ SUM(EligibleFlag). |
| Lapsed Patients | Patients with no order in two or more cycles — rows where LapsedFlag = 1. |
| Annual Patient Resupply Value | Annualized resupply revenue across active patients — SUM(AnnualizedValue). |
| Auto-Enroll Coverage Rate | Active patients enrolled in automated resupply outreach — SUM(AutoEnrolledFlag) ÷ SUM(ActiveProgramFlag). |
Used by: Resupply program manager; clinical/respiratory lead
Frequently asked questions
What is on-cycle order rate in a resupply program?
It's the share of eligible patients who order within their resupply window. A high on-cycle rate means predictable recurring revenue and patients staying on schedule; a low one means orders are slipping late or not happening, which is the leading edge of lapse. It's the single best heartbeat metric for program health.
What counts as a lapsed resupply patient?
Typically a patient who hasn't placed a resupply order in two or more cycles. Each lapsed patient was a recurring revenue stream that stopped, so tracking the lapsed count — and where it concentrates by payer and channel — turns silent attrition into an actionable win-back list.
How does auto-enroll coverage affect resupply revenue?
Auto-enrollment in automated outreach keeps patients ordering on cycle without manual follow-up, so a higher auto-enroll coverage rate generally drives a higher on-cycle order rate and fewer lapses. It's a leading indicator: raising coverage today tends to lift recurring revenue in future cycles.
Build this report on your own data
Clone this DME/HME template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →