Onboarding Completion Rate

Onboarding Completion Rate: Percentage of customers who complete the onboarding program.

Formula

Completion Rate = Customers completing onboarding / Customers starting onboarding × 100

Computable definition

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

count_distinct(field.onboarding_id where in_period(field.onboarding_completion_date)) / count_distinct(field.onboarding_id where in_period(field.onboarding_start_date))

Unit: percent (the formula yields an unscaled ratio)

Notes: Onboardings completed in the period over onboardings started in the period.

Data requirements

Grain: Per event, aggregate monthly · Frequency: Daily · Aggregation: aggregate (month) · Staged: no · Main source: CS Platform.

Field	Dataset	Type
`onboarding_completion_date`	onboarding	date
`onboarding_id`	onboarding	string
`onboarding_start_date`	onboarding	date
`snapshot_date`	onboarding	date

Example SQL (Postgres)

SELECT (CAST((SELECT COUNT(DISTINCT onboarding_id) 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_start_date >= :period_start AND onboarding_start_date <= :period_end)), 0)) AS onboarding_completion

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": "Onboarding Completion Rate" }) or generate_query({ "metric": "Onboarding Completion Rate", "adapter": "<your adapter JSON>" }).

Benchmarks

Below 70%: Low, investigate friction points
70-85%: Average
85-95%: Good
Above 95%: Excellent

What It Tells You

Onboarding program effectiveness.

Connected in the GASP relationship graph.

Upstream: what drives this

Time to First Value reduces Onboarding Completion Rate (Onboarding)

Downstream: what this drives

Onboarding Completion Rate drives Activation Rate (Onboarding)
Onboarding Completion Rate measures Customer (Entity)

← Back to Onboarding metrics