GASP
Core Revenue Metrics Outcome

ARPA (Average Revenue Per Account)

ARPA (Average Revenue Per Account): Average monthly recurring revenue per customer.

Also known as: ARPA

Formula

ARPA = MRR / Active Customers

Computable definition

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

metric.mrr / metric.total_customers

Unit: currency

Breakdowns

  • by_segment: one row per segment value

Notes: by_segment returns one row per customer segment, since a blended ARPA across SMB and enterprise describes neither.

Data requirements

Grain: End-of-month snapshot · Frequency: Daily sync · Aggregation: snapshot (month) · Staged: no · Main source: Billing.

Field Dataset Type
customer_id customer string
customer_status customer string
mrr subscription decimal
snapshot_date customer date
snapshot_date subscription date
subscription_status subscription string
Example SQL (Postgres)
SELECT (CAST(((SELECT COALESCE(SUM(mrr), 0) FROM subscription WHERE snapshot_date = :period_end AND subscription_status = 'active')) AS DOUBLE PRECISION) / NULLIF(((SELECT COUNT(DISTINCT customer_id) FROM customer WHERE snapshot_date = :period_end AND customer_status = 'active')), 0)) AS arpa

Access: recommended sensitivity tier confidential, access scope unscoped. Guidance your policy engine enforces.

From an agent: with the GASP MCP server, call lookup_metric({ "name": "ARPA (Average Revenue Per Account)" }) or generate_query({ "metric": "ARPA (Average Revenue Per Account)", "adapter": "<your adapter JSON>" }).

What It Tells You

The average value of a customer on a monthly basis. Used in LTV and CAC Payback calculations.

Connected in the GASP relationship graph.

Upstream: what drives this

Downstream: what this drives

Try searching for:

↑↓navigate↵select