Conversion rates between deal stagesSOLVE
Feb 20, 2020 8:58 AM
I'm not sure if i'm just interpreting this wrong, but I'm having difficulty calculating the actual conversion rates between each deal stage.
I.e 100 deals get created, and 70 of them move to the next stage = 70% conversion rate.
50 of those remaining 70 deals move to the next stage = 71% conversion. And so on, until Deal won or deal lost.
I can pull a report that just takes two astages, and select deals that have been in ALL stages, which although a bit manual, I thought would give me the correct conversion rates. But! This does not take into account any deals that skip stages.
What I really need, is All opportunities that have been in "Deal stage 1" AND, ANY of all following stages, except Lost. Then "Deal stage 2", AND, ANY of all following stages, except LOST. and so on.
Has anybody else done this? Or is there another way to look at it that I'm missing?
Solved! Go to Solution.