Time to Start
Time to Start: Time from services sold to project kickoff.
Formula
Time to Start = Median of (Kickoff date - Close date)Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
median(field.project_start_date - field.close_date where in_period(field.project_start_date))Unit: days
Notes: close_date on the project is the close date of the won opportunity.
Data requirements
Grain: Per event · Frequency: Per milestone · Aggregation: event · Staged: no · Main source: PSA.
| Field | Dataset | Type |
|---|---|---|
close_date | project | date |
project_start_date | project | date |
snapshot_date | project | date |
Example SQL (Postgres)
SELECT (SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY (project_start_date - close_date)) FROM project WHERE snapshot_date = :period_end AND (project_start_date >= :period_start AND project_start_date <= :period_end)) AS time_to_start From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Time to Start" }) or generate_query({ "metric": "Time to Start", "adapter": "<your adapter JSON>" }).
What It Tells You
Resource availability and scheduling efficiency.