Skip to content
English
  • There are no suggestions because the search field is empty.

Custom report templates and their columns

Every template a custom report can be built on, what it shows, and the columns you can choose from.

Every template a custom report can be built on, what it shows, and the columns you can choose from.

This is for System Admins and HR users who run custom reports. A custom report must already be set up for your organisation, and Custom reports explains how to open, run, export and change the columns of one.

Templates and columns

Every custom report is built on one of these templates. The Template column in the list of custom reports shows which one a report uses. You choose which columns to show from the Columns menu, and the choices are those of the report's template. HR users cannot open reports built on the three templates marked System Admin only.

TemplateWhat it showsColumns you can choose from
Advert ReportJob posting performance and application volume, one row per job.Job ID, Job Title, Reference, Location, Department, Status, Job Type, Job Category, Job Time, Salary Min, Salary Max, Published Date, Closed Date, Closing Date, Created Date, Applications, Hired
Vacancy Advertised ReportJobs that went live in a date range, based on the published date.Job ID, Job Title, Reference, Location, Department, Status, Published Date, Closed Date, Applications
Time to Hire ReportHired applications and how many days each took from applying to being hired.Job ID, Job Title, Department, Candidate ID, Candidate Name, Applied Date, Hired Date, Days to Hire, Status
Offers ReportOffer details alongside the candidate and job.Offer ID, Candidate Name, Job Title, Salary, Currency, Offer Type, Status, Created Date, Sent Date, Responded Date, Start Date
Cost to Hire ReportOffered salary and speed to offer, keyed off the offer date. It lists every offer, accepted or not, and is not a full cost of hiring.Offer ID, Candidate Name, Job Title, Department, Salary, Currency, Offer Date, Job Published Date, Days to Offer
Candidate Source ReportCandidates by source, with job and pipeline stage.Candidate ID, Candidate Name, Source, Source (This Application), Source Detail (This Application), Job ID, Job Title, Pipeline Stage, Applied Date, Status
Individual Candidates ReportOne row per application: candidate, job reference, email, status and source.Candidate Name, Advert / Job Reference, Email, Status, Source, Applied Date
Question Response ReportCandidate answers to the scheme compliance questions (Disability Confident, Armed Forces, Care Leaver), one row per candidate per question.Candidate ID, Candidate Name, Question, Answer, Compliance Category, Applied Date
Agency Efficiency ReportSubmissions, hires, hire rate and average days to hire for each recruitment agency.Agency ID, Agency, Submitted, Hired, Hire %, Avg days-to-hire
RTR Approved ReportRequest to Recruit approvals, by the date of final approval.Cycle ID, Job Title, Reference, Department, Location, Submitted By, Submitted Date, Approved Date, Days to Approve
RTR Info ReportOne row per approver per Request to Recruit: the decision, who made it, and days taken since the request was submitted.Cycle ID, Job Title, Reference, Department, Location, Level, Step, Approver Group, Approver, Decision, Requested Date, Decided Date, Days to Decide
DEI Report (System Admin only)Diversity, equity and inclusion answers from application forms, as counts and percentages per category.Category, Value, Count, Percentage
DEI Pipeline Report (System Admin only)The same equality data broken down by pipeline stage. Rank is optional and shows the sub-status a candidate currently holds in the stage. When it is included, small counts are hidden for each rank value.Category, Value, Pipeline Stage, Rank, Count, Percentage
Conviction Report (System Admin only)Counts of the declared conviction answers given on application forms.Answer, Count, Percentage

The Cost to Hire Report

This template is the only way to see a money figure in reports. Salary and Currency are the values entered when the offer was created. Days to Offer is the number of days from the job being published to the offer being created. It includes every offer, whether or not it was accepted. Time and cost report explains why that report itself shows no costs.