Small businesses often skip RFM analysis, assuming it's the domain of large corporations with complex CRM systems, an analyst team, and expensive software. In reality, you can segment customers by their purchasing activity using a plain spreadsheet, and the benefits are noticeable right away.
RFM segmentation lets you stop sending the same email to your entire list and start communicating with customers based on their actual purchase history.
What RFM is and how to adapt it for small business
The acronym RFM stands for three key metrics:
- Recency: how long ago the customer made their last purchase. Customers who bought recently are more likely to open your next email.
- Frequency: how often the customer buys from you. Helps distinguish one-time buyers from devoted brand fans.
- Monetary: how much money the customer has spent overall. Shows the financial value of each contact.
In classic analysis, each parameter gets a score from 1 to 5, producing 125 tiny segments. For a small business, that level of detail is overkill. A simplified three-point scale (1 to 3) is enough, where 3 is high and 1 is low.
5 key segments you can easily identify in a spreadsheet
Instead of hundreds of combinations, a small business only needs to focus on five basic customer groups:
Segment name | Code (R-F-M) | Behavior description | Email communication strategy |
|---|---|---|---|
Core (Champions) | 3-3-3 / 3-3-2 | Buy often, recently, and in large amounts. | Private sales, new arrivals, loyalty programs, review requests. |
Newcomers | 3-1-X | Made their first purchase very recently. | A welcome chain, product instructions, a selection of related products. |
At risk of churning | 2-3-X / 2-2-X | Used to buy often, but activity has dropped recently. | Surveys ("Is everything okay?"), personal recommendations, useful content. |
Dormant loyalists | 1-3-3 / 1-3-2 | Your former regulars who haven't bought anything in a very long time. | Strong reactivation offers, gifts, exclusive discounts. |
One-time bargain hunters | 1-1-1 | Made one inexpensive purchase a long time ago and never came back. | Automatic promotional emails during major sale periods. |
A step-by-step algorithm: how to run RFM analysis with basic tools
To launch segmentation, you only need three data columns from your accounting system (for example, MoySklad, Tilda, 1C, or your payment processor): customer ID/email, the date of the last order, the total number of orders, and the total amount spent.
- Export the data to Google Sheets or Excel. Build a list of customers with all their purchases.
- Define the range boundaries. Look at the data and set the rules. For example, for Recency: a score of 3 means a purchase in the last 30 days; 2 means 31 to 90 days ago; 1 means more than 90 days ago.
- Assign scores. Use simple formulas (like IF or VLOOKUP) to assign a score from 1 to 3 for each criterion.
- Build the final code. Combine the three scores into a single three-digit index (for example, 311).
How to automate working with segments without a complex CRM
Once you've defined your segment criteria, you can eliminate the manual work. Modern campaign automation platforms handle this easily.
You can pass the basic tags or order parameters into Letteros once. Dynamic segments are configured inside the platform. This means you won't have to recalculate spreadsheets by hand every month: as soon as a customer makes a purchase, the system automatically moves them from the "At risk" segment to the "Core" segment, and they start receiving a completely different type of email.
What to avoid when implementing RFM
— Recalculating too often by hand: if you update spreadsheets manually every day, email marketing turns into pure routine. Recalculate manual lists once a month, or set up automatic event syncing to your email platform.
— Ignoring your product's specifics: if you sell products with a long repurchase cycle (like furniture or appliances), a 30-day Recency window for a score of "3" would be a mistake. Adapt the time windows to your business.
— Overloading the "Core" segment with special offers: loyal customers already love your product. Constant discounts for them will only cut into your margin. Give them attention, unique service, and early access to new products instead.
— Sending elaborate emails to "one-time" customers: don't spend resources building complex personalized selections for someone who bought once two years ago. Simple, infrequent mass announcements are enough for them.
What to check before launching an RFM campaign
— Data freshness: the data export used for analysis includes the latest sales, including returns and canceled orders.
— Content differentiation: at least three different email templates are prepared (for newcomers, loyal customers, and dormant ones), reflecting their current relationship with the brand.
— No overlaps: the same email address can't end up in two opposite segments at once due to filter configuration issues.
— A control group: a small share of the audience is set aside to keep getting standard generic emails, so you can measure how effective the segmentation actually is.
Bottom line
RFM segmentation is an accessible, straightforward tool that works even with plain spreadsheets. By dividing customers based on their activity, a small business can allocate its marketing budget more precisely: stop wearing out loyal customers with endless discounts, and re-activate those who are starting to forget about the brand in time.