How to Read Your Group Health Plan’s Claims Data (And What to Act On)

Most employers receive some version of a claims report from their carrier or TPA at least once a year. A significant number of those reports get reviewed once, briefly, and filed. That’s an expensive habit.

Claims data is the most direct window into what is actually driving your health plan’s costs — not what you budgeted, not what your carrier projected, but what is actually happening with your covered population. Employers who know how to read that data, and more importantly, who know which numbers should trigger an action and which are noise, are the ones who enter renewal negotiations with leverage rather than surprises.

This article is a practical guide to the metrics that matter most, how to interpret them, and — critically — what to do when a number looks wrong. It is written for self-funded and level-funded employers who have direct access to their claims data, but the analytical framework applies equally to fully insured employers reviewing their carrier’s annual utilization report.

Why Most Claims Reports Don’t Get Used

The barrier isn’t access to data — it’s knowing what to look for. A standard carrier or TPA claims report can run dozens of pages, presenting data in formats optimized for the vendor’s internal systems rather than for employer decision-making. Diagnosis codes, procedure codes, service categories, member months, allowed amounts, paid amounts, plan liability, and member liability appear in combinations that are technically accurate but practically opaque to anyone who hasn’t spent years working in healthcare finance.

The result is a common pattern: HR teams open the report, confirm that total paid claims are higher or lower than last year, note the top five or ten highest-cost members in the aggregate (de-identified), and close the file. The renewal comes around, the carrier presents a rate increase, and the employer has no meaningful data to push back with — because they never extracted the insights the data contained.

Changing that pattern requires knowing which four or five metrics are genuinely decision-relevant, where to find them in a standard claims report, and what action each one should trigger.

The Metrics That Actually Matter

1. Per-Member Per-Month (PMPM) Paid Claims

What it is: Total plan-paid claims divided by total member months (the number of covered members multiplied by the number of months they were enrolled). PMPM is the single most important normalizing metric in health plan analytics — it allows you to compare claims experience across years with different enrollment levels, against industry benchmarks, and across plan design variations.

Where to find it: Most carrier and TPA reports include PMPM either directly or as a calculable figure from total paid claims and member months data. If it’s not presented, divide total plan-paid claims by total member months.

What to look for: Compare your current plan year PMPM against the prior two to three years. Trend matters more than absolute level — a PMPM that is increasing faster than medical inflation (typically 5 to 8 percent annually in the current environment) warrants investigation. Compare against industry benchmarks for your sector and geographic market; your broker should be able to provide benchmark PMPM ranges for comparable employer groups.

What to act on: A PMPM running more than 10 to 15 percent above benchmark suggests either a higher-risk population, a plan design that isn’t managing utilization effectively, or a pricing arrangement with the carrier or TPA that isn’t competitive. Each of those has a different remedy — but you can’t identify the right one without the baseline comparison.

2. Claims by Service Category

What it is: Total paid claims broken down by service type — inpatient facility, outpatient facility, professional services, emergency room, pharmacy, behavioral health, and ancillary services. Most reports present this as both dollar amounts and percentage of total plan spend.

Where to find it: Standard utilization reports from carriers and TPAs almost universally include a service category breakdown. It may be labeled as “claims by type of service,” “utilization by category,” or “cost by service line” depending on the vendor.

What to look for: The typical distribution for a mid-market employer group runs roughly as follows: inpatient facility 25 to 35 percent, outpatient facility 20 to 30 percent, professional services 15 to 25 percent, pharmacy 15 to 25 percent, emergency room 3 to 8 percent, and behavioral health 2 to 6 percent. Distributions that deviate materially from these ranges — particularly high emergency room spend, high outpatient facility spend relative to inpatient, or pharmacy spend above 25 percent — indicate specific utilization patterns worth investigating.

What to act on:

• High emergency room spend (above 8 percent of total paid claims or more than $150 PMPM) suggests employees are using the ER for non-emergency conditions. This is a prime target for concierge navigation services, telehealth promotion, and urgent care access improvement.
• High outpatient facility spend relative to professional services suggests employees are receiving services — imaging, infusions, minor procedures — in hospital outpatient settings rather than lower-cost independent facilities. Site-of-care redirection is the intervention.
• Pharmacy above 25 percent of total spend warrants a PBM contract and formulary review, particularly if specialty drug spend (typically drugs costing more than $6,000 annually per member) is driving the trend.
• Behavioral health below 2 percent in a workforce that hasn’t visibly addressed mental health access often indicates network access problems — employees who need mental health care can’t find in-network providers and are either going out of network (appearing elsewhere in the data) or going without care entirely (not appearing in claims at all but creating productivity and disability costs).

3. High-Cost Claimant Analysis (De-Identified)

What it is: A ranking of the highest-cost individual claimants during the plan year, presented without individually identifying information to comply with HIPAA. Most reports show the top 10 to 25 claimants by total paid claims, including diagnosis category and total plan liability.

Where to find it: Often labeled “large claimant report,” “high-cost claimant analysis,” or “catastrophic claims summary.” For self-funded employers, this is typically available from the TPA. For fully insured employers, carriers may provide a de-identified version with limited detail.

What to look for: What percentage of total plan spend is concentrated in the top 5, 10, and 25 claimants? In most mid-size employer plans, the top 5 percent of claimants generate 50 percent or more of total claims spend. If concentration is even higher — the top 10 members generating 60 to 70 percent of total spend — the plan has acute high-risk member exposure that requires specific attention. Look also at the diagnosis categories driving the highest claims: oncology, neonatal intensive care, end-stage renal disease, and hemophilia are among the most common large-claimant diagnoses and each has specific care management interventions that can affect both cost and member outcomes.

What to act on: High-cost claimant concentration is the primary driver of stop-loss attachment point decisions. If your top claimants are approaching or exceeding your specific stop-loss deductible, that is both a current-year financial alert and a renewal-year indicator that your carrier may laser those members. It is also the trigger for a care management conversation — not to restrict care, but to ensure the member is being connected with the right specialists, disease management programs, and care coordination resources that both improve outcomes and reduce avoidable complications.

4. Inpatient Utilization: Admissions, Days, and Average Length of Stay

What it is: The number of inpatient hospital admissions per 1,000 member years, the total inpatient days per 1,000 member years, and the average length of stay per admission. These three metrics together reveal whether your plan’s inpatient utilization is clinically appropriate and cost-efficient.

Where to find it: Presented in the inpatient section of the utilization report, typically alongside average cost per admission and cost per day.

What to look for: Industry benchmarks for commercial employer plans typically run 60 to 100 admissions per 1,000 member years and 250 to 400 inpatient days per 1,000 member years, though these vary significantly by industry, workforce age, and geography. Average length of stay above 4.5 to 5 days for non-surgical admissions warrants investigation into discharge planning and concurrent review effectiveness. More admissions per 1,000 than benchmark, combined with shorter stays, may indicate fragmented care or readmission patterns. Fewer admissions than benchmark with high emergency room utilization may indicate employees are using the ER for conditions that would otherwise become inpatient — a cost and quality concern simultaneously.

What to act on: Inpatient admissions per 1,000 significantly above benchmark is a direct conversation with your TPA or carrier’s utilization management team. Are concurrent review processes functioning as designed? Are discharge planning and case management programs actively managing lengths of stay? For self-funded employers, this is also a plan design question — whether pre-authorization requirements, network tiering, and case management programs are structured to support appropriate inpatient utilization.

5. Generic Dispensing Rate and Pharmacy Cost Drivers

What it is: The percentage of total prescription drug claims filled with generic drugs versus brand-name drugs, combined with a breakdown of total pharmacy spend between generic, preferred brand, non-preferred brand, and specialty drug categories.

Where to find it: Your PBM report or the pharmacy section of your carrier’s utilization report. If your pharmacy benefit is carved out to a separate PBM, this data requires a separate request from the PBM directly.

What to look for: A generic dispensing rate (GDR) below 85 percent in most commercial employer populations indicates underperformance — the industry average GDR for well-managed commercial plans runs 88 to 92 percent. Each percentage point improvement in generic dispensing rate reduces total pharmacy spend materially, because generics typically cost 70 to 90 percent less than their brand equivalents. Beyond GDR, look at specialty drug spend as a percentage of total pharmacy spend — specialty drugs represent a small fraction of total prescriptions filled but frequently account for 40 to 50 percent of total pharmacy spend in plans with even a handful of members on specialty therapies.

What to act on: A below-benchmark GDR triggers a formulary review — are generic alternatives available for the brand drugs being dispensed, and is the plan’s formulary design and member cost-sharing structure incentivizing generic selection? Specialty drug spend above 45 percent of total pharmacy spend warrants a PBM contract review focused on specialty drug rebate passthrough, specialty pharmacy network requirements, and step therapy protocols for the specific drug classes driving the spend.

6. Out-of-Network Utilization Rate

What it is: The percentage of total paid claims — by both dollar amount and claim count — attributable to out-of-network providers and facilities.

Where to find it: Most carrier and TPA reports include in-network versus out-of-network breakdowns by service category. The overall out-of-network rate is often buried in a summary table rather than highlighted.

What to look for: Out-of-network utilization above 10 to 12 percent of total paid claims is generally a signal worth investigating. Critically, look at which service categories are driving out-of-network spend. Out-of-network behavioral health above 15 percent of total behavioral health spend is a network adequacy indicator — employees are going out of network because they can’t find in-network mental health providers, not because they prefer them. High out-of-network emergency room spend may indicate that employees in certain geographic locations don’t have adequate in-network hospital access. High out-of-network specialist spend may indicate that referral processes are not effectively directing members to in-network options.

What to act on: Elevated out-of-network utilization has three potential causes, each requiring a different intervention. Network access problems — not enough in-network providers in key specialties or locations — require a carrier network conversation or a network supplementation strategy. Member behavior — employees who choose out-of-network providers despite in-network availability — requires benefits communication and cost-sharing design review. Billing and claim filing errors — claims incorrectly processed as out-of-network — require an audit of claims administration accuracy with the TPA.

From Data to Conversation: How to Use Claims Analysis at Renewal

Claims data is most powerful when it converts a reactive renewal conversation into a proactive one. The sequence that works:

Sixty to ninety days before renewal: Request a full plan year utilization report from your carrier or TPA. Ask specifically for PMPM by service category, large claimant de-identified summary, inpatient utilization metrics, pharmacy GDR and specialty drug breakdown, and in-network versus out-of-network breakdown by service line.

Review against benchmarks: Compare each metric against industry benchmarks for your sector and region. Your broker should provide benchmark data — if they can’t, that’s a capability gap worth noting.

Identify the two or three highest-leverage items: Not every metric above benchmark requires an intervention this renewal cycle. Prioritize the categories where your plan is furthest from benchmark and where an intervention is feasible within your plan design and vendor relationships.

Enter the renewal conversation with specific questions: “Our emergency room PMPM is $180 against a benchmark of $120 — what utilization management interventions are you implementing to address this?” is a fundamentally different conversation than “why is our renewal increase 14 percent?

Document what your carrier or TPA commits to: Any utilization management changes, network improvements, or care management program adjustments your carrier commits to at renewal should be documented and tracked against the following year’s claims data.

A Note on Data Access Rights

Self-funded employers have a legal right to their plan’s de-identified claims data under ERISA and the CAA 2021 gag clause prohibition. TPAs and carriers cannot contractually restrict access to this data for plan administration purposes. If your TPA is providing only summary-level data and resisting requests for detailed utilization reports, that resistance is itself a red flag — both a potential gag clause violation and a signal that the TPA may not want the employer to see what the data contains.

Fully insured employers have more limited data access rights — carriers are not required to provide member-level claims data to fully insured plan sponsors — but most major carriers will provide aggregate utilization reports upon request, and some provide employer portals with robust reporting tools. Push for the most detailed data your carrier will provide, and use what you get.

Bottom Line

Your claims data contains the roadmap to a better-performing, lower-cost health plan. Most employers are sitting on that roadmap without opening it — either because the report format is intimidating, or because nobody has explained which numbers actually move the needle.

The six metrics covered in this article — PMPM paid claims, cost by service category, high-cost claimant concentration, inpatient utilization, pharmacy GDR and specialty spend, and out-of-network rate — are the foundation of any credible claims analysis. Mastering them doesn’t require a healthcare actuary. It requires knowing what to look for, where to find it, and what question each number should prompt.

Taylor Benefits Insurance Agency conducts detailed claims analysis for employer clients as part of our annual plan review and renewal preparation process. If you’d like a professional review of your plan’s claims data — and a clear picture of where your cost-management opportunities are — contact our team before your next renewal.

---

Claims data analysis should be conducted in compliance with HIPAA privacy requirements. All member-level data used for plan management purposes must be handled as protected health information (PHI) and accessed only by authorized plan administrators and their business associates under a valid Business Associate Agreement.