Sales Analytics and Forecasting

Running sales by the numbers: activity and pipeline metrics, conversion rates, sales velocity, quotas, forecasting methods, territory data and dashboards, using spreadsheets.

SLS-214 Year 2 3 credits 12 lessons · 4 h 27 min ▶ Video lessons coming soon

Last updated

Offered by HSM University · Sales

This is the Canadian version of this course. See the American version.

What you'll learn

  • Explain why sales teams measure, distinguish leading from lagging indicators, and recognize how targets can be gamed under Goodhart's law.
  • Calculate activity ratios and pipeline coverage, compare like with like using first-year and total contract value, and turn a quota into an activity plan.
  • Measure stage conversion rates from cohorts, find where a sales funnel leaks, and use conversion rates to plan the opportunities a target requires.
  • Calculate sales velocity, split a change in velocity into its terms, and assess the four levers and their trade-offs.
  • Calculate overall, competitive and value win rates, compare win rates by segment, and describe cycle length with the median.
  • Explain how quotas are set, ramped and split by season, calculate quota attainment and commission, and judge attainment fairly.
  • Build a weighted pipeline forecast, calibrate stage probabilities against history, and handle large deals and slipped close dates.
  • Use forecast categories to build commit and best-case forecasts, compare them with a weighted forecast, and measure forecast error, MAPE and bias.
  • Analyze a territory with penetration, white space, tiering and potential, and use the quota-to-potential ratio to judge fairness.
  • Lay out sales data as tables and use SUMIFS, COUNTIFS, AVERAGEIFS, XLOOKUP, SUMPRODUCT, pivot tables and moving averages to analyze it.
  • Design sales dashboards for sellers, managers and executives that compare each figure with a target and lead to action.
  • Diagnose a missed quarter by sizing the gap, building a driver tree, testing causes against data and writing a measurable action plan.

Course content

12 lessons · 4 h 27 min total · final exam

  1. 1 Why sales teams measure 18 min · quiz
  2. 2 Activity, pipeline and outcome metrics 20 min · quiz
  3. 3 Conversion rates by stage 24 min · quiz
  4. 4 Sales velocity 23 min · quiz
  5. 5 Win rates and sales cycle length 23 min · quiz
  6. 6 Quotas and attainment 23 min · quiz
  7. 7 Forecasting with a weighted pipeline 25 min · quiz
  8. 8 Forecast categories and judgment 21 min · quiz
  9. 9 Territory and account data 24 min · quiz
  10. 10 Spreadsheet skills for sales 21 min · quiz
  11. 11 Sales dashboards 21 min · quiz
  12. 12 Case study: diagnosing a missed quarter 24 min · quiz
  13. E Final exam 20 questions

Requirements

Recommended background. You can start any course at any time.

Description

Running sales by the numbers: activity and pipeline metrics, conversion rates, sales velocity, quotas, forecasting methods, territory data and dashboards, using spreadsheets.

Part of the Business stream, typically taken in year 2.