Revenue per Rep
Revenue per Rep: New revenue closed in the period divided by the number of quota-carrying reps.
Formula
Revenue per Rep = Total New Revenue / Number of Quota-Carrying Reps Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
sum(field.closed_revenue) / count_distinct(field.rep_id where field.quota > 0) Unit: currency
Notes: Total new revenue per quota-carrying rep.
Data requirements
Grain: Monthly aggregate · Frequency: Monthly · Aggregation: aggregate (month) · Staged: no · Main source: CRM.
| Field | Dataset | Type |
|---|---|---|
closed_revenue | sales_rep | decimal |
period_start | sales_rep | date |
quota | sales_rep | decimal |
rep_id | sales_rep | string |
Example SQL (Postgres)
SELECT (CAST((SELECT COALESCE(SUM(closed_revenue), 0) FROM sales_rep WHERE period_start >= :period_start AND period_start <= :period_end) AS DOUBLE PRECISION) / NULLIF((SELECT COUNT(DISTINCT rep_id) FROM sales_rep WHERE period_start >= :period_start AND period_start <= :period_end AND quota > 0), 0)) AS revenue_per_rep From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Revenue per Rep" }) or generate_query({ "metric": "Revenue per Rep", "adapter": "<your adapter JSON>" }).
Benchmarks
By company stage:
- Seed: $250K-$400K
- Series A: $400K-$600K
- Series B+: $600K-$1M+
- SMB: $400K-$600K
- Mid-market: $600K-$800K
- Enterprise: $800K-$1.5M+
What It Tells You
Sales team productivity and efficiency.