Many public works departments report numbers, but few report the same numbers the same way twice. One supervisor counts a work order as complete when the crew leaves the site, another when paperwork is closed, and the monthly report quietly changes shape. This guide defines 25 maintenance KPIs in five groups, each with a formula and a plain explanation of what it tells you. It also covers dashboards, reporting cadence, and data rules that keep metrics consistent. Along the way you will see how Oxmaint maintenance reporting software produces them from everyday work orders.
Public Works KPIs: 25 Maintenance Metrics to Track
Consistent definitions turn scattered numbers into a story that crews, directors, and councils can all read the same way.
Why public works metrics become inconsistent
Inconsistent performance data usually comes from unclear definitions, not unwilling staff.
Leading and lagging indicators
Lagging measures report what already happened. Leading measures give you time to change the outcome. Track both.
Leading indicators
- PM compliance
- Inspection completion
- Backlog age
- Critical spares availability
Lagging indicators
- Unplanned failures
- Emergency overtime
- Repeat repairs
- Service interruptions
The 25 public works maintenance KPIs
Five groups of five. Each formula can be calculated from work order, asset, inventory, and timesheet data.
Work order and backlog
Preventive maintenance
Cost and budget
Reliability and asset health
Service, safety, and workforce
Calculate these KPIs without a monthly spreadsheet scramble
Capture every work order, inspection, and part in one system, and let dashboards report the same definitions every time.
Start with eight, not twenty-five
No team needs all 25 on day one. Begin with a balanced starter set and add measures as data quality improves.
- PM compliance rate
- Average backlog age
- Planned-to-reactive ratio
- Response time by priority
- Cost per work order
- Repeat failure rate
- Emergency overtime share
- Safety-related work completed
Who needs which numbers, and how often
Different audiences need different views. Match the metric and cadence to the decision.
Data rules that keep KPIs trustworthy
Agree these rules once and apply them across every division.
- Define work order statuses and when each one is used.
- Require asset, priority, and work type on every work order.
- Capture actual labor hours and parts at closeout.
- Record failure cause codes for corrective work.
- Name an owner for each metric and review definitions yearly.
- Freeze reporting periods so past numbers do not shift.
KPI traps to avoid
A good metric can still mislead when used carelessly.
How Oxmaint supports public works reporting
Oxmaint is maintenance management software. It records the underlying activity and reports on it consistently.
Work order management
Standard statuses, priorities, labor, and parts on every job.Preventive maintenance scheduling
Automatic generation and tracking supports compliance measures.Mobile inspections
Field checklists feed completion and safety metrics.Asset records
Cost and failure history by asset for reliability and cost KPIs.Inventory tracking
Parts usage and stockouts tied to jobs.Dashboards and reports
Role-based views for crews, supervisors, and leadership.Public works KPI FAQs
How many KPIs should a public works department track?
Start with five to eight, then add more as data quality and review habits mature.
What is a good PM compliance target?
Set it from your own baseline and asset criticality, with tighter targets for safety and regulated work.
Can we benchmark against other cities?
Carefully. Definitions and asset mix differ, so trend against your own history first.
Do we need a CMMS to track these?
Spreadsheets can start it, but consistency is easier in a system. Try Oxmaint free to compare.
How do we get crews to enter good data?
Keep forms short, show how the data is used, and use mobile entry. Book a demo to see it.
Write a definition sheet for every KPI
If a metric is not defined in writing, it will drift. Keep one short sheet per KPI with these fields.
- Name and one-sentence purpose
- Exact formula, including what is counted and excluded
- Data source and the fields it depends on
- Owner responsible for accuracy
- Reporting frequency and audience
- Target or acceptable range, and how it was set
- What action follows if it moves out of range
- Date of last review
Setting targets that are fair and useful
A target without a baseline is a guess. Build targets in stages.
Reading the numbers together
One metric rarely tells the story. These combinations point toward likely causes.
Add division-specific measures
The 25 core KPIs travel across departments. Each division also needs a few measures of its own.
Streets
Potholes repaired within target days, pavement condition trend, and sign replacement completion.Water
Main breaks per length of pipe, hydrant inspections completed, and valve exercising progress.Wastewater
Overflow events, lift station availability, and calibration compliance for permit instruments.Fleet
Vehicle availability, preventive service on time, and cost per mile or hour.Facilities
Comfort complaints, life safety inspection completion, and energy use against baseline.Parks
Playground inspection compliance, equipment out of service, and irrigation startup completion.Presenting KPIs to council and the public
Elected officials need a short, clear story, not a spreadsheet of thirty numbers.
- Pick five or six headline measures and keep them stable year to year.
- Show trends over time, not only the latest month.
- Explain each number in one sentence a resident would understand.
- Pair every red metric with a planned action and an owner.
- Note data limitations openly rather than hiding them.
- Link results to the budget, showing what funding changes would do.
Reporting mistakes to avoid
These habits erode trust in the numbers faster than any single bad month.
- Changing definitions midyear without noting the change.
- Reporting averages without showing the worst cases.
- Closing work orders in bulk to clear the backlog figure.
- Leaving out contractor work from cost and completion counts.
- Rebuilding reports by hand each month in different layouts.
- Tracking so many measures that none gets a real review.
Data quality checks before you trust a KPI
A confident wrong number is worse than no number. Run these checks before publishing a metric.
A sample monthly maintenance report outline
A consistent structure helps readers find what they need quickly.
Early wins in the first 90 days
You do not have to wait for a full year of data. Build momentum with small, visible improvements.
Days 1 to 45
- Agree definitions for the starter eight
- Clean up work order statuses
- Require asset and work type on every job
- Publish a first baseline report
- Name an owner for each metric
Days 46 to 90
- Hold the first monthly KPI review
- Set initial targets from the baseline
- Fix the top data quality gap
- Share one improvement story with crews
- Decide which metrics to add next
Report the same numbers the same way, every month
Bring work orders, inspections, and asset history together and give every audience a clear, consistent view of maintenance performance.
