I'm working on developing a model to predict total sales of a product. I have about a year and a half of bookings data, so I could do a standard time series analysis. However, I also have a lot of data about each 'opportunity' (potential sale) that was either closed or lost. 'Opportunities' are progressed along stages of a pipeline until they are closed or lost; they also have associated data about the prospective buyer, sales person, interaction history, industry, estimated size of bookings, etc.

My goal is ultimately to predict total bookings, but I want to account for all of this information about the current 'opportunities' which are the true 'root cause' of bookings.

One idea I have is to use two different models serially as follows:

  1. Use historical 'opportunities' to build a model that predicts the bookings arising from an individual 'opportunity' (I'd probably use random forests or even plain old linear regression for this step).

  2. Use the model from 1 to predict the estimated bookings of all 'opportunities' currently in the pipeline, then sum those estimates based on the month each 'opportunity' was created.

  3. Use a time series model (possibly ARIMA?), using the 1.5 years of monthly historical time series data AND the predicted (using the model from 1) total bookings for all 'opportunities' created in that month.

Granted there would be a lag in those opportunities converting to actual bookings, but the time series model should be able to deal with the lag.

How does this sound? I've done a lot of reading on time series and predicting sales, and from what I can tell this is a somewhat unique approach. Therefore I'd really appreciate any feedback!

  • $\begingroup$ You seem to be pretty cavalier about the model of step 1. If this isn't done well enough that impacts the rest. Be sure about your model. How do you measure if time and opportunities are your only inputs? How do you account for economic climate, sales effectiveness, or how prepared the market is? The cost of materials? Manufacturing costs? What are all of the inputs? Output is what? Is it mean and variation for estimated sales? Try several cousin products, not just one. Make a consistent domain and range. If you are living in cumulative, then live only there. $\endgroup$ Jun 25, 2013 at 20:07
  • $\begingroup$ Yep, definitely getting a bit ahead of myself. Thanks for your input. I play with incorporating some economic indicators in to the model of step 1. $\endgroup$ Jun 25, 2013 at 20:44
  • 1
    $\begingroup$ Would you like to share how you finally approached your model building exercise ? $\endgroup$
    – user75202
    May 4, 2015 at 6:00

1 Answer 1


You may end up with a model which seems to fit your current data OK, but it will come unstuck as soon as you try and produce an out-of-sample forecast. Consider producing your forecast for 6 months time. You have no way of knowing what the opportunities will be in six months, so you are going to have to create another set of models predicting each of of the inputs to your opportunity model. And, once you do this you are going to have lots of models feeding into your main model, but each of the little models is going to have its own prediction error attached to it,and these will be compound, but your main model will not know about these, and, as a result, all your prediction intervals will be grossly deflated.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.