A case study from a VP of Marketing & Sales.

Most businesses of any meaningful size track performance through KPIs — revenue, costs, cash flow, and balance sheet items. But tracking a number and truly understanding what it’s telling you are two different things. This is especially true when you’re trying to make sense of sales performance across a typical five-year business cycle.

To illustrate why, let’s follow a VP of Marketing & Sales as she looks at five years of monthly revenue data and asks four questions that matter to any sales leader.

The four questions every VP of Sales is asking

• Are sales developing positively over time?
• Is there any seasonality in the sales numbers?
• Is the company on track against budget — and how early can corrective action be taken?
• What impact are marketing activities actually having on sales?

The company in our case study has monthly sales of around five million euros. Looking at a raw monthly sales chart, it’s immediately apparent that none of the four questions above can be answered with confidence. The data is too noisy. We need to transform it.

Step one: accumulated monthly sales

A common approach is to accumulate monthly sales throughout the year and compare the running total against the budget or against the previous year. In our case study, year five’s accumulated sales track closely alongside the prior year, recover somewhat in July, and close the year at 58 million euros — just short of the previous year’s result.

This is useful, but it still doesn’t reveal any trend. You can see where you’ve ended up, but not where you’re heading. For that, we need to go one step further

Step two: the rolling 12-month method

The rolling 12-month (R12) method works by accumulating sales across a moving 12-month window. Starting from the first month of the dataset, you sum 12 consecutive months of sales and record the result. Then you drop the oldest month, add the next one, and repeat. Every point on the resulting chart represents a full year of sales — giving you an always-current, always-comparable view of performance.

For our VP, the R12 chart immediately reveals something the monthly and accumulated views couldn’t: the company experienced a sharp initial drop in the five-year cycle, then recovered steadily, with annual sales trending positively over the last two years before peaking five months ago.

Back to the four questions — now with answers

Are sales trending positively?

Yes — the R12 chart shows a clear upward trend over the past two years, with a peak five months ago. The direction is visible at a glance.

Is there seasonality?

No — and that’s an insight in itself. The absence of seasonality is a direct, actionable input for marketing strategy and budget planning.

How early can corrective action be taken?

Against a full-year budget of 60 million Euro, the company fell short by 2 million. But crucially, the R12 chart showed the decline two months before year-end — enough time to launch a targeted promotional campaign rather than simply absorbing the miss.

What’s the impact of marketing activity?

Market research indicated flat growth in the broader market. The VP’s view — supported by the R12 trend — is that the company’s aggressive marketing investment in earlier years is the primary driver of its outperformance. Without the R12 view, that connection would have been far harder to see.

R12 goes beyond revenue

The rolling 12-month method isn’t limited to sales. It can be applied to any KPI tracked over time — costs, margins, customer numbers, and more. It also enables you to calculate rolling year-on-year growth rates and benchmark performance against market growth, giving you a richer, more complete view of where your business stands.