How to Build Zoho CRM Dashboards Your Team Will Actually Use

Zoho CRM's built-in dashboards have come a long way. A few years ago we'd move almost every client straight into Zoho Analytics because CRM reporting was too limited. Today it's the other way round: for most sales and marketing teams, dashboards inside Zoho CRM do the job — and they're far easier for a team to live with day to day.

This guide walks through building a dashboard from scratch, component by component, with the settings that make the difference between a dashboard people check every morning and one nobody opens after week two. It's written up from our Zoho CRM reporting and dashboards masterclass.

Dashboards, analytics and Zoho Analytics: which is which?

You'll see two names for the same thing. Depending on when your account was created, Zoho CRM calls this area either Analytics or Dashboards — they're identical. Separately there's the Reports module, which gives you the more traditional, spreadsheet-style pivot reports.

Zoho Analytics is a different application altogether: a Power BI-style tool that can pull in data from outside Zoho CRM. It's more powerful, but with that comes complexity. If everything you need to report on lives in Zoho CRM, start with CRM dashboards.

Step 1: Create the dashboard

From the Dashboards (or Analytics) view, create a new dashboard and give it a name. You'll get a sidebar of component types you can add. Most components follow the same pattern — pick a module, pick a measure, pick a time field and a period — so once you've built one, the rest come quickly.

One quirk worth knowing: after you save a new dashboard for the first time, cancel out of the editor rather than saving again. Saving twice makes Zoho think you're creating a second dashboard with the same name and it throws a duplicate-name error.

Step 2: Start with KPI widgets

The simplest useful component is a KPI showing, say, deals created this month. Choose the KPI component, then:

• Module: Deals (or Leads, if you want leads created).
• Measure: Count of deals — or sum, minimum, maximum or average of the amount.
• Duration: based on Created Time (a system field every record has), set to This Month. Use Closing Date instead if you want deals expected to close this month.

The setting almost everyone gets wrong

KPIs let you compare against the previous period. If you choose plain Previous Period, then halfway through the month you're comparing 15 days of this month against all of last month — so the widget glows red for most of the month even when you're on track.

Switch it to Previous Period (Relative). That compares the 1st to today against the same number of days last month — a genuine like-for-like comparison. If your business is seasonal, use Same Period Last Year (or its relative version) instead, so a quiet January isn't judged against a busy December.

Step 3: Add scorecards to see where results come from

The scorecard KPI is one of the most useful components in Zoho CRM. It's a KPI with a ranking attached. For example, to see where this month's leads came from:

1. Choose the Leads module and Count of Leads.
2. Set the duration to Created Time, This Month, compared to the previous period (relative).
3. In the ranking section, group by Lead Source and show the top 10.

Every number on a Zoho CRM dashboard is clickable, and this is where the built-in dashboards beat Zoho Analytics: click a lead source and you get the list of leads behind the number, then click straight into any record. Cloning a scorecard and grouping by Created By (for records created) or by owner with a filter of Stage is Closed Won (for deals won) quickly shows who's generating deals versus who's closing them.

Step 4: Use related modules for richer charts

For charts, use Chart → Quick Create. Say you want open deals by lead source. The catch: lead source usually lives on the lead or contact, not the deal, so it won't appear in the deal's grouping options.

This is what related modules are for. They let a report pull in data linked to the main module. If your deals come from converted leads, choose Converted Leads as the related module — converted leads still exist in the background, just hidden — and Lead Source becomes available as a grouping.

A few settings worth adding to charts:

• Component filter — adds a filter icon so viewers can slice the chart, for example by deal stage.
• Sum instead of count — change the measure to sum of amount to see value rather than volume.
• Sort by value (descending) and a target line — both hidden under the easy-to-miss "more options" link. The target line gives you a quick benchmark against a quarterly or annual goal.

Put an "open deals by lead source" chart next to a "closed-won value by lead source" chart and a story appears. A source that generates millions in open pipeline but no closed deals is telling you something — perhaps you're attracting the wrong people, the marketing message is off, or something in the sales process is putting those leads off.

Step 5: Try the other chart types

Zoho defaults every chart to a column chart, and the other types are tucked away in the top-right corner of the editor. Two we use constantly:

• Funnel chart grouped by deal stage — an instant view of how value (or deal count) is spread through the pipeline.
• Heat map grouped by day of month and month. It shows hot spots at a glance. Plot deals closed and you'll often see the last week of the month or quarter light up as the team rushes to hit target; plot notes created and you'll often find a Friday-afternoon spike where meetings from the whole week get written up at once.

Step 6: Compare your team with comparators

The comparator is the report sales teams ask for more than any other. Columns are the things you're comparing — usually users — and rows are the KPIs. A typical set:

• Leads created — count of leads, compared on Created By rather than owner, so the person who created a lead keeps the credit if it's reassigned.
• Leads converted — filtered to Is Converted, using converted time.
• Deals created — from the Deals module.
• Notes created — Leads module with Notes as the related module, compared on note owner.

Comparing leads converted with deals created is revealing. In a well-run system, converting a lead should always create a deal or link to an existing one. If you're converting hundreds of leads but creating a fraction as many deals, prospects are falling into the contacts module and being forgotten.

A tip for measuring sales activity: ask the team to title notes from meaningful sales interactions "MSI". Then add a comparator row that counts only notes titled MSI, and you're measuring real conversations rather than every logged call.

Comparators are limited to five KPIs and five columns. If you have six salespeople, clone the component and split the users (or KPIs) across the two copies.

Step 7: Measure conversion with funnels and stages

The Funnel component shows conversion across your whole process — for example lead created, lead converted, deal created, deal won — with the conversion rate between each step and overall. Add Classified By: Lead Source and you get the conversion rate for every source. That matters: judging marketing by the number of leads it creates tells you little. A campaign that brings in a thousand leads and no sales wasn't a success.

The Stages component works within one module that tracks stage history (in most systems, Deals). You set an expected number of days a deal should sit in each stage, and the report splits each stage into deals that have moved, deals still within the window, and stalled deals that have sat too long. Add the deal owner as a component filter and it becomes a one-to-one coaching tool: some people are strongest at booking meetings, others at closing.

Step 8: Targets and anomaly alerts

A target meter is a KPI with a goal — set one for the whole organisation or individual targets per salesperson, and adjust the red, amber and green zones.

The anomaly detector is underused. It learns the normal pattern of, say, daily leads created, and emails you when something falls outside it. We set one up for a client that normally received around ten leads a day; when they suddenly had three days with none, the alert led us to a broken website form nobody else had noticed.

Step 9: Put it where people will see it

• Add to home page. Any dashboard component can be pinned to the Zoho CRM home page. This is the single best way to make sure a dashboard gets used — the numbers are in front of the team every time they log in.
• Share and lock. Dashboards are private by default. Share with all users or specific users, and tick lock this dashboard so only you can edit it.
• Dashboard filters. Add a filter to the whole dashboard (for example, lead source) and every compatible component updates at once.
• Presentation mode and embed links for putting a dashboard on an office screen or an intranet, plus export to PDF or Excel for the raw data.

Where to start

If you only build one thing this week, make it the Stages report for your deals pipeline. Zoho is already tracking the data, it takes minutes to set up, and it immediately shows your conversion rate between stages and where deals are stalling. Pin it to your home page and review it weekly.

The reports are the easy part, though. The real value comes from acting on what they show — which is usually a question about your sales process rather than the software.