Recruitment Dashboard: What to Track and How to Build It
A recruitment dashboard for a company hiring a few people a year. Which metrics work at low volume, which mislead, and a spreadsheet you can start today.
Every guide to this topic shows you the same dashboard: a grid of quarterly averages, funnel conversion rates by stage, source of hire attribution, and a time to fill trendline against an industry benchmark. It is a good dashboard, but it is built for an organization making three hundred hires a year and reporting to a leadership team. If you hire a handful of people a year, this guide shows what to build instead.
At six hires a year, that dashboard is actively misleading. Not incomplete, misleading. A conversion rate computed on eleven candidates is a rounding artifact, and an average time to fill across four roles hides the only role that matters.
Benchmarking against a published figure is worse than useless once you notice that two cost per hire figures SHRM itself publishes differ from each other by more than four times, because one is a mean and the other is a median from a different survey. My advice to any founder in that position is to skip the grid and watch one column instead.
The guide is written for the company with no recruiting team. It covers which metrics stay meaningful at low volume, the single number that matters most and that almost nobody publishes, what to deliberately leave off, why your dashboard should show current state rather than history, and a three tab spreadsheet you can start using this afternoon. I build onboarding and employee records tooling at FirstHR, and everything below works in a spreadsheet if you would rather not use software at all.
- Sign the offer letter
- Sign the employee handbook
- Workplace Safety course
What It Is
A recruitment dashboard is a single view of your hiring activity that answers, at a glance, what is open, where every candidate stands, and whether the process is working.
The word dashboard implies software, and it should not. A dashboard is a habit of looking at the same small set of information on the same cadence and acting on it. A company with a spreadsheet it reviews every Monday has a working dashboard. A company with an expensive reporting module nobody opens does not.
It also differs from a general HR metrics report, which covers the whole employee lifecycle rather than the hiring slice, and from HR analytics, which is the discipline of finding patterns rather than the artifact you look at on Monday.
Larger organizations call the same artifact a talent acquisition dashboard. The data underneath is close to identical, and the difference is the audience. Theirs reports upward to a leadership team on a quarterly rhythm, and yours tells one person which candidate to call before lunch.
The distinction from an applicant tracking system is worth stating early. A tracking system stores candidates and moves them through stages. A dashboard summarizes what that data says. Most tracking systems include dashboard views, so buying one gives you both, but the two are separable and the habit is the harder half to acquire.
Why Averages Mislead
Most metrics in standard recruiting guidance are ratios or averages computed across many hires. At six hires a year those numbers do not describe your process, they describe whichever hire was unusual.
| Metric | At 300 hires a year | At 6 hires a year |
|---|---|---|
| Average time to fill | A stable process measure worth trending | Four roles averaged together, hiding the one that stalled |
| Screening to interview conversion | A real signal about screening quality | Computed on eleven people; one referral moves it 9 points |
| Cost per hire | A budget planning input | One agency placement moves it more than a year of improvement |
| Source of hire effectiveness | Tells you where to spend | Three sources, two hires each, no way to separate signal from luck |
| Quality of hire | Correlates with something across cohorts | A sample of six, scored by one person, months after the fact |
| Offer acceptance rate | A trend worth watching | Still useful, because each decline is investigable individually |
The right hand column is not an argument for measuring nothing. It is an argument for measuring different things. Small samples are bad at supporting averages and excellent at supporting individual attention, which is a genuine advantage: with six hires a year you can know every candidate by name and investigate every declined offer personally, which no enterprise recruiting function can do.
The same arithmetic explains why a single unusual role distorts everything downstream of it. A role that took ninety days because a hiring manager was on leave will sit inside your average for a year, and any planning built on that average, including your headcount plan, inherits the distortion.
The last row of that table shows what survives. Offer acceptance stays useful at low volume precisely because a decline is a discrete event with a cause you can ask about, rather than a percentage you have to interpret. That is the test for whether a metric belongs on a small company dashboard: can you act on a single data point, or do you need the aggregate.
Nick Anisimov, FirstHR founderThe Benchmark Problem
Before you benchmark anything, look at what the published SHRM figures actually say, because they disagree with each other in a way that most articles quoting them do not mention.
According to the SHRM 2025 benchmarking reports, average nonexecutive cost per hire was $5,475. The SHRM 2026 recruiting benchmarking data brief reports a median nonexecutive cost per hire of $1,300. Both figures are correct for what they measure, and they are more than four times apart.
The difference is mean versus median. The 2025 average is pulled upward by the organizations that spend the most per hire, while the 2026 median describes the middle organization. SHRM put the 2025 nonexecutive median at $1,200, so the gap comes from the measure rather than the year.
Articles routinely present one of the two SHRM figures as the industry average with no qualifier, which is how a small business ends up benchmarking against a number built from a different question.
| Published figure | What it actually is | Why it differs | Use it for |
|---|---|---|---|
| $5,475 average nonexecutive cost per hire | A mean from the SHRM 2025 benchmarking reports | The biggest spenders pull the average far above the median | Understanding the upper end of what hiring can cost |
| $1,300 median nonexecutive cost per hire | A median from the SHRM 2026 recruiting benchmarking brief | Medians describe the middle organization, not the average dollar | A more realistic reference for an ordinary role |
| $15,000 median executive cost per hire | A median, up from $10,600 the prior year | Executive roles are reported separately and cost far more to fill | Budgeting a senior hire, not a general benchmark |
| 39 calendar days median time to fill | A median for nonexecutive roles, down from 44 the prior year | Medians resist distortion from a few very slow roles | A sanity check, not a target |
For a business making six hires a year, the honest conclusion is to stop benchmarking externally and compare against yourself. Your last four roles are a better reference than any published median, because they share your pay bands, your location, your brand recognition, and your approval process.
If your fifth role takes twice as long as your previous four, that is a finding. If it takes twice as long as a national median, that is a coincidence with a number attached.
Broader labor market context is still worth a glance, and the federal job openings and labor turnover data is the right source for it, because it tells you whether the market got harder for everyone or only for you. That distinction stops a normal market shift from being misread as a process failure.
Metrics Worth Tracking
Six measures cover a small business hiring dashboard. Four of them are current state readings rather than historical averages, which is the structural difference from every enterprise dashboard you will see.
The first metric, days since last movement, deserves the emphasis it gets. It is not on any standard recruiting metrics list, and at small scale it is the most actionable number available. A column that surfaces every candidate you have not touched in five days turns a quiet loss into a Monday morning task.
Research on job seekers shows why silence from an employer matters. In a longitudinal study of student job seekers, Rynes, Bretz, and Gerhart (Personnel Psychology, 1991) found that applicants read recruitment delays as a signal about the organization as a whole, and that those delays had strongly negative effects.
The formulas for the two conventional measures are worth stating precisely because they are commonly conflated. Time to fill runs from the day the role was approved to the day the offer was accepted. Time to hire runs from the day the candidate entered the process to the same endpoint, so it measures your speed with a specific person rather than the whole requisition.
Time to first response is the one most small teams have never measured, and it is the cheapest of the six to start. You need the application date and the date of your first reply, both of which already exist in your inbox, and the median of the gap is the number.
Cost per hire follows the SHRM standard formula of internal plus external recruiting costs divided by hires in the period. The part small businesses under-count is internal time, which at a few hires a year can easily outweigh the external spend.
What to Leave Off
Few published guides tell you what to omit, which is why small business dashboards end up as scaled down enterprise dashboards full of numbers nobody can act on. Here is the omission list.
| Metric | Why it is on every list | Why to leave it off below ~30 hires a year |
|---|---|---|
| Funnel conversion rate by stage | It is the classic recruiting diagnostic | Denominators in single digits; each candidate moves it several points |
| Source of hire effectiveness | It tells enterprises where to spend | Two hires per source cannot separate a good channel from a lucky one |
| Quality of hire | It is the metric everyone says matters most | Requires a scoring method, a cohort, and time you do not have |
| Diversity analytics | It is standard on enterprise dashboards | Small samples make percentages volatile and individuals identifiable |
| Candidate satisfaction scoring | It is a real signal at scale | At six hires, ask the three finalists directly instead |
| Cost per hire against a benchmark | Every guide includes the comparison | Two SHRM cost per hire figures disagree fourfold; compare against yourself |
| Recruiter productivity | It manages a recruiting team | You do not have a recruiting team |
Leaving these off is not lowering the bar. Tracking a metric whose sample cannot support it produces confident wrong conclusions, which is worse than tracking nothing, because you then act on them. The threshold to revisit is roughly thirty hires a year, at which point conversion rates and source effectiveness start carrying real information.
Quality of hire is worth singling out. The SHRM 2025 benchmarking reports found that only 20 percent of organizations track it at all, which tells you how much work the measure takes even with a recruiting team and a large enough cohort behind it.
Track Aging, Not Averages
The structural insight behind everything above is that a small company dashboard should show how long things have been sitting, not what the average was last quarter.
Aging views have three properties that suit low volume. They work from day one with no accumulated history. They point at a specific item rather than a trend, so the response is obvious. And they surface a failure mode that costs small businesses candidates, which is less often a bad interview process than a slow one.
| Instead of this average | Show this aging view | The action it produces |
|---|---|---|
| Average time to fill across open roles | Days open, per role, sorted descending | Look at the slowest role today |
| Average days in each stage | Days since each candidate last moved | Contact everyone above five days this morning |
| Screening to interview conversion | How many people are sitting at screening right now | Schedule, or admit the role is not a priority |
| Average response time last month | Applications with no reply yet, and how old | Reply to them |
| Offer acceptance rate | Outstanding offers and how long each has been out | Follow up before the deadline you set expires |
| Historical source performance | Where this week's live candidates came from | Post where the live ones came from |
The right hand column of that table is the test. Each aging view produces an action you can take before lunch, while each average on the left produces a discussion. For a business whose entire hiring function is one person doing it alongside another job, that difference decides whether the dashboard gets used.
This is also why the pipeline view matters more than the funnel diagram. A recruiting funnel is a useful mental model for how candidates flow, and a poor dashboard, because it describes proportions rather than positions. What you need on a Monday is the list of people who are stuck, not the shape of the cohort.
Types of Dashboard
Three types appear across the literature, and the ordering of which to build first is the opposite of how they are usually presented.
Guides tend to present the analytical dashboard as the sophisticated destination and the operational one as a starting point. For a company hiring a handful of people a year that ordering is backwards: the operational dashboard is the destination, and the analytical one becomes available later if hiring volume grows enough to make patterns real.
If someone does start asking for a KPI view, build it from the hiring log tab rather than from scratch, because hires, days to fill, cost, and ninety day retention already live there. The recruitment KPI guide covers which of those are worth a target at this size.
Building It in a Sheet
Three tabs, no formulas beyond date subtraction, and it can be running before the end of the day.
Below is that build already laid out, with one example row on each tab showing what belongs in the columns that are not self-evident. Delete the example rows and start with your live roles.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Role | Hiring manager | Approved on | Target start date | Days open | Live candidates | Furthest stage reached | Blocked on | Status |
| 2 | Example: Operations coordinator | Interview | Waiting on manager availability | Active | |||||
| 3 | |||||||||
| 4 | |||||||||
| 5 | |||||||||
| 6 | |||||||||
| 7 | |||||||||
| 8 |
The file opens in Excel and in Google Sheets, and the same two formulas work in either. Days open is =TODAY()-C2, pointing at the approval date. Days since movement is =TODAY()-F2, pointing at the stage change date. Format both results as plain numbers, or the sheet renders them as dates in 1900.
The aging tab carries the two columns that most templates omit: the date you first responded, which is the only way to measure how quickly you reply, and the date the stage last changed, which drives the aging column that makes the whole thing work.
The hiring log includes a ninety day retention column, because a fast cheap hire who leaves in two months was not a good hire and the dashboard should be able to say so.
What this deliberately is not is a candidate record. Scores, pay expectations, references and the reason you passed on someone all matter, and they all belong in the candidate tracker instead, which is built for exactly that kind of record. The dashboard reads that work back as movement and cost. Keeping the two apart is what lets this sheet stay narrow enough to open every week.
One habit makes it reliable: update it when the thing happens rather than before the weekly review. A stage change recorded three days late produces an aging column that is wrong in the direction that hides the problem.
The Weekly Review
Fifteen minutes, same slot, only while roles are open. Three steps in order.
| Step | What you look at | What you do | Time |
|---|---|---|---|
| Clear the silence | The aging tab sorted by days since movement | Every candidate above five days gets a message today, even if the message is a status update with no news | 5 minutes |
| Find the stuck role | Open roles sorted by days open | Identify what the slowest role is blocked on and name one person responsible for unblocking it | 5 minutes |
| Confirm every candidate has a next action | The next action and due date columns | Anyone with a blank next action either gets one or gets closed out honestly | 5 minutes |
Reviewing on this cadence is also what keeps candidate experience from degrading quietly, since much of what candidates complain about in small company hiring is a timing problem rather than a substance one.
The third step is the one that prevents the most damage. A candidate with no next action is a candidate who will be forgotten, and forgetting them costs more than rejecting them, because a clean rejection preserves the relationship and silence does not. In a small local or professional network that difference compounds, since your next hire frequently comes through someone you spoke to during this one.
Keep the review to the dashboard rather than letting it become a hiring discussion. Decisions about who to advance belong in a separate conversation with the hiring manager; this fifteen minutes exists to find what has stopped moving. Mixing the two reliably turns a quarter hour into an hour, and the meeting stops happening within a month.
Recruiting Dashboard Examples: Four Readings and What They Mean
Four readings come up constantly once the sheet is live, and each has an obvious response that the equivalent average would have buried. Learn to recognize them by shape: the fifteen minutes exist to spot which reading you are looking at and act on it, not to analyze it.
| What the sheet shows | What it means | What you do |
|---|---|---|
| Two candidates at screening, 8 and 11 days since movement, nobody scheduled | The role is not stalled on candidate quality. It is stalled on you | Book both interviews today, or close the role out honestly |
| Three open roles at 19, 24, and 62 days | The average of 35 days is meaningless. Only the third role is a problem | Read the blocked on column for the 62 day role and name one person to clear it |
| An offer out for nine days with no follow-up date recorded | Silence after an offer may signal a competing process rather than deliberation | Call rather than email, and set a decision date in the conversation |
| Every row under three days, every row with a next action and a date | Nothing is wrong. This is what a working dashboard looks like | Close the sheet. The habit is doing its job |
When to Move Off Sheets
A spreadsheet is genuinely the right tool for a while, and there are five specific signals that it has stopped being one.
| Signal | What is actually happening | What to do |
|---|---|---|
| Two people edit it and overwrite each other | You have concurrent editing without record locking | Move to something with a real data model |
| Candidate details live in email as well as the sheet | Two sources of truth, and the sheet is now the less current one | Move, or accept that the dashboard is unreliable |
| You are copying data into the sheet by hand from somewhere else | The manual step will be skipped during a busy week, and it will be the week that matters | Automate the capture or move |
| Hire count passes roughly thirty a year | Analytical metrics become meaningful and manual aggregation stops scaling | Move, and start tracking the metrics you deliberately left off |
| A hired candidate's data has to be retyped for onboarding | You are maintaining the same person twice | Consolidate where employee records already live |
The last row is the one worth planning for rather than reacting to. The moment someone accepts an offer, their information has to exist in whatever system holds employees, and retyping it is both wasted effort and a reliable source of errors in the record you least want errors in.
The handover from hiring to employee records is the natural seam between hiring tooling and the rest of your people data, and it is worth checking before you buy anything on the hiring side.
How much tooling you need depends on your size. According to the SBA Office of Advocacy FAQ (February 2026), small businesses, defined there as firms with fewer than 500 employees, make up 99.7 percent of US firms with paid employees.
Census Bureau data (Statistics of U.S. Businesses, 2022) show that 89.4 percent of US employer firms have fewer than 20 employees, so most employers building a recruitment dashboard are hiring at a volume the published guidance never addresses.
What should not drive the decision is dashboard sophistication. Most tracking systems produce prettier charts than your sheet, and prettier charts on a base of eleven candidates are still eleven candidates. Buy for the data model, the collaboration, and the handover into employee records, not for the reporting module.
Common Mistakes
Most failures come from copying an enterprise dashboard rather than building the one your volume supports.
| Mistake | Why it happens | The fix |
|---|---|---|
| Tracking conversion rates at single digit volume | Every published guide includes them | Show counts. A percentage from eleven people removes information |
| Benchmarking against a published average | The number looks authoritative | Even SHRM publishes two cost per hire figures that differ fourfold. Compare against your own last four roles |
| Averaging across roles | It produces one clean number | One slow role is invisible inside an average and is the only thing worth acting on |
| Building it backward looking | Enterprise dashboards summarize history | Show current state. You are managing live hiring, not reporting to a board |
| No column for days since last movement | It is on no standard metrics list | Add it, sort by it, and act on anything above five days |
| Updating the sheet just before the review | It feels efficient | Late stage changes produce aging figures that hide the problem |
| Reviewing monthly instead of weekly | Monthly feels proportionate to the volume | Three weeks of silence is long enough to lose the candidate |
| Buying software for better charts | The charts look like the solution | Buy for the data model and the handover into employee records |
The second row is the one I would fix first. A small business comparing its cost per hire against a published mean is comparing a number built from six data points against a number built from thousands, drawn from a survey with a different methodology. Most articles quote that figure without saying whether it is a mean or a median.
Nothing useful comes out of benchmarking that way, and something useful does come out of comparing your fifth role against your previous four. None of this requires analytics capability, a recruiting team, or a platform. It requires three tabs, two date formulas, and a recurring fifteen minutes, so build the sheet this week and book the first review.
Frequently Asked Questions
What is a recruitment dashboard?
A recruitment dashboard is one place to see your open roles, the stage each candidate has reached, and whether your hiring process is working. Large organizations usually build the analytical kind, which summarizes past hiring for leadership. A small business gets more from an operational dashboard that reflects where live hiring stands right now. It tells you what needs attention today instead of what happened last quarter, and it is useful the day you start it, with no need to wait for a year of accumulated data.
What metrics should a recruitment dashboard include?
Six measures are enough at low hiring volume: days since each candidate last moved stage, days open for each role, the number of live candidates at every stage today, cumulative cost per hire, offer acceptance, and time to first response. Four of the six describe where things stand today instead of averaging the past, which is why each one points at something you can act on this week. Conversion rates, source effectiveness, and quality of hire need far more hires than a small company makes before they say anything reliable.
What is a good time to fill?
Published medians sit near 40 days for nonexecutive roles. SHRM reported a 2026 median of 39 calendar days against 44 a year earlier, with executive roles landing at 45 days. A small company can beat those medians, with fewer approval layers and fewer calendars to align. The more useful question for a company that fills six roles a year is whether your own roles are getting slower, since a benchmark computed across thousands of organizations says nothing about whether your process is working. Track the gap between your own roles instead, and treat a sudden jump as the finding rather than the level.
What is the average cost per hire?
It depends which published figure you use, and two figures from SHRM itself differ by more than four times. The SHRM 2025 benchmarking reports put average nonexecutive cost per hire at $5,475, while the SHRM 2026 recruiting benchmarking brief gives a nonexecutive median of $1,300 and an executive median of $15,000. Both are accurate for what they measure: one is a mean lifted by the biggest spenders, the other a median describing the middle organization. Quoting either as the industry number without saying which is a common error, and at six hires a year neither figure tells you anything useful about your own spending.
Can I build a recruitment dashboard in a spreadsheet?
Yes, and for most small businesses a spreadsheet is the correct tool rather than a compromise. Three tabs cover it: open roles with days open, a candidate pipeline with the date each person last changed stage, and a log of completed hires. The only formulas required are date subtractions. A spreadsheet fails when several people need to update it simultaneously or when candidate data starts living in two places, which is the signal to move rather than a reason to start elsewhere.
How is a recruitment dashboard different from an ATS?
An applicant tracking system is where candidates are stored and moved from stage to stage, while a dashboard is the summary of what that activity looks like right now. Many tracking systems ship with dashboard views of their own, so one purchase can cover both. You can still have either without the other. A spreadsheet reviewed every week works as a complete dashboard with no tracking system behind it, and a tracking system can come with a dashboard nobody opens. What makes a dashboard work is the review habit, not the software.
How often should I look at a recruitment dashboard?
Weekly, for about fifteen minutes, and only while roles are open. The review has three steps: sort the pipeline by days since last movement and clear anything above five days, look at the open roles list for anything sitting notably longer than the others, and confirm every live candidate has a named next action with a date. Monthly is too slow, because a candidate who has heard nothing for three weeks may already have gone elsewhere.
What are the types of recruitment dashboard?
Three kinds are in common use: operational, analytical, and strategic. The operational kind tracks live hiring as it stands today and tells you what to deal with this week. The analytical kind studies many completed hires to spot patterns, such as which sources deliver better candidates, where candidates drop out of the funnel, and whether a process change worked. The strategic, or KPI, kind boils everything down to a few headline figures measured against targets for executives. A small business should start with the operational dashboard, because the other two depend on hiring volume or on an executive audience that a small company usually lacks.
What should I not put on a small business recruitment dashboard?
Quality of hire scoring, source of hire return on investment, funnel conversion rates by stage, diversity analytics, and comparisons against published benchmarks. Each is a legitimate measure that requires more hires than a small company makes for the number to mean anything, and tracking them produces confident conclusions from samples too small to support them. Leave them off until your annual hire count reaches roughly thirty, then revisit.
Make HR the easy part of running your business
Onboarding, e-signatures, training and core HR in one place. Up and running in 5 minutes.
- 7-day free trial
- No credit card required
- Cancel anytime