Skip to main content

Important system message. Read More

View Alert [ close x ]
Content Starts Here
< Back

Article

Recruiting Workflow Searches: Candidates by Number of Times Applied to Jobs with the Same Title

Release: 16.1

View As PDF

Overview

The searches and reports identified in the Common Searches & Reports article are the most commonly requested, and include this report type. To learn how to run searches and reports in the iCIMS Talent Platform, 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

Scenario: You would like to view how many jobs with the same job title (Scuba Diver II) each candidate has applied to. You will:
  • Search for Recruiting Workflow Profiles where Job : Title is Scuba Diver II
  • Add a column for Count #
  • Add a column for Person : System ID
  • Add a column for Person : Full Name: First Last
  • Add a column for Job : Title
  • Add a Group-by for Person : System ID
  • Add a Group-by for Person : Full Name: First Last
  • Add a Group-by for Job : Title
  • Sort by Count #

An image that displays this kind of search.

Actions:

Menu Path: Go to: Search > Recruiting Workflow
Keywords:
N/A
Filters:
  1. Use the Add Filter button to add Job Title. The selection is Filters > Job File > Job > Detail Tab > Title. Type the desired job title in the text field (e.g. Scuba Diver II)
Output:
  1. Use the Add Column button to add Count #. The selection is Columns > Reporting & Advanced Options - General > Count (#) [If multiple options appear, try the first one listed.]
  2. Use the Add Column button to add Person : System ID. The selection is Columns > Person File > Person > Reporting & Advanced Options - General > System ID.
  3. Use the Add Column button to add Person : Full Name: First Last. The selection is Columns > Person File > Person > Contact Tab > Full Name: First Last.
  4. Use the Add Column button to add Job : System ID. The selection is Columns > Job File > Job > Reporting & Advanced Options - General > System ID.
  5. Use the Add Column button to add Job : Title. The selection is Columns > Job File > Job > Detail Tab > Title.
  6. Clear all default Group-Bys.
  7. Use the Add Group-By button to add Person: System ID. The selection is Group-Bys > Person File > Person > Reporting & Advanced Options - General > System ID.
  8. Use the Add Group-By button to add Person : Full Name: First Last. The selection is Group-Bys > Person File > Person > Contact Tab > Full Name: First Last.
  9. Use the Add Group-By button to add Job : Title. The selection is Group-Bys > Job File > Job > Detail Tab > Title.
  10. Clear all default Sort-Bys.
  11. Use the Add Sort-By button to add Count #. The selection is Sort-Bys > Reporting & Advanced Options - General > Count (#) [If multiple options appear, try the first one listed.]
Tip:
  • To review only individuals who have been associated with this job more than once using this report, export the search after running the search by clicking More (if necessary) then clicking Export. Update the Format option to Export Level 1 Only. In Excel, identify all rows where the count equals 1 and delete them. The remaining individuals all have been associated with two or more jobs of this title.