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-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

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
  • 729 views
  • 0 likes
  • 2 in conversation