The core KPIs
A behavioral health KPI dashboard tracks a short set of weekly numbers: census and average daily census, admissions and conversion, authorizations, denials, collections and staffing. Each KPI needs one written definition, one owner and one data source so the numbers mean the same thing every week.
The definitions below are written in words, with no target values. Targets come from your own baseline and trend; the benchmarks guide explains where published comparisons exist and why most operating metrics have none.
Census and average daily census
Census is the number of patients the program is serving on a given day, counted at the same time each day for each level of care.
Average daily census is the total of the daily census counts for a period, divided by the number of days in that period. Show it by level of care and by payer, so a full residential unit does not hide an empty outpatient program.
Census is the result of admissions and length of stay, so track discharges too. Average length of stay is the total days of care for patients discharged in a period, divided by the number of those discharges.
Admissions and conversion
Admissions are the patients who start care in the week. Conversion is admissions divided by qualified inquiries in the same period.
Write down what counts as a qualified inquiry and when an inquiry counts as converted. If either definition changes from week to week, the rate stops meaning anything. Track inquiries by referral source too, so you can see which sources send patients who are admitted, not just who calls.
Authorizations
Track authorization requests submitted, approved, denied and still pending, by payer and level of care. The approval rate is approvals divided by the decisions received in the period.
Track continued-stay reviews apart from initial authorizations. They are separate steps, often with separate owners, and a problem in one can hide inside a combined number. Record how long each decision took from request to answer, and how much care was approved against how much was requested.
Denials
The denial rate is denied claims divided by the claims that received a payer decision in the period. Decide whether you count by claim or by claim line, and keep that choice.
Record the payer's reason for every denial, so the dashboard shows which reasons are growing and which team owns each one. Split the denials you can prevent at the front end, such as eligibility and authorization, from those that need a clinical or coding fix, so each goes to the right owner.
Collections
Track cash collected in the week beside what was billed. Days in accounts receivable is the balance still owed to the program divided by its average daily charges over a recent period, so it shows how long a billed dollar takes to arrive.
Add the balance by payer and by age, so the dashboard shows where money is stuck and not just how much.
Staffing
Track open positions, staff who left in the period, overtime hours and the share of shifts filled by agency or contract staff. Show vacancies in roles your license requires on their own line, because a gap there is a compliance risk as well as a staffing one.
Turnover is the number of staff who left in the period divided by the average number of staff employed in it. Count clinical and non-clinical staff separately, because they leave for different reasons and are replaced in different ways.
Building the dashboard
A dashboard is only as good as its definitions and its data. Build it in this order, before you worry about the layout.
Write the definitions down
Keep a definitions sheet: each KPI's name, its formula in words, what counts and what does not, and the date the definition last changed. When someone questions a number, the sheet settles it.
Give each KPI one owner
The owner explains the number each week and leads the fix when it moves the wrong way. Admissions usually owns conversion, utilization review owns authorizations, the revenue lead owns denials and collections, and the program or clinical director owns census.
Name one data source for each
Pull each KPI from one system of record, such as the electronic health record, the billing system or the scheduling system, and note which report it comes from. When two reports disagree, fix the definition before you fix the number.
Keep patient details off the dashboard
A leadership dashboard needs counts and rates, not names. A program covered by 42 CFR Part 2 "must have in place formal policies and procedures to reasonably protect against unauthorized uses and disclosures of patient identifying information."[1]
Build the dashboard from totals, and leave patient-level detail in the systems and reports where access is already controlled.
Set a weekly cadence
Refresh the numbers on the same day each week, before the leadership meeting, and keep the history so each number is shown against its own trend. The free KPI dashboard template gives you a layout to start from.
Keep it to one page
Fit the weekly dashboard on one screen or one printed page. If a KPI has not prompted a question or an action in months, move it to a monthly report and keep the weekly view short enough to read in the meeting.
From KPI to action
A number on a dashboard is only useful if someone acts on it. Use the same steps every week:
- Read the trend, not the single week. A bad week is noise until it repeats.
- Ask the owner what changed: volume, payer mix, staffing or a step in the process.
- Trace the number to the step that produced it, such as a missed authorization request or a late return call.
- Agree one action, one owner and a date, and record them next to the KPI.
- Check the action at the next meeting, and close it only when the cause is fixed.
- Escalate an action that misses its date twice, so the problem reaches the person who can remove the obstacle.
Weekly, monthly and quarterly views
Use the weekly view to act and a monthly view to see trends across levels of care and payers. Owners and investors may want a quarterly summary; build it from the same definitions, so its numbers match the ones leadership uses every week.
Read the KPIs together
Some KPIs move together. A lapse in authorizations shows up later as denials and slower collections, so read the revenue numbers beside the admissions and utilization review numbers, not on their own.
If the dashboard keeps showing the same problem, the fix is usually in a workflow, not the dashboard. Pacific Viking's revenue cycle and utilization review consulting covers those workflows for programs nationwide. It is not a billing vendor.
This guide is general information, not legal, billing or financial advice. Confirm current requirements with the agency and your counsel.
Sources
- [1]42 CFR 2.16, Part 2 policies and procedures for records · Electronic Code of Federal Regulations (eCFR) · ecfr.gov/current/title-42/section-2.16
Last checked Nov 12, 2026

