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.
| Template | What it shows | Columns you can choose from |
|---|---|---|
| Advert Report | Job 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 Report | Jobs 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 Report | Hired 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 Report | Offer 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 Report | Offered 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 Report | Candidates 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 Report | One row per application: candidate, job reference, email, status and source. | Candidate Name, Advert / Job Reference, Email, Status, Source, Applied Date |
| Question Response Report | Candidate 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 Report | Submissions, hires, hire rate and average days to hire for each recruitment agency. | Agency ID, Agency, Submitted, Hired, Hire %, Avg days-to-hire |
| RTR Approved Report | Request 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 Report | One 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.