When we published the Gain More Insight Into Sales With 3 Types of CRM Reports post, CRM user Wendy Wright wanted to know, “What % of leads were closed/won in the last month?” (i.e., how to know the total number of leads got, to those that finally got converted to sales)
This is where the Advanced Analytics Add-on for Zoho CRM, powered by Zoho Reports, comes in. It helps CRM users to slice and dice data, and get actionable insights.
Coming to Wendy’s question, what we first do is create an SQL query table, which combines the Leads and Potentials modules data. What the below query table does is it gets all the records from the Leads table, uses the UNIONALL SQL function to combine it first with total potentials, followed by won potentials.
And then we create the Sales Funnel Report, by drag-and-drop of the appropriate columns.
The above Sales Funnel Data query table and the Sales Funnel Report are part of the CRM demo database (they are under the Sales Reports folder).
You too can create a sales funnel report or any other ad hoc report you may need, using advanced analytics. Trying the Zoho CRM Advanced Analytics Add-on is simple. Login to Zoho CRM, and visit any page under the Reports or Dashboards tabs. Click the Configure Advanced CRM Analytics link at the top-right and go from there (note that Advanced Analytics can be configured by any CRM ‘Administrator’).