The Vacancy Hire Success (Organization Hierarchy) Trend Analytics workbook provides a trend analysis showing the changes in vacancy success over a selected period of time. You can analyze the:

• Total number of openings recorded for vacancies.

• Total number of openings that have been filled.

This workbook also enables you to view the success of your recruitment activities.

The workbook calculates the total number of vacancy openings and the number of filled vacancies in a particular time period, to produce a vacancy success rate. Vacancy success is defined as the percentage of vacancy openings that are filled.

The workbook only includes vacancies that have a status of Closed and have an End Date within the selected time period.

The workbook only includes assignment that match the criteria selected in the workbook parameters. For example, an assignment must have the same budget measurement value as the worksheet parameter.

Business Questions

How many vacancies have there been in my enterprise over, for example, the last quarter?

How many of these vacancies have been filled? How does this compare with the previous quarter?

Parameters

Before running the worksheets you must enter a value for the following parameters:

• Start Date

• End Date

• Organization Hierarchy

• Top Organization

• Rollup Organizations - Yes/No

• Workforce Measurement Type

Use the following parameters to further restrict the values in the workbook:

• Area (Geography)

• Country (Geography)

• Region (Geography)

• Location (Geography)

• Job Category

• Job Name

• Grade Name

• Position Name

Worksheets

This workbook has the following worksheets:

• By Year

• By Semi Year

• By Quarter

• By Bi Month

• By Month

The worksheets display one row for each time period. For example, the by Month worksheet displays one row per month.

Headings and Calculations

All worksheets contain the following columns:

• Start Date

  The start date of the time period.

• End Date

  The end date of the time period.

• A time period column

  The heading depends on the selected worksheet, for example, in the by Year worksheet, this column is named "Year".

• Openings

  The number of openings within the time period.

• Employee Starts

  The number of employee starts within the time period. The worksheets calculate the Employee Starts total by totaling the employee assignments created to fill the vacancies

• Success Rate Percent

  Displays the total workforce starts as a percentage of total workforce openings.

The worksheets count employee assignments using Workforce, enabling you to define the employee value of each assignment. See: Workforce Calculation