Required Datapoints
- Sales Revenue Achieved: The total revenue generated by the sales rep or team during the measurement period.
- Sales Quota: The revenue target assigned to the sales rep or team for the same period.
Quota Attainment Rate measures the percentage of sales reps or teams that meet or exceed their assigned revenue or bookings quota within a given time period. It helps assess sales performance, forecasting accuracy, and compensation alignment.
Quota Attainment Rate is a key indicator of sales execution efficiency and GTM strategy alignment, reflecting how sales reps perform against their assigned targets across various sales motions—whether inbound, outbound, or product-led.
The relevance and interpretation of this metric shift depending on the model or product:
A rising attainment rate signals healthy pipelines, good enablement, and achievable goals, while a declining trend may flag strategy misalignment, poor lead quality, or onboarding gaps.
By segmenting by rep, region, product line, or funnel type, you unlock insights for rep coaching, GTM recalibration, and territory planning.
Quota Attainment Rate informs:
These are the main factors that directly impact the metric. Understanding these lets you know what levers you can pull to improve the outcome
Actionable ideas to optimize this KPI, from fast, low-effort wins to strategic initiatives that drive measurable impact.
Activities commonly tied to improving or operationalizing this KPI.
| Activity | Description |
|---|---|
| Sales Enablement | Sales Enablement focuses on Revenue Enablement integrates people, processes, content, and technology to empower customer-facing teams throughout the buyer journey. It coordinates execution across touchpoints so teams can move users or accounts toward the target outcome. Relevant KPIs include Average Contract Value and Average Days from Referral to Close. |
| Forecast Accuracy | Forecast Accuracy involves systematically reviewing and verifying the accuracy of revenue forecasts through collaborative efforts among revenue operations, sales leadership, product teams, and finance. It helps teams translate strategy into repeatable execution. Relevant KPIs include Quota Attainment. |
| Deal Coaching | Deal Coaching is a guided, collaborative process where sales, product, and cross-functional teams work together to analyze and optimize specific customer opportunities. It helps teams translate strategy into repeatable execution. Relevant KPIs include Quota Attainment. |
| Territory Planning | Territory Planning is a strategic process that involves defining, segmenting, and allocating customer accounts, prospects, and geographies to appropriate teams such as sales, customer success, or growth. It gives teams a clear plan for where to focus, how to sequence work, and what to measure. Relevant KPIs include Quota Attainment. |
A sales rep has a quarterly quota of $100,000 and achieves $85,000 in sales:
This KPI is associated with the following stages in the AAARRR (Pirate Metrics) funnel:
This KPI is classified as a lagging Indicator. It reflects the results of past actions or behaviors and is used to validate performance or assess the impact of previous strategies.
This role is directly accountable for the KPI and is expected to drive progress and decisions around it.
These roles contribute directly to performance and typically partner on execution, reporting, or optimization.
These leading indicators influence this KPI and act as early signals that forecast future changes in this KPI.
These lagging indicators confirm, quantify, or amplify this KPI and help explain the broader business impact on this KPI after the fact.
How this KPI is structured in Cube.js, including its key measures, dimensions, and calculation logic for consistent reporting.
cube('SalesPerformance', { sql: `SELECT * FROM sales_performance`,
measures: { salesRevenueAchieved: { sql: `sales_revenue_achieved`, type: 'sum', title: 'Sales Revenue Achieved', description: 'Total revenue generated by the sales rep or team during the measurement period.' },
salesQuota: { sql: `sales_quota`, type: 'sum', title: 'Sales Quota', description: 'Revenue target assigned to the sales rep or team for the same period.' },
quotaAttainmentRate: { sql: `sales_revenue_achieved / NULLIF(sales_quota, 0)`, type: 'number', title: 'Quota Attainment Rate', description: 'Percentage of sales reps or teams that meet or exceed their assigned revenue or bookings quota.' } },
dimensions: { id: { sql: `id`, type: 'string', primaryKey: true, title: 'ID', description: 'Unique identifier for each sales performance record.' },
salesRep: { sql: `sales_rep`, type: 'string', title: 'Sales Rep', description: 'Name of the sales representative.' },
team: { sql: `team`, type: 'string', title: 'Team', description: 'Name of the sales team.' },
period: { sql: `period`, type: 'time', title: 'Period', description: 'Time period for the sales performance measurement.' } }});Note: This is a reference implementation and should be used as a starting point. You’ll need to adapt it to match your own data model and schema