Sales Productivity Metrics Outcome Operational

Quota Attainment

Quota Attainment: The percentage of quota achieved by a rep or team.

Formula

Quota Attainment = Revenue Closed / Quota × 100

Team Attainment = Total Team Revenue / Total Team Quota × 100

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) / sum(field.quota)

Unit: percent (the formula yields an unscaled ratio)

Mean of reps variant: avg(field.closed_revenue / field.quota)

Notes: Individual form groups by rep_id; team form uses totals.

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

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 COALESCE(SUM(quota), 0) FROM sales_rep WHERE period_start >= :period_start AND period_start <= :period_end), 0)) AS quota_attainment

Access: recommended sensitivity tier confidential, access scope owner-scoped. Guidance your policy engine enforces.

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

Benchmarks

Below 50%: Below average
50-80%: Average range
80-100%: Strong performer
100%+: Top performer / exceeding

What It Tells You

Sales rep and team performance against targets.

Connected in the GASP relationship graph.

Upstream: what drives this

Employee Turnover Rate reduces Quota Attainment (People)

Downstream: what this drives

Quota Attainment drives New MRR (Core)
Quota Attainment measures Employee (Entity)

Sources

← Back to Sales metrics