Onboarding Efficiency Metrics Operational

Time Spent per Onboarding

Time Spent per Onboarding: Total hours invested per customer onboarding.

Formula

Hours per Onboarding = Total onboarding hours / Customers onboarded

Computable definition

The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.

sum(field.hours where in_period(field.onboarding_completion_date)) / count_distinct(field.onboarding_id where in_period(field.onboarding_completion_date))

Unit: hours

Data requirements

Grain: Per event · Frequency: Per onboarding · Aggregation: event · Staged: no · Main source: CS Platform.

Field	Dataset	Type
`hours`	onboarding	decimal
`onboarding_completion_date`	onboarding	date
`onboarding_id`	onboarding	string
`snapshot_date`	onboarding	date

Example SQL (Postgres)

SELECT (CAST((SELECT COALESCE(SUM(hours), 0) FROM onboarding WHERE snapshot_date = :period_end AND (onboarding_completion_date >= :period_start AND onboarding_completion_date <= :period_end)) AS DOUBLE PRECISION) / NULLIF((SELECT COUNT(DISTINCT onboarding_id) FROM onboarding WHERE snapshot_date = :period_end AND (onboarding_completion_date >= :period_start AND onboarding_completion_date <= :period_end)), 0)) AS time_spent_per_onboarding

From an agent: with the GASP MCP server, call lookup_metric({ "name": "Time Spent per Onboarding" }) or generate_query({ "metric": "Time Spent per Onboarding", "adapter": "<your adapter JSON>" }).

Benchmarks

Self-serve/digital: 0-2 hours
SMB: 5-15 hours
Mid-market: 20-50 hours
Enterprise: 50-200+ hours

← Back to Onboarding metrics