Probability for a deal to win
Hi all,
I currently have a large dataset of deals that are either 'open', 'lost', or 'won'. Most deals that are won will take approximately 2-3 months.
I want to essentially forecast the subtotal of won deals in the next few months, but I'm having trouble setting up my model. Namely, I'm having trouble incorporating the 2-3 month average time for deals to be won. Because the probability for a deal to win increases with time, before it hits around 3 months and then it starts decreasing with time.
Does anyone have any ideas? I managed to implement a super basic model within my BI tool that follows a normal distribution, but I'm looking for something more robust. Thanks in advance!
Posted Sep 30, 2021, 8:10 PM UTC
Have you tried fitting any models yet? Other than the BI tool one
The thing is, you seem to be basing this model off of time as your only parameter? I'm not convinced you'll ever get a good output from this alone. Sales deals are subject to a lot of stochastic events that make them incredibly difficult to predict (maybe your top sales rep got a better offer and jumped ship, taking the guts of the team with her)
You'll want to include other predictors here. Not sure what those would be, maybe performance of a sales team, win rate for a particular customer or product, addressable market etc
Also going back to the business question, what value does prediction give you here? Ok so you hit in and around the predicted value each month and the model works well...so what?
Perhaps instead of predictive models you should be looking at inference models, such models that would highlight opportunities that are more(or less) likely to win, allowing the teams to try focus on the opportunities with a greater win probability, which opportunities to send to put on the backburner etc
Thanks for the reply! I should have been more specific, but yes I'm including predictors (win rates based on country, agents, markets, etc). The point of the prediction is to predict inventory stock, the plan is to use the probability to get some idea on what our demand will be like for certain materials for our products. That's why I want some kind of tangible 'expected quantity' from my model.
The thing that jumps to mind is a logistic regression, but I'm still having trouble applying this 'probability distribution' I have, where deals only begin to have a high P(win) a few months after it gets entered in our system.