Customer Success Retention Metrics Outcome

Logo Retention Rate

Logo Retention Rate: The percentage of customers retained over a period.

Formula

Logo Retention Rate = (Customers at end - New customers) / Customers at start × 100

Logo Retention Rate = 100% - Logo Churn Rate

Computable definition

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

1 - metric.logo_churn_rate

Unit: percent (the formula yields an unscaled ratio)

Customer counts variant: (count_distinct(field.customer_id where field.customer_status = 'active') at period_end - count_distinct(field.customer_id where field.event_type = 'new')) / count_distinct(field.customer_id where field.customer_status = 'active') at period_start

Breakdowns

by_segment: one row per segment value

Notes: by_segment returns one row per customer segment through Logo Churn Rate.

Data requirements

Grain: Per event, aggregate monthly · Frequency: Daily sync · Aggregation: aggregate (month) · Staged: no · Main source: Billing.

Field	Dataset	Type
`customer_id`	customer	string
`customer_id`	revenue_event	string
`customer_status`	customer	string
`event_date`	revenue_event	date
`event_type`	revenue_event	string
`snapshot_date`	customer	date

Example SQL (Postgres)

SELECT (1 - ((CAST(((SELECT COUNT(DISTINCT customer_id) FROM revenue_event WHERE event_date >= :period_start AND event_date <= :period_end AND event_type = 'churn')) AS DOUBLE PRECISION) / NULLIF(((SELECT COUNT(DISTINCT customer_id) FROM customer WHERE snapshot_date = :period_start AND customer_status = 'active')), 0)))) AS logo_retention_rate

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

What It Tells You

How many customer relationships you keep, whatever each one is worth.

← Back to Customer Success metrics