The opportunity process in Salesforce contains functions that you don’t necessarily run across until you report on them. Here are a couple of easy formulas for reporting on sales performance – right out of the box.
Calculating the win rate
Number of opportunities won per number of opportunities closed. These numbers come from the opportunity process where you determine which stages are marked as “Open”, “Closed” or Closed Won”. Note – this means that “Closed” includes BOTH won and lost opportunities.
Number of closed opportunities per total number of opportunities.
CLOSED:SUM / RowCount
This one is a bit trickier because it requires knowledge on how the opportunity standard fields function. After that it becomes relatively simple.
This compares all closed opportunities based on Expected Revenue to Amount. The Expected revenue field is a standard opportunity field that shows what the expected amount on the opportunity is.
1) If an opportunity is “Closed Lost”, the Expected Revenue is 0 Euros. (0% of the amount)
2) It the opportunity is “Closed Won”, the Expected Revenue = Amount (100% of the amount)
3) Amount of course always shows the value of the opportunity regardless of the opportunity status
Senior Business Consultant, Fluido