Renewal Notification Rate

Renewal Notification Rate: Percentage of renewals where customer was notified on time.

Formula

Notification Rate = Renewals notified on time / Total renewals × 100

Computable definition

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

count_distinct(field.subscription_id where in_period(field.contract_end) and field.renewal_notified_on_time = true) / count_distinct(field.subscription_id where in_period(field.contract_end))

Unit: percent (the formula yields an unscaled ratio)

Notes: Population is renewals in the period.

Data requirements

Grain: Monthly aggregate · Frequency: Monthly · Aggregation: aggregate (month) · Staged: no · Main source: Billing.

Field	Dataset	Type
`contract_end`	subscription	date
`renewal_notified_on_time`	subscription	boolean
`snapshot_date`	subscription	date
`subscription_id`	subscription	string

Example SQL (Postgres)

SELECT (CAST((SELECT COUNT(DISTINCT subscription_id) FROM subscription WHERE snapshot_date = :period_end AND ((contract_end >= :period_start AND contract_end <= :period_end) AND renewal_notified_on_time = TRUE)) AS DOUBLE PRECISION) / NULLIF((SELECT COUNT(DISTINCT subscription_id) FROM subscription WHERE snapshot_date = :period_end AND (contract_end >= :period_start AND contract_end <= :period_end)), 0)) AS renewal_notification_rate

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

← Back to RevOps metrics