Key takeaways
- A live office dashboard is for decisions made in the next hour: who calls back, who gets dispatched, which estimate gets chased.
- Every tile needs a definition, a data source, a refresh rate and a decision it supports; drop tiles that support none.
- Unreturned missed calls deserve the top spot: only 19% of US adults generally pick up calls from unknown numbers[1].
- Keep monthly measures such as margin and labor percentage off the live screen; they belong in the monthly and quarterly reviews.
- Show team totals and queues, not individual rankings, on a screen everyone can see.
What a live dashboard is for
Most plumbing companies have reports. Fewer have a screen that tells the office, at a glance, what needs doing right now. The difference matters. A monthly report shows that missed calls went up last month; a live dashboard shows that three callers are waiting for a call back and the oldest has been waiting forty minutes. Only the second one changes what happens today.
So the test for every tile is simple: what will someone do differently when this number changes? If the answer is nothing until month end, the measure belongs in a report, not on the wall. A good office dashboard has six to ten tiles, all about queues, promises and gaps that the team can act on within the hour.
That also means the dashboard is not a replacement for the scorecard you review each month or quarter. Margins, labor percentage, renewal rates and callback rates move slowly and need context. Put them in the quarterly business review and keep the live screen for the work in front of the team.
The tiles worth showing
| Tile | Definition | Data source | Decision it supports |
|---|---|---|---|
| Missed calls not yet returned | Inbound calls not answered live, with no completed callback | Phone system call log | Who calls back next |
| Oldest unreturned call | Minutes since the oldest missed call with no callback | Phone system | Escalate when it passes your limit |
| Calls answered live today | Answered live divided by inbound, since opening | Phone system | Move a person to the phones |
| Unassigned jobs | Booked jobs with no tech assigned | Field service software | Dispatch now or reschedule |
| Emergency queue | Emergency calls waiting for a tech, with promised arrival | Field service software | Pull a tech off routine work |
| Arrival promises at risk | Jobs where the tech will miss the window on current ETA | Field software with GPS | Call the customer before they call you |
| Estimates awaiting follow-up | Open estimates older than two days with no contact logged | Field software or CRM | Who gets a follow-up call today |
| Booked revenue today vs target | Value of jobs booked today against a daily target | Field software | Push marketing or offer earlier slots |
Notice what is missing: revenue to date for the month, average ticket, technician rankings and review scores. These are useful numbers, but nobody in the office can change them in the next hour, and showing them on a wall screen tends to start conversations rather than actions.
Why missed calls go at the top
Plumbing calls are often urgent, and the caller is usually ringing several companies. Once a call is missed, getting the customer back is harder than it looks. Only 19% of US adults generally pick up cellphone calls from unknown numbers[1], and 67% say their practice is not to answer but to check a voicemail if one is left[2]. A callback from your office may look like an unknown number to the customer.
Source: Pew Research Center, 2020[2]
Show the data
| Item | Value |
|---|---|
| Generally pick up | 19% |
| Don't answer, but check voicemail | 67% |
That is why the dashboard should show unreturned calls and their age, not just a count of missed calls. Set a target for the oldest unreturned call and make it visible. When the office calls back, leave a short voicemail with the company name and the reason, and follow with a text where the customer has agreed to receive them. If Ava answers your overflow or after-hours calls, count those calls as answered and check the job details it sends to the team against the dispatch board.
Dispatch and promise tiles
The second group of tiles is about promises made to customers. Emergency calls waiting, unassigned jobs and arrival windows at risk all show where the company is about to let someone down. Plumbers are often on call for emergencies, and evening and weekend work is common[3], so these tiles need to work outside office hours too, on the on-call dispatcher's phone if not on a wall screen.
Coverage matters on weekends, when fewer people are working everywhere. On an average Saturday, Sunday or holiday in 2025, 30.3% of employed people worked, compared with 80.5% on an average weekday[4]. Customers with a leak on Sunday are calling companies with thin staffing, which is when a dashboard that shows the queue clearly is most useful.
Show promised arrival windows, not just job counts. A board with twelve jobs and two at risk of being late needs a phone call to two customers now; a board that just says twelve jobs does not tell anyone to act.
Building it in six steps
List the decisions
Write down the decisions the office makes every hour: callbacks, dispatch, rescheduling, estimate follow-up. Each tile must support one.
Find the data
Check which system holds each number: phone system, field service software, CRM, GPS. Most have reports or an export; many have built-in dashboards or can feed a simple dashboard tool.
Set the refresh rate
Queues need to refresh every minute or two. Daily totals can refresh every 15 minutes. A tile that is an hour stale is worse than no tile.
Define the thresholds
Agree when a tile turns from normal to needs attention, such as the oldest unreturned call passing your limit. Keep it to two states; more colors create noise.
Place the screen
Mount it where dispatchers and CSRs can see it without leaving their desks. Make the same view available on phones for on-call staff.
Test for two weeks
Ask the team which tiles they used and which they ignored. Remove the ignored ones and adjust thresholds.
Example: a seven-tile office screen
Example (fictional): a 9-truck shop with two CSRs and a dispatcher builds a wall screen in two columns. The left column is phones: calls waiting, missed calls not returned, oldest unreturned call and calls answered live today. The right column is jobs: emergency queue, unassigned jobs and arrival promises at risk. A thin strip along the bottom shows booked revenue today against the daily target.
In this Example the team sets one rule: when the oldest unreturned call passes 15 minutes, whoever is free calls back before taking a new task. After a month, the owner reviews the call log and sees far fewer missed callers left without a callback. The board did not change how many calls came in; it changed how quickly the team acted on the ones that slipped through.
Using the board in the daily huddle
A dashboard works best when the team uses it together for a few minutes each day. Start the morning with a ten-minute huddle in front of the screen: yesterday’s unreturned calls that still need a callback, today’s unassigned jobs, emergency capacity and any estimates due for follow-up. Agree who owns each item and move on.
Repeat a shorter check after lunch, when the morning schedule has usually slipped and afternoon windows are at risk. This is the moment to call customers whose arrival window will be missed, offer earlier slots to people waiting and decide whether a tech should be pulled to an emergency. The screen gives everyone the same picture, so the conversation is about what to do rather than what is happening.
- Morning: callbacks owed, unassigned jobs, emergency capacity, estimate follow-ups.
- After lunch: arrival windows at risk, open slots to offer, emergency queue.
- End of day: calls still unreturned, jobs to confirm for tomorrow, handover to on-call.
Keep the huddle short and standing. If an item needs a longer discussion, park it for the weekly meeting and keep the board moving.
Mistakes to avoid
- Ranking techs on a shared screen. Leaderboards on the office wall can create resentment and gaming. Discuss individual numbers privately in coaching or in technician performance reviews.
- Too many tiles. Past about ten, people stop reading the screen. Every new tile should replace one.
- Numbers nobody trusts. If a tile is wrong twice, people ignore it forever. Check definitions against the source system before going live.
- Monthly measures on a live screen. Margins and labor percentage move slowly; showing them live invites worry without action.
- No owner. Someone must fix broken tiles, update thresholds and remove the ones that stopped being useful.
Once the live board works, connect it to the weekly view. Our weekly scorecard and the explainer on plumbing KPIs show how the same measures roll up into weekly and monthly reports, and cost per lead vs cost per job covers the marketing side.
Frequently asked questions
What should a plumbing office dashboard show?
Queues and promises the team can act on within the hour: unreturned missed calls and their age, calls answered live, unassigned jobs, the emergency queue, arrival windows at risk and estimates awaiting follow-up.
Should technician rankings be on the office screen?
Usually not. Shared leaderboards can create resentment and gaming. Keep individual performance for private coaching and reviews.
How often should dashboard numbers refresh?
Queues every minute or two, daily totals every 15 minutes or so. Stale numbers lead to wrong decisions and quickly lose the team's trust.
Do I need special software for a KPI dashboard?
Not always. Many phone systems and field service platforms have built-in dashboards or exports that feed simple dashboard tools. Start with the data you already have.
References
Pew Research Center (2020). Most Americans don't answer cellphone calls from unknown numbers (opens in a new tab) ↑
Pew Research Center (2020). Most Americans don't answer cellphone calls from unknown numbers (opens in a new tab) ↑
U.S. Bureau of Labor Statistics (2025). Occupational Outlook Handbook: Plumbers, Pipefitters, and Steamfitters (opens in a new tab) ↑
U.S. Bureau of Labor Statistics (2025). American Time Use Survey, Table 4: Employed persons working and time spent working on days worked, 2025 (opens in a new tab) ↑