Order-to-Activation Time
Order-to-Activation Time: Time from signed order to customer activation/provisioning.
Formula
Order-to-Activation = Median of (Activation date - Order signed 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.activation_date - field.acquisition_date where in_period(field.activation_date))Unit: days
Data requirements
Grain: Per event · Frequency: Per transaction · Aggregation: event · Staged: no · Main source: Billing.
| Field | Dataset | Type |
|---|---|---|
acquisition_date | customer | date |
activation_date | customer | date |
snapshot_date | customer | date |
Example SQL (Postgres)
SELECT (SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY (activation_date - acquisition_date)) FROM customer WHERE snapshot_date = :period_end AND (activation_date >= :period_start AND activation_date <= :period_end)) AS order_to_activation_time From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Order-to-Activation Time" }) or generate_query({ "metric": "Order-to-Activation Time", "adapter": "<your adapter JSON>" }).
What It Tells You
How quickly customers get access after buying.