It's always useful to know, on average, how many applications are required at each stage of the recruitment process to make a successful hire. For instance, how many applications are needed, how many are shortlisted, the number of phone screenings, number of interviews and then offers.
There's a number of ways this can be achieved using the Advanced Insights BI Report Builder - we've provided some video and step-by-step options below:
Video guides:
Both videos below provide different ways of achieving these reports, with the Time to Hire video providing the quickest solution with steps 3 to 5 (in the Step by Step Guides section below) will further embellish it.
There are a number of ways to get the same answer, so if you prefer more freedom over report content, these solutions would build a report you can go to whenever you wish to run such a query.
Create a Report
Select Application Data Set
Drag Job Status, Job Title and Location to filters
Select Advanced Settings
Set the filters as follows: Job Status: In List; Filter: Closed/Complete Job Title: In List; User Prompt (i.e. don't choose any filters) Location: In List; User Prompt (i.e. don't choose any filters)
Select the small X in the upper right corner to exit
Now back in the data canvas, drag from the left - Job Reference, Job Title, Location, Application Candidate ID Number - and drop in columns:
Select the small triangle on the Candidate ID Number, choose Aggregation, and set it to Count
9A. If you always have one job record for one person hired, then follow this additional step. Otherwise move to 9B:
Click the small triangle on Candidate ID Number and select Totals, and set it to Average.
Go to Design (top menu)
You will now have the average number of applications across all these jobs, to give you the app:hire (n:1) ratio
9B. If not, follow these additional steps:
Select the small triangle on Candidate ID Number and choose Format > Edit. Change the field label to ''Number of Applications''
It's always useful to know, on average, how many applications are required at each stage of the recruitment process to make a successful hire. For instance, how many applications are needed, how many are shortlisted, the number of phone screenings, number of interviews and then offers.
There's a number of ways this can be achieved using the Advanced Insights BI Report Builder - we've provided some video and step-by-step options below:
Video guides:
Both videos below provide different ways of achieving these reports, with the Time to Hire video providing the quickest solution with steps 3 to 5 (in the Step by Step Guides section below) will further embellish it.
Advanced Insights - Time to Hire Reports
Advanced Insights - Recruitment Funnel Reports
Step by Step Guides
There are a number of ways to get the same answer, so if you prefer more freedom over report content, these solutions would build a report you can go to whenever you wish to run such a query.
Job Status: In List; Filter: Closed/Complete
Job Title: In List; User Prompt (i.e. don't choose any filters)
Location: In List; User Prompt (i.e. don't choose any filters)
9A. If you always have one job record for one person hired, then follow this additional step. Otherwise move to 9B:
9B. If not, follow these additional steps:
Candidate Status: In List; Filter: Hired (or Offer Accepted - check which status you prefer)
0 Votes
0 Comments
Login or Sign up to post a comment