Customer Success Renewal Metrics Operational

Days to Renewal

Days to Renewal: Average number of days until upcoming renewals.

Formula

Days to Renewal = Average of (Contract end date - Today) across active subscriptions with an upcoming term end

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 where field.subscription_status = 'active' and field.contract_end >= field.snapshot_date)

Unit: days

Notes: Averaged over active subscriptions whose term ends on or after 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
`subscription_status`	subscription	string

Example SQL (Postgres)

SELECT (SELECT AVG((contract_end - snapshot_date)) FROM subscription WHERE snapshot_date = :period_end AND (subscription_status = 'active' AND contract_end >= snapshot_date)) 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 falling average means more renewal work lands soon.

← Back to Customer Success metrics