Loading tutorials…
Loading tutorials…
Zoho ships 50+ default reports. They cover 30% of what your team actually needs. The Custom Report Builder + Zoho Analytics is where real leverage lives — and where most owners build dashboards nobody opens. Here is the design discipline that makes them load-bearing.
Who this is forRevOps leads, sales managers, marketing managers, and founders who want operational visibility beyond defaults. Zoho CRM custom reports work on Standard+; Zoho Analytics (the BI layer) is a separate license or bundled in Zoho One.
What you'll need
Step 1
Every report should answer a specific business question. "Show me sales pipeline" is not a question. "Which deals over $50K have not moved stages in 30 days?" is.
Before opening the report builder, write down: what decision will I make differently based on this report's answer?
Good question examples: 'What is our deal velocity by stage compared to last quarter?' 'Which lead sources are producing customers vs churned trials?' 'Which reps are above quota with 3 weeks left in the quarter?'
Bad question examples: 'Show me all my deals,' 'Build a marketing dashboard,' 'Pull a report on contacts.'
For each question, identify the module (Leads / Contacts / Accounts / Deals / Custom), the metric (count, sum, average), the breakdown (by stage, by owner, by source), and the filter (last 90 days, owner = team).
Write 5-8 questions before building. You will end up with a focused dashboard instead of one with 20 charts nobody reads.
Step 2
Reports → "+ Create Report" inside Zoho CRM. This is where single-module queries live — Deals by Stage, Leads by Source, Tasks by Owner.
Open Reports (main nav) → "+ Create Report."
Pick a Report Type: Tabular (table), Summary (grouped), Matrix (cross-tab), or Chart.
Pick the Primary Module: Leads, Contacts, Accounts, Deals, etc.
Add columns (for Tabular), grouping (for Summary), or row/column dimensions (for Matrix).
Add filters: standard filters (Stage = Closed Won, Created Time = last 90 days, Owner = sales team) and cross-module filters (Deals with Account Industry = SaaS — joins across modules).
Pick chart type: Bar, Line, Pie, Funnel, Heat Map, Bubble. Match chart to question — count goes Number, distribution goes Bar, trend goes Line, conversion goes Funnel.
Step 3
Zoho Analytics is the BI layer. Joins CRM with Books, Campaigns, Desk, Projects, or external sources (SQL DB, Snowflake, Salesforce). Required for questions like "MRR by Lead Source."
Zoho Analytics is a separate app — included in Zoho One ($37/user/mo), Zoho CRM Plus ($57/user/mo), or standalone ($25/user/mo for 2 users + $13/user/mo per additional).
Sign in to analytics.zoho.com → Create Workspace → "+ Import Data" → pick "Zoho CRM" as the source. Zoho Analytics syncs your CRM modules automatically (typically every 4-6 hours, configurable).
For cross-app analysis: also connect Zoho Books (revenue + invoices), Zoho Campaigns (email engagement), Zoho Desk (support tickets). All sync into one workspace.
Build a report by dragging fields onto rows/columns/values. Behind the scenes, Analytics generates a SQL query. For complex reports, use the Query Builder to write SQL directly — joins, subqueries, custom calculations.
Example questions only Analytics can answer: 'MRR by Lead Source for the last 12 months' (CRM × Books), 'Email engagement vs. closed-won rate' (CRM × Campaigns), 'Customer health score by ticket volume + renewal stage' (CRM × Desk).
Step 4
Naming convention: [Module] - [Metric] - [Filter]. "Deals - Velocity by Stage - Last 90 Days." Reports without good names become unfindable graveyards.
Click Save → Name the report.
Bad names: "Sales Report," "Deals 2," "Test Report Final."
Good names: "Deals - Pipeline by Stage - This Quarter," "Leads - New This Week by Source," "Reps - Tasks Completed - Last 30 Days."
Save report to a folder. Create folders by use case: "Leadership Dashboard," "Sales Ops," "Marketing Performance," "Customer Success."
Sharing: Reports → click report → Share. Options: Only Me, Specific Users, Specific Roles, Everyone. For company-wide leadership reports, share with all sales-facing profiles.
Step 5
Dashboards → "+ Create Dashboard." Each dashboard should have 6-12 reports max, organized by a single audience.
Open Dashboards (main nav) → "+ Create Dashboard" → name + pick layout.
Audience-first: build one dashboard per audience. "Leadership Weekly Review," "Sales Ops Daily," "Marketing Monthly," "CS Quarterly." Do not mix audiences.
Add reports: drag from your report library to the dashboard canvas. Arrange so the most-important metric is top-left (where the eye lands first).
Restraint: a dashboard with 6 sharp reports gets opened. A dashboard with 24 reports gets ignored. Cut ruthlessly.
For dashboards in Zoho Analytics: same principles, plus you can embed interactive filters (date range, owner, region) that filter all reports on the dashboard simultaneously.
Step 6
Pull-mode dashboards mostly go unopened. Push them to where people work — email digest, Slack, Teams.
Open any report or dashboard → "Schedule" → pick frequency (daily, weekly, monthly), pick recipients, pick format (PDF, HTML email, Excel).
Common schedules: Monday morning leadership dashboard PDF to exec team. Daily 9am sales ops dashboard to sales managers. Weekly Friday marketing performance PDF to marketing team.
For Slack: install the Zoho Reports Slack integration (Marketplace) → route dashboard updates to channels. Useful for "Sales Daily" in a sales channel.
For mobile: Zoho Analytics has native iOS / Android apps — leaders open dashboards on phone during meetings without needing to log into web.
Track open rates on scheduled emails: if leadership opens the Monday digest <50% of weeks, the digest content is not landing. Iterate.
Step 7
Dashboards rot. Reports go stale, questions evolve. Audit quarterly: archive dashboards nobody opens, retire reports that have not loaded in 60 days.
Quarterly: Dashboards → sort by Last Accessed. Any dashboard not opened in 60 days is dead weight.
Talk to dashboard owners (or audiences). Ask: "what decision have you made from this dashboard in the last 60 days?" If "none," archive.
Reports → sort by Last Used. Reports not loaded in 90 days: archive (Reports → click report → Actions → Archive). They can be restored if needed.
Active dashboard set should be 4-8 dashboards across the portal. Past 15, the system has become a dashboard graveyard.
Replace dead dashboards with new ones that answer current questions. Dashboards should evolve as the business evolves.
Common mistakes
Building reports before defining the question
What goes wrong: Dashboard has 16 charts; nobody knows what decision each supports. Leadership opens it once, doesn't understand it, never opens it again. Hours of build time produce a screensaver.
How to avoid: Write the question first. "What decision will I make from this report?" If you cannot answer that, do not build the report.
Using only Zoho CRM reports when the question crosses apps
What goes wrong: Owner tries to build 'MRR by Lead Source' in Zoho CRM reports. Cannot — CRM does not have invoice / subscription data. Builds an approximate version in CRM that uses Deal Amount as a proxy. The proxy drifts from real MRR by 20%+. Decisions get made on bad data.
How to avoid: For cross-app questions (CRM + Books, CRM + Campaigns, CRM + Desk), use Zoho Analytics. The license cost is recouped in week one if you make a single revenue decision from accurate data.
Tabular reports for management dashboards
What goes wrong: Sales pipeline dashboard is a table of 800 rows. Leadership cannot scan it. They want the answer 'is pipeline up or down vs last quarter,' but the report shows raw data. Cognitive overload, dashboard ignored.
How to avoid: Tabular for ops use cases (export this list). Summary or Matrix or Chart for management dashboards. Match the report type to the audience.
Dashboards mixing audiences
What goes wrong: Leadership dashboard has 'rep activity by SDR' (relevant to sales ops, not leadership) and 'top 10 deals' (relevant to leadership). Both audiences ignore it because half of it is irrelevant to them.
How to avoid: One audience per dashboard. Leadership = company-level metrics. Sales ops = rep-level operational metrics. CS = customer-health metrics. Marketing = campaign + funnel metrics.
No scheduled delivery — relying on people to open Zoho
What goes wrong: Leadership opens Zoho dashboard once a quarter. Sales reps never. Marketing manager checks weekly. Most people forget. Dashboards exist but are not consumed.
How to avoid: Scheduled email delivery (weekly for leadership, daily for ops). Slack delivery to relevant channels. Push the dashboard to where people work, not where Zoho lives.
No quarterly audit — dashboards rot indefinitely
What goes wrong: Three years in, the org has 45 dashboards. 30 are stale. New hires can't tell which are current. Decisions get made from old reports. Trust in the data erodes.
How to avoid: Quarterly audit: archive dashboards not opened in 60 days, retire reports not loaded in 90 days. Replace stale ones with new ones answering current questions.
Recap
Done — what's next
How to set up a Zoho sales pipeline that produces accurate forecasts
Read the next tutorial
Hand it off
Good dashboards drive decisions. Bad dashboards waste hours. The difference is design discipline — knowing which questions to ask, which charts to use, and how to ruthlessly cull noise. EverestX Zoho specialists who have built 50+ dashboard sets do this in days. Typical engagement: $300-600 for the initial design, $200-400/mo ongoing iteration at $14-16/hr.
See specialist rates
Zoho CRM Reports are the built-in reporting inside CRM — single-module or cross-module within CRM, simple charts, no SQL. Zoho Analytics is the dedicated BI app — joins CRM with Books, Campaigns, Desk, Projects, or external SQL sources. Required for cross-app metrics like 'MRR by Lead Source.' Most healthy Zoho deployments use both.
Zoho One includes Zoho Analytics at no extra cost (one of the 45+ apps). If you have Zoho One, use it — there is no reason not to. If you have standalone CRM, Analytics is $25/mo for 2 users — cost-effective for most ops teams.
Limits by edition: Standard allows 100 custom reports. Professional 1,000. Enterprise / Ultimate unlimited. Practically, most healthy orgs have 20-40 active custom reports. Past 100, you have report sprawl and the value-per-report drops fast.
Zoho Analytics has APIs and direct connectors that let Power BI, Tableau, and Looker query its data. For one-off exports, every Zoho report has an Export to CSV / Excel / PDF action. For full warehousing, push data from Zoho Analytics to Snowflake / BigQuery via Zoho's Sync API and let your BI tool read from the warehouse.
Yes (2026 feature). Zia in Zoho CRM and Zoho Analytics supports natural-language queries: 'Show me deals closing this quarter by owner' generates a report config. Treat its output as a starting point — always verify the filters, dimensions, and measures match what you actually wanted before saving as a permanent report.
Zoho CRM
A Zoho pipeline is the single most-referenced view in the CRM. Set up wrong, the forecast number is fiction and reps stop trusting it. Set up right, the CRO walks into Monday with a real number. Here is the discipline that holds up.
Zoho CRM
Without lead scoring, SDRs work leads in the order they arrive. The Fortune 500 buyer who downloaded a pricing page sits in the queue behind the student doing a class project. Lead scoring fixes the order. Here is the setup that produces lift, not noise.
HubSpot CRM
HubSpot ships with 80+ default reports. They cover 30% of what your team actually needs. The Custom Report Builder is where the real leverage lives — and where most owners build dashboards nobody opens. Here is the design discipline that makes them load-bearing.
Zoho CRM
DIY Zoho is a great idea — until it isn't. Zoho rewards specialization more than almost any other CRM because the platform is so feature-dense. This is the honest framework for when the cost of self-managing exceeds the cost of hiring help.