PROJECT's KAGGLE LINK :

https://www.kaggle.com/code/dvaser/store-customer-crm-analysis/

STORE CUSTOMER CRM ANALYSIS

What will you learn from this project?

• Data Preparation
• Data Cleaning
• RFM Analysis
  • Calculate RFM Metrics
  • Calculate RFM Scores
  • Creating & Analysing RFM Segments
• CLTV Analysis
  • Average Order Value
  • Purchase Frequency
  • Repeat Rate & Churn Rate
  • Profit Margin
  • Customer Value
  • Customer Lifetime Value
  • Segmentation

Introduction

• RFM Analysis: It is a technique used to segment customer behaviour. It helps to determine marketing and sales strategies by segmenting customers based on their buying habits.

  

  • Recency (Yenilik): It is the period from the customer's last contact with the company, that is, from the customer's last purchase to today.(Recency = Today's date - Last purchase date)
  • Frequency (Sıklık): Shows how often the customer shops.
  • Monetary (Parasal Değer): It is the total expenditure made by the customer in their shopping.

  

• Customer Lifetime Value (CLTV): is considered to be the monetary value that a customer will bring to a company during its relationship and communication with that company.

  

---

Analysis Content

1. Python Libraries
2. Data Content
3. Read & Analyse Data
4. Data Distributions
5. Data Preparation (Box Plot Analysis)
6. Data Cleaning & Analysis
7. RFM (Recency, Frequency, Monetary)
8. RFM Scores
9. RFM Segmentation
10. RFM Analysis (Heatmap)
11. CLTV (Customer Lifetime Value)
12. CLTV Scores
13. CLTV Segmentation
14. CLTV Analysis
15. Conclusion

---

Data Content

• This Online Retail II data set contains all the transactions occurring for a UK-based and registered, non-store online retail between 01/12/2009 and 09/12/2011.The company mainly sells unique all-occasion gift-ware. Many customers of the company are wholesalers.

  • InvoiceNo: Invoice number. Nominal. A 6-digit integral number uniquely assigned to each transaction. If this code starts with the letter 'c', it indicates a cancellation.
  • StockCode: Product (item) code. Nominal. A 5-digit integral number uniquely assigned to each distinct product.
  • Description: Product (item) name. Nominal.
  • Quantity: The quantities of each product (item) per transaction. Numeric.
  • InvoiceDate: Invice date and time. Numeric. The day and time when a transaction was generated.
  • UnitPrice: Unit price. Numeric. Product price per unit in sterling (£).
  • CustomerID: Customer number. Nominal. A 5-digit integral number uniquely assigned to each customer.
  • Country: Country name. Nominal. The name of the country where a customer resides.

• Online Retail II Official Website: https://archive.ics.uci.edu/dataset/502/online+retail+ii