Hiring Metrics Dashboard Templates: Free Excel + Google Sheets Downloads with 15 Recruiter KPIs

August 18, 2026
By Jürgen Ulbrich

A hiring metrics dashboard turns raw ATS exports into one live view of pipeline health, tracking speed and cost across the whole funnel from first application to first year on the job. The fifteen KPIs below, pre-built into free Excel and Google Sheets templates, show a DACH mid-market team exactly where a requisition is stuck and why.

Most recruiting teams already sit on this data inside their applicant tracking system. Only a minority run dedicated recruitment analytics tools, so the rest stitch dashboards together from spreadsheet exports once a month, usually too late to act on. These templates close that gap, and the healthy bands below come from DACH figures, not the US benchmarks most recruiting glossaries keep recycling.

  • Fifteen metrics split into four working groups: speed, source and funnel, cost and productivity, quality and retention.
  • DACH time-to-hire runs close to 70 days on average, with IT and engineering roles stretching past 85 days.
  • A healthy offer acceptance rate sits at 80% or higher, and anything lower flags a pay, process or experience problem.
  • Only three of these fifteen belong in the monthly leadership review. The other twelve stay operational.

What 15 Hiring KPIs Belong on a Recruiting Metrics Dashboard?

A hiring metrics dashboard needs four groups of KPIs: how fast the funnel moves, where candidates come from, what each hire costs, and whether the people you hire stay and perform. These fifteen belong in the free template, grouped the way a TA lead reads them in a Monday stand-up.

  1. Time-to-fill: days from job posted to accepted offer and confirmed start date.
  2. Time-to-hire: days from first candidate contact to signed contract.
  3. Req age: how many days a requisition has sat open right now.
  4. Source-of-hire: which channel produced the person who actually got hired.
  5. Source-quality-score: which channel produces hires who stay and perform after they start.
  6. Funnel conversion by stage: drop-off rate between application, screen, interview and offer.
  7. Sourcing-response rate: share of outbound messages that get a reply.
  8. Screen-to-onsite rate: share of screened candidates who reach an onsite or final round.
  9. Onsite-to-offer rate: share of onsite candidates who receive an offer.
  10. Cost-per-hire: total recruiting spend divided by hires made in the period.
  11. Recruiter req-load: open requisitions carried per recruiter at any given time.
  12. Agency spend: share of the recruiting budget going to external recruiters.
  13. Offer acceptance rate: share of extended offers that get signed.
  14. First-year retention: share of new hires still employed after twelve months.
  15. Diversity-of-shortlist: how balanced the candidate pool looks before a hiring decision.

Pulling these numbers by hand every month is exactly the work an applicant tracking system should do for you. Sprad's built-in ATS analytics, an AI-first, free-core system, log each of these events automatically as a candidate moves through the funnel, so the data feeds straight into your Excel or Google Sheets dashboard every day without any export project.

How Do Time-to-Fill and Time-to-Hire Expose a Slow DACH Funnel?

Time-to-fill and time-to-hire measure two different windows of the same hiring process, and DACH teams that mix them up chase the wrong number. Time-to-fill counts from the day a role posts to the day someone accepts and confirms a start date. Time-to-hire counts a narrower stretch, from first candidate contact to signed contract.

MetricFormulaDACH healthy bandRead it as
Time-to-filljob posted → confirmed start~70 days average (58 in care/health, up to 87 in IT and engineering)overall vacancy speed
Time-to-hirefirst contact → signed contract~24 working days, roughly five weeksprocess speed once a candidate is engaged
Req agetoday minus date opened, for open reqsflag anything past your rolling average time-to-fillwhich req is about to become an emergency

Those two figures, roughly 70 days and roughly 24 working days, come from an analysis of 2.5 million DACH applications and a separate recruiter survey with a narrower start point. Label your own start point clearly, or a hiring manager comparing a different definition will wrongly assume your team is slow.

Don't confuse time-to-fill with Vakanzzeit: Germany's Bundesagentur für Arbeit publishes an official "Vakanzzeit" that averaged around 170 to 180 days in 2025, nearly 300 days for care-sector roles. It measures the gap between a company's desired start date and a listing's delisting, and it is not a usable recruiting KPI. Keep it off the dashboard.

Once an offer is signed, statutory notice periods do the most damage to these numbers anywhere in DACH. Germany's base notice period under §622 BGB is four weeks, stretching to seven months after twenty years of tenure. Austria's §20 AngG starts at six weeks and can reach five months. Swiss notice periods customarily run 30 to 90 days. None of that reflects a slow process. The candidate simply can't start sooner, the law won't let them. Tag every req with the candidate's notice period and report a "recruiting time-to-fill" that stops at signature, alongside the full figure that includes notice.

Pull four timestamps from the ATS: job-posted, first-contact, offer-accepted and confirmed-start. Segment every report by role family and seniority before comparing across teams. A 45-day time-to-fill for a warehouse role and an 80-day time-to-fill for a senior engineer are both healthy; blending them into one company average hides both stories.

Which Source and Funnel Metrics Show Recruiter Productivity?

A recruiter's real output shows up in three numbers: source-of-hire, source-quality-score and funnel conversion by stage. Source-of-hire shows which channel a hire came from. Source-quality-score asks whether hires from that channel actually stay and perform.

MetricFormulaDACH signalRead it as
Source-of-hirehires from channel ÷ total hireswatch for one channel above roughly half of all hireschannel concentration risk
Source-quality-scorehires retained past probation ÷ hires from channelcompare against your first-year retention baselinethe real value a channel delivers, beyond raw volume
Funnel conversion by stagecandidates advancing ÷ candidates entering each stagedirectional, track your own trendexactly where the funnel leaks
Sourcing-response ratereplies ÷ outbound messages sentaround 20% for structured German active-sourcing outreachwhether outreach messaging lands
Screen-to-onsite rateonsite invites ÷ completed screensdirectional, no published DACH figure yetscreening accuracy
Onsite-to-offer rateoffers made ÷ onsite interviewsdirectional, no published DACH figure yetinterview-to-decision efficiency

Recruiting and HR outreach already sit near the top of every industry for reply rates, and a German active-sourcing study puts direct-outreach replies at around 20% for structured outreach. Screen-to-onsite and onsite-to-offer don't have a published DACH benchmark yet, so read those two as trend indicators against your own history.

Your source mix is about to shift once salary ranges become mandatory. The EU Pay Transparency Directive requires disclosing a salary range before the first interview from 7 June 2026 and bans asking about previous pay. Germany missed its own transposition deadline, so the national law likely lands only in early 2027, but candidate behavior is shifting already: a StepStone survey found six in ten German job seekers say they're more likely to apply when a listing discloses salary. Expect source-of-hire and source-quality-score to tilt toward your own career page and transparent job boards as this becomes standard.

Feiertag effect on funnel-week comparisons: Job-search volume across German, Austrian and Swiss public holidays barely moves, Indeed's German platform data shows seasonal swings under 1%. What actually slows down is your team: hiring managers on leave push back interview slots, so screen-to-onsite and onsite-to-offer dip for two or three weeks even though the applicant pool never shrank. Read those weeks as a scheduling gap that resolves once your team is back.

If referrals already make up a meaningful slice of your source mix, they deserve their own tracking layer beyond this dashboard, covered separately in our guide to referral-specific KPIs DACH HR teams should track beyond hire counts. And if inbound application volume is what's straining your screen-to-onsite numbers, we walk through that problem in how voice interviews handle the AI applicant flood.

What Does Cost-per-Hire Really Cost in a DACH Mid-Market Team?

Cost-per-hire adds every internal and external recruiting cost in a period and divides it by hires made. DACH mid-market teams should expect a figure around €4,500 to €4,700 per hire, a converging estimate from several DACH sources rather than one single audited study, so treat it as a budget-planning range to watch over time.

MetricFormulaDACH benchmarkRead it as
Cost-per-hire(internal + external recruiting costs) ÷ hiresroughly €4,500 to €4,700, converging estimatebudget figure, trend matters more than the exact number
Recruiter req-loadopen reqs assigned ÷ recruiteraround 16 open reqs and 47 hires per recruiter per yearoverload signal before time-to-fill creeps up
Agency spendagency fees paid ÷ total recruiting budgetagency fee averages 27.8% of the placed role's gross annual salarydependency on paid external sourcing

For scale, the 2025 SHRM benchmarking survey of over 2,300 US HR professionals put average cost-per-hire at $5,475 for nonexecutive roles and $35,879 for executive roles, useful for scale but on a very different cost base.

Agency spend and cost-per-hire get confused constantly. The 27.8% figure prices what an external recruiter charges as a fee against the placed role's gross annual salary. Your blended cost-per-hire also includes internal recruiter time, job-board spend, assessment tools and referral bonuses, so a heavy agency mix pushes the blended number well above the internal-only average. Give that gap its own line so you can actually see it month to month.

Recruiter req-load is the clearest early-warning metric here. German recruiters carry an average of 16 open requisitions and close roughly 47 hires a year, per the 2025 DGFP, Wollmilchsau and HTWK Leipzig benchmark of 736 HR professionals. Once req-load climbs meaningfully past that without extra headcount, time-to-fill and cost-per-hire usually move next, within a quarter.

How Do Offer Acceptance, Retention and Quality of Hire Prove the Funnel Works?

Offer acceptance rate, first-year retention and quality of hire answer the question speed metrics never touch: were the hires any good? A healthy offer acceptance rate sits at 80% or above. Fall below that and something specific is broken, usually compensation or candidate experience, sometimes simply a process that moved too slowly and lost the candidate to another offer.

MetricHow it's trackedDACH healthy bandRead it as
Offer acceptance rateoffers accepted ÷ offers extended80% or higherwhether comp, experience and speed are aligned
First-year retentionhires still employed at month 12 ÷ hires madearound 85% cross-industry, lower in care, hospitality, IT and retailwhether the hire actually worked out
Quality of hirecomposite: retention + manager rating + ramp timeonly 20% of organizations track it at allthe one most teams don't build, then regret
Diversity of shortlistprocess adherence under structured, blind criteriashare of shortlists built that wayfairness of the process itself

Roughly 15% of new hires in Germany leave within their first year, climbing to as much as 30% in high-turnover sectors such as care, hospitality, IT and retail. An earlier warning sign shows up before day one: 36% of German employers report cancellations between contract signing and the actual start date, often because a long notice period gave a competing offer time to land. Put both on the dashboard. Losing a hire in week two costs you nearly as much as never filling the role.

Quality of hire is the metric everyone says they want, yet hardly anyone actually builds it. Only 20% of organizations track it, despite being widely seen as the most strategically important recruiting metric, and 89% of talent-acquisition professionals expect it to matter more, according to SHRM's 2025 benchmarking research. A simple composite of first-year retention, a manager's satisfaction rating at the 90-day mark, and time to full productivity already puts a team ahead of most of the industry.

Diversity of shortlist, tracked honestly: There is no standard DACH quota benchmark for shortlist diversity. German AGG and GDPR rules restrict collecting protected-characteristic data during hiring, so DACH teams track process adherence instead, mainly blind CV screening and structured interview scorecards. Over 4,000 German companies have signed the voluntary Charta der Vielfalt as the same kind of qualitative commitment. Build this into the dashboard as a percentage of shortlists reviewed under structured criteria.

Which Three Metrics Belong in the Monthly CFO Review?

Three metrics belong in front of the CFO every month: cost-per-hire, time-to-fill and first-year retention. The other twelve stay operational, reviewed weekly by the TA team, because a review covering all fifteen numbers loses the room in five minutes.

Each earns its place for a different reason. Cost-per-hire is a budget line the CFO already tracks elsewhere, so tying it to recruiting closes a loop instead of opening a new one. Time-to-fill translates into a delivery-risk story: an open seat costing 70 days to fill means 70 days of unproduced work or a manager quietly covering two roles. First-year retention proves the first two weren't wasted, since a fast, cheap hire who leaves in month four erases whatever the other two claimed to save.

Building the recruiter-hour ROI case: A German recruiter carries roughly 16 open reqs and closes about 47 hires a year. If compiling these fifteen metrics from ATS exports takes even one hour a week, that's close to 50 hours a year, more than a full working week, spent on a report instead of a req. Live ATS analytics that feed the dashboard automatically hand that week straight back as usable req-load capacity. That's roughly the clearest ROI case there is: the reporting runs itself and your recruiters get that week back.

The metrics DACH teams track heavily aren't always the ones leadership values most, per the DGFP, Wollmilchsau and HTWK Leipzig 2025 benchmark. Time-to-hire is used by 74% of organizations but rated genuinely relevant by fewer than half. Cost-of-vacancy is valued by 53% but measured by under 10%. Cost-per-hire is desired by 67% of teams but only used by 47%, exactly the gap a pre-built dashboard closes.

Turning Fifteen Numbers Into One Recruiting Story

The gap between what DACH teams measure and what they actually value is the real finding buried in this data. Teams over-track time-to-hire because it's easy to pull from the ATS, and under-track quality of hire and cost-of-vacancy because both need someone to sit down and build a composite by hand. A dashboard is only worth keeping if it closes that gap and makes the metrics people usually dodge update themselves.

Start smaller than fifteen if that feels like too much on day one. Build the three CFO-facing metrics first, cost-per-hire, time-to-fill and first-year retention, get them updating automatically from your ATS, then layer in the funnel and source metrics once the leadership view is solid. Whether you build it in Excel or Google Sheets, the full template is structured to grow into exactly that order, one working group at a time.

Frequently Asked Questions

What's a realistic cost-per-hire benchmark for a DACH mid-market company?

Roughly €4,500 to €4,700 per hire is the converging estimate across current DACH recruiting-cost sources, though no single audited study confirms one exact figure. US benchmarks like the $5,475 nonexecutive average sit in a different cost base and shouldn't be imported directly. Use the DACH range as a planning guide and watch your own trend over time.

Why is our time-to-hire longer than the benchmarks we found online?

The benchmark you found and your own number are almost certainly measuring different things. DACH studies report figures ranging from around 24 working days, measured from first contact to signature, up to roughly 70 days, measured from application to hire. Germany's official Vakanzzeit figure, around 170 to 180 days, measures something else again, desired start date to delisting, and shouldn't be used as a team KPI at all.

How do you calculate quality of hire without a formal performance-review system?

You don't need one. A simple three-part composite does the job: first-year retention, a hiring manager's satisfaction rating at the 90-day mark, and time to full productivity. Only 20% of organizations track quality of hire at all, so even this rough version puts a team ahead of most of the industry. Add a formal performance score later once one exists.

Can we track diversity of shortlist under German AGG and GDPR rules?

You can, just not the way most people expect. German AGG and GDPR keep you from collecting protected-characteristic data during hiring, so you track the process instead: blind CV screening and structured interview scorecards, tightened by gender-neutral job-ad language. Frame the dashboard metric as a percentage of shortlists built under those structured criteria.

Which hiring KPI should a solo recruiter focus on first?

Req age, the number of days each currently open requisition has sat unfilled. For a single recruiter juggling the DACH average of around 16 open requisitions at once, req age flags which specific role is about to become an emergency before time-to-fill or cost-per-hire even move. It's the fastest early-warning number on the whole dashboard.

Jürgen Ulbrich

CEO & Co-Founder of Sprad

Jürgen Ulbrich has more than a decade of experience in developing and leading high-performing teams and companies. As an expert in employee referral programs as well as feedback and performance processes, Jürgen has helped over 100 organizations optimize their talent acquisition and development strategies.

Free Templates &Downloads

Become part of the community in just 26 seconds and get free access to over 100 resources, templates, and guides.

Free IDP Template Excel with SMART Goals & Skills Assessment | Individual Development Plan
Video
Performance Management
Free IDP Template Excel with SMART Goals & Skills Assessment | Individual Development Plan

The People Powered HR Community is for HR professionals who put people at the center of their HR and recruiting work. Together, let’s turn our shared conviction into a movement that transforms the world of HR.