How to predict won dates?
I was wondering if any of the more technical users have implemented a helpful algorithm for predicting the Won date of a deal?
My current draft:
Remaining days in sales cycle =
average # of days deals spend in each of the next stages in the pipeline
# of days usually spent in the current stage - # days spent in this stage so far
Some improvements I need to look at:
Average days in stage isn't accessible from the api, so I'll need to update each month manually.
Deals that have been in a stage for longer than average need a sensible guess for when they will leave that stage. I have drafted "if 8 days over the average, expect 8 more".
If anyone has experience with analysis like this I'd love to hear what solutions you came up with.