GASP
Onboarding Engagement Metrics Operational

Task Completion Rate

Task Completion Rate: Percentage of assigned onboarding tasks completed by customer.

Formula

Task Completion = Tasks completed / Tasks assigned × 100

Computable definition

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

sum(field.steps_completed) / sum(field.steps_total)

Unit: percent (the formula yields an unscaled ratio)

Data requirements

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

Field Dataset Type
snapshot_date onboarding date
steps_completed onboarding integer
steps_total onboarding integer
Example SQL (Postgres)
SELECT (CAST((SELECT COALESCE(SUM(steps_completed), 0) FROM onboarding WHERE snapshot_date = :period_end) AS DOUBLE PRECISION) / NULLIF((SELECT COALESCE(SUM(steps_total), 0) FROM onboarding WHERE snapshot_date = :period_end), 0)) AS task_completion_rate

From an agent: with the GASP MCP server, call lookup_metric({ "name": "Task Completion Rate" }) or generate_query({ "metric": "Task Completion Rate", "adapter": "<your adapter JSON>" }).

What It Tells You

Customer follow-through on their responsibilities.

Try searching for:

↑↓navigate↵select