Recruiting Metrics On A Free Spreadsheet
📖 Bu rehber ToolPazar ekibi tarafından hazırlanmıştır. Tüm araçlarımız ücretsiz ve reklamsızdır.
The 4 metrics that matter
“How do I track recruiting metrics without buying analytics software?” is mostly a vocabulary problem. The 4 metrics that actually drive hiring decisions all fit in a single Google Sheet, can be updated in 10 minutes a week, and tell you more than the dashboards built into paid ATSes.
The spreadsheet template
This guide is the spreadsheet template + the formulas + which numbers matter for a small team. Plus a candidate-database structure that doubles as a CRM, all on free Google Sheets.
Tab 1: Candidates
Recruiting analytics tools surface 30+ metrics. For a 5-to-20-req team only four drive decisions:
Tab 2: Metrics dashboard
That’s it. Cost-per-hire, applicant volume, candidate satisfaction scores — noise unless you’re a 50+ person team.
Candidate database — the free CRM-lite
Build it yourself in Google Sheets in 30 minutes. Two tabs:
Cheap automation
Columns:
Weekly review checklist (10 minutes)
Formulas (assuming the Candidates tab is named “Candidates”):