Time to Full Adoption
Time to Full Adoption: Time from contract to using all purchased features/modules.
Formula
Time to Full Adoption = Median of (Full adoption 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 = 'full_adoption')Unit: days
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 = 'full_adoption') AS time_to_full_adoption From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Time to Full Adoption" }) or generate_query({ "metric": "Time to Full Adoption", "adapter": "<your adapter JSON>" }).
What It Tells You
How long until customers are fully utilizing what they paid for.