RFM-SQL Analysis

Recency, frequency, monetary (RFM) Model for customer segmentation.

The customers are grouped based on 3 main values:

• Recency: how recent the last transaction is.

• Frequency: how many times the customer has bought from our store.

• Monetary: how much each customer has paid for the products.

The programming language was Oracle SQL and the application I was coding on was Toad.