Renewal Processing Time
Renewal Processing Time: Time to process a renewal from trigger to completion.
Formula
Processing Time = Median of (Renewal complete - Renewal trigger)Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
median(field.renewal_complete_date - field.renewal_trigger_date where in_period(field.contract_end))Unit: days
Data requirements
Grain: Monthly aggregate · Frequency: Monthly · Aggregation: aggregate (month) · Staged: no · Main source: Billing.
| Field | Dataset | Type |
|---|---|---|
contract_end | subscription | date |
renewal_complete_date | subscription | date |
renewal_trigger_date | subscription | date |
snapshot_date | subscription | date |
Example SQL (Postgres)
SELECT (SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY (renewal_complete_date - renewal_trigger_date)) FROM subscription WHERE snapshot_date = :period_end AND (contract_end >= :period_start AND contract_end <= :period_end)) AS renewal_processing_time From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Renewal Processing Time" }) or generate_query({ "metric": "Renewal Processing Time", "adapter": "<your adapter JSON>" }).