Skip to main content
Bennet Simonton (JOOR) 님이 #Reports & Dashboards에 질문했습니다

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개
  1. 2025년 3월 25일 오후 5: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