Everything you need to know about the new Acendre Analytics module and the redesigned data warehouse (DWH).
| Table of Contents |
|---|
What is Acendre Analytics?
It’s a new Analytics module for Recruit. Completely fresh. We have:
1. Redesigned the database holding Recruit data - the new Data Warehouse (DWH). New structure, better performance, faster refreshes. | 2. Simplified the way reports are built. Simpler views, better fields and descriptions, new report templates and instructions. |
| Info | ||||
|---|---|---|---|---|
More information
|
A Single, Simplified Custom View
In the old Analytics Classic you had to choose from three main views for your reporting needs, and even more for specific requirements like job or application status history.
Imagine if you could combine all of those needs into a single view?
Say hello to your simplified custom view: View 1.0 Jobs, Application and Assessment.
It combines:
requisition/job, job process and job status history data
application, assessment process and assessment history data
all of your reportable job, application and global assessment custom global questions
key system and placeholder metrics
additional fields like specific date formats, scheduler activity data, and various permissions.
Folders and fields are grouped by importance, from top level context down to the detail.
You’ll also get two other custom views out of the box (for candidate and user data), and users with Corporate Report Writer access can also use advanced system views with additional system data.
See Simplified Custom Views for more information.
New Custom View Fields
| title | New Custom View 1.0 |
|---|
Field Category
Field Name
Description
Job Details
Current Job or Requisition
Indicates whether a job is a Currently Requisition or has progressed to a Current Job at job creation, advertising, assessment, onboarding or archived stages.
Job Template Name
The name of the job template used for each job. Will be blank if job was not created from a job template, or a requisition not yet attached to a job template.
Requisition Process Name
The name of the requisition process used for each job. Will be blank if job was not created from a requisition. Note - use of this field does not limit Process Step fields to requisition steps only (use Process Type).
Assessment Process Name
The name of the assessment process used for each job. Will be blank if requisition or job is not attached to an assessment process. Note - use of this field does not limit Process Step fields to assessment steps only (use Process Type).
Process Step Is Current
Indicates if a process step is the current workflow step (Yes) or not (No). Use this field as a filter to limit Process Step fields to just the current step.
Process Step Last Edited
The latest date that a step decision was made, as in make successful or unsuccessful. Does not include accessing steps and updating forms without making a step decision.
Process Step Permission Type
Indicates if step permission is assigned to All users with access to job, specific users, user groups and/or job roles. Will return separate rows for each type of permission. Will be blank for permission type 'All users with access to this job' and for users that have been deleted.
Process Step Permissioned To
Indicates the User Full Name (Last, First format), Group name, or User and Role (Last, First (Role)) format for User, User Group or Role permission types respectively. May include multiple values if multiple permission types, users and/or user groups were assigned to a step. Will be blank for permission type 'All users with access to this job' and for users that have been deleted.
Process Step Task - Date Last Accessed
The date any user last accessed a task for a given step. Single date per task across all users (not an individual date for each user).
Process Step Task - Full Name
The full name (Last, First) for any user that accessed a task for a given step.
Application Details
Application Note - Reinstatement Requested
The reason given when a candidate requests to reinstate their withdrawn application.
Application Note - Withdrawn Application
The reason given when a candidate withdraws their application.
Application Reinstatement Requested
Indicates if a withdrawn candidate has requested a reinstatement of their withdrawn application.
Assessment Details
Assessment Step - Is Current
Indicates if an assessment step is the current assessment step (Yes) or not (No). Use this field as a filter to limit Assessment Step fields to the candidate's current step.
Reference Request Status
The reference check status for an application, for when the online reference module is used.
New System View Fields
| title | SYS 1.x Series (Jobs,Apps and Assessment) |
|---|
Field Category
Field Name
Description
SYS 1.1 Jobs and Apps
Jobs and Requisitions
Job Edited Date
The date that the last edits or changes were made against a job, including job details, configuration or job status update. In dd/MM/yyyy (01/01/2000) format by default. Single value per job.
Job Status Type
The job status type for the current status of each job. Single value per job.
Job Status Display Order
The order in which job statuses are displayed, for the current status of each job.
Job Status Is For Requisitions
Indicates if a job's current job status is used for requisitions only, and thus indicates if a job is a currently a requisition.
Job Template Name
The name of the job template used to create each job. Will be blank if job was not created from a job template, or a requisition not yet attached to a job template.
Job Roles
Role Description
The description for a role against a job.
Role Is Mandatory
Indicates if the role is mandatory.
Role Order Index
The order that job roles appear in.
Applications
Application Count - Late Application Given
Number of applications that have a late application expiry date. Includes those that may have then been submitted.
Application Count - Late Application Outstanding
Number of applications that have a late application expiry date and have not been submitted (application status is incomplete).
Application Count - Reinstatement Requested
Number of applications where reinstatement has been requested after being withdrawn, including those that have since been reinstated.
Application Count - Reinstatement Request Outstanding
Number of applications where reinstatement has been requested but not actioned after being withdrawn (application status is reinstatement requested).
Application Reinstatement Requested
Indicates if a withdrawn candidate has requested a reinstatement of their withdrawn application.
Current Application Process Step Name
The step name for a candidate's current application step.
Current Application Process Step Number
The step number for a candidate's current application step.
Current Application Process Step Status
The step status for a candidate's current application step.
Online Testing Status
The testing status for a candidate's online assessment.
Reference Request Status
The status for each reference request through the reference module.
Late Application Expiry Date Time
The date and time that a late application expires for a candidate. In dd/MM/yyyy hh:mm AM (01/01/2000 12:00 AM) format by default.
Application Sourcing
Entered Audience Date Time
The date and time a candidate logged into an application source. Usually the same as the application started date (in timestamp format).
Flags
Application Count - Application Flag
Number of distinct applications with an Application Flag.
Candidate Count - Global Flag
Number of distinct candidates with a Global Flag.
Notes
Application Count - All Notes
Number of distinct applications with a Note against them.
Application Count - Reinstatement Requests
Number of distinct applications with a Reason for Reinstatement Request Note.
Application Count - Withdrawn Notes
Number of distinct applications with a Reason for Withdrawn Application Note.
Reinstatement Requested Note
The reason given when a candidate requests to reinstate their withdrawn application.
Withdrawn Application Note
The reason given when a candidate requests to reinstate their withdrawn application.
SYS 1.2 Job Process
Jobs and Requisitions
Job Status Is For Requisitions
Indicates if a job's current job status is used for requisitions only, and thus indicates if a job is a currently a requisition.
Job Status Type
The job status type for the current status of each job. Single value per job.
Job Edited Date
The date that the last edits or changes were made against a job, including job details, configuration or job status update. In dd/MM/yyyy (01/01/2000) format by default. Single value per job.
Process
System Event
The type of system event that forms a part of the process.
System Event Date
The date the corresponding System Event took place.
Workflow Status
Gives Job Open or Pending Open Date if the job is open (Job Status = Job Open or current date is between open and close dates) or pending open (Job Status = Pending Open Date), otherwise returns the process type for the current process step.
Days Open
Days from Job Open to Job Close (or current date if no close date). DATEDIFF(d, "JobsAndReqsList"."JobAdvertisingOpenDateTime", CASE WHEN "JobsAndReqsList"."JobAdvertisingCloseDateTime" IS NOT NULL THEN "JobsAndReqsList"."JobAdvertisingCloseDateTime" ELSE GETDATE() END)
Process Steps
Process Step Last Edited
The date a process step was last updated. In dd/MM/yyyy (01/01/2000) format by default.
Process Step Permissions
Step Permission Type
Indicates if step permission is assigned to All users with access to job, specific users, user groups and/or job roles. Will return separate rows for each type of permission. Will be blank for permission type 'All users with access to this job' and for users that have been deleted.
Step Permission ALL - Assigned To
Indicates the User Full Name (Last, First format), Group name, or User and Role (Last, First (Role)) format for User, User Group or Role permission types respectively. May include multiple values if multiple permission types, users and/or user groups were assigned to a step. Will be blank for permission type 'All users with access to this job' and for users that have been deleted.
Process Step Statuses
Step Status - History
The step status for a corresponding process step at a point in time. Includes current and previous step statuses for the current and previous steps. In the job context for Requisition, Job Creation and Approval process types only.
Step Status - Date Updated
The date and time that a step moved to the corresponding step status. In dd/MM/yyyy h:mm a (01/01/2000 12:00 am) format by default.
Step Status - Is Current for Step
Indicates if a step status is the current status for the associated step. Includes current and former steps.
Step Status - Step Sequence Number
The sequential order step statuses were applied to a given step, within that step only.
Step Status - Max Step Sequence Number
The maximum sequence number for step statuses applied to a given step, within that step only.
Step Status - Is Current Overall
Indicates if a step status is the current status for the current step.
Step Status - Overall Sequence Number
The sequential order step statuses were applied to a job for its entire workflow, across processes and steps.
Step Status - Max Overall Sequence Number
The maximum sequence number for step statuses applied to a job for its entire workflow, across processes and steps.
SYS 1.3 Assessment
Jobs and Requisitions
Job Status Type
The job status type for the current status of each job. Single value per job.
Assessment Details
Assessment Process Name
The name given to an assessment process. Single value per job.
Assessment Step - Is Current
Indicates if an assessment step is a candidate's current assessment step.
Assessment Step - Duration (Days)
The number of whole days (rounded down) between a candidate arriving and exiting an assessment step, or from arriving and when their application was last assessed at that step.
Assessment Step Statuses
Step Status - History
The step status for a corresponding assessment step at a point in time. Includes current and previous step statuses for the current and previous steps. In the application context for Assessment process types only.
Step Status - Date Updated
The date and time that an application moved to the corresponding step status within the associated assessment step. In dd/MM/yyyy h:mm a (01/01/2000 12:00 am) format by default.
Step Status - Is Current for Step
Indicates if a step status is the current status for an application in the associated assessment step. Includes current and former steps.
Step Status - Step Sequence Number
The sequential order step statuses were applied to an application in a given assessment step, within that step only.
Step Status - Max Step Sequence Number
The maximum sequence number for step statuses applied to an application in a given assessment step, within that step only.
Step Status - Is Current Overall
Indicates if a step status is the current status for an application at its current assessment step.
Step Status - Overall Sequence Number
The sequential order step statuses were applied to an application across the entire assessment process.
Step Status - Max Overall Sequence Number
The maximum sequence number for step statuses applied to an application across the entire assessment process.
Step Status Updated By - Candidate or User
Indicates if the step status resulted from the action of a candidate or user. Original format IsAdminUser is true/Yes = User, false/No = Candidate.
Online Assessment
Online Testing Status
The testing status for a candidate's online assessment.
Online Test Name
The name of the online test.
Online Test Provider
The name of the online test provider.
Online Test Process Name
The assessment process using this online test.
Online Test Process Step Name
The assessment process step name using this online test.
Online Test Process StepID
The unique identifier for the process step used for this online test.
SYS 1.4 Job Status History
Job Status History
Is Current Job Status
Indicates if a job status is the current job status.
Job Status - Days At Status
The number of whole days since the current Job Status was applied, or between Job Status - Date Updated and Next Job Status - Date Changed To, for previous Job Status - History values. Rounded down. CASE WHEN Is Current Job Status = 'Yes' THEN Job Status - Days Since Changed To ELSE Job Status - Days At Previous Status END
Job Status - Days At Current Status
The number of whole days since the current Job Status (current iteration) was applied. Rounded down. CASE WHEN Is Current Job Status = 'Yes' THEN Job Status - Days Since Changed To END
Job Status - Days At Previous Status
The number of whole days between Job Status - Date Updated and Next Job Status - Date Changed To, for the relevant Job Status - History value. Null for the current iteration of the current job status (Is Current Job Status = Yes). Rounded down.
Job Status - Days Since Changed To
The number of whole days between Job Status - Date Updated and at the time of running the report. Rounded down.
Job Status - Total Days At Status
The TOTAL number days a job has spent at a selected Job Status - History value(s). Includes number of whole days since the current Job Status was applied, or between Job Status - Date Updated and Next Job Status - Date Updated for previous Job Status - History values, all summed together. Will be segmented to the granularity of other job status history data in the report. SUM ( CASE WHEN Is Current Job Status = 'Yes' THEN Job Status - Days Since Changed To ELSE Job Status - Days At Previous Status END )
Job Status - Total Days At Previous Status
The TOTAL number of days a job has spent at a selected Job Status - History value(s). Excludes the current iteration of the current job status. Rounded down. Will be segmented to the granularity of other job status history data in the report.
Job Status - Total Days On Hold
The TOTAL number days a job has spent On Hold (Job Status - History contains 'On Hold'). Will be segmented to the granularity of other job status history data in the report. SUM ( CASE WHEN Is Current Job Status = 'Yes' AND Job Status - History LIKE '%On Hold%' THEN Job Status - Days Since Changed To WHEN Is Current Job Status = 'No' AND Job Status - History LIKE '%On Hold%' THEN Job Status - Days At Previous Status END )
Next Job Status - History
The job status that followed the corresponding Job Status - History value, based on Job Status - Sequence Number. Single value per Job Status - History.
Next Job Status - Date Updated
The date that a job was given the next job status after the corresponding Job Status - History value, based on Job Status - Sequence Number. In dd/MM/yyyy (01/01/2000) format by default.
Next Job Status - Sequence Number
The next job status sequence number for the corresponding Job Status - History value, based on Job Status - Sequence Number.
SYS 1.5 App Status History
Application Status History
Is Current Application Status
Indicates if an application status is the current application status for an application.
Application Status - Date Changed To
The date that an application was given the corresponding application status. In dd/MM/yyyy (01/01/2000) format by default.
Application Status - Days At Status
The number of whole days between Application Status - Date Changed To and Next Application Status - Date Changed To. Null for the current iteration of the current application status (Is Current Application Status = Yes). Rounded down.
Application Status - Days At Current Status
The number of whole days since the current Application Status (current iteration) was applied. Rounded down. CASE WHEN Is Current Application Status = 'Yes' THEN Application Status - Days Since Changed To END
Application Status - Days At Previous Status
The number of whole days between Application Status - Date Updated and Next Application Status - Date Changed To, for the relevant Application Status - History value. Null for the current iteration of the current application status (Is Current Application Status = Yes). CASE WHEN Is Current Application Status = 'No' THEN Application Status - Days At Status END
Application Status - Days Since Changed To
The number of whole days between Application Status - Date Changed To and at the time of running the report. Rounded down.
Application Status - Total Days At Status
The TOTAL number days an application has spent at a selected Application Status - History value(s). Includes number of whole days since the current Application Status was applied, or between Application Status - Date Updated and Next Application Status - Date Updated for previous Application Status - History values, all summed together. Will be segmented to the granularity of other application status history data in the report. SUM ( CASE WHEN Is Current Application Status = 'Yes' THEN Application Status - Days Since Changed To ELSE Application Status - Days At Previous Status END )
Application Status - Total Days At Previous Status
The TOTAL number of days an application has spent at a selected Application Status - History value(s). Excludes the current iteration of the current application status. Rounded down. Will be segmented to the granularity of other job status history data in the report.
Next Application Status - History
The application status that followed the corresponding Application Status - History value, based on Application Status - Sequence Number. Single value per Application Status - History.
Next Application Status - Date Changed To
The date that an application was given the next application status after the corresponding Application Status - History value, based on Application Status - Sequence Number. In dd/MM/yyyy (01/01/2000) format by default.
Next Application Status - Sequence Number
The next application status sequence number for the corresponding Application Status - History value, based on Application Status - Sequence Number.
SYS 1.6 Candidate Status Log
Candidate Status Log
Change Type Description
A description of the change made. Generated via the following formula and fields. EventTypeName + ' | ' + CASE WHEN EventTypeName = 'Application Edited' THEN AdditionalInformation ELSE EventResultName END
Change
The details of the change made. Combines a range of fields depending on the event type name and result.
Candidate Status Log Components
User Responsible - Candidate or User
Indicates if the user responsible for the status log was the candidate or a system user. Original format IsAdminUser is true/Yes = User, false/No = Candidate.
User Responsible - First Name
The First Name of the candidate or user responsible for the status log.
User Responsible - Last Name
The Last Name of the candidate or user responsible for the status log.
Custom, EXEC and System Templates
Now you won’t have to start from scratch every time you want to build a report.
Custom Templates | Custom templates are available out of the box and built on your custom view 1.0. Some even come with built in chart ideas and drill-throughs to other templates setup. See Custom Templates for more information. |
|---|---|
EXEC Templates | EXEC and EXEC+ templates are advanced custom templates that give you executive-level reporting on key metrics and data. These will need customisation to your organisation’s requirements, processes and definitions but will save you a significant amount of time in designing and configuring your own. They replace the previous PACE templates. These templates will need to be copied or imported into your system based on your requirements. Once you have access to Acendre Analytics, speak to your Client Success Manager about a demo and further details. See EXEC Templates for more information. |
System Templates | System templates, using the new system views, are available to users with Corporate Report Writer access. They are primarily designed for you to get insights into your system data. You can use the templates as they are on the System Templates dashboard and drill through to more detail, including a comprehensive Job and Apps template suite covering a wide range of relevant data, and a new suite of Scheduler reports. See something you like but need to customise it, or want to explore how that formatting, chart or drill through is configured? Go for it. Make a copy and make it your own. See System Templates and Tools for more information. |
How Do I Get It?
Speak to your Client Success Manager about setting up the Acendre Analytics module for your organisation. You have a choice of two approaches:
Acendre Analytics only | I don’t have any existing reports/I don’t need to keep existing reports and want to start afresh. Great. We can turn on the new analytics and turn off the old analytics ('Analytics Classic'). You’ll access it from the same tab in your system. |
|---|---|
Both Analytics Classic and Acendre Analytics | I have existing reports (and broadcasts) that I need to set up again. Also great. We can turn on the new analytics on a new ‘Acendre Analytics’ tab and you can access that and the Analytics Classic that you already have. This ‘dual-tab’ approach will give you time to update your reports, broadcasts and any other content in the new Acendre Analytics whilst referencing content in Analytics Classic. Note that there will be an end date to this dual-tab approach. |
We’ll need some info from you to get started, particularly which user group (or users) need the initial access to Acendre Analytics so that you can start setting up your reports.
We may need to clarify details at a later stage, such as definitions for your placeholder fields, or confirming which custom GQs you’d like added to your custom views.
Adding Your Custom Global Questions
You will have access to a new tab when you manage a global question - Acendre Analytics Report Options. This is where you will enable global questions for reporting in the new analytics. On setup, any questions enabled for reporting in Analytics Classic (under ‘Report Options’) will be automatically enabled for Acendre Analytics in the same context(s).
In a perfect world, the process for adding questions to your view(s) would be automated when you save these settings. Unfortunately, you will still need to contact support to request that they add the now-enabled questions to your custom view(s).
The good news is that:
the questions will become available to add to your view with the next refresh - as in, within a few minutes rather than having to wait overnight
you will only have to have them added to one custom view
you can now enable group questions for reporting in the same process as other question types.
FAQs
How do the 5 minute refreshes work? The data refresh only includes changes made to your data, rather than overwriting all of your data each refresh.
Is it really every 5 minutes? It depends on how much data you have. If you don’t have much, it will likely be 5 or close to 5 minutes. If you have a lot, it might take a little bit longer sometimes, depending on how many changes have occurred.
Can I migrate my old reports and other configuration? Unfortunately not, as the database that drives them has been completely redesigned. Take the opportunity to assess your reports and update the reports you need using the simplified views and updated fields.
What happens to my old reports and other configuration? If you choose the option to access both the old and new analytics, you will still have read-only access to your reports. At some stage you’ll need to rebuild those you need to keep and set up any broadcasts so that we can turn off the old broadcasts and, ultimately, the Analytics Classic module itself.
Are all my global questions reportable now? No, you still need to specify which global questions you want to report on and in which context. Those that were already reportable will be enabled for reporting in the new analytics (excluding group and other special custom questions).
Do my global questions get added to my views automatically now? Unfortunately not, as this cannot (yet) be automated, though we did seriously look at it. The good news is that they will only have to be added to one view, and will be available for Acendre Support to do their thing in a much shorter space of time.