Business Context

NimbusCRM sells annual SaaS subscriptions to mid-market sales teams. The CRO asks you to explain why the company missed its Q4 new ARR quota and what metrics should be managed to improve next quarter's attainment.

Metric Scenario

NimbusCRM set a Q4 new ARR quota of $12.0M. Actual closed-won new ARR was $10.2M, or 85% attainment. Last quarter, attainment was 102% on a $10.0M quota. The sales team generated 4,800 qualified opportunities in Q4 versus 4,500 in Q3, but win rate fell from 24% to 19% and average deal size declined from $9,300 to $8,700. Sales cycle length increased from 41 days to 49 days, causing some late-quarter pipeline to slip. Marketing-sourced opportunities converted to closed-won at 14%, while outbound SDR-sourced opportunities converted at 22%. Enterprise deals represented 18% of opportunities but 39% of ARR, and enterprise win rate dropped from 17% to 11%.

Requirements

1. Define quarterly revenue quota attainment precisely, including numerator, denominator, and what counts toward quota.
2. Calculate Q4 attainment and decompose the miss into pipeline volume, conversion rate, deal size, and timing/slippage.
3. Identify the most important leading indicators that would have predicted the miss before quarter end.
4. Segment the problem by source, segment, rep, and stage to identify the biggest drivers.
5. Recommend specific actions to improve next quarter's attainment while noting any trade-offs.

Data Available

• opportunities: opportunity_id, account_id, owner_id, created_date, source_channel, segment, stage, close_date, amount_arr, is_closed_won
• pipeline_stage_history: opportunity_id, stage_name, entered_at, exited_at
• sales_reps: owner_id, team, region, tenure_months, quarterly_quota
• marketing_leads: lead_id, acquisition_channel, campaign_id, created_date, converted_to_opportunity