We use ‣ to estimate the cost per hire KPI: Cost per hire 🔗.
To fill the columns:
Role. The name of the role, normally one of Roles.
Ashby Job. The link to the Ashby Job URL is on the hired tab. Same name as 1. Role.
The cell will be red if not of this format:
^https://app\\.ashbyhq\\.com/jobs/[a-f0-9-]{36}/candidate-pipeline/hired$
Full name. The full name of the new hire. To be clear, it’s the legal name, not HiBob’s Display name.
**Meeting time (hr)
SUM Ashby Job**
Use https://app.ashbyhq.com/reports/saved/f81be3b0-33e2-4280-ae69-3bfab555dc64 to get the total interviewer time spent on a given Ashby job, except for a hard-coded list of interviewers:
At MUI, an “Ashby job” maps to what we consider a so this data is the cumulative IC time spent on all the Ashby openings (what we consider ‣). You could use https://app.ashbyhq.com/reports/saved/3bfe1866-c7d7-4c4a-8ea5-a41af9621025 to see the breakdown per opening, but it will only show the time spent with the candidate hired. It doesn’t show the real breakdown because we use "evergreen jobs” Evergreen Jobs/Postings. To solve this, we use ⬇️
* 1.5. Use a math formula.* 80. Use a math formula.