Are you familiar with terms like People analytics, recruitment KPIs, and recruitment funnel, but unsure of how to apply them in your organization?
Do you wish to reduce recruitment costs and save time, but are unsure of the strategies to achieve that?
Do you want to make informed decisions about your application sourcing channels to improve conversion rates?
Do you desire to easily adopt best practices from one department and implement them company-wide?
If you think that optimized recruitment processes are limited to large companies or require excessive data entry, we present to you our Recruitment Manager Google Sheet Template.
You can visualize the pipeline of open positions, track the progress of applicants through various stages of the interview process, and effortlessly monitor the overall hiring status in a single glance.
The Recruitment Manager Google Sheet Template
If you need to track, in detail the application details of each and every candidate for all your job postings, this template is for you.
This follows a simple five step process to view crucial recruitment KPIs, dashboards and a detailed job report for each job opening.
5 Step process to track recruitment or hiring process
The steps have been designed to keep data entry as minimal as possible, while retaining ability to gain valuable insights about the recruitment process.
With Recruitment Manager Google Sheet Template, you will have access to Hiring efficiency KPIs:
- Number of Candidates Hired
- Average time it takes to fill an opening
- Average days taken to Hire
- Total cost of hiring
- Cost per hire
Days taken for each stage: Know if there is a bottleneck in your process – if one recruiting step is taking a long time and extending your overall time to fill an opening.
Sources’ Contribution: Know which sources contribute the most of your hires in terms of quantity.
Quality of applications is extremely important to monitor.
- Number of Applications Received
- Offer %
- Offer Acceptance %
- Hired % of applications
Recruitment funnel provides you great insights – for example, do a lot of candidates fall out very early in the process indicating the lack of fit of applications to the jobs, or do they fall out in one specific later step may be technical interview indicating that there is a specific skill that is hard to find in the market.
Source Performance: You can identify which application sources bring you better quality of candidates as you can compare the hired % for the sources.
Decline Reasons Analysis: Knowing why you are declining the candidates will help identify what’s missing in the applications. Knowing why candidates decline your offers will help you modify the job or reset expectations accordingly with your company leadership.
Know how many jobs are currently open and how large the active pipeline is.
- Number of Open Positions
- Avg. Days in Market for Open positions
- Number of Pending Applications
- Applications per open Position
Active Pipeline of candidates: Know exactly how many applications are in which stage of recruiting.
Pending Applications by Applied Month: Monitor and close out pending applications and inform candidates accordingly.
Jobs open for a long time: Have instant view of positions that are not filled for a long time.
Analyze the KPIs by Department, Location or Hiring Manager to find the best performing areas. Reach out to them and find the best practices. Document them and try to implement them across the company.
View all the candidates for a job in one view to compare comments/notes and make a decision on hiring.
Our promise to you is that after making a copy of this Recruitment Tracker Dashboard Google Sheet template, within 15 minutes,
You will have a clear and simple streamlined process
You will spend less time in data entry and spend more time with hiring managers and candidates.
You will have instant access to important Recruitment KPIs such as Cost per hire and Time to Fill
You will have amazing insights – How can you reduce the time it takes to hire? Which application sources should I invest more in? Why the candidates are not being selected? Why are offers getting rejected? You can then address those concerns to improve your conversion and reduce cost.
You can identify departments or hiring managers that are doing well in the KPIs. Implement those practices across the entire company, thus improving efficiency and reducing cost.
You can present all this rich insightful information in a simple Recruitment dashboard to your company leadership anytime on demand.
Our templates are backed by 100% satisfaction guarantee. Download now, Simplify your process & Save time.
We have a dedicated support portal with step by step tutorials, FAQs for every template, explaining how to use, visit the support page:
There is a detailed step-by-step guide for the template,
You can also reach us at email@example.com with any questions.