Sales forecasting is probably the most frustrating part of sales management. When the boss asks how much revenue the team will close this month, the sales director either pulls a number out of thin air or says "we'll do our best"—that's not forecasting, that's wishful thinking.
Truly effective sales forecasting needs to be built on data and process. It's not guessed—it's calculated.
Step One: Build a Forecast Model
The core of a forecast model comes down to two numbers: conversion rate and average deal size.
For example, say your sales funnel looks like this: 100 leads → 20 qualified prospects → 5 closed deals. That's a 5% conversion rate. If your average deal size is $100K, then 100 leads theoretically produce $500K in revenue.
This model doesn't need to be complex, but it must exist. Without a model, forecasting is just guesswork.
Step Two: Collect Key Data
Once you have a model, the next step is to collect three types of data:
1. Funnel data: How many customers are at each stage, what the conversion rates are, and the average time spent in each stage. This data helps you assess whether your funnel is healthy.
2. Historical data: Closed deals from the past 3-6 months, seasonal fluctuations, and the impact of major accounts. History doesn't repeat exactly, but it rhymes.
3. Real-time data: New leads this month, progress on qualified prospects, and expected close dates. Real-time data helps you adjust your forecast.
Step Three: Continuously Calibrate and Optimize
Forecasting isn't a one-and-done exercise. It requires continuous calibration. At the end of each month, compare your forecast to actual results and analyze the reasons for any variance.
If your forecast is consistently too high, you may be overestimating conversion rates. If it's consistently too low, you may be overlooking certain factors that drive deals.
The calibration process is a learning process. After 3-6 months of iteration, your forecast accuracy will improve significantly.
Tool Recommendation
Use Tuji to track each customer's follow-up status and expected close date. The system automatically calculates conversion rates and predicted deal probability. You don't need to manually compile data—just open the dashboard to see your forecast results.