Skip to content

This repository contains the "RFM Analysis" for a Sales Data of a Retailer in SQL. This is part of my Data Science Portfolio Projects

Notifications You must be signed in to change notification settings

AyushiAsthana18/RFM-Analysis

Repository files navigation

RFM-Analysis

Sales | Marketing | Retail | E-Commerce

RFM Analysis is used to understand and segment customers based on their buying behaviour. RFM stands for recency, frequency, and monetary value, which are three key metrics that provide information about customer engagement, loyalty, and value to a business. These segments enables targeted marketing and personalized strategies for each segment. Using RFM Analysis, a business can assess customer's:

  • recency (the date they made their last purchase)
  • frequency (how often they make purchases)
  • monetary value (the amount spent on purchases)

To perform RFM analysis, we need a dataset that includes customer IDs, purchase dates, and transaction amounts.

Dataset : https://data.world/dataman-udit/us-regional-sales-data

We cab divide Customers into 3 Value segments based on average RFM Score as follows:

  • High-Value (Top 20%)
  • Mid-Value (Next 30%)
  • Low-Value (Next 50%)

When segmenting customers based on RFM (Recency, Frequency, Monetary), we can create customer segments that reflect their purchasing behavior. Here are five segment names we can consider:

  1. VIP Customers: This segment represents the high-value customers who have made recent and frequent purchases with a high monetary value. They are the most valuable and loyal customers.
  2. Regular Customers: This segment includes customers who make frequent purchases but may not have the highest monetary value. They are reliable and contribute to consistent sales.
  3. Dormant Customers: This segment consists of customers who haven't made a purchase in a while, despite having a history of previous purchases. These customers may require targeted marketing efforts to reactivate them.
  4. New Customers: This segment represents customers who have recently made their first purchase. They require nurturing and engagement to encourage repeat purchases and long-term loyalty.
  5. Churned Customers: This segment comprises customers who were once active but haven't made a purchase in a long time. They require re-engagement strategies to win them back and prevent them from churning.

References :

About

This repository contains the "RFM Analysis" for a Sales Data of a Retailer in SQL. This is part of my Data Science Portfolio Projects

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages