Create Weekly Recruiting Report
Sheet 1
- avg # days candidate is in process before hire
-
- Screen : Hire ratio
- Avg candidate time spent in applicant
- Avg candidate time spent in screened
-
-
- Job w/ least activity
- Job w/ most activity
-
-
- Avg. candidate experience score (NPS)
-
-
-
- Total headcount still open
Sheet 2
I'd like on a second sheet to have a list of all of the open positions and a column next to them with how many days the role has been open. Any role open less than 90 days should be green, 90 - 120 yellow, and 120+ red.
Sheet 3
I'd like a third sheet with the upcoming roles from the hiring forecast with a similar color coding. If the roles need to be opened within 10 days they should be red, within 30 days should be yellow, and over 30 days should be green.