Growth modeling: how to build a growth model that forecasts revenue

A growth model is a spreadsheet that connects inputs such as traffic, conversion rate and retention to a revenue forecast. Instead of hoping growth arrives on its own, you calculate what happens when you turn a particular dial. TL;DR: good growth modeling shows you which lever has the biggest effect on your revenue, so you can point your budget and attention at what really counts. In this article we build such a model step by step, in plain language and without complicated formulas.

Let’s be honest up front: a growth model does not predict the future exactly. No model does. The value lies elsewhere. It forces you to cut your growth into components and make an honest assumption for each one. Suddenly you see where your growth has to come from and which assumptions you cannot yet back up.

Why a growth model is more than a revenue forecast

A classic revenue forecast often starts with a wishful number. You put a revenue target at the top and work back to what that means per month. The problem: that number does not tell you how you get there. You know revenue has to grow, but not which actions cause it.

A growth model reverses the reasoning. You start with the building blocks you can actually influence, and those building blocks roll up into a revenue figure. The difference is causality. A forecast says: this is what we want to hit. A model says: if traffic, conversion and retention behave like this, then this is the revenue that comes out. If you want to translate that outcome into a concrete forecast of your pipeline and revenue, read how to build a realistic growth forecast.

That fits exactly with how we look at growth. Growth is not a standalone tactic but a system in which traffic, conversion, deal value and retention together form your growth engine. A growth model is simply that system, translated into numbers. If you want the bigger picture first, read our guide on what growth marketing actually involves, where we explain how those components interact.

The four layers of a growth model

Almost every B2B growth model consists of four layers that stack on top of each other. Between each layer sits a ratio: the percentage that flows from one layer to the next. Those ratios are your dials.

1. Traffic. The number of people reaching your website or landing page. Sources: SEO, paid, email, social, direct.
2. Leads. The share of that traffic that fills in a form, requests a demo or signs up. The ratio between them is your visitor-to-lead conversion rate.
3. Customers. The share of your leads that ultimately buys. The ratio between them is your sales conversion or win rate.
4. Revenue. The number of customers multiplied by your average deal value, plus the revenue that recurring customers keep generating.

Put these four layers underneath each other in a spreadsheet, fill in the ratios between them, and you have the core of your model. Change one input at the top and you immediately see what happens to your revenue at the bottom.

Here is the logic, without pinning yourself to specific numbers. Say you get visitors in a month, part of them converts into leads, part of those buys, and every customer has an average value. Multiplying those links together gives you your monthly revenue. Double your traffic and keep everything else the same, and your revenue from new customers doubles. Improve your conversion rate instead, and you pull more revenue out of the same traffic.

Step by step: building the model

Step 1: lay out your timeline

Create columns per month, for example twelve months ahead. Monthly columns work better than an annual total, because growth is rarely linear and you want to see seasonal effects or a ramp-up period.

Step 2: fill in your inputs

Put your traffic per channel at the top. Be honest here. Use your real numbers from the past few months as a starting point, not your hopes. If you have no data yet, estimate cautiously and flag that cell as an assumption.

Step 3: add the ratios

Below your traffic, put the conversion rate to leads, and below that the lead-to-customer conversion rate. Multiply the layers with each other. Keep every ratio in a separate cell, so you can adjust it on its own without breaking the formula.

Step 4: calculate through to revenue

Multiply your number of new customers by your average deal value. If you work with subscriptions or recurring revenue, add a retention layer: what share of your customers keeps paying every month. That retention often makes the biggest difference in the long run, because retained customers stack up.

Step 5: make the assumptions visible

Put all your assumptions in a separate block or give them a colour. A growth model is only valuable if everyone can see what it rests on. A conversion rate plucked out of thin air is not a forecast but a wish. By flagging assumptions you know exactly where you still need research or a test.

Retention: the layer most models forget

Many growth models stop at the first sale. That is an expensive mistake, certainly in B2B. A customer who stays generates revenue month after month without you incurring acquisition costs again. In a model with recurring revenue you see that retention does not add revenue but multiplies it over time.

In practice this means: add a row that tracks how many of your existing customers roll over into the next month. A small difference in that retention percentage produces a big difference in total revenue after a year. That is exactly why a growth model is so clarifying.

Which dial do you turn? That is what it is really about

Once your model is in place, the real work starts: playing out scenarios. Raise your traffic by a quarter and watch what happens at the bottom. Then do the same with your conversion rate, and after that with your retention. What you see is which lever has the biggest effect in your specific situation.

That answer differs per company. For one, traffic is the bottleneck and it pays to invest more in an SEO strategy to attract targeted traffic. For another, too much leaks away along the way and the biggest win sits in conversion optimisation. A growth model makes that debate objective, because you no longer argue about opinions but about numbers you can adjust together.

This is also where a growth model protects you from vanity metrics. More visitors looks good, but if your conversion or deal value is too low, your revenue barely moves. The model forces you to judge every metric on its contribution to revenue and pipeline, not on how impressive the figure looks.

Common mistakes when building a growth model

• Building it too complicated. A model with fifty tabs that nobody understands or maintains is worthless. Start with one clear tab.
• Optimistic assumptions. If every ratio is just a little too rosy, those errors stack up into a fantasy number. Better to calculate conservatively.
• Never updating the model. A growth model is a living document. Fill in your real numbers as soon as they come in and compare them with your assumptions. That is where you learn the most.
• Stopping at the first sale. Without a retention layer you miss the biggest part of your future revenue.

From spreadsheet to growth engine

Growth modeling is not an academic exercise. It is how you make growth predictable instead of dependent on luck. Once it is in place, it becomes your compass: every month it tells you whether you are on track and which dial to adjust.

The next step is connecting the model to real execution, because a forecast without a team that operates the levers stays a spreadsheet. That is exactly what we do as a growth marketing agency: we build the model and operate the dials, so that traffic, conversion and retention together become one predictable growth engine.

Want to set up your own growth model together and find out which lever grows your revenue fastest? Get in touch and we will build it alongside you.