Template · Recruiting and hiring

Recruitment metrics report template

By TapTalent Editorial TeamUpdated

In short

A recruitment report template gives talent acquisition a consistent monthly view of hiring: requisition volume, time to fill, funnel conversion, offer acceptance, early retention, cost and source of hire, each compared with target and last period. This template includes the report structure, metric definitions, a worked funnel example and advice on what leaders actually read.

Monthly Recruitment Metrics Report template

Monthly Recruitment Metrics Report

Complete by the fifth working day of each month. Report each metric for the month, the prior month and year to date, with the target. Use the definitions in the last block so numbers are comparable over time and across sites.

Report details

Reporting period
Business unit / region / site
Prepared by
Date prepared
Data sources (ATS, HRIS, payroll, survey tool) and extract date

Headline summary

Three things leaders need to know this month
Overall status
On trackAt riskOff track
Decisions or support needed from leadership

Volume

Open requisitions at start of period
New requisitions opened
Requisitions filled
Requisitions cancelled or on hold
Open requisitions at end of period
Hires (starts) versus plan
Open requisitions older than 60 days
Open requisitions per recruiter

Speed

Median time to fill (requisition approved to offer accepted), days
Median time to hire (application to offer accepted), days
Median time to start (offer accepted to first day), days
Median days from application to first contact
Median days from final interview to offer

Funnel conversion

Applicants
Applicants who passed screening (%)
Screened candidates who interviewed (%)
Interview show rate (%)
Interviewed candidates who received an offer (%)
Offer acceptance rate (%)
Accepted offers who started (%)
Applicants per hire
Biggest drop-off stage and likely cause

Quality

New hires still employed at 30 days (%)
New hires still employed at 90 days (%)
Training or nesting completion rate (%)
Hiring manager satisfaction score
Quality of hire indicator (e.g. 90-day performance rating or ramp to target)

Cost

Total recruiting spend in period
Cost per hire (internal + external ÷ hires)
Advertising cost per applicant
Agency spend and number of agency hires
Spend versus budget (%)

Source of hire

Hires by source (job boards, careers site, referrals, agency, internal, events, sourcing, rehires)
Source with the best applicant-to-hire conversion
Source with the best 90-day retention
Source to cut or increase next period

Candidate experience and diversity

Candidate satisfaction or Net Promoter Score
Application completion rate (%)
Candidates who withdrew, with top reasons
Aggregate applicant and hire demographics from voluntary self-identification (no individual data)
Stages with a selection rate gap to review

Actions

Actions agreed last month and status
New actions, owners and due dates
Forecast for next month (hires, open requisitions, risks)

Metric definitions used in this report

  • Time to fill: calendar days from requisition approval to offer acceptance.
  • Time to hire: calendar days from the candidate's application to offer acceptance.
  • Time to start: calendar days from offer acceptance to first day of work.
  • Offer acceptance rate: offers accepted ÷ offers extended in the period.
  • Cost per hire: (internal recruiting costs + external recruiting costs) ÷ hires in the period.
  • 90-day retention: hires from the cohort that started 90+ days ago who are still employed ÷ total hires in that cohort.
  • Source of hire: the source recorded on the hired candidate's application, using one agreed list of source values.

How to use this template

  1. Agree the metric definitions with HR, finance and operations before the first report, and do not change them mid-year without noting it.
  2. Extract data from your ATS and HRIS on the same date each month so periods are comparable.
  3. Fill in each block with the month, prior month, year to date and target.
  4. Write the headline summary last, in three sentences a busy executive can read in 30 seconds.
  5. Identify the biggest funnel drop-off and propose one action with an owner and date.
  6. Review the report with TA leadership before it goes out, then circulate it with the actions log.

What a monthly hiring metrics report is for

A recruitment report exists to drive decisions: add a recruiter, cut a job board, fix a slow hiring manager, raise a pay rate. If a metric does not change what anyone does, leave it out. Most leadership teams read the first half page and nothing else, so the structure puts the summary and decisions first and the detail after.

The report is built on data that recruiters record day to day. If your recruitment tracker template or ATS has missing dates and blank source fields, the report will be wrong no matter how good it looks. Fix data entry before you build dashboards.

Pick 10 to 15 metrics, not 40

A good report covers five questions: are we hiring enough people (volume against plan), fast enough (time to fill and time to start), efficiently (funnel conversion and cost), the right people (early retention and hiring manager satisfaction), and fairly (candidate experience and aggregate selection rates). The template has one block per question.

Use medians for time metrics, not averages. One executive search that took 190 days will drag an average time to fill for 60 hourly hires from 18 days to 21, and leaders will chase a problem that does not exist. Define every metric once and print the definitions in the report. The difference between time to fill and time to hire causes more argument in review meetings than any actual hiring problem.

Reading the funnel: a worked example

A contact center hiring for customer service agents had 1,800 applicants in October and 64 starts against a plan of 80. The funnel looked like this:

  • 1,800 applicants, 55% passed the screening questions: 990.
  • 990 screened, 40% booked an interview: 396.
  • 396 booked, 62% showed up: 245.
  • 245 interviewed, 38% received an offer: 93.
  • 93 offers, 86% accepted: 80.
  • 80 accepted, 80% started: 64.

The weak spots are the booking rate and the show rate. Six in ten screened candidates never booked an interview, and nearly four in ten who booked did not appear. That points to slow follow-up and a manual scheduling process, not a shortage of applicants. Buying more advertising would have made October more expensive without fixing it. The six stages of the recruitment funnel are explained in more detail in our guide.

Quality and source: the metrics that change budgets

Speed and volume are easy to measure, but leaders care most about whether hires stay and perform. For hourly roles, 30- and 90-day retention by source and by recruiter is the most practical quality of hire signal. Report it by start cohort, since you cannot know October's 90-day retention until January.

Combine source of hire with retention and cost. A job board that produces many hires who leave in the first month is often more expensive than a referral program with a $500 bonus. That comparison is what moves budget, so make sure the report puts the two numbers side by side.

Adapting the report for high-volume and multi-site hiring

When you hire hundreds of people a month, a monthly report is too slow. Run a weekly one-page version with starts against plan, interview show rate, offer acceptance and requisitions at risk by site, then keep the full monthly report for leadership. Report each site separately before rolling up, because a strong site can hide a failing one.

Interactive custom dashboards let site leaders filter their own numbers instead of waiting for a spreadsheet. Keep the monthly narrative anyway; a dashboard shows what happened but someone still has to say why and what to do next.

Common mistakes

  • Reporting activity (calls made, profiles viewed) instead of outcomes.
  • No target next to each number, so nobody knows if 24 days is good or bad.
  • Changing definitions between months, which makes trends meaningless.
  • Reporting diversity data at a level where individuals can be identified. Keep self-identification data aggregated and separate from hiring decisions.
  • Listing problems with no owner or date for the fix.

Frequently asked questions

What should be included in a recruitment report?

Volume against plan, time to fill and time to start, funnel conversion by stage, offer acceptance, early retention, hiring manager satisfaction, cost per hire, source of hire, candidate experience and aggregate diversity data, plus a short summary and actions.

What are the most important recruiting KPIs?

For most teams: hires against plan, time to fill, offer acceptance rate, 90-day retention of new hires, cost per hire and source of hire. High-volume teams should add interview show rate and offer-to-start rate.

How often should a hiring metrics report be produced?

Monthly for leadership, with quarterly trend reviews. Teams hiring hundreds of people a month usually add a weekly one-page operational version by site.

Can I build a recruitment KPI template in Excel?

Yes. Use one tab for raw ATS exports, one for definitions and calculations, and one for the report page. Lock the formulas and the definitions so numbers stay comparable from month to month.

What is the difference between a recruiting dashboard and a recruitment report?

A dashboard shows live or regularly refreshed numbers that people can filter. A report is a point-in-time document with commentary, explanations and agreed actions. Most teams need both.