Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

How to create sales funel for closed opportunities (win/lost rate for each stage = stage conversion)?

By
Kos
on 4/18/14, 8:42 PM 1,037 views

Hi,

How to create sales funnel for closed opportunities (win/lost rate for each stage)? I want to see conversion rate for each stage (to see how many opportunities were lost on each stage). For example for all closed opportunities I want to see smth. like this:

  • Stage "New" - 1000 opportunities (conversion = 900/1000 = 90%)
  • Stage "Qualification" - 900 opportunities (conversion = 810/900 = 90%)
  • Stage "Proposition" - 810 opportunities (conversion = 10/810 =~1,2%)
  • Stage "Negotiation" - 10 opportunities (conversion = 100%)
  • "Win" - 10 opportunities (total conversion 1%)
  • "Lost" - 990 opportunities (99% of all closed opportunities)

So, in this report I could see that I have 1000 closed opportunities, 910 of them were lost and 810 of them were lost at "Proposition" stage (conversion for this stage is vary bad ~1,2%). So it's seems to be a problem on "Proposition" stage.

Here is a good example of sales funnel for closed opportunities: screenshot i062.radikal.ru/1404/ff/7a610e7c1690.png (sorry I haven't got enough carma to post img)

Hello did you get any positive answer ? Many thanks

DOMALYS
on 4/8/15, 9:42 AM
0
Hesham ELMAHDY
On 12/13/14, 9:37 AM

Logically, you would do that only for lost opportunities. But the won one have already gone through all stages to the end. Hence, henever an opportunity is closed as lost, the counting must take place.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 4/18/14, 8:42 PM
Seen: 1037 times
Last updated: 4/8/15, 9:42 AM