Time to Hire
Time to Hire: Days from the hired employee's application to their start date, for employees hired in the period.
Formula
Time to Hire = Average of (Start date - Application date)Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
avg(field.hire_date - field.application_date where in_period(field.hire_date))Unit: days
Notes: Days from the hired employee's application to their start date, per employee hired in the period. Time to Fill covers requisition opened to offer accepted.
Data requirements
Grain: Per event · Frequency: Per hire · Aggregation: event · Staged: no · Main source: ATS.
| Field | Dataset | Type |
|---|---|---|
application_date | employee | date |
hire_date | employee | date |
snapshot_date | employee | date |
Example SQL (Postgres)
SELECT (SELECT AVG((hire_date - application_date)) FROM employee WHERE snapshot_date = :period_end AND (hire_date >= :period_start AND hire_date <= :period_end)) AS time_to_hire From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Time to Hire" }) or generate_query({ "metric": "Time to Hire", "adapter": "<your adapter JSON>" }).
What It Tells You
Candidate experience and process efficiency.