Zoho CRM Advanced Analytics Solutions Catalog

This page catalogs a very useful set of analytics solutions that will guide you in creating reports for widely asked Key Sales Performance metrics over the Zoho CRM data. If you need a solution that is not listed here and you are finding it difficult to achieve, please write to us at support@zohoanalytics.com. We will be happy to help you.

You can also check out our complete documentation on Zoho CRM Advanced Analytics.

  1. How can I calculate sales Win Rate % and Loss Rate % from potentials/opportunities?
  2. How can I create Year-over-Year or Quarter-over-Quarter or Month-over-Month growth reports?
  3. How can I create a Sales Pipeline Funnel Chart?
  4. How can I create reports to view Average Sales Cycle?
  5. How can I create Top 5 or Bottom 5 Sales Person report?
  6. How do I create Target (Quota) based reports in Zoho Analytics?
  7. How to create leads to opportunities conversion funnel?
  8. How can I calculate a Lead to Potential Conversion rate?
  9. How do I calculate the Average Time Taken to Convert a Lead to Potential?
  10. How can I calculate the Profit Margin?
  11. How do I calculate the Number of Activities per Account?
  12. How do I construct an Inventory Sales Funnel?
  13. How can I calculate the Average Duration of a Winning Deal?
  14. How can I analyze my sales history to optimize my sales?
  15. How do I perform Sales Team analytics?
  16. Marketing Lead Analytics: How do I improve the quality of my leads?
  17. How can I create a cohort to analyze customer retention?
  18. How is a sales cohort useful in keeping track of the team's performance?  
  19. How do I measure the conversion rate of my leads to potentials using cohorts? 
  20. How can I create a cohort to calculate the win rate?
  21. I am unable to view the Parent Account Name of an Account in the Accounts module (table). How do I display the Parent Account Name column in the Accounts table?
  22. What types of report can I create by combining Zoho Books and Zoho CRM?
  23. What are the insights that I can derive using the activities module?

Solutions

1. How can I calculate sales Win Rate % and Loss Rate % from potentials/opportunities?

2. How can I create Year-over-Year or Quarter-over-Quarter or Month-over-Month growth reports?

3. How can I create a Sales Pipeline Funnel Chart?

4. How can I create reports to view Average Sales Cycle?

5. How can I create Top 5 or Bottom 5 Sales person report?

6. How do I create Target (Quota) based reports in Zoho Analytics?

7. How to create Leads to Opportunities conversion funnel?

8. How can I calculate a Lead to Potential Conversion Rate?

9. How do I calculate the Average Time taken to Convert a Lead to Potential?

10. How can I calculate the Profit Margin?

11. How do I calculate the Number of Activities per Account?

12. How do I construct an Inventory Sales Funnel?

13. How can I calculate the Average Duration of a Winning Deal?

14. How can I analyze my sales history to optimize my sales?

In CRM, the analysis of sales history by stages plays a vital part. A sales stage history gives you the number of potentials in each stage for a particular time period. The Advanced Analytics connector for Zoho CRM auto generates reports such as the number of potentials in each stage, stage-wise conversion, average duration of won or lost deals etc. Read our blog "Sales Pipeline Optimization through Stage History Analysis" to know more.

15. How do I perform sales team analytics?

You can create various reports to analyze the performance of your sales team. For example, you can create a funnel chart to depict how each salesperson has fared in converting the potentials from one stage to another or you can create a pivot to examine the overall performance of the team in terms of the revenue generated and revenue lost. Read our blog "The Essential Sales Analytics Reports – Sales team" Analytics to know more.

16. Marketing Lead Analytics: How do I improve the quality of my leads?

Improving the quality of your leads directly influences sales. Integrating the lead management process with data analytics can bring in quality leads for your company. Read our blog "Marketing Lead Analytics with Advanced CRM Analytics" to learn how!

17. How can I create a cohort to analyze customer retention?

18. How is a sales cohort useful in keeping track of the team`s performance?

19. How do I measure the conversion rate of my leads to potentials using cohorts?

20. How can I create a cohort to calculate win rate?

21. I am unable to view the Parent Account Name of an Account in the Accounts module (table). How do I display the Parent Account Name column in the Accounts table?

The Parent Account Name data will be a self-lookup of the Account Name data in Zoho CRM. When you import the Accounts module into Zoho Analytics, the Parent Account Name data will be linked to the Account Name data. You need to write a query to segregate the Parent Account Name data from the Account Name column.

SELECT

                 pa."ACCOUNTID" as "Parent Account ID",

                 pa."Account Name" as "Parent Account Name",

                 ca."ACCOUNTID" as "ACCOUNTID",

                 ca."Account Name" as "Account Name",

                 ca."Account Type" as "Account Type",

                 ca."Industry" as "Industry",

                 ca."Website" as "Website",

                 ca."Tasks Involved" as "Tasks Involved",

                 ca."Events Involved" as "Events Involved",

                 ca."Calls Involved" as "Calls Involved",

                 ca."Activities Involved" as "Activities Involved",

                 ca."Created Time" as "Created Time",

                 ca."Modified Time" as "Modified Time"

FROM "Accounts" AS  ca

LEFT JOIN "Accounts" AS  pa ON ca."Parent Account ID"  = pa."ACCOUNTID

You can also add the other required columns to the query table using the function ca."<Required column name>" as "<Name to be displayed in the query table>".

Note: In the above query, we have performed the ALIAS operation and renamed the column names. This is done to avoid any confusion as both the Parent Account Name and Account Name are available on the same table. Here, ca represents the child account table and pa represents the parent account table. 

22. What types of report can I create by combining Zoho Books and Zoho CRM?

Zoho Analytics allows you to seamlessly integrate your Zoho Books and Zoho CRM data and create insightful reports like deals to invoice funnel, expense report etc.
Read this blog topic on Why your sales team needs finance reports to learn more.

23. What are the insights that I can derive using the Activities module?

Zoho Analytics advanced analytics add-on for Zoho CRM provides you with more than 25 auto-generated reports to analyze activities data, gain insight, and visualize your sales execution in a snap. Read this blog post to learn more.