RFM Customer Segmentation in Zoho CRM

By Amazing Business Results | Certified Zoho Premium Partner

Automation #13 from The Top 20 CRM Automations in the World by Lior Izik

Topics: RFM Segmentation · Account Management · Customer Retention · Zoho CRM · Revenue Protection

You have 100 accounts in your CRM. A handful of them pay most of your bills. Another slice matters a lot — lose one and it genuinely hurts. And some you could lose tomorrow without blinking.

The problem is that when every account looks the same on the screen, you treat them the same, and you find out which ones mattered only after they are gone. Account segmentation fixes that.

This is Automation #13 from The Top 20 CRM Automations in the World, where Lior Izik walks through building RFM-based account segmentation directly inside Zoho CRM — ranking every account so you know exactly who your champions are, who is slipping, and who to act on before they walk.

Why Segmentation Is Not Optional

Assume 20% of your accounts are the significant ones — the VIPs, the ones that would be very painful to lose. If you cannot see that 20% at a glance, you cannot protect it. Segmentation gives every account a level so that the moment you look at the screen, you know what is going on.

A common structure looks like this, though you can create as many levels as you want and name them anything that makes sense for your business:

Champions — the top of the top, your VIPs.

Loyal customers — second in place, cannot afford to lose.

Cannot lose them — third tier, still critical.

Lower tiers — down to the accounts where, if you lose them, nothing much happens to the business.

The payoff

Once accounts are segmented, you can act differently on each level. Give your champions and loyal customers a strong SLA. Have account managers contact them on a weekly or monthly basis to take the temperature of the account. Invite your top customers to restaurants, events, and knowledge webinars.

Different companies treat their VIPs in different ways. The point is that you know who they are, so they go nowhere.

This is the same principle as Automation #3 — Lead Scoring, applied to accounts instead of leads. A score that sits in a field is decoration. A score that decides which lane an account enters, and what service level it gets, is a system.

The Sales Manager View That Catches Problems Early

Segmentation is not just a label. It drives action. One of the most valuable pieces is a view built for the sales manager that surfaces every high-value account that is not being contacted on time.

In the demo, that view had 26 records in it. The right number is zero, because if the team is doing its job, every account that is supposed to be contacted has been contacted. The view turns a vague responsibility into a clear, working list: here are the accounts falling through the cracks, go fix it.

That view only tells the truth if the contact data is complete, which is why it depends on Automation #14 — centralised communication → If account managers are calling VIPs from personal phones, the view shows an account as neglected when it was not, or worse, shows it as handled when nobody called.

How RFM Scoring Works

RFM stands for Recency, Frequency, and Monetary value — three data points that, taken together, tell you how healthy an account is.

In Zoho CRM you build the segmentation on the Accounts module and measure it using a contributing module. In this case, the Deals module supplies all three signals: how many deals in total, when the last deal happened, and how much money the account has generated overall.

Recency — when was the last deal?

Points	Condition
3 points	Deal in the last 30 days
2 points	Deal within 31 to 90 days
1 point	Last deal older than 90 days

Frequency — how many deals in total?

Points	Condition
3 points	More than 3 deals
2 points	1 to 3 deals
1 point	1 deal or fewer

Monetary — how much has the account spent?

Points	Condition
3 points	More than $2,000
2 points	$1,000 to $2,000
1 point	Less than $1,000

These numbers are examples. Yours will differ.

The thresholds above are a demo. Some businesses measure in the multi-millions, some in the hundreds of thousands. One company might treat an invoice under 30 days as a sign the client is not on a package — the exact opposite signal.

Every business sets its own ranges, which is what makes the same model fit any company. Get the thresholds right for your business and the segmentation becomes accurate.

Turning Scores Into Segment Levels

Once points are collected across all three dimensions, you map score combinations to segment levels. A champion is the best of the best: 3 points in recency, 3 in frequency, and 3 in monetary value — a perfect 3-3-3.

But the real money is in the in-between levels. Create a level like “about to sleep” (or “about to lose”) for accounts with high monetary and high frequency scores but a low recency score — say a 3-3-1. These are big spenders where everything looks great, except they have not done business with you in longer than they should have.

This is where segmentation makes you money

When clients contacted these quiet-but-valuable accounts, they often heard the truth: “There was a problem in the last deal. We were not happy, and we were thinking of moving somewhere else.”

That conversation is a chance to make it right, and the account moves back up from “about to lose” to champion. Without segmentation, you never make the call, and you lose the account without ever knowing why.

Before that call happens, check the account for open support tickets. Walking into a recovery conversation without knowing there is an unresolved problem makes things worse, which is exactly what Automation #12 — account health is built to prevent.

The Bottom Line

The RFM model is a necessity for any company that has clients and wants to segment them the right way. There is not a business owner alive who would look at this system and say it is not for them.

It takes the accounts you already have and tells you exactly where to spend your attention — protecting the revenue that pays your bills and catching the accounts slipping away before they are gone.

Building the scoring fields, the calculation workflows and the manager views inside Zoho CRM is a standard part of our Zoho CRM customisation service →

The Top 20 CRM Automations Series

This post is part of an ongoing series covering all 20 automations from Lior’s book:

NOTE: Verify all URLs above against the actual published URLs before this post goes live.

Work With Amazing Business Results

Amazing Business Results is the most reviewed Zoho Partner in the world, with 2,000+ completed projects across the US, Canada, and Europe over 12 years. We build solutions precisely tailored to your business needs. We extract your business requirements, translate them into custom Zoho systems unique to your business, and provide the development and training to make sure your team uses them correctly.

If you need help rethinking your segmentation strategy, we are always happy to jump on a call.

The Top 20 CRM Automations in the World covers all 20 automations with real client stories and the exact systems behind each one.

Explore our related services:

Book a free consultation

Start your free Zoho One trial (no credit card required): USA | Canada | Europe

Subscribe to the ABR Dispatch — Free Weekly AI and CRM Newsletter: zfrmz.com/54B40ZnE2NSRhC3s1Yoh

Top Zoho Extensions: ABR on Zoho Marketplace

Zoho CRM Course: amazingbusinessresults.com/zoho-crm-course

Recent Posts