web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Opportunity Close Won ...
Microsoft Dynamics CRM (Archived)

Opportunity Close Won Ratio

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I'm looking to create a report that shows the "closed won" ratio of all the opportunities a rep has opened. I would also like to take this further and understand what percent of the opportunities close won at each pipeline phase.

I don't think this should be too difficult as it is something all sales teams would want to know I'm sure? Is there an out of the box solution to that or is it going to be custom?

Thanks in advance for your help! 

AJTbenanbar

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Opportunity Close Won Ratio

    Hi,

    Can you please read below thread.

    community.dynamics.com/.../108149

    Mansoor

  • Suggested answer
    Nikica Profile Picture
    Nikica 311 on at
    RE: Opportunity Close Won Ratio

    And Wizard is only subset of fetchXML, so not possible with that too.

    For online, I see possibility to make Webresource (HTML/javascript) doing it, or to have e.g field where plugin or will calculate it.

  • Suggested answer
    Nikica Profile Picture
    Nikica 311 on at
    RE: Opportunity Close Won Ratio

    Which technology you are using? Wizard, SSRS or FetchXML? I'm not reporting expert, but it looks to me only feasible with SSRS (and that's feasible only  on-premise). If you are using other technologies, I don't see the way to have e.g. count of won, count of lost and then do divide these two numbers.  Here is topic where you can find that it is not possible for FetchXML community.dynamics.com/.../231386

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Opportunity Close Won Ratio

    Hi AJT,

    is not difficult to build a report:

    you can lookup at this video https://www.google.it/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwiWoJG_pLzXAhXJcBoKHZktA2EQtwIIJjAA&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DS48JPPNL0iQ&usg=AOvVaw089mPzHucYjyR6Lc9PwQHF 

    Hope it helps!

    If you found the answer helpful, please mark as Verified 

    Join my network on LinkedIn      Follow me on Twitter 

    Thank You & Best Regards

    Francesco Picchi

    Microsoft Dynamics CRM Consultant, Bologna, ITALY

    Independent Contractor

    http://www.francescopicchi.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#2
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans