Need some help defining your placeholder fields? This page goes into some detail into how to understand, explore and define your key metrics and measures.
The following placeholders are built into your view 1.0 to capture the metrics that you’ll most likely need in your reports. Defining these up front will save you significant time in future report builds and in using the EXEC Templates.
Field Category | Field Type | Field Name | Description | Example Definition |
---|---|---|---|---|
Jobs and Requisitions | NUMERIC | Placeholder - Time to Fill (Days) | Time to Fill (Days) - Placeholder (Job Open to Job Archived).
| Based on Time to Fill Start and End Date definitions. |
DATE | Placeholder - Time to Fill Start Date | Time to Fill Start Date - Placeholder (Job Open Date)
| When Requisition Process Step Name = “Requisition Approved” is started. | |
DATE | Placeholder - Time to Fill End Date | Time to Fill End Date - Placeholder (Job Archive Date)
| When the first candidate arrives at the ‘Offer’ assessment step. | |
Metrics | NUMERIC | Placeholder - Application Count - Diversity and Other Groups | Requires custom definitions and individual fields required for each diversity or other candidate group. | Female candidates: any candidate that answered custom global question APP: Gender = Female (application context) |
NUMERIC | Placeholder - Application Count - Shortlisted | Requires custom definition. Placeholder definition counts all applications that had an application status at any point of Shortlist or reached a step named Shortlist. | When a candidate reaches the ‘Shortlist’ assessment step. | |
NUMERIC | Placeholder - Application Count - Interview | Requires custom definition. Placeholder definition counts all applications that had an application status at any point of Interview or reached a step named Interview. | When a candidate is given the ‘Interview’ application status. | |
NUMERIC | Placeholder - Application Count - Accepted Offer | Requires custom definition. Placeholder definition counts all applications that had an application status at any point of Accept, Accepted Offer or Offer Accepted. | When a candidate has a value for the ‘Date Accepted Offer’ global question. |
Time to Fill (or Hire, or Recruit, or…)
Exploring Your Dates
Why so many options for defining your data? SImply put, because you were able to design your recruitment process in any which way to suit your organisation’s practices and processes, it means that your key dates could be reflected in any number of ways. The View Demo report can help you understand what dates are captured where, and how to find/define them.
VIEW DEMO | Date Type | View Demo Report and Columns |
---|---|---|
Open the View Demo report in your Templates folder.
Drill To - Additional Data Column
| Key System Dates
*I fully acknowledge that created is in the past tense whilst open, close and archive are in the present and it is too late to go back and fix this. I shall forever live with this anomaly. | VIEW DEMO 1.0 Jobs, Applications and Assessment |
Job Details
| Drill To: Job Details | |
Job Status History
| Drill To: Job Status History | |
Process Steps
… for a specified Process Type, Process Name and Step. | Drill To: Process Steps | |
Applications and Applicant Details
…for the first (minimum), last (maximum) or each applicant (for individual time to measures per successful applicant) | Drill To: Applications and Applicant Details | |
Application Status History
…for the first/last/each time a specified Application Status - History is applied to an application | Drill To: Application Status History | |
Assessment Steps
…for the first/last/each candidate for a specifed assessment step - name. | Drill To: Assessment Steps | |
Your Custom Global Questions (GQs) Not shown in this view demo will be any custom date fields captured against the job or each application. | Custom GQs
| Explore your view when creating a report or access your data dictionary |
Diversity and Other Metrics
You will likely need to count how many applications fulfil certain criteria - not just how many were submitted (already built in). but also various diversity splits, or how many are current employees, how many reached each stage of your process, were made an offer, or accepted an offer.
You can always calculated these in each report, but defining these in the view means you have a consistent approach and don’t have to keep recreating your calculations.
Exploring Your Metrics
Applicant Demographics | Applicant Progress or Status |
---|---|
You probably have custom global questions on your application form in the format of:
The aim of each metric is to count how many applications gave certain answers to these questions, eg ‘Female’ or ‘Aboriginal’ or ‘Current Employee’. Determine which questions and answers capture the data you need to measure. | Use the View Demo report outlined above to determine how applicant progress or status is defined in your process. It could be via:
|
Other Fields
If you need other fields or custom filters added to your view, you can define and request these too. See Calculated Fields and Filters for more info.