Time to First Value (TTFV)
Time to First Value (TTFV): Time from contract start to the customer's first meaningful value milestone.
Also known as: TTFV
Formula
TTFV = Median of (First value milestone date - Contract start 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.milestone_date - field.contract_start where field.onboarding_milestone = 'first_value') Unit: days
Notes: Days from contract start to the first value milestone.
Data requirements
Grain: Per event · Frequency: Daily · Aggregation: event · Staged: no · Main source: CS Platform.
| Field | Dataset | Type |
|---|---|---|
contract_start | onboarding_milestone | date |
milestone_date | onboarding_milestone | date |
onboarding_milestone | onboarding_milestone | string |
Example SQL (Postgres)
SELECT (SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY (milestone_date - contract_start)) FROM onboarding_milestone WHERE milestone_date >= :period_start AND milestone_date <= :period_end AND onboarding_milestone = 'first_value') AS ttfv Access: recommended
sensitivity tier internal,
access scope department-scoped.
Guidance your policy engine enforces.
From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Time to First Value (TTFV)" }) or generate_query({ "metric": "Time to First Value (TTFV)", "adapter": "<your adapter JSON>" }).
Benchmarks
What It Tells You
How quickly customers realize value, which feeds directly into retention.
Related Metrics
Connected in the GASP relationship graph.
Downstream: what this drives
- Time to First Value reduces Onboarding Completion Rate (Onboarding)
- Time to First Value measures Customer (Entity)