~/portfolio/projects/pipeline-analysis
← cd ../projects

#06 · 2023

SaaS Pipeline Conversion Analysis

Analysis (employer work, de-identified)
readme.md

Sales analytics · Enterprise SaaS

my_role: Individual Contributor (IC) - mapped stage conversion and identified where and why deals stall.

Where deals stall in the sales pipeline, and why. A conversion analysis across pipeline stages for an enterprise SaaS product, surfacing the exact points where opportunities drop off and what distinguishes won deals from lost ones.

## Background

Global historical coverage over three years: peak coverage trend increasing, while the conversion trend was declining.

## Business question

Why is global conversion declining?

  • ›What are the driving forces behind the conversion trends?
  • ›Could these be attributed to a key segment in our customer base?

## Methodology

Hypothesis: pipeline composition is shifting away from high-conversion business units toward lower-conversion BUs. Baseline metrics were built from daily pipeline snapshots (NNACV) and global conversion FY18–21, compared quarter over quarter (Q1). Breakdown dimensions:

  • ›Segment, Source, Opportunity Type, Geo, Area, Rep Tenure, Deal Size / ACV Band
  • ›Median QoQ pipeline - has the average value changed significantly QoQ? (pipeline at close of quarter / peak pipeline)
  • ›Historical volatility QoQ - average volatility of the daily change in pipeline value in Q1 FY18–21
  • ›Weighted pipeline - weighted pipeline $ = opportunity pipeline $ × pipeline stage weight (%); % weighted pipeline = weighted pipeline / total pipeline $

## Volatility explained

Historical volatility is a statistical measure of the daily change in pipeline volume. It leverages short-term indicators to inform future risk and can be used as an early indicator, since it can be calculated at various intervals (weekly, monthly, quarterly). Two sets of daily values can have the same average (e.g. $800K) but very different volatility - high volatility signals an unstable pipeline.

## % weight explained

Weighted pipeline ($) is the product of the % weight assigned by opportunity stage and the pipeline $ NNACV value (e.g. for a $100,000 opportunity: stage 2 = 1% → $1K, stage 4 = 20–30% → $20–30K, stage 6 = 70% → $70K, won = 100% → $100K). % weighted pipeline serves as a proxy for overall pipeline stage maturity and can be monitored daily to evaluate underlying pipeline strength.

## Key findings - Q1-21 is a departure from historical performance

Two-population Z-tests show a significant departure from historical performance for key customer segments.

  • ›Segments with historically better conversion decreased vs. past year - with significantly increased volatility, decreased % weightage and lower median pipeline
  • ›License Upsell opportunity type: 16% conversion decline
  • ›Sales opportunity source: 18% conversion decline
  • ›Enterprise+ segment: 17% conversion decline (FY21 closing pipeline = $31.4M)
  • ›Segments with historically lower conversion increased - with lower volatility, increased % weightage and higher median pipeline
  • ›ACE opportunity source: 22% conversion increase (FY21 closing pipeline = $13.9M)
  • ›New Business opportunity type: 10% increase ($4.9M); SMB segment: 10% increase ($7.3M)
meta.json
year
2023
status
Analysis (employer work, de-identified)
tags
AnalyticsEnterprise SaaS
gallery [5]
SaaS Pipeline Conversion Analysis - figure 1SaaS Pipeline Conversion Analysis - figure 2SaaS Pipeline Conversion Analysis - figure 3SaaS Pipeline Conversion Analysis - figure 4SaaS Pipeline Conversion Analysis - figure 5