Recruiting Agency Statistics Report

The Recruiting Agency Statistics report is a new report that enables you to report on agency statistics and cost. This report enables you to track where agency costs are being spent and determine which agencies are the best performers. The information in this report can also help organizations understand and track the cost of recruiting new employees.

To access the Recruiting Agency Statistics report, go to Reports > Standard Reports > Recruitment.

Criteria

Feature Description
Date Criteria
  • Date Criteria - Select the date range for the report from the drop-down list or enter specific dates in the From and To fields.
  • Dates Based On - Select one of the following options on which to base the date range defined in the Date Criteria fields:
    • Requisition Creation - This option returns results based on the date that the requisition was created.
    • Agency Submission - This option returns results based on the date that the recruiting agency submitted the applicant.
Advanced Criteria

You can limit report output to the following:

  • Requisition Owner - Select requisition owners from standard OUs.
  • Division - Use the default value of "All" or select one or more Division OUs.
  • Location - Use the default value of "All" or select one or more Location OUs.
  • Job Title - Use the default value of "All" or select one or more Position OUs. Note: The job title criterion uses the position title defined in the Position OUs, rather than the display job title defined on the requisition.
  • Requisition ID - Enter the requisition ID, which can be found on the Agency Portal - My Jobs page. Only one ID can be used, and the ID must match exactly. Note: Entering a Requisition ID supersedes all other criteria.
  • Recruiting Agency - Click the plus icon to add one or more agencies. Both active and inactive agencies can be selected. If no agency is selected, then all agencies are included in the report.
  • Agency User - Select the user criteria from the drop-down. Then, click the Select icon to select the users from the Select pop-up. The users available to select are users that have been defined as agency users for at least one recruiting agency. If no agency user is selected, then all agency users are included in the report.
  • Applicant Status - Select one of the following options:
    • Only 'Hired' status included in report - Select this option to only include submissions that have a Hired applicant status.
    • All statuses included in report - Select this option to include all submissions regardless of their current status.
  • Minimum days since hire - This option enables you to filter the results of submissions that have a Hired status by the number of days since they achieved a Hired status. Select a number from the drop-down, between 0 and 365. This is a required field.

Multiple values can be selected for each criterion except Requisition ID. The report only runs within the defined constraints for the user running the report. If the user's permission to run the report is not constrained, at least one criterion must be selected. If the user's permission to run the report has at least one constraint and no criterion is selected, the report is run for all available advanced criteria.

Display Options

Select one of the following options to determine how the report displays:

  • Summary - Select this option to display the report in the summary output view.
  • Details - Select this option to display the report in the detail output view. If selected, the following additional options are available:
    • Submission Full Name - This column displays the full name of the applicant.
    • Application Date - This column displays the date that the applicant completed the application. Note: This is not the date that the applicant was submitted by the recruiting agency.
    • Applicant Status - This column displays the current status of the applicant at the time the report is processed.
    • Hire Date - This column displays the date that the applicant's status changed to Hired.
    • Days Since Hire - This column displays the number of days that have passed since the applicant's status last changed to Hired.
    • Accepted as Applicant Date - This column displays the date that the applicant was moved from the New Submissions page to the Manage Applicants page. In other words, this is the candidate date, which is the date on which the submission received an active applicant status.
    • Interviewed Date - This column displays the date of the earliest scheduled interview for the applicant. If the applicant does not have any interview sessions scheduled, then the column is blank. If the applicant does not have a scheduled interview with a date, then the column is blank in the report output. Interview credit is defined as the first time that the applicant is moved into the Scheduled Interview applicant status that is defined as the status type Interview.
    • Agency Cost - This column displays the cost associated with each submission.

Report Title Enter a title for the report. If a title is not entered, the report title defaults to the report name. The title appears on both the report output and in the Processed Reports list.

When the Process Report link is clicked, the report is run based on the selected criteria. The report output is stored in the Processed Reports table.

The administrator can choose the following actions and options for each report in the Processed Report table:

  • Click the Excel icon to generate an Excel output of the report.
  • Click the Refresh icon to refresh the report results.
  • Click the View Details to view the filter criteria for the report.
  • Click the Delete icon to delete the report.

Output - Summary

The summary view of the report is an Excel table with a bar graph included.

Graph

  • X Axis - This axis displays the name of the recruiting agency.
  • Y Axis - This axis displays percentages, from 0 to 100 in 10 percent increments.
  • Bar 1 - This bar displays the percent of accepted applicants. The percentage is calculated by dividing the total number of accepted applicants for the agency by the total number of submissions to the agency. Note: An "accepted" applicant is an applicant that has a candidate date.
  • Bar 2 - This bar displays the percent of applicants interviewed. The percentage is calculated by dividing the total number of applicants interviewed for the agency by the total number of submissions to the agency. The value for total number of applicants interviewed is dependent upon completion of the Interview status. Applicants achieve completion the first time that the applicant is moved into the Scheduled Interview applicant status that is defined as the status type Interview.
  • Bar 3 - This bar displays the percent of applicants hired. The percentage is calculated by dividing the total number of applicants hired for the agency by the total number of submissions to the agency.

Table

Each recruiting agency displays in a separate table. Agencies appear in the report in alphabetical order. All submissions within an agency are grouped by agency user. The following columns display:

  • Agency User Full Name - This column displays the name of the agency user.
  • # of Submissions - This column displays the total number of submissions per agency user.
  • # of Accepted Applicants - This column displays the total number of accepted applicants per agency user.
  • # of Interviewed Applicants - This column displays the total number of applicants interviewed per agency user. The value for total number of applicants interviewed is dependent upon completion of the Interview status. Applicants achieve completion the first time that the applicant is moved into the Scheduled Interview applicant status that is defined as the status type Interview.
  • # Hired - This column displays the total number of applicants hired per agency user.
  • Submission to Hired Rate - This column displays the hired ratio. The ratio is calculated per agency user by dividing the total number of applicants hired by the total number of applicants submitted.
  • Agency Cost - This column displays the total agency cost per agency user.
  • Total - This row displays the totals for each column.
  • Grand Total - This row displays the totals for all of the agencies included in the report.

Note: The information that displays in the report is the information that meets the report criteria.

Report Criteria

The Report Criteria section displays the criteria values configured for the report.

Output - Details

The details view of the report is an Excel table that displays the columns selected in the Display Options section when configuring the report. If Agency Cost is selected in the Display Options section, then the following associated columns appear:

  • Agency Cost Total - This column displays the total agency cost for the submission.
  • Agency Cost for Submission - This column displays the agency cost of each submission.
  • Agency Cost for Interview - This column displays the agency cost per interview.
  • Agency Cost for Salary Flat Rate - This column displays the agency cost per salary hire flat rate.
  • Agency Cost for Salary Percentage - This column displays the agency cost per salary percentage.
  • Agency Cost for Hourly Flat Rate - This column displays the agency cost per hourly flat rate.
  • Agency Cost for Hourly Percentage - This column displays the agency cost per hourly percentage.