Versions Compared

Old Version 29

changes.mady.by.user Brendan Codrington

Saved on

compared with

New Version Current

changes.mady.by.user Brendan Codrington

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Advanced Simple and advanced templates for executive-level reports, summarising your key data. Requires specialised configuration for your fields and definitions.

Table of Contents
maxLevel2

EXEC+ Suite

The EXEC+ template suite gives you multiple, advanced reports on key recruitment data.

tip
Info

The Simple EXEC and EXEC+ Template suite is available as a demo to users with the Corporate Report Writer role permission, and can be customised by these users once deployed.

EXEC vs EXEC+ Templates

Templates are configured at two levels: EXEC and EXEC+. One is simple and quick, the other is comprehensive and more adaptable.

EXEC

EXEC+

Purpose

I need a report on this topic

I need to understand this topic

Reports

Single report per topic

Multiple reports per topic

Granularity

Total volume and by job

Variable

Customisation

Additional fields and filters only

Comprehensive

Built on

System views combined with custom view

Imported onto your custom view

EXEC Suite

The EXEC template suite gives you foundational reports on key recruitment data.

Tip

The EXEC templates are designed to be quick and easy to deploy. They are built on system views and at the job level so that they can be easily connected to your custom view 1.0, custom global questions, and fit your definitions.

Once copied and connected to your custom view, you will be able to add any other fields and filters to these reports as required.

They are set up as single-level reports. If you have additional requirements, like showing volume as a percentage of the total, additional categorisation, or with drill throughs, you may require the EXEC+ templates instead.

EXEC Templates

Image Removed

EXEC: Time to Hire

Info

Average time to hire vs target.

  • average time to fill/hire

  • target

  • distribution

  • average by month (time to hire/fill end)

Uses example time to hire start and end dates and basic stage breakdown. Report table displays data at the job level.

EXEC: Diversity and Candidate Groups

Info

Gender, diversity and other candidate group counts.

  • volume of submitted applications by gender

  • volume of submitted applications by diversity groups

  • volume of internal and external submitted applications

  • volume of gender and diversity groups over time (month application submitted)

Uses example gender, diversity and current employee fields and definitions. Report table displays gender, diversity group and internal/external submitted application totals by job.

EXEC: Source Submitted Applications

Info

Submitted application sources.

  • volume of submitted applications by source

  • in bar and treemap chart format for limited and extensive source lists respectively

Report table displays number of submitted applications by source then by job.

EXEC: Vacancy Management

Info

Current vacancies by job owner and team (user group).

  • current status

  • current step and step status

  • step last edited timestamp and days since updated

Report table displays each current job and its details.

Not sure which template type you should use? See Which Template Do I Use?.

Simple EXEC

These reports give a quick demo of how to visualise time taken, common candidate breakdowns, and current vacancies by current process type, name and step.

They are built on system views with no custom data, but are designed for you to see how they are configured and to replicate on your custom view 1.0.

Image Added

EXEC Simple Strategic
Status
colourGreen
titleSTrategic

  • EXEC Simple Time to Fill/Recruit/Hire

  • EXEC Simple Gender Diversity

  • EXEC Simple Diversity Group

  • EXEC Simple Current Employer

Simple reports using system dates or example gender/diversity/current employer questions in a format that allows basic chart summaries.

EXEC Simple Operational
Status
colourYellow
titleOPERATIONAL

  • EXEC Simple Vacancy Management

Simple report that lists jobs by their current workflow type and step, step permissions and days since last updated.

Accessing Simple EXEC/EXEC+ Templates

You can access a demo of the Simple EXEC and EXEC+ templates in the following way.

  • Browse to System Templates > SMART/EXEC+ Templates.

    Image Added

  • Add the SMART/EXEC+ Templates dashboard available in the above folder.

Image Added

Note that this dashboard also displays the SMART Jobs Access subtab.

Note

These will give you a demo of the reports using a combination of your data and some dummy definitions, and in some cases may not present as intended. They will need to be customised for your circumstances, fields and requirements.

EXEC+ Templates

The EXEC+ templates are designed to give comprehensive insights into your data at operational and strategic levels, and thus require careful design and customisation. They need to be imported onto your custom view 1.0 and are often built at a summary level so that they can look at trends and percentages of volume over time, not just at the job and application level.

Once deployed onto your custom view, you will be able to add any other fields and filters to these reports as required.

They are predominantly set up as single-level reports. Any additional drill through report (looking at additional, related information) is best set up once the initial template has been configured.

You might choose to use all the reports for a given topic. Alternatively, you could use some of them as a basis for your own purposes.

Some may be relevant, some may not. Some may present the data exactly how you need it, others might need adapting for your circumstances.

In any case, this suite will get you started, give you some ideas, and can be expanded upon.

Using EXEC+ Templates

Tip

See a template (or set of templates) you’d like to use or adapt?

  1. Contact your Client Success Manager to discuss your requirements

  2. Review the EXEC+ Requirements section below

  3. Complete the relevant requirements in the Requirements Template on Analytics Solutions

  4. Acendre will deploy the templates for your customisation

You will need to specify:

  • which EXEC+ templates you need customised

  • the relevant metrics and category fields specified below

  • any other field, filter and format customisations

  • any drill through/additional report requirements

You can then customise the deployed version yourself or through our Solutions team to:

  • update existing formatting

  • add fields and filters

  • add or adapt charts

  • add drill through reports

  • arrange final reports on a dashboard.

EXEC+ Time to Hire
Status
colourGreen
titleSTRATEGIC

Expand
titleEXEC+ Time to HIre Details
Image Modified

EXEC+: Time to Hire Summary and by Category

Info

Time to hire average vs target, jobs under vs over and time to hire by category.

Advanced template for time to hire/fill with:

  • overall average vs target

  • count of jobs that met target vs total jobs

  • average time to hire by example category (job template) against overall average and target

EXEC+: Time to Hire Days at Job Status

Info

Job statuses with the longest duration.

  • shows average total days spent at each status per job

  • help identify bottlenecks

  • specific job statuses (e.g. “On Hold”) can be excluded from results

EXEC+: Time to Hire Days at Step

Info

Process steps with the longest duration.

  • shows the average total days spent at each process step per job

  • help identify bottlenecks

  • adjustable step days minimum to limit or expand the steps returned

EXEC+ Diversity
Status
colourGreen
titleSTRATEGIC

Expand
titleEXEC+ Diversity Details
Image Modified

EXEC+: Gender and Diversity Time Series

Info

Gender/Diversity percentages over time.

  • volume of example gender and diversity fields over time

  • example female/male as percentage of submitted

  • example non-binary and diversity group submitted by month job opened

EXEC+: Specific Diversity Tracker

Info

Count of a specific gender/diversity metric.

  • volume of submitted applications for an example niche gender or diversity group that would be a low/untraceable % of all submitted applications

EXEC+: Diversity and Candidate Groups by Stage

Info

Gender, diversity and internal/external percentages by assessment stage.

  • volume of example gender, diversity groups and internal external candidates

  • by submitted vs example offer stages

  • % of all submitted applications

EXEC+: Diversity and Gender by Category

Info

Gender and diversity group percentage by category.

  • example gender, diversity groups and internal/external candidates as a % of submitted applications

  • against an example category (job template)

EXEC+: Gender by Year Drill Down

Info

Applicant gender percentage over time.

  • example gender groups as % of submitted applications

  • by job open year

  • drill down to month then date

EXEC+: Diversity by Year Drill Down

Info

Diversity group percentage over time.

  • example diversity groups as % of submitted applications

  • by job open year

  • drill down to month then date

EXEC+ Sourcing
Status
colourGreen
titleSTRATEGIC

Expand
titleEXEC+ Sourcing Details
Image Modified

EXEC+: Source by Stage

Info

Applicant sources for candidates by stage reached.

  • volume of submitted applications and example offered candidates

  • shown as a % of all at that stage

  • against an example source (audience name)

EXEC+: Source Gender and Diversity

Info

Applicant sources for gender and diversity groups.

  • volume of example gender and diversity groups

  • as a % of submitted applications

  • against an example source (audience name)

EXEC+: Source by Category

Info

Applicant sources for different job types.

  • volume of submitted applications

  • compares example source (audience name) by example category (job template)

  • additional chart shows example breakdown for a specific candidate group or assessment stage

EXEC+: Source by Job

Info

Sources used to advertise jobs.

  • example source (audience name) by number of jobs that used it

EXEC+ Vacancy Management
Status
colourYellow
titleOPERATIONAL

Expand
titleEXEC+ Vacancy Management Details
Image Modified

EXEC+: Vacancy Management Detailed

Info

Detailed status breakdown for current vacancies, with drill through.

  • current processes (not archived)

  • summary by job status

  • average days since updated by job status

  • jobs by team and job owner

  • drill through on job status, average days since updated or job owner charts to see matching jobs, and filter to jobs that haven’t been updated in X days

EXEC+: Vacancies with Time to Hire Tracking

Info

Detailed time to hire tracking for current vacancies.

  • summary of open vacancies (not archived and example time to fill end date is null)

  • the current average time to fill against an example target

  • number of jobs under target vs total open vacancies

  • average current time to fill by example category (job template) against the overall average and target

Accessing

EXEC

and EXEC

+

Templates

You can access a demo of the EXEC/EXEC+ templates in one of two ways.

  • Browse to System Templates > EXEC Templates.

Image Removed

  • Add the EXEC Templates dashboard available in the above folder.

Image Removed
Note

These will give you a demo of the reports using a combination of your data and some dummy definitions, and in some cases may not present as intended. They will need to be customised for your circumstances, fields and requirements.

Using EXEC and EXEC+ Templates

Tip

See a template (or set of templates) you’d like to use or adapt?

  1. Contact your Client Success Manager to discuss your requirements

  2. Review the EXEC and System Templates section of Dashboard Solutions

  3. Complete the relevant requirements in the Requirements Template on Analytics Solutions

  4. Acendre will deploy the templates for your customisation

You can then customise the deployed version yourself or through our Solutions team to:

  • update existing formatting

  • add fields and filters

  • add or adapt charts

  • add drill through reports

  • arrange final reports on a dashboard.

Each template will use example definitions for time to hire, or gender, or source etc. To change these to your metrics and definitions, you can:

  • update the calculated field for a given metric (eg count of females) to your definition (EXEC+ reports only)

    • add extra metrics to the report using your view’s built-in metrics or a calculated field and add these to the relevant chart(s) (EXEC and EXEC+ reports), before removing any example metrics no longer required.

    Requirements

    Theme

    I want to…

    Template

    Default Chart Metric(s)

    You’ll need to provide your own definitions

    Default Chart Categories

    You’ll need to provide your own definitions

    Other Requirements

    Additional field, filter, format and drill through requirements

    Current Vacancies

    Track vacancies

    EXEC+: Vacancy Management

    • Current processes

    • Time to hire/fill measure (start and end date fields)

    • Time to hire/fill target

    • Categories:

      • jobs status

      • days since last updated

      • team and job owner

    Time to Hire/Fill

    Assess time taken to hire

    EXEC+: Time to Hire

    • Time to hire/fill measure (start and end date fields)

    • Time to hire/fill target

    • Time to hire category

    • Job status and process steps

    Gender/Diversity/Other

    • Gender

    • Diversity Groups

    • Internal/External

    • Other

    Compare candidates

    EXEC+: Diversity

    • Candidate group(s)

      • Gender

      • Diversity

    • Candidate groups by assessment stages

    • Assessment stages

    • Job (or other) category

    Application Sourcing

    Assess applicant sources

    EXEC+: Sourcing

    • Submitted applications

    • Submitted applications by assessment stage

    • Gender and diversity groups

    • Application source

    • Assessment stages

    • Job (or other) category

    • Job source