How to use Customer RFM Analyzer
- Enter unique transaction IDs, customer IDs, calendar dates and nonnegative amounts.
- Set the inclusive observation window and its as-of date.
- Choose the two increasing cutoffs for each three-band score.
- Compare customer measures and scores, then download the report.
Example: Customer RFM Analyzer
Score two customers using January transactions and entered R, F and M cutoffs.
Supported inputs and limits
- Up to 2,000 transactions, 80 columns and 2 MiB.
- The date window includes both ends.
- Only customers with an included transaction appear.
- Frequency counts transaction IDs; recency counts calendar days from the last included transaction.
- Amounts are nonnegative with two decimal places in one currency; refund rows are refused.
More details
Each score uses two increasing thresholds.
Frequency/spend score 1 below the first, 2 below the second, otherwise 3; recency reverses that direction.
No automatic quantiles or marketing segments are inferred.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Questions about Customer RFM Analyzer
Is frequency a count of purchases or products?
It counts unique included transaction IDs. If your source has one row per item, first aggregate those rows into transactions so that an order with several items does not count several times.
Do inactive customers appear with zero frequency?
Only customers with activity inside the chosen window appear. A separate customer master list is not inferred from older transactions.
What happens exactly at a scoring threshold?
Equality enters the next numeric band. For example, recency 30 with cutoffs 30 and 90 receives the middle recency score rather than the highest score.