Sample Report - Recruiting Activity

Bullhorn Reporting comes packaged with sample reports in order to give you a general feel for how reports function and how they are created. These reports are named similarly to existing Bullhorn reports, however the sample reports do not contain the same level of detail. Sample reports should be seen as an example of what is possible with Bullhorn Reporting. You have the ability to add as much detail to these reports as you like.

Recruiting Activity

Bullhorn Support is able to assist you with navigating the sample reports. However, Bullhorn Support is unable to build customizations on the reports for you. You'll need a Business Intelligence specialist who is familiar with writing database queries.

The Recruiting Activity Report allows you to track the recruiting activity for your users during a predefined time period, grouped by department.

When you run the Recruiting Activity Report, you are prompted to select a date range and specify who gets credit using the Group Activities By field:

  • Activity Author: Credit is attributed to the user's primary department that performed the activity (added a client submission).
  • Candidate Owner: Credit is attributed to the user's primary department that owns the candidates record, regardless of who added the activity.



The report then displays information on the following data within your system based on what you selected above, grouped by department:

Data item in report

Definition
Pre-Screens*

Number of Notes added by all users in the department with a note action of Prescreen or Screened.
Submissions

Number of Submissions added by all users in the department.
Client Submissions

Number of Client Submissions (sendouts) added by all users in the department.
Client Interviews

Number of Interviews added by all users in the department.
Job Offers*

Number of Internal Submissions added by all users in the department that are in status of Offer Extended.

The Job Offers column also takes into account placements that were previously in a status of Offer Extended.
Hires*

Number of Placements added by all users in the department.
Starts

Number of Placements added by all users in the department.

The placement's start date will need to be within your defined reporting period. The placement must have been in a status of Approved to count for the total number of starts.
Submissions / Pre-Screens*

Divides the number of Submissions by the number of Pre-Screens for all users in the department.
Client Submissions / Internal Submissions*

Divides the number of Client Submissions by the number of Submissions for all users in the department.
Client Interviews / Client Submissions*

Divides the number of Interviews by the number of Client Submissions for all users in the department.
Job Offers / Client Interviews*

Divides the number of Job Offers by the number of Interviews for all users in the department.
Starts / Job Offer*

Divides the number of Starts by the number of Job Offers for all users in the department.
Hit Rate*

Divides the number of Starts by the number of Client Submissions for all users in the department.

*This information will display in the table below the chart instead of the chart itself.

The report creates a chart to give you a visual representation on how each department is performing. A table is underneath the chart that gives you a little more insight on the exact numbers.

Modifying the Recruiting Activity Report

Bullhorn recommends making a copy of the sample report before editing so you can retain the original report. If you accidentally delete or overwrite the report, Bullhorn can restore the stock sample report for you.

When you modify this report you will see two charts and a table with two of each column (excluding the Pre-Screens column). The chart and table columns that display when the report is ran is dependent on the Group Activities By prompt, therefore there are two of everything in this report.



When modifying this report there are a few general things to in mind:

  • This specific report is drawn from the User Activity Analysis source which means anything you add will need to come from that source.
  • Click on the icon under (Default Legend Title) to modify the charts.

  • Add additional information to both charts or as two columns on the table so your data is counted correctly for both activities as determined by the Group Activities By prompt.

Adding Additional Note Actions

The Pre-Screens column counts notes with actions of "Prescreen" or "Screened". Let's say that your company's note action for a prescreen is "Pre-screen". You will need to add this note action to the report as it will not count in this report by default.

Follow the below steps to add additional note actions to count for the total number of prescreens in this report.

Steps

  1. Double click the Pre-Screens column within the table.
  2. Edit the expression definition to include 'Pre-Screen'.  

      Copy

      Original

      if ([NOTE ADDED].[NOTE].[action] in ('Prescreen','Screened')
      AND
      [NOTE ADDED].[NOTE].[dateAdded] between ?StartDate? and ?EndDate?)
      then
      (1)
      else
      (0)
      Copy

      New Expression

      if ([NOTE ADDED].[NOTE].[action] in ('Prescreen','Screened','Pre-screen')
      AND
      [NOTE ADDED].[NOTE].[dateAdded] between ?StartDate? and ?EndDate?)
      then
      (1)
      else
      (0)
  3. Click Ok to save.