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.
Feb 20, 2020 10:50 AM
Just incase you want to give this a try...
-Go to Reports (Select reports)
-Click Create Custom Report
-Select the funnel report
-Select Deals, and click Next
-Pick the pipeline you wish to leverage for this report.
-Add all the related pipeline stages you wish to track however the difference between this as the conversion report is that you adjust as shown below to Any stage. This won't have conversions but will give you totals of deals to move into this stage over the period of time you have filters.
Hope this helps a bit,