CRM Report on Lead/Opportunity Annalysis

Leads/Opportunities analysis reports is a tool to help track the indexes related to customer care service, such as the number of opportunities, expected revenue, closing rate, etc.

This article will guide you through the Leads/Opportunities analysis feature in the CRM app.

Requirements

This tutorial requires the installation of the following applications/modules:

Note

Viin CRM is a module to help you can see more different Lead/Opportunity report types such as corhort report, dashboard on CRM system. When you activate the CRM application, Viin CRM module will be automatically activated.

Install modules

Leads/Opportunities Analysis Reportings

To view the Leads/Opportunities analyze Reportings, navigate to CRM > Reporting, select Leads or Pipeline to view the respective report.

View reports CRM Viindoo

Depending on the needs of each position or the purpose of the users, you can use different charts for different purposes: for example, Graph chart to see the general changes of leads, opportunities based on different measures; Pivot for deeper analysis purposes.

Graphs and charts

You can view the Leads/Opportunities analysis reportings by using Bar chart, Line chart, Pie chart, etc. To view reports in graph form, you can navigate to CRM > Reporting > Lead/Pipeline and then click on the graph icon.

Graph icon Viindoo

Line chart

Line Chart Viindoo

Bar chart

Bar Chart Viindoo

Pie chart

Pie Chart Viindoo

Hit Measures to select the measurements to be displayed on the chart. For instance, Automated Probability.

Select measures to view the report Viindoo

Use these icons to display the data in ascending or descending order:

Sort the data in order CRM chart Viindoo

Pivot Analysis

To go to Pivot analysis, you navigate to CRM > Reporting > Lead/Pipeline and then click on the Pivot Table icon as shown in the image below. This is one of the most flexible charts.

Pivot analysis crm Viindoo

The Pivot analysis provides the following features:

  • Select different measures to view the report.

  • Export the report to an Excel file.

  • Add/Remove parameters to the column by hitting the plus sign (+) or the minus sign (-) when you want to show/hide the values of those parameters, respectively.

  • Flip the axis of the report or expand all the selected parameters.

Operate on Pivot analysis CRM report Viindoo

Cohort Analysis

In the CRM app, the Cohort analysis helps to measure the closing progress on opportunities that have been in care for a certain period of time. To go to Cohort analysis, navigate to CRM > Reporting > Lead/Pipeline and then click on the Cohort icon as shown in the image below. Each measure has a specific meaning and serves a specific purpose. Select Day, Week, Month, Year to choose the period for the leads/opportunities. For example, the chart below tracks a 15-days process of taking care of leads and opportunities:

  • In the Day period, there are 09 opportunities in total on 03/03/2022.

  • From the first day to the 12th day of the period, there is only 01 won opportunity, so the percentage is 11.1%.

  • From the 13th day to the 15th day of the period, there is 1 more won opportunity, so the percentage is 22.2%.

Cohort analysis Viindoo

To see the opportunities, you can directly hit the numbers on the table. The system will redirect you to another view. On this view, there is a list of opportunities for you to compare.

See opportunity detail Viindoo

Filter, Group By data

You can use the filters to filter the data according to your needs: for example by time period, different measures, grouping by one or more Leads/Opportunities with the same criteria, etc.

To filter or group data, hit Filters or Group by and select the criteria. Save the filter to Favorites if you want to review it at another time.

Filters and Group by report Chart CRM Viindoo