{"id":4270129,"date":"2014-05-22T08:12:03","date_gmt":"2014-05-22T06:12:03","guid":{"rendered":"https:\/\/www.deptagency.com\/insight\/forecasting-monthly-run-rate-right-way\/"},"modified":"2025-12-08T13:45:02","modified_gmt":"2025-12-08T11:45:02","slug":"forecasting-monthly-run-rate-right-way","status":"publish","type":"article","link":"https:\/\/www.deptagency.com\/en-au\/insight\/forecasting-monthly-run-rate-right-way\/","title":{"rendered":"Forecasting by monthly run rate: Do it the right way"},"content":{"rendered":"
\n\t\n\t<\/svg>\n\t\t\t\n\t\t\tBack to all articles\t\t<\/span>\n\t\n<\/button>\n\t\tForecasting by monthly run rate: Do it the right way\t<\/h1>\n\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/picture>\n\t\n\t<\/div>
\n\t\t\t\n\t\n\t
\n\t\tFeliks Malts\t\t
\n\t\t \n\t\t\t<\/div>\n<\/div>\n\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\tDate\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t22 May 2014\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t<\/div>\n<\/div>\n\n
\n\t
\n\t\t\n\t\t\t\t\t
\n\t\t\t\t\n
\n\t\tMonthly spend forecasting can often be a thorn in the side of a search marketer, as it is not always an easy question.\u00a0 For today\u2019s article, we will be focusing on calculating monthly run rates, and two relatively simple ways to do so.

The first, and least accurate, method involves just looking at a certain lookback, calculating the daily average spend, and applying that to the remaining days in the month.\u00a0 I don\u2019t need to tell any of you the big reason this could be inaccurate, but I am going to anyway.\u00a0 This approach does not take into account the remaining days of the week, which can be a massive factor in almost any account.

To adjust for this, I prefer using a second approach that takes into account average spend by day of the week, and apply that to the remainder of the month.\u00a0 This becomes more valuable as you get deeper into the month and fewer days remain to be forecasted.\u00a0 The approach might sound tedious, but Excel makes it quite easy.\t<\/p><\/div><\/div>\n\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\n\t