Which date decides the period?

By default, Created Time for leads and Closing Date for won deals. Say in the request if you want a different date, such as the date a deal was modified.

Where does a deal’s Lead Source come from?

From the Lead Source field on the deal. When a lead is converted with a deal, that field usually carries over from the lead; deals created directly have whatever the rep chose.

The table is only as good as the field. An empty or “Other” source hides the real channel, and the report shows those rows rather than spreading them over the others. If a count cannot be read, it says so instead of estimating.

Can I break it down further?

Yes. It groups by up to three fields at once, for example Lead Source, owner and lead status.

Will it work on my Zoho CRM edition?

It needs a Zoho CRM edition and user profile with API access, and it can only do what your profile is allowed to do. This use case has not been checked edition by edition yet, so write to us if you want to check yours first.

Want to ask something?

Write to the team at hello@zsetup.com.

Count leads and won deals by lead source in Zoho CRM

The Zoho CRM AI Assistant counts leads, converted leads and won deals with their amounts by Lead Source for the period you choose. It shows how many records have the source empty, and changes nothing.

Add to Chrome

Zoho CRM AI Assistant is a Chrome extension that opens beside Zoho CRM. Tell it what you want to do in plain language, and it works with your CRM for you. Try Plus free for 14 days, then stay on Free forever.

the problem

Which source brings deals, not just leads?

A channel that sends many leads may send few deals, and the event that looked quiet may have closed the largest one. The Lead Source field is in Zoho CRM, but getting leads and won deals side by side, by source and period, means two reports and a spreadsheet.

the solution

One request, one table by source

Ask for the period and the numbers you want:

For this year so far, count leads, converted leads and won deals with their total amount, grouped by Lead Source. Show the rows where Lead Source is empty.

The assistant counts Leads created in the period by Lead Source, and how many of them were converted. It counts and totals Deals in a Closed Won stage, with Amount, by the Lead Source on the deal.

It shows one table, with a row for records where the source is empty. You can add up to two more groupings, such as the owner or another field on the record.

Reads leads and deals, with their Lead Source, stage, amount and dates.
Writes nothing: this request only reads.
It reports the source as recorded. It does not claim which campaign or touch caused a deal.

Try it on your leads More use cases

This is an example CRM.Connect your own Zoho.

What would you like to do?

Ask about your CRM or describe a change you want to make.

pricing

Start with 14 days of Plus. Stay on Free after that.

Every new account gets 14 days of Plus free — no card, nothing to claim — and then settles onto Free, which is permanent. In the side panel every plan has the same safety controls and supported actions, and they differ in how much you can ask for each week. The MCP connector is included in every paid plan (Plus, Pro and Max) and in the 14-day Plus trial, with the same 10,000 tool calls a month on each.

Plus

For reps who use the assistant every day.

5x the Free usage

$23/ month

Try Plus

14-day free trial, then billed monthly

5x the Free usage
All supported CRM actions
Approval controls
Includes the MCP connector

Pro

For heavy daily CRM work.

25x the Free usage

$94/ month

Get Pro

Billed at signup, then monthly

25x the Free usage
5x the usage of Plus
All supported CRM actions
Approval controls
Includes the MCP connector

Max

For the heaviest CRM workloads.

125x the Free usage

$500/ month

Get Max

Billed at signup, then monthly

125x the Free usage
5x the usage of Pro
All supported CRM actions
Approval controls
Includes the MCP connector

Free

$0No card, and permanent

Limited weekly usage, with the same supported CRM actions and approval controls. It is where your account settles after the 14-day Plus trial.

Start free

By hand

Without the assistant

Not ready to install? Here is how to do the same thing in Zoho CRM yourself, step by step.

See the steps

Need more than Max? Contact sales

without the assistant

How to do it by hand in Zoho CRM

You can do this in Zoho CRM yourself. Here are the steps.

In Reports, create a report on Leads, grouped by Lead Source, filtered to the period.
Create a second report on Deals, grouped by Lead Source, filtered to Closed Won stages and the period, with the sum of Amount.
Export both and put them side by side in a spreadsheet.
Add a check for empty sources in each report.

The reports themselves are quick to build. Putting leads and deals side by side, and redoing it for each new period or grouping, is where it takes time.

Add to Chrome

questions

Frequently Asked Questions

No. This request only reads leads and deals and computes counts and totals. Nothing is written to your CRM.

More in Marketing

All Lead sources use cases