| Table of Contents | ||||
|---|---|---|---|---|
|
You can:
define the placeholder fields in your Acendre Analytics custom view 1.0 Jobs, Applications and Assessment
add the metrics and calculated fields that you are likely to use in multiple reports
add calculated filters and filter groups for filters you repeatedly configure or use
split the answers from a multi-select question to a seperate value per selected answer (per job or application).
Doing these will give you a consistent approach to your reporting and ensure a single source of truth for how these metrics and fields are defined, or make it much easier to report on the data you are after.
You’ll need to provide clear definitions for all placeholder and additional fields, metrics and calculated filters, including:
Time to Fill Start and End Dates
Gender and diversity group counts
Candidates by assessment stage counts
Any other requirements
| Info |
|---|
Complete the Requirements Template available on the Analytics Solutions page. |
Placeholder Fields
The following placeholders are built into your view 1.0 to capture the fields that you’ll most likely need in your reports.
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. |
Additional Metrics and Fields
Other potential metrics and calculated fields may include:
Field Category | Field Type | Example Fields |
|---|---|---|
Other Application Groupsapplication Ggroups | NUMERIC | Internal, External, On Merit List, Verbal Offer, Declined Offer… |
Job Countscounts | NUMERIC | Casual Processes, Internal Processes, Secondments… |
Dates | DATE | Job Approved, Selection Process Approved… |
Combining fields | TEXT (DIMENSION) | Location (Old) and Location (New) |
Addition of time to dates | DATE | Date Merit Pool Expires (Job Open Date + 1 year) |
Calculated Filters
Calculated filters allow you to quickly include/exclude certain results, like excluding test jobs, isolating or excluding your graduate programs, or eliminating any jobs archived more than a year ago.
  | Set Filter | Set filters automatically limit the results of the report - no further selections are required. Suggested uses might be exclude test jobs or any process that isn’t recruitment, or to only show special processes. You will need to provide the logic that identifies each of these (eg Job Type = graduate, Job Name starts with xxTest). |
Option Filter | Option filters allow you to make a choice but with the logic pre-configured. Suggested uses might be to exclude graduate programs OR only show graduate programs; only show internal jobs OR only show external jobs. You will need to provide the logic that differentiates your desired options. | |
Filter Group | Filter groups allow you to combine a group of filters that you commonly use together, including their AND/OR relationships and other settings. It allows you to quickly add the whole filter group to your report without any further configuration BUT it also means you cannot modify any of those filter settings, like the name, whether the values are cached, or how the filters are organised. |
Multi Select Extractions (Beta)
There is a solution in testing that enables us to separate multiselect answers into different rows. This is made possible by isolating each specific answers from within the combined multi-select block - e.g. so that a candidate’s answer of “alpha,bravo,charlie” as it appears against the multi select question can be separate into three rows of “alpha”, “bravo” and “charlie”. This then allows easier searching and filtering of multi-select responses.