Video Summary - Analytics Mastery Session 5 : Customer Profitability Analysis Part 1

Main ideas and concepts

Topic: Customer Profitability Analysis (to identify which customers generate the most profit/sales, and focus effort on them).
Core definition/goal: The method identifies the most profitable customers and helps generate more revenue with less effort.
Key principle used: Pareto Principle (80/20 rule)
- For many outcomes, ~80% of effects come from ~20% of causes.
- In sales/profitability context: focus on the ~20% of customers that produce ~80% of sales.
- Clarification: This doesn’t mean ignoring the remaining customers—it guides prioritization.

Step 1: Understand the data
- Use customer transaction data where:
  - Each customer has multiple purchases
  - Purchases occur on different dates
Step 2: Summarize data (per-customer totals)
- Since the goal is sales per customer, aggregate/summarize transactions into a single total per customer.
- The subtitles reference using a “private option” (likely meaning a pivot-table style summarization).
- Example totals:
  - Customer 1 total sales: 2130.95
  - Customer 2 total sales: 2277.92
Step 3: Calculate total sales and identify top 20% customers
- Path 1: Calculate sales using a function (“some function”).
- Path 2: Find the cut-off value corresponding to the top 20% using a percentile function:
  - Inputs:
    - array = sales data
    - K = cutoff value for the desired percentile
  - The percentile result sets the threshold for being in the top 20%.
- Path 3: Compute total sales for customers above that cut-off using a function (“some F function”):
  - Filter sales to include customers whose sales exceed the cutoff.
  - Subtitles mention a cutoff example: “cut-off value is for 0.8” (intended to reflect the top 20% = 80th percentile).

Increase productivity
- Use the analysis to decide which customers to focus on to maximize efficiency.
Increase profitability
- Improve overall profitability by concentrating resources on a small number of high-impact customers.
Improve customer service
- Pareto principle applied to service: 80% of complaints are associated with 20% of products/services.
- Proper identification can help permanently reduce/resolve recurring customer service issues.

A follow-up will show:
- How to find top 100 and top 1000 customers
- How to compute their percentage sales contribution

Team architects (speaker group/channel name as stated)
Joseph M. Juran (mentioned as suggesting/naming the principle)
Vilfredo Pareto (mentioned as the Italian economist the principle is named after)