Quality of Hire: Performance rating of new hires after defined period.
Formula
Quality of Hire = Average performance rating of hires at 6-12 months Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
avg(field.performance_rating where field.hire_date is not null and field.snapshot_date - field.hire_date >= 182 and field.snapshot_date - field.hire_date <= 365) Unit: score
Notes: Average performance rating of hires at 6-12 months. The markdown also allows the share of hires meeting or exceeding expectations, which needs a rating threshold it does not define.
Data requirements
Grain: Per event · Frequency: Per hire · Aggregation: event · Staged: no · Main source: HRIS.
| Field | Dataset | Type |
|---|---|---|
hire_date | employee | date |
performance_rating | employee | decimal |
snapshot_date | employee | date |
Example SQL (Postgres)
SELECT (SELECT AVG(performance_rating) FROM employee WHERE snapshot_date = :period_end AND ((hire_date IS NOT NULL AND (snapshot_date - hire_date) >= 182) AND (snapshot_date - hire_date) <= 365)) AS quality_of_hire From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Quality of Hire" }) or generate_query({ "metric": "Quality of Hire", "adapter": "<your adapter JSON>" }).
What It Tells You
Recruiting effectiveness at finding good candidates.