Customer RFM Analyzer

Calculate customer recency, frequency and monetary scores from transactions within a declared date window.

On-device No sign-up Free to use

Score customer RFM controls

Showing an example. Edit to see your own.

?

Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    ?

    Two increasing cutoffs separated by a comma. Scores use < first, < second, otherwise upper band. Recency reverses the score.

    ?

    Two increasing cutoffs separated by a comma. Scores use < first, < second, otherwise upper band. Recency reverses the score.

    ?

    Two increasing cutoffs separated by a comma. Scores use < first, < second, otherwise upper band. Recency reverses the score.

    Processed in your browser. Your inputs stay on this device.

    Result

    Showing an example.

    Score two customers using January transactions and entered R, F and M cutoffs.

    As of 2026-01-31, customer A has recency 11 days, frequency 2, spend 140.00 and scores R=3, F=2, M=2. Customer B has recency 30 days, frequency 1, spend 20.00 and scores 2,1,1.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/customer-rfm-analyzer · 20 November 2026

    Was this helpful?

    How to use Customer RFM Analyzer

    1. Enter unique transaction IDs, customer IDs, calendar dates and nonnegative amounts.
    2. Set the inclusive observation window and its as-of date.
    3. Choose the two increasing cutoffs for each three-band score.
    4. 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.

    You add
    Customer transactions: id,customer,date,amount O1,A,2026-01-02,60.00 O2,A,2026-01-20,80.00 O3,B,2026-01-01,20.00 Window start, inclusive: 2026-01-01 As-of date, inclusive: 2026-01-31 Recency thresholds: 30,90 Frequency thresholds: 2,5 Spend thresholds: 100,500
    You get
    As of 2026-01-31, customer A has recency 11 days, frequency 2, spend 140.00 and scores R=3, F=2, M=2. Customer B has recency 30 days, frequency 1, spend 20.00 and scores 2,1,1.

    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.

    Page updated · Project managed by Tony Hines · Report a problem with Customer RFM Analyzer