Running the Source Effectiveness Report

Recruiters and recruiting managers can use the Source Effectiveness report to evaluate the effectiveness of their recruiting sources to determine their return on investment.

You can limit the records returned in this report by setting one or more of the filters in the table below. If you select multiple filters, Bullhorn returns records meeting the criteria of all selected filters. The filters marked with a red asterisk are required: you must enter data there. Filter and column names may vary depending on your company's terminology.

Column	Description
Reporting Period	Time period of when candidates were added.
Date Added From and Date Added To	Date range for when candidates were added.
Filter User Activity By (Me check box)	Limits data to candidates you own.
Candidate Owner	Limits data to candidates owned by selected users.
Submission Owner	Limits data to the selected users as submission owners.
Filter Department Activity By (My Department check box)	Limits data to candidates owned by users in your department(s).
Department of Candidate Owner	Limits data to candidates owned by users in selected departments.
Department of Submission Owner	Limits data to submissions created by users in selected departments.
Source	Limits data to selected sources.
Export Level	Defines what level of detail to display if exporting to Excel. Candidate Summary: Includes counts for candidates, submission, client submission, interview, and placement counts for each source. Placement Detail: Includes candidate, job, and placement information. Candidate Detail: Includes candidate and hiring activity information.
Report Format	Display format of the report: web browser or Excel.

If you view the report as a webpage, after clicking Generate Report a graph displays and the following columns appear:

Column	Description
Source	Name of the source from which candidates were added to the application.
New Candidates	Number of candidates by source, added during the selected date range.
Submissions	Number of candidates by source, added during the selected date range that have at least one submission.
Client Submissions	Number of candidates by source, added during the selected date range that have at least one client submission.
Interviews	Number of candidates by source, added during the selected date range that have at least one interview. Interviews are appointments where the: Appointment type includes the word Interview A job and candidate are referenced Date falls in the selected date range
Placements	Number of candidates by source, added during the selected date range that have at least one placement (approved or not).

If you view the report as an unformatted Excel file with candidate summary information, after clicking Generate Report the following information appears:

Column	Description
Source	Name of the source from which candidates were added to the application.
Submissions	Number of candidates by source, added during the selected date range that have at least one submission.
Client Submissions	Number of candidates by source, added during the selected date range that have at least one client submission.
Interviews	Number of candidates by source, added during the selected date range that have at least one interview. Interviews are appointments where the: Appointment type includes the word Interview. A job and candidate are referenced. Date falls in the selected date range.
Placements	Number of candidates by source, added during the selected date range that have at least one placement (approved or not).

If you view the report as an unformatted Excel file with placement detail information, after clicking Generate Report the following information appears:

Column	Description
ID	Placement's Bullhorn identification number.
Source	Source from which the candidate's record was created.
Referred By	Name of the person who referred the candidate.
3rd Party	Name of the agency that referred the candidate.
First Name	Candidate's first name.
Last Name	Candidate's last name.
Date Added	Date and time when the candidate's record was created in Bullhorn.
Candidate Status	Current status of the candidate.
Company	Company associated with the job.
Job ID	Job's Bullhorn identification number.
Job Title	Job title as listed on the job record.
Employee Type	Employee type as listed on the placement record.
Employment Type	Employment type as listed on the placement record.
Candidate Owner	Name of the user who owns the candidate's record.
Candidate Submitter	Name of the user who submitted the candidate to the job.
Submission Source	Source of the submission.
Salesperson	Name of the user who owns the job record.
Category	Categories listed on the job record.
Specialty	Specialties listed on the job record.
City	City listed on the job record.
State	State listed on the job record.
Country	Country listed on the job record.
Placement Status	Status of the placement.
Date Added	Date the placement was created in Bullhorn.
Start Date	Date the candidate's employment starts at the company.
End Date	Date the candidate's employment ends at the company.
Bill Rate	Bill rate as listed on the placement record.
Pay Rate	Pay rate as listed on the placement record.
Salary	Annual salary as listed on the placement record.
Flat Fee	Amount (in dollars) for what the staffing/recruiting agency charges for the placement. This pulls from the placement record.
Fee %	Percentage of the salary that the staffing/recruiting agency charges for the placement. This pulls from the placement record.

If you view the report as an unformatted Excel file with candidate detail information, after clicking Generate Report the following information appears:

Column	Description
ID	Candidate's Bullhorn identification number.
Source	Source from which the candidate's record was created.
Referred By	Name of the person who referred the candidate.
3rd Party	Name of the agency that referred the candidate.
First Name	Candidate's first name.
Last Name	Candidate's last name.
Date Added	Date and time when the candidate's record was created in Bullhorn.
Owner	Name of the user who owns the candidate's record.
Category	Categories listed on the candidate record.
Title	Job title listed on the candidate record.
Specialty	Specialties listed on the candidate record.
City	City listed on the candidate record.
State	State listed on the candidate record.
Country	Country listed on the candidate record.
Rate Low	Low range of the candidate's pay rate as listed on the candidate record.
Rate High	High range of the candidate's pay rate as listed on the candidate record.
Salary Low	Low range of the candidate's salary as listed on the candidate record.
Salary High	High range of the candidate's salary as listed on the candidate record.
Submissions	Number of times the candidate was internally submitted to a job.
Client Submissions	Number of times the candidate was submitted to a contact.
Interviews	Number of times the candidate was scheduled for an interview with a contact.
Placements	Number of times the candidate was placed in a job.