Module 1: Sales Data Foundations

The Metrics That Actually Predict Revenue

Sales teams can measure hundreds of things: calls made, emails sent, meetings booked, deals created, average deal size and more. Not all of these help you predict revenue. Some are simply busy-work counters. In this lesson you will learn to separate the metrics that genuinely drive and predict revenue from those that only look impressive, and you will build a simple model that connects them.

The revenue equation

For most sales teams, revenue in a period can be broken into a few multiplying parts:

Revenue = Number of qualified opportunities x Win rate x Average deal size

And the timing of that revenue depends on sales cycle length: how long it takes a deal to go from qualified opportunity to closed. These four numbers, often called the pipeline velocity drivers, explain most of the variation in sales results. A common way to combine them is:

Pipeline velocity (revenue per day) = (Qualified opportunities x Win rate x Average deal size) / Average sales cycle length in days

If any one driver improves while the others hold steady, revenue rises. If any one falls, revenue falls. This gives you a clear way to diagnose problems: is the issue too few opportunities, a falling win rate, smaller deals or slower cycles?

Worked example: diagnosing a shortfall

A company selling point-of-sale systems to shops in Kenya had these figures in two consecutive quarters (hypothetical):

Revenue fell by more than a fifth. The number of opportunities and deal size barely changed, so the problem is the win rate. That points the manager toward questions about competition, pricing, qualification or sales skills, rather than toward spending more on lead generation, which would not fix the real problem.

Leading and lagging indicators

Metrics fall into two groups:

• Lagging indicators report results after they happen: revenue won, deals closed, quota attainment. They are definitive but arrive too late to change the current period.
• Leading indicators change before results do: new qualified opportunities created, pipeline value added, proposals sent, meetings with decision-makers. They give you time to act.

A useful sales analytics system tracks both, and checks which leading indicators actually predict results in your business. For example, you may find that the number of first meetings held has little relationship with revenue, but the number of site visits does. Look at your own history before deciding which leading indicators to manage.

Choosing your core metrics

Start with a small set:

1. Qualified opportunities created per month.
2. Win rate (by count and by value).
3. Average deal size.
4. Average sales cycle length.
5. Pipeline coverage: open pipeline value for the period divided by the remaining target.
6. Revenue won versus target.

Write a precise definition for each, including which deals are counted and over what dates. Different definitions are the most common source of arguments about numbers.

Once you have your core set, review it with the people who use it. Ask your sales manager which numbers they would check first if results dropped, and ask reps which numbers they feel they can influence. Metrics that nobody looks at, or that nobody can act on, should be dropped or replaced.

Common mistakes to avoid

• Tracking activity for its own sake. Calls and emails matter only if they lead to opportunities.
• Looking only at revenue. By the time revenue drops, the cause happened months earlier.
• Assuming relationships without checking. Test whether a leading indicator really moves with results in your data.
• Mixing definitions. A win rate that includes open deals in the denominator is very different from one that does not.