Recruiting Pipeline Tracker Template

A recruiting pipeline tracker gives you one row per open role instead of one row per candidate. It answers the questions a hiring manager or CEO asks every week: how many roles are open, how many candidates are at each stage, and which roles are about to miss their target date.

Enter the role, the hiring manager, the date the role opened and the target fill date, then update five stage counts once a week: applied, screened, interviewed, offers and hires. The sheet works out the screen rate, interview rate and offer acceptance rate for every role, counts the days each role has been open and flags any open role that has passed its target date.

The Summary tab rolls everything up into the numbers worth reporting: open roles, roles past their target date, total applicants, total hires, applicants per hire, overall offer acceptance and the average number of days roles stay open.

Low screen rates usually point to the job ad or the sourcing channel, low interview-to-offer rates to unclear requirements, and low offer acceptance to pay or process. Looking at the rates per role, rather than one company-wide funnel, shows where to fix first.

The sheet opens in Excel and imports into Google Sheets (File, then Import) with its formulas intact. Pair it with the free applicant tracking spreadsheet when you also need candidate-level detail.