Versions Compared

Old Version 27

changes.mady.by.user Brendan Codrington

Saved on

compared with

New Version 28

changes.mady.by.user Brendan Codrington

Saved on

Key

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

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

Table of Contents
maxLevel2
Info

The 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 RemovedImage Added

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:

Gender

Diversity and

Diversity

Candidate Groups

Info

Gender, diversity and diversity 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 diversity current employee fields and definitions. Report table displays gender and , 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.

EXEC+ Suite

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

Tip

The EXEC+ templates are designed to give comprehensive insights into your data, 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.

EXEC+ Time to Hire

Image RemovedImage Added

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

Image RemovedImage Added

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+:

Gender

Diversity and

Diversity

Candidate Groups by Stage

Info

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

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

  • by submitted vs example offer stages

  • % of all submitted applications

EXEC+: Diversity and Gender

and Diversity

by Category

Info

Gender and diversity group percentage by category.

  • example gender and , 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

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

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.

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

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 Use Existing 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.