Days to Renewal
Days to Renewal: Average number of days until upcoming renewals.
Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
avg(field.contract_end - field.snapshot_date)Unit: days
Notes: Averaged over upcoming renewals at the snapshot date.
Data requirements
Grain: End-of-month snapshot · Frequency: Daily sync · Aggregation: snapshot (month) · Staged: no · Main source: Billing.
| Field | Dataset | Type |
|---|---|---|
contract_end | subscription | date |
snapshot_date | subscription | date |
Example SQL (Postgres)
SELECT (SELECT AVG((contract_end - snapshot_date)) FROM subscription WHERE snapshot_date = :period_end) AS days_to_renewal From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Days to Renewal" }) or generate_query({ "metric": "Days to Renewal", "adapter": "<your adapter JSON>" }).
What It Tells You
How soon the renewal workload arrives. A short average means renewals are bunched close together, which strains CSM capacity.