Expected Close Date, Likelihood, and Forecast Reports
Y
Yusuf Young
In almost every other CRM, it is possible to enter not only close value, but also expected close date, a percentage of how likely it is to close (with each stage in the pipeline having its own default % value unless you change individual opps manually), and and along with that be able to get some reports of forecasted close values on various dates (possible to filter by pipeline).
Please enable this since this will be a crucial thing for a B2B CRM.
Log In
P
Pallavi Kothari
Merged in a post:
Forecasting
M
Matt West
I want to be able to see quarterly sales and break this down for each Q next year for example. The CRM is very basic and two clients are keen to move to the free version of HubSpot instead. Happy to chat to someone about what more it needs
P
Pallavi Kothari
Merged in a post:
Estimated Close Date
E
Ed Erickson
Add a field for estimated close date to opportunities
P
Pallavi Kothari
Merged in a post:
Pipeline forecasting! How is it possible there's no way of knowing pipeline is values?
J
Jessi Johnson
I know each stage shows the total "closed" value. However, that's only if the deal closes. Not all deals close. If a lead is brand new and it has a $15,000 funded value. If 10% of your leads fund, that lead is currently worth $1,500. That is the actual value of your lead in your pipeline, not $15,000. There should also be a total of all actual value stages to show the current pipeline value. How else do you gauge the current value?
P
Pallavi Kothari
Merged in a post:
sales probability and forecasting
A
Aurora ADMIN
We'd like to have an assigned sales probability to each deal or opportunity in the pipeline.
We’d like to manage our sales forecasting more accurately by attributing a conversion likelihood (%) to each stage or individual deal.
Additionally, we’re looking for a way to calculate sales forecasts based on current pipeline opportunities, ideally taking into account the assigned probabilities to estimate potential revenue.
P
Pallavi Kothari
Merged in a post:
Revenue Forecasting via Weighted Value Pipeline Stages x Opporunity Value
T
Tyler Zegil
Each pipeline should tell you how much money is in it by weighting the chance of success in each stage against the opportunity value.
Here's how..
There's a new section at the top of a pipeline that says Total Pipeline Value: $???
There's a field for % at the top of each pipeline stage
There's a Weighted Value field at the top of each stage
Some pipelines are linear (step 1, 2, 3, 4 etc). Some piplelines are non-linear because they have steps that don't need to be done in any particular order, we just need to track what step they are on and complee a checklist of things. When creating a pipeline there would be an option for Revenue Based Pipeline, no, yes. If no then no opportunity value is shown on the opportunity cards (or they stay there for easy coding and just don't do anything more than what they do now). If yes, the another question shows up for Pipeline Style.. the options for that..
- linear
- non-linear
If linear is selected, the user fills the percentage field at the top of each pipeline stage with the chance at which opportunities will move from this stage to the next
- each opportunity in a stage is given a weighted value by multiplying the opportunity value by the chance rate in the percentage field, those weighted opportunity values are added up..
- that sum is then subsequently multiplied by each remaining stage's percentage field to the right in the pipeline
- the final weighted value is placed in the Weighted Value field for that stage
- same thing is done for each subsequent stage, Weighted Value fields are then added together, and that is the value that goes in the Total Pipeline Value field at the top
If non-linear is selected, the user fills the percentage field at the top of each pipeline stage with the chance an opportunity is likely to close after completing that stage. This would work the same as the previous formula except you would not include the linear step 2..
- each opportunity in a stage is given a weighted value by multiplying the opportunity value by the chance rate in the percentage field, those weighted opportunity values are added up..
- the final weighted value is placed in the Weighted Value field for that stage
- same thing is done for each subsequent stage, Weighted Value fields are then added together, and that is the value that goes in the Total Pipeline Value field at the top
P
Pallavi Kothari
Merged in a post:
Enhanced Pipeline Forecasting
T
Todd Masters
it would be nice to add weighting in a percent of the stages in a pipeline to know what the total forecast will be for a given pipeline. Such as the first stage being 10% probability and next stage would be 30% etc up to won at 100% so we can know the true forecasted value of our pipeline and report a forecast by stage.
R
Rich Ribeiro
This would be very neat! Great explanation and breakdown.
J
Jessi Johnson
Agreed, what is the point of associating a value on every deal that assumes 100% of deals complete.
J
Jessi Johnson
Agreed, forecasting is nonexistent
Load More
→