Overview
The searches and reports identified in the Common Reports article are the most commonly requested and include the following report. To learn how to run searches and reports in the iCIMS Applicant Tracking (ATS), refer to the Creating a Recruiting Workflow Search article. To learn how to save a report for future use, refer to the Saving Search & Output Templates article.
Candidates by Number of Times Applied to Jobs with the Same Job
Helpful Hint: When creating a search, it is helpful to first come up with a clear idea for your report. Think about which jobs you want to report on (the "Which Talent Pools"), what details you want to know about them (the "What"), and how you want to organize the information (the "How") - and be as specific as possible. The more specific you are with your idea, the easier it will be to break it down into these sections, which will help you choose the right Filters (for "Which Talent Pools"), Columns (for "What") and/or Group-bys and Sort-bys (for "How") for your report. This three section concept is used below to search for candidates by the number of times they applied for jobs with the same title.
Scenario: You would like to view how many jobs with the same job title (Sales Associate) each candidate has applied to.
1. Break your report idea down into the three sections to help determine the best way to create your search:
- Who are you reporting about: Using filters, you can focus your metrics report on candidates who have applied to jobs with a certain title.
- What do you want to know about them: Using columns, you can view how many times the candidates have applied to jobs with a certain title.
- How would you like this information organized: Using sort-bys, you can organize your results by count to see the candidates with the most applications first.
2. To create your search, from the top menu bar, select Search > Recruiting Workflow. The "Who," "What," and "How" directly correlate with the three sections (A, B, and C, respectively) outlined in the below image.
A. Keywords and Filters: Who are you reporting about?
To report on candidates who applied to jobs with a certain title, add Title as a filter.
- Keywords: N/A for this report.
- Filters:
1. Click Add Filter and add Title. The selection path is Job File > Job > Detail Tab > Title.
2. In the text box to the right of the added filter, type in the desired job title – in this case, Sales Associate.
B. Columns: What do you want to know about these candidates?
To see how many times candidates have applied to jobs with the specified title, add a column for Count. To view the name of the candidate who applied and the date they applied to each job, add filters for Person: Full Name and Application Date.
1. Click Add Column and add Count (#). The selection path is Reporting & Advanced Options - General > Count (#).
2. Click Add Column and add Person: Full Name. The selection path is Person File > Person > Contact Tab > Full Name: First Last.
3. Click Add Column and add Application Date. The selection path is Reporting & Advanced Options - General > Application Date.
C. Group Results By and Sort Results By: How would you like this information organized?
To review the total number of times each candidate has applied for a given job, add a group-by for Person: Full Name and Title to group all applications together. Add Count as a sort-by to show candidates with the most applications at the top of the search results.
1. Click Add Group-By and add Person: Full Name. The selection path is Person File > Person > Contact Tab > Full Name: First Last.
2. Click Add Group-By and add Title. The selection path is Job File > Job > Detail Tab > Title.
1. Click Add Sort-By and add Count (#). The selection path is Reporting & Advanced Options - General > Count (#).
2. Select Descending (Z to A) from the order dropdown menu to see the candidates with the most applications at the top of the list.
