Insights reports: deal conversion
With the Insights reporting feature, you can get a deeper understanding of your sales process and pipeline performance by building customizable conversion reports to see the conversion rate when a deal moves from stage to stage or from open to closed.
Insights conversion reporting can be divided into two types of reports:
- Funnel conversion reports allow you to clearly view your deal conversion rate between stages in your pipeline.
- Win/loss conversion reports allow you to see the overall deal win and loss rates for various groups such as owner, organization and time periods.
Funnel conversion reports are always generated by pipeline and show how your deals are performing as they move through the pipeline's stages.
Creating a funnel conversion report
To create a report for your funnel conversion data, click the plus "+" sign next to the search bar, then Report > Deal > Conversion.
By default, the funnel conversion report will display each stage of your pipeline and the percentage of deals that were won from all deals created.
Viewing your funnel conversion report
Your funnel conversion report will display your overall win rate. This is the percentage of deals that you have won compared to the total number of deals in that pipeline (won deals/total deals in the first stage).
Along with the percentage of deals progressed through your pipeline, you will see a breakdown of the number of deals that should be started in order for you to win one deal, as well as your deal conversion between stages. This statistic will only show when "Number of deals" is chosen on the left-hand side of your report.
Editing or deleting your funnel conversion report
When your report is generated it will have a default filter. You can edit the default filter or add your own conditions.
The X-axis will show all of the stages in your pipeline by default, so you can view the conversion of your deals from each stage to the next. You can exclude stages from your pipeline to compare the conversion between any two stages.
The Y-axis represents the number of deals in your pipeline. This can be changed to your deal value, deal weighted value, number of deals, or any of your numerical or monetary type custom fields. Click on the number of deals to switch to any of these other options.
The win/loss conversion report displays your win/loss ratio regardless of the pipeline. Like the rest of your Insights reports, you have the ability to create filters to customize your reports.
Creating a win/loss conversion report
To create a report for your deal conversion data, click the "+" sign in the sidebar, and select deal conversion. By default, a funnel conversion report will be created, but you can change this to a win/loss conversion report by clicking the win/loss toggle at the top of the page.
Viewing your win/loss conversion report
In this report, you can view both your win and loss rates on the same graph. In order for this report to be generated, you will need to ensure that the filter is set to show deals that have been marked as won or lost.
By hovering your cursor over the bar charts, you will see a breakdown of the won/lost ratio.
Below your chart, you also have a table where you can see your data by deals or summary:
- Deals will give you a detailed list of all of the deals in your graph.
- Summary will show you information based on the field selected on the x-axis of your chart.
You can change between the Deals and Summary tabs to view your preferred data.
Editing your win/loss conversion report
We recommend generating your overall conversion reports based on the number of closed deals, so the filter for your overall conversion report will be set to this year and won/lost deals by default. If you prefer, you can change the status filter to also include open deals.
When editing the filter for your report, you can use default fields or custom fields to add filter conditions.
Your report will generate the conversion rate by Owner automatically, but it is possible to change the grouping option by clicking on the field on the x-axis.
You also have the option to edit the measurement of your conversion, which will be set to Number of deals by default. Along with the number of deals, your deal value, weighted value and custom monetary/numerical field types are supported.