A medical practice KPI scorecard should hold 12 to 15 measures that leaders review every week: access, provider productivity, revenue cycle, quality, patient experience and staffing. Each measure needs one written definition and formula, an owner, and a red, amber and green threshold that tells someone what to do. Use a published benchmark only where a body such as the American Academy of Family Physicians (AAFP) or the Institute for Healthcare Improvement (IHI) publishes one; otherwise, track your own trend.
Why one written definition matters more than the list
The Medical Group Management Association (MGMA) lists dozens of operational and revenue cycle KPIs a practice can track, from work RVU productivity to phone abandonment rates. Choosing from that list is the easy part. The hard part is making sure every clinic calculates "no-show rate" the same way, from the same data, on the same day.
Ben Miller, who leads EMBERSTONE Partners, built a first analytics data warehouse from athenahealth Data View that integrated 150+ healthcare metrics into one source of truth for operational, clinical and quality reporting. The lesson we took from that work is simple: write the definition before you build the chart.
The scorecard: 14 KPIs with definitions and formulas
| Area | KPI | Definition and formula | Benchmark |
|---|---|---|---|
| Access | Third next available appointment | Calendar days, weekends included, from a weekly reference day to the third open routine slot (IHI) | Routine: 7 days or fewer (AAFP) |
| Access | No-show rate | Patients who did not keep their appointment ÷ patients scheduled | 5% or less (AAFP) |
| Access | Fill rate | Filled appointments (including walk-ins, excluding no-shows) ÷ possible appointments | 90% to 95% (AAFP) |
| Productivity | wRVUs per provider | Sum of work relative value units billed per provider per week | Track your own trend |
| Productivity | Visits per provider day | Completed visits ÷ provider clinical days worked | Track your own trend |
| Revenue cycle | Days in accounts receivable (A/R) | Total A/R ÷ (adjusted charges × 1/365) (MGMA) | Track your own trend |
| Revenue cycle | Clean claim rate | Claims that pass edits with no manual intervention ÷ claims accepted into the claim tool (HFMA) | Track your own trend |
| Revenue cycle | Denial rate | Claims denied (actionable denials) ÷ claims remitted (HFMA) | Track your own trend |
| Revenue cycle | Net collection rate | Net fee-for-service revenue × 100 ÷ adjusted fee-for-service charges (MGMA) | Track your own trend |
| Quality | Two or three priority measures | Patients meeting the measure ÷ eligible patients, using the measure's own specification | Use the measure's published benchmark |
| Patient experience | Rating of provider | Share of surveyed patients giving the top rating | Track your own trend |
| Staffing | Staffing rate | Actual clinical hours ÷ desired clinical hours | 95% to 100% (AAFP) |
| Staffing | Staff turnover | Staff who left in the period ÷ average staff headcount | Track your own trend |
| Staffing | Phone abandonment rate | Calls abandoned before answer ÷ calls received | Track your own trend |
A few notes on the rows:
- Third next available is counted on one reference day each week, and the weekly results are averaged for the month. IHI sets an ambitious goal of same-day access in primary care and access within 7 days in specialty care.
- wRVUs come from the three categories of relative value units that the Centers for Medicare & Medicaid Services (CMS) sets for each service: work, practice expense and malpractice. Use the work part only.
- Quality works best with a short list. The Healthcare Effectiveness Data and Information Set (HEDIS) has more than 90 measures, so pick the two or three tied to your payer contracts or your Merit-based Incentive Payment System (MIPS) submission. Our guides to MIPS reporting in athenahealth and HEDIS gap closure cover the measure logic.
- Patient experience can come from the Consumer Assessment of Healthcare Providers and Systems (CAHPS) Clinician & Group Survey, whose core measures include timely appointments, provider communication, office staff and an overall rating of the provider, or from your own survey vendor. Keep the question the same week to week.
- Revenue cycle numbers vary widely by specialty and payer mix. Our denial rate reporting guide covers how to break the denial rate down by payer and reason in athenaOne data.
How do goals cascade from the organization to each role?
One scorecard with every number on it helps nobody. Cascade it so each level sees what it can change.
- Organization. Leadership sees all 14 measures as totals, with each clinic's trend behind them.
- Clinic or site. Each clinic manager sees the same 14 rows, filtered to their clinic, with their own targets.
- Provider. Each provider sees access, productivity and their quality measures, filtered to their own panel.
- Role. Front desk sees no-show rate, fill rate and phone abandonment. Billing sees clean claim rate, denial rate and days in A/R. Clinical staff see the quality gaps they can close this week.
Set targets top down, then check them bottom up. If a clinic cannot name the action that would move its number, the target is a wish, not a goal.
What does a weekly cadence look like?
The AAFP dashboard authors recommend a weekly meeting with operational leaders to review access and staffing and adjust schedules. We use the same rhythm for the whole scorecard.
- Monday morning: the scorecard refreshes automatically from the warehouse. No one builds it by hand.
- Monday or Tuesday, 30 minutes: leaders review only the reds and ambers. Each one gets an owner and a next step.
- Through the week: owners act. Clinic huddles use the clinic and role views.
- Monthly: a longer review of revenue cycle and quality trends, which move more slowly, and a check that targets still make sense.
How do you set red, amber and green thresholds?
Where a published benchmark exists, use it. The AAFP dashboard sets these bands, which we use as written:
| KPI | Green | Amber | Red |
|---|---|---|---|
| No-show rate | 5% or less | 6% to 10% | More than 10% |
| Third next available, routine | 7 days or fewer | 8 to 10 days | More than 10 days |
| Third next available, same day | 24 hours or less | 25 to 48 hours | More than 48 hours |
| Staffing rate | 95% to 100% | 85% to 94%, or over 100% | Under 85% |
Source: AAFP Family Practice Management, 2023.
For measures without a published benchmark, set bands from your own history. A simple rule: green is at or better than your target, amber is a move in the wrong direction for two weeks running, and red is a move past a line you agree in advance. Write down what each color triggers, such as "red denial rate means billing reviews the top three denial reasons by Friday."
Where to start
Pick the 14 measures above, or your own 12 to 15, and write one definition and formula for each on a single page before anyone builds a dashboard. Then decide who owns each number and which meeting reviews it. Ben has led operational build-out and clinical readiness for 7 primary care clinics (about 45,000 patients) and 1 infusion center, including 2 conversions of commercial space into clinics. If you want help designing the cadence, see our strategic operations service; for the data layer behind it, see analytics and BI architecture, or book a free strategic assessment.