Payors / cost of care

Explain the Trend Before the Meeting

A PMPM spike is three changes pretending to be one. Ana splits utilization, price and mix, follows the trend to the members, providers and sites of care behind it, and hands medical economics the driver with the claims attached.

[ the difference ]

The Trend Meeting, Before and After

today
  • A PMPM spike waits a month for a report request
  • Utilization, price and mix argued from different extracts
  • Drill-downs stop at the dashboard’s edge
  • IBNR and forecasts rebuilt by hand each close
with textql
  • The spike arrives with its drivers already found
  • Every change decomposed from one model of the plan
  • Follow any trend to the member and the claim line
  • Forecasts refreshed from the same claims, on schedule
[ 01 decompose ]

Split Every Trend Into What Actually Moved

A PMPM change is three changes pretending to be one. Ana walks every trend from last year to this one — utilization, unit price, service mix, site of care — from the same claims, eligibility and contracts, so the conversation starts from the driver, not the total.

  1. Trend watch runs weekly, across every line of business
  2. Drivers ranked by dollars, not by row count
  3. Member months, allowed and paid reconciled to finance
imaging pmpm · q3 vs q3 +$2.17 pmpm · 18.0%
$0.05 pmpm · axis from $11.50 site of care +$1.90
[ 02 prove ]

Not More Scans — the Same Scans at Hospital Prices

The dashboard says imaging is up 18%. The claims say volume is flat: one radiology group joined a hospital system, and the same MRIs are now billed as hospital outpatient. Every driver arrives split into utilization, price and mix, with the claims behind it.

  1. Each driver arrives with its members and claims
  2. Price effects tied to the contract in force
  3. Mix shifts by setting, service line and provider
trend · outpatient imaging
Imaging PMPM up 18% year over year
flagged
  1. q3 Imaging PMPM — commercial all lines · 412k members $14.20
  2. q3 Year-over-year change same members · same benefits +$2.17
Imaging is up 18%. The dashboard can’t say why. +18%
[ 03 act ]

Turn the Driver Into a Decision

A driver is only useful if someone can act on it. Ana sizes the opportunity from the same claims — which members, which centers, what it saves — and writes it up for the team that will act.

  1. Opportunities sized from the same claims
  2. Briefs written for network, care and finance teams
  3. Results tracked after the change lands
opportunity · hopd imaging
Imaging steerage, sized
flagged
  1. q3 MRIs billed as hospital outpatient npi group 1629 · 2,568 scans $1,240 avg
  2. q3 PMPM added by the shift same members · same benefits +$1.90
Hospital imaging adds $1.90 PMPM. The slide stops there. +$1.90
[ customer story ]
client
Lumeris
profile
health plans · health systems · medical groups
workload
claims forecasting · pmpm · cost trend
environment
hipaa · private cloud · redshift
days minutes claims forecasting
  • manual on demand executive pmpm and cost-trend reports
  • 2–3 day wait 0 analyst on-call for ad-hoc reports
Lumeris

PMPM and cost-trend reporting on demand, and claims forecasting cut from days to minutes.

Before TextQL, it took users multiple steps trudging through a number of reports in order to connect the dots and find where the opportunities and insights lie. Now, they no longer have to do that.

Anna Libers, VP of Product and Solution Management, Lumeris
8 months
From POC to production platform
3
Business lines with self-serve analytics
[ the trend review ]

Start With the Trend on This Quarter’s Slide

The first run looks back over a year of claims, so the drivers are sized in dollars before anyone changes a program. The ones that hold up become a weekly watch.

Explain a Trend

Bring the one on this quarter’s slide. We run it against a year of your claims, inside your cloud, and walk medical economics through what actually moved.

  1. 01A 30-minute call to pick the trend and the claims in scope
  2. 02We connect inside your cloud under a BAA — nothing leaves your environment
  3. 03Your team checks every driver against its own claims
[ use cases ]

Where Medical Economics Starts

  • 01 Trend decomposition

    Split every PMPM change into utilization, unit price and mix, by line of business, region and service category.

  • 02 High-cost claimants

    Track the members driving the top of the curve, what is driving them, and which are rising before they cross a threshold.

  • 03 Site-of-service steerage

    Find the services moving to higher-cost settings and the members and referrers behind them.

  • 04 Specialty and pharmacy spend

    Follow drug spend across medical and pharmacy benefits, including biosimilar adoption and J-code mix.

  • 05 Value-based contract performance

    Measure attributed spend against shared-savings targets as claims arrive, not after reconciliation.

  • 06 Claims forecasting and IBNR

    Refresh completion factors and forecasts from the same claims on a schedule, instead of rebuilding them each close.

[ faq ]

What Teams Ask Before They Start

Read access, inside your environment, to a year of medical and pharmacy claims, eligibility and the contracts in force. Your team picks the trend; we decompose it and walk medical economics through the drivers.

[ try textql ]

Bring Us Your Hardest Problem