Auto-Renewal Rate

Auto-Renewal Rate: Percentage of renewals processed automatically.

Formula

Auto-Renewal Rate = Auto-renewed contracts / 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.auto_renewed = 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
`auto_renewed`	subscription	boolean
`contract_end`	subscription	date
`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 auto_renewed = 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 auto_renewal_rate

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

What It Tells You

Renewal process efficiency.

← Back to RevOps metrics