BookmarkSubscribeRSS Feed
sassygrl
Calcite | Level 5
Hello,

I am trying to forecast future web sales for my company. A subset of that is "keycoded" revenue that can be traced back to particular advertising campaigns. The marketing dept. produces forecasts for keycoded revenue, and I would like to use those as an explanatory variable to predict overall web sales.

My concern is this: there is almost a perfect relationship between *actual* keycoded revenue and *actual* overall web sales. Obviously, I won't have the benefit of knowing future actuals when making forecasts; I will have *forecasted* keycoded revenue instead.

So my question is, would you prefer to use historical actuals or historical forecasts of keycoded revenue when developing the forecasting model?

I hope this wasn't too confusing. Thank you!
1 REPLY 1
udo_sas
SAS Employee
Hello -
I'm not completely sure I'm getting your point, but here are some thoughts anyway:
when using explanatory variables in your models it will be crucial to have future values of these variables in order to calculate the forecast for the dependent variable.
As such I think I would go with actual numbers, as they reflect what was happening in fact - not the "wishful thinking" of ours.
What you will need to do is to create forecasts for your independent variable first (if you don't have future estimates - or use the forecasts of your marketing folks as future values) and then create the prediction of the dependent variable.
In fact, you might consider doing a what-if analysis, i.e. testing what happens if you change the future values of your dependent variables.
Note that this is an out-of-the-box feature of SAS Forecast Studio - which is part of SAS Forecast Server.
Thanks!
Udo

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1219 views
  • 0 likes
  • 2 in conversation