Take the financial lens a consumer marketer uses to run a business — lifetime value, acquisition funnel, retention/churn, share-of-wallet, expansion revenue — and apply it to a Medicare patient relationship, reconstructed empirically from claims. Everyone else's "patient journey" is a workshop whiteboard. Ours is how thousands of real beneficiaries actually moved through care, with real dollars on every step.
| Consumer-marketing concept | Medical equivalent | Data readiness |
|---|---|---|
| Customer journey / funnel | Observed care journey — the service sequence a patient walks over time | Built · #433 |
| Customer Lifetime Value (CLV) | Patient LTV — revenue across the full care relationship | Built · #432 |
| Cohort retention / churn | Active / stopped-but-living / deceased + length-of-service | Built · #432 |
| Share of wallet | Share of care — what one player captures vs. what leaks to others | Net-new · hard |
| Expansion / cross-sell revenue | Revenue stack — devices, drugs, virtual visits, referrals beyond the core service | Preliminary · #430/#431 |
| Vertical integration / make-vs-buy | Control vs. partner across the care value chain | Framing layer |
How do real patients actually move through this company's care — where do they enter, branch, stall, and drop off — and where does revenue accumulate along the path? Built from the claims-derived transition matrix in GHI #433.
E&M → SDOH → CCCM — and when you flip to the revenue view, that same funnel is where the dollars pool (CCCM bills ~3–5× any other service per patient/month). Two things fall out that you can act on:
E&M → PIN step — a prospect sees in one glance how a competitor's model differs from theirs.dim_care_mgt_hcpcs (#433).E&M → SDOH Assessment → CCCM → … — an operational onboarding funnel built on G0136 → 99487/99489 layering.E&M → PIN path, 95% less stacking. A prospect instantly sees how a competitor's model differs from theirs — GHI #432's literal stated purpose.Across everything a patient generates in billable care, how much does this player capture today — and what are the adjacent rungs they could own, build, partner, or cede? Each bar splits captured (solid) from whitespace (hatched).
Both screens are projections of one object — a per-patient claims event stream with revenue attached. Most of it already exists in Christian's vinci notebooks. This is what's built, what's preliminary, and what's net-new.
| Object | Grain | Key fields | Status |
|---|---|---|---|
bene_journey_eventsthe engine |
one row per bene × service | bene_id, entity, service_date, service_yearmo, hcpcs_cd, care_mgt_cat, family, phase, allowed_amount, seq_index, days_since_prior, served_by |
Net-new join components exist separately |
| Table | Maps | Source |
|---|---|---|
dim_care_mgt_hcpcs | HCPCS → care_mgt_cat / phase / family (CCM, CCCM, CHI, PIN, BHI, SDOH…) | care_mgt_hcpcs_lookup_table.ipynb |
dim_access_track_diag | diagnosis → eCKM / CKM track patterns | used in eckm_ccm_rpm_stack.ipynb |
dim_zip_geo_mapping | ZIP → geo / market | shared dim |
carrier_claimlines_clean_2025 | cleaned claim-line source (allowed amount, NPI, bene, date) | pipeline output |
| Artifact (table / output) | Powers | Status | Source / what's missing |
|---|---|---|---|
journey_transition_matrixfrom→to, benes, %_of_from, median_gap_mo | Journey Map ribbons + timing | Built | pin_landscape_by_entity_time_period.ipynb · #433 (Steps 4c–4f) |
journey_sequence_patternsfirst-appearance sequence, benes, % | Journey Map entry/top-paths | Built | SEQUENCE_ANALYSIS.md · #433 |
bene_revenue_segmentsegment (deceased/active/stopped), months_of_service, first/last_service, avg_monthly_revenue, total_allowed | LTV, churn, drop-off labels | Built | #432 (Solace revenue calc) |
revenue_by_hcpcs / by_care_mgt_cat | Revenue-mode flow weighting; CCCM spine | Built | #432 |
rpm_rtm_stackbilling_npi × bene × yearmo, is_stack, annual rev | Revenue Stack — RPM/RTM rung | Built | eckm_ccm_rpm_stack.ipynb |
device_rung | Revenue Stack — devices | Preliminary | #430 — example data only; needs $ per bene by claim type (DME/prof/SNF/HH) |
drug_glp1_rung | Revenue Stack — drugs/GLP-1 | Preliminary | #431 — prescriber counts only; needs Part D spend attribution per bene |
bene_journey_events (unified) | Both screens (the engine) | Net-new | Join #432 revenue onto #433 sequence into one persisted stream |
revenue_stack_rungrung, captured_amt, whitespace_amt, posture | Revenue Stack — captured vs. whitespace | Net-new | Needs total-billable-care denominator per bene (all claims, not just entity's) |
share_of_care / referral leakage | Share-of-care / leakage (deferred screen) | Net-new | Cross-entity claims + entity resolution — the hard one. Not v1. |
served_by dimension | Shared with the competition lens | In progress | Being built in competition work — reuse, don't fork |
| LTV projection (forward) | Cohort-economics screen (deferred) | Net-new | Foundation in #432; survival/projection logic TBD |
| Term | Definition |
|---|---|
| Patient LTV | Lifetime value — total revenue a patient generates across the full care relationship. The medical version of customer lifetime value. |
| Care journey | The observed, time-ordered sequence of services a patient receives, reconstructed from claims (not a workshop diagram). |
| Care phase / family | A group of HCPCS codes playing the same role: E&M Office, SDOH Assessment (G0136), Complex CCM/CCCM (99487/99489), Illness Navigation/PIN (G0023/24), Community Health Integration/CHI (G0019/22), Behavioral Health Integration/BHI. |
| Segment | Mutually-exclusive bene status (#432): deceased (date of death) → active (billed in trailing window) → stopped-but-living (= churn; capture length-of-service). |
| Transition matrix | For each phase, the share of patients moving to each next phase + median time gap. The Markov edges behind the Journey Map. |
| Revenue stack | The layered set of revenue rungs around a patient: care-mgt, E&M, virtual visits, devices, drugs, labs, referrals, plus ACCESS/RPM/RTM payment programs. |
| Captured vs. whitespace | Captured = what the target entity bills today. Whitespace = the rest of the patient's billable care (addressable adjacency). |
| Posture (own/build/partner/cede) | The strategic call per rung: already have it / vertically integrate / collaborate / walk away. |
| Share of care | Medical share-of-wallet: the fraction of a patient's total billable care one player captures vs. loses downstream. |
| Referral leakage / keepage | Revenue lost when patients get care outside the network. Industry estimates: 10–30% of system revenue. |
Concept doc: design/screens/care-journey/care_journey_value_concept.md · Data engine: vinci GHIs #430–433 · Worked example: Solace.