Spending Enough on Advertising? How to Forecast Ad Spend

Check Out Your Historical Ads Data

How can you perform a predictive spend analysis? The best way to forecast ad spend is to take a look at the status quo. Pull your advertising program data for the last 12 months, including ad spend, orders, revenue, and cost of goods. (If you’re not accounting for the cost of goods in your advertising strategy, you should be. Read this whitepaper to see why!)

Now, you can calculate profit driven by your ads, and the percentage of revenue that was preserved as profit, otherwise known as contribution margin. 

As an example, let’s consider the following retailer, which primarily sells hockey gear. 

In the above table, you can see that profit varies across ad groups. Some, like CCM RobCor Hockey Stick, produce a lot of profit — 30% of revenue! On the other hand, the ad group for Bauer Supreme Elbow Pads isn’t creating any profit at all. In fact, this ad group is losing money for the program.

Forecast Your Ideal Ad Spend

Now, you need to figure out whether your previous ad performance maximized profit — or if you missed some opportunities along the way!

We typically recommend evaluating your current target margin, compared to the total available margin. What percentage of available margin was invested as ad spend? Are you comfortable with that percentage, or do you need to aim higher or lower?

Looking again at the example, you can see target margins are now included for the hockey retailer below.

Here, the percentage varies widely according to the cost of goods for each ad group. Obviously —you can’t preserve more as profit than is available to you after accounting for cost of goods, and realistically you need to set some aside as ad spend as well.

We usually recommend aiming for very minor changes at first, unless the ad group itself is entirely unprofitable. In that case (assuming you don’t want to simply break even on your ads), take a look at your individual business goals, and develop a target from there. If you’re not sure where to start — check out this guide to choosing contribution margin!

See Where You Missed The Mark

Compare the results from last year to your ideal scenario. Did your campaigns hit their targets?

Now, you can calculate the spend you would have needed to meet those targets using a predictive spend analysis. (Hint: It might be more or less, depending on your targets and how close you were to meeting them.) To do forecast ad spend, calculate the percentage of revenue that would have been a) cost of goods, and b) your profit. The remainder is what you would have needed to spend on ads to achieve your ideal profit!

Let’s return to our example.

You can see this retailer needs to increase spend in some places to match margin targets (like the CCM RibCor Hockey Stick group) and reduce spend in others (like the Warrior Alpha Hockey Gloves group.)

Taking the Next Steps in Predicting Ad Spend

Did you spend enough on advertising — or did you leave profit on the table?

Analyzing last year’s performance is really only half the story. If you want to see the impact this additional spend will have on your revenue and profit in the upcoming year, continue on to a predictive spend analysis! This report models the effect additional spend will have on your campaigns, giving you the full picture of your program’s potential.

Read our whitepaper, Predictive Spend Analysis: How to Forecast Cost and Revenue, to learn how to model the impact of changes in spend!

Did you find this article helpful?

Get more delivered to your inbox just like it!