Contractor KPI dashboard template
A build-it-yourself contractor KPI dashboard template for home-service and skilled-trades companies. Copy the field layout, drop in your own numbers, and turn five scattered metrics into one board an owner can read in ten seconds.
Free resource
How to build a contractor KPI dashboard, and the template to copy
A contractor KPI dashboard template is a fixed layout for the handful of numbers that actually run a home-service business: how many calls turn into booked jobs, what each technician produces, and whether the work is profitable after labor and materials. This page gives you the whole thing to build yourself: the five KPIs to start with, a four-step design method (the 4 P's), a filled-in sample week, and a read-it guide. You can recreate it in a spreadsheet in twenty minutes. Examples below are illustrative; your own targets will vary by trade, season, market, and business model.
The short version
- To create a KPI dashboard: pick five metrics, give each one an owner and a target, pull them on a fixed cadence, and color-code against target.
- Start with five KPIs: booking rate, average ticket, callback rate, gross margin %, and cost per booked job. They cover the front office, the field, and the books.
- Use the 4 P's of KPI as your design check: Purpose, Pulse, People, and Practice. If a metric fails one of the four, leave it off.
- A good KPI dashboard is short, targeted, and reviewed out loud. A spreadsheet works to start, and breaks once you add locations or want it real-time on the shop TV.
Build it yourself
The contractor KPI dashboard template layout
Recreate this in a spreadsheet, a notebook, or a whiteboard in the shop. The template is one tight table: a metric column, the current value, a target, the person who owns it, and a status. Keep it to the five to twelve numbers that drive the week. If a row does not change a decision, it does not belong on the board.
- Metric: the KPI name, written the same way every week so the number means the same thing.
- This week: the current value, pulled from your CRM, call tracking, or QuickBooks.
- Target: the line that turns a raw number into good, watch, or poor at a glance.
- Owner: the one person accountable for moving that number, for example a CSR, a technician, or the owner.
- Status: a color or word so the eye lands on the off-target rows first.
The 5 KPIs to start with
Booking rate, average ticket, callback rate, gross margin %, cost per booked job
These five are the construction and home-service equivalent of the standard set: one for whether you win the work (booking rate), one for the size of the work (average ticket), one for quality and rework (callback rate), one for whether it pays (gross margin %), and one for what it costs to win it (cost per booked job). Together they cover the front office, the field, and the books. Add trade-specific rows later; build the dashboard on these first.
Construction and field-service KPIs vary by source. This five-metric starter set is a practical operator default, not an industry standard.
The 4 P's of KPI: a design check for every row
| The P | What it means | Question to ask of each metric |
|---|---|---|
| Purpose | The metric ties to a business goal someone cares about. | If this number moves, does a decision change? If not, cut it. |
| Pulse | It updates often enough to act on, not just at month-end. | Can I see it weekly or daily, while there is still time to coach? |
| People | One named person owns the number and can move it. | Whose name goes next to this row in the weekly meeting? |
| Practice | There is a target and a routine for reviewing it. | What is the target, and when do we walk this board out loud? |
Fields to include, by function
| Metric | Function | Owner | How to read it |
|---|---|---|---|
| Booking rate | Front office | CSR / call center manager | Booked jobs divided by bookable calls; the biggest lever on demand you already paid for. |
| Average ticket | Field | Technician / field manager | Revenue divided by completed jobs; coach low tickets, watch for churn on the high ones. |
| Callback rate | Field | Field manager | Jobs needing a return visit; a quality and rework signal that quietly eats margin. |
| Gross margin % | Financial | Owner / controller | Revenue minus labor and materials, as a percent; the truth about whether the work pays. |
| Cost per booked job | Financial | Marketing lead / owner | Marketing spend divided by booked jobs; ties ad budget back to actual work won. |
Filled-in sample week (illustrative)
| Metric | This week | Target | Status |
|---|---|---|---|
| Booking rate (HVAC, residential) | 73% | 80% | Watch |
| Average ticket (electrical service) | $498 | $525 | Watch |
| Callback rate (plumbing) | 9% | Under 5% | Poor |
| Gross margin % (roofing jobs) | 41% | 45% | Watch |
| Cost per booked job | $118 | Under $125 | Good |
Info
Owner takeaway: read the status column first
In the sample above the obvious fire is the 9% plumbing callback rate against a sub-5% target. That one poor row is quietly pulling down the roofing margin too, because every callback is a truck roll you do not bill for. A template earns its keep when one glance at the status column tells you where Monday's coaching time should go, before the month closes and the numbers are already history.
How to create the dashboard, step by step
01 Pick five metrics that pass the 4 P's
Start from the five-KPI set above. Run each one through Purpose, Pulse, People, and Practice. A four-truck plumbing shop and a multi-location HVAC group will not land on the same exact list.
02 Set an owner and a target for each row
A metric with no owner gets ignored. A metric with no target is just trivia. Use last quarter's actuals as a starting target and tighten from there.
03 Pull the numbers on a fixed cadence
Front-office and field metrics weekly, financials monthly once the books close. Pull from your CRM, call tracking, and QuickBooks, and write down where each number came from so it is repeatable.
04 Color-code against target
Mark each row good, watch, or poor. The whole point of the board is that the eye lands on the poor rows first, not that it lists every number you have.
05 Review it out loud, every week
Walk the board in your weekly meeting and assign one action per off-target row. A dashboard nobody reviews is just a spreadsheet nobody opens.
Interpretation guide: what good, watch, and poor look like
Use these as starting targets, not laws. Real targets vary by trade, season, market, and business model. The status colors below match how the same metrics render on a live board.
- Booking rateAt or above your booking target means the front office is converting demand you already paid for.Good
- Current
- On or above target
- Target
- Company-set
- Average ticketUsually a handful of techs skipping options or diagnostics, not the whole crew; coach the bottom quartile first.Watch
- Current
- A few points under
- Target
- Company-set
- Callback rateRework is invisible until you track it; a rising callback rate is margin walking out the door.Poor
- Current
- Climbing week over week
- Target
- Low and stable
- Gross margin %Check material costs and discounting before you blame revenue; small margin slips compound fast.Watch
- Current
- Drifting down
- Target
- Company-set
| Metric | Current | Target | Status |
|---|---|---|---|
| Booking rateAt or above your booking target means the front office is converting demand you already paid for. | On or above target | Company-set | Good |
| Average ticketUsually a handful of techs skipping options or diagnostics, not the whole crew; coach the bottom quartile first. | A few points under | Company-set | Watch |
| Callback rateRework is invisible until you track it; a rising callback rate is margin walking out the door. | Climbing week over week | Low and stable | Poor |
| Gross margin %Check material costs and discounting before you blame revenue; small margin slips compound fast. | Drifting down | Company-set | Watch |
Warning
Common mistake: a board full of vanity metrics
The fastest way to kill a KPI dashboard is to put 40 numbers on it. Total website visits, raw call volume, and lifetime revenue look impressive and change nothing about your week. A good KPI dashboard is the opposite of comprehensive: five to twelve numbers that each have an owner and a target. If you cannot say who moves a number and what good looks like, leave it off.
Warning
When the spreadsheet template breaks
A static template works until one of three things happens. You add a second location and the tabs multiply faster than anyone updates them. You want it real-time, but the numbers are always last week because someone copies them in by hand. Or you want it on the shop TV, and a spreadsheet is the wrong thing to stare at all day. At that point you are not maintaining a dashboard, you are maintaining a copy-paste job.
What a good KPI dashboard looks like running live
This is the spreadsheet layout above, automated: the numbers refresh as jobs close and calls come in, with targets and trend built in. Datacube consolidates data from your CRM, call tracking, and QuickBooks into a custom board for web, mobile, and the office TV. Figures below are illustrative.
Illustrative tiles for layout reference. A real datacube board is built around your KPIs, targets, teams, and data sources.
Spreadsheet template vs an automated datacube board
| Feature | datacube | Spreadsheet template |
|---|---|---|
| Cost to start | Custom build (4 to 6 week onboarding) | Free, today |
| How current the numbers are | Real-time as jobs and calls update | As current as the last manual update |
| Data sources | Designed to consolidate CRM, call tracking, QuickBooks, reviews, and more | Whatever you copy in by hand |
| Multi-location rollups | Standardized KPIs rolled up across locations | More tabs, more drift |
| Office TV, mobile, web | Built for all three | A spreadsheet on a screen |
| Leaderboards, goals, contests | Included | Not really |
Contractor KPI dashboard template FAQs
See your KPI template as a live board
Use the template to get your numbers organized, then see what they look like running in real time. In a live demo we map your KPIs, targets, and data sources to a custom datacube board for your front office, field, and financials.
Keep exploring
Related
Go deeper