Time to Fill
Time to Fill: Days from a requisition opening to it being filled with an accepted offer, for requisitions filled in the period.
Formula
Time to Fill = Average of (Offer accepted date - Job posted 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.filled_date - field.requisition_opened_date where in_period(field.filled_date))Unit: days
Notes: Days from job posted to offer accepted, per filled requisition.
Data requirements
Grain: Per event · Frequency: Per hire · Aggregation: event · Staged: no · Main source: ATS.
| Field | Dataset | Type |
|---|---|---|
filled_date | requisition | date |
requisition_opened_date | requisition | date |
snapshot_date | requisition | date |
Example SQL (Postgres)
SELECT (SELECT AVG((filled_date - requisition_opened_date)) FROM requisition WHERE snapshot_date = :period_end AND (filled_date >= :period_start AND filled_date <= :period_end)) AS time_to_fill From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Time to Fill" }) or generate_query({ "metric": "Time to Fill", "adapter": "<your adapter JSON>" }).
Benchmarks
- Below 30 days: Fast
- 30-45 days: Good
- 45-60 days: Average
- Above 60 days: Slow, may impact growth