Metrics finance

A live KPI dashboard for the plumbing office

How to build a live KPI dashboard for a plumbing office: which tiles to show, where the data comes from, refresh rates, layout and the mistakes to avoid.

AssistCall research teamPublished Reviewed by Faruque Amin, VP of Sales and Marketing6 min read

On this page
  1. What a live dashboard is for
  2. The tiles worth showing
  3. Why missed calls go at the top
  4. Dispatch and promise tiles
  5. Building it in six steps
  6. Example: a seven-tile office screen
  7. Using the board in the daily huddle
  8. Mistakes to avoid
  9. Frequently asked questions
  10. References
Metrics finance: A live KPI dashboard for the plumbing officeArticle coverMETRICS FINANCEA live KPI dashboardfor the plumbing officeAva for PlumbersInsightsMetrics finance: A live KPI dashboard for the plumbing officeArticle coverMETRICS FINANCEA live KPI dashboardfor the plumbingofficeAva for Plumbers

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

Start with these and remove any tile that does not lead to an action.
TileDefinitionData sourceDecision it supports
Missed calls not yet returnedInbound calls not answered live, with no completed callbackPhone system call logWho calls back next
Oldest unreturned callMinutes since the oldest missed call with no callbackPhone systemEscalate when it passes your limit
Calls answered live todayAnswered live divided by inbound, since openingPhone systemMove a person to the phones
Unassigned jobsBooked jobs with no tech assignedField service softwareDispatch now or reschedule
Emergency queueEmergency calls waiting for a tech, with promised arrivalField service softwarePull a tech off routine work
Arrival promises at riskJobs where the tech will miss the window on current ETAField software with GPSCall the customer before they call you
Estimates awaiting follow-upOpen estimates older than two days with no contact loggedField software or CRMWho gets a follow-up call today
Booked revenue today vs targetValue of jobs booked today against a daily targetField softwarePush 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.

How US adults handle cellphone calls from unknown numbersPew Research Center survey, 2020
How US adults handle cellphone calls from unknown numbersComparison. Generally pick up: 19%; Don't answer, but check voicemail: 67%.19%Generally pick upGenerally pick up: 19%67%Don't answer, but check voicemailDon't answer, but check voicemail: 67%How US adults handle cellphone calls from unknown numbersComparison. Generally pick up: 19%; Don't answer, but check voicemail: 67%.19%Generally pick upGenerally pick up: 19%67%Don't answer, but check voicemailDon't answer, but check voicemail: 67%

Source: Pew Research Center, 2020[2]

Show the data
ItemValue
Generally pick up19%
Don't answer, but check voicemail67%

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

  1. List the decisions

    Write down the decisions the office makes every hour: callbacks, dispatch, rescheduling, estimate follow-up. Each tile must support one.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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

  1. Pew Research Center (2020). Most Americans don't answer cellphone calls from unknown numbers (opens in a new tab) ↑

  2. Pew Research Center (2020). Most Americans don't answer cellphone calls from unknown numbers (opens in a new tab) ↑

  3. U.S. Bureau of Labor Statistics (2025). Occupational Outlook Handbook: Plumbers, Pipefitters, and Steamfitters (opens in a new tab) ↑

  4. 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) ↑

Book a demo

See Ava handle your calls.

Book a short demo. We’ll walk through your calls and workflow, and agree what Ava should take care of.

Book a demo