Marketing · Free tool

RFM Segmentation Tool

Drop a CSV of customer orders (customer ID, last order date, frequency, total spend). The tool auto-quintile-scores Recency, Frequency, Monetary and labels each customer into 11 named segments. Export per-segment CSVs.

Loading calculator…

RFM: Recency, Frequency, Monetary

Each customer is scored 1–5 on each dimension by quintile. The combined 3-digit code (e.g. 555 = best) maps to a named segment. Quintile scoring is dataset-relative: the same customer might be a champion in a furniture brand and lost in a coffee shop.

The 11 named segments

SegmentWhat to do
ChampionsVIP perks, referral programs
Loyal CustomersUpsell, recommend
Potential LoyalistsNurture, second-order push
New CustomersWelcome series
PromisingBuild trust, free shipping
Need AttentionRe-engagement, surveys
About to SleepLimited-time offer
At RiskPersonalised win-back
Cannot Lose ThemStrong incentive, phone call
HibernatingAggressive reactivation
LostSuppress to protect deliverability

From CSV to live segments

Running RFM monthly via CSV upload works. Running it nightly on Shopify + retail POS data with segment migration tracking is where the real insight lives. RFM analysis in FireAI.

Get this calculator running on your live data

Try FireAI free — go from one-off calculations to a live dashboard updated every hour.

Frequently asked questions