Onboarding Duration
Onboarding Duration: Time from onboarding start to onboarding completion, for onboardings completed in the period.
Formula
Onboarding Duration = Median of (Onboarding complete date - Onboarding 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.onboarding_completion_date - field.onboarding_start_date where in_period(field.onboarding_completion_date))Unit: days
Notes: Days from onboarding start to onboarding complete.
Data requirements
Grain: Per event · Frequency: Per onboarding · Aggregation: event · Staged: no · Main source: CS Platform.
| Field | Dataset | Type |
|---|---|---|
onboarding_completion_date | onboarding | date |
onboarding_start_date | onboarding | date |
snapshot_date | onboarding | date |
Example SQL (Postgres)
SELECT (SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY (onboarding_completion_date - onboarding_start_date)) FROM onboarding WHERE snapshot_date = :period_end AND (onboarding_completion_date >= :period_start AND onboarding_completion_date <= :period_end)) AS onboarding_duration From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Onboarding Duration" }) or generate_query({ "metric": "Onboarding Duration", "adapter": "<your adapter JSON>" }).
What It Tells You
Length of onboarding program.