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.
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%.
opportunities: opportunity_id, account_id, owner_id, created_date, source_channel, segment, stage, close_date, amount_arr, is_closed_wonpipeline_stage_history: opportunity_id, stage_name, entered_at, exited_atsales_reps: owner_id, team, region, tenure_months, quarterly_quotamarketing_leads: lead_id, acquisition_channel, campaign_id, created_date, converted_to_opportunity