Skip to main content

Hello,    I want to analyze the win rates for all opportunities that had a close date in a given quarter. In my Salesforce reports, the data is grouped based on the current close date, which means it doesn't account for deals that have been pushed to a later quarter. For example, if we have 10 opportunities with a close date this quarter, and 5 of those were won, the win rate would show as 50%. However, in reality, we may have had 15 opportunities that were initially in play—5 of which were pushed to the next quarter—so the actual win rate, including those, would be 33%.    Any thoughts on how to do this within salesforce without using other tools?    - Bennet   

2 respostas
  1. 25 de mar. de 2025, 17:00

    "For example, if we have 10 opportunities with a close date this quarter, and 5 of those were won, the win rate would show as 50%. However, in reality, we may have had 15 opportunities that were initially in play—5 of which were pushed to the next quarter—so the actual win rate, including those, would be 33%. "

      

     

    For that you would need to already have a mechanism in place that would record that at some point the Opportunity "was due" to Close in the current Quarter, but no longer is.   

    The standard CloseDate field is only gonna have 1 value in it, the current CloseDate.   

    So you'd either need a custom field, or use a Report Type like Opportunity History, or Opportunity Trends, or create a Report Snapshot