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