Your pipeline model is fine. Your conversion rates are fiction

Every annual plan I have reviewed contains the same structure. Revenue target, average deal size, required opportunities, required pipeline, required spend. The arithmetic is always correct. The output is almost always wrong, and the reason is that the whole chain rests on three or four conversion rates that were typed into a cell once and then treated as physical constants.

The four ways the rates lie

1. 1

   They are blended across segments that behave differently

   Enterprise converts at a fraction of the rate of self serve and takes four times as long. A blended rate describes an average company that does not exist, and it will be wrong in both directions simultaneously.

2. 2

   They come from the best quarter you ever had

   Usually the quarter where one large deal came in through a relationship. That quarter set the expectation and nobody has revisited it since, because revising it downward requires an uncomfortable conversation.

3. 3

   They assume the mix stays constant

   If you plan to double spend, the incremental spend reaches a colder audience by definition. Applying the current blended rate to incremental volume is the single most common planning error in B2B.

4. 4

   They ignore time

   A model that converts spend to revenue within the same quarter is describing e-commerce. With a five month cycle, most of Q4 revenue was determined by Q2 activity, and no amount of December budget changes that.

A forecast built on one number per stage is not a forecast. It is a hope with a decimal point.

What a defensible version looks like

The fix is not a more sophisticated model. It is a more honest one, and it usually takes an afternoon.

The three case version also changes the conversation with finance. A single number invites a debate about whether it is right. A range invites a discussion about which case you are resourcing for, which is the discussion you actually want to have.

The two structural fixes that matter most

• Date pipeline to creation, not to close. Marketing is accountable for what it created this quarter. Crediting it with deals created eleven months ago hides both the wins and the problems.
• Model the lag explicitly. Put the median cycle length into the model so the plan shows when spend must happen for revenue to land. This one change prevents most end of year panic spending.

Recalculate quarterly, in public

Rates move. Product changes, pricing changes, the segment mix shifts, competitors enter. A rate that was accurate in January is a guess by July. Recalculating every quarter from actuals takes an hour and it is the difference between a model that tracks reality and a model that documents last year's beliefs.

Do it visibly, with the sales leader in the room. A conversion rate that marketing calculated alone is a marketing number. A conversion rate both teams recalculated together is a shared assumption, and shared assumptions are what stop the end of quarter argument about whose fault the gap was.