Customer lifetime value (CLV) calculation in Digital Marketing - Mini Project: Build & Apply

Customer Lifetime Value (CLV) Calculation

📖 Scenario: You work for an online store that wants to understand how valuable each customer is over time. This helps the store decide how much to spend on marketing and customer service.

🎯 Goal: Build a simple step-by-step calculation of Customer Lifetime Value (CLV) using basic data about customers' purchases and retention.

📋 What You'll Learn

Create a data structure with customer purchase data

Add a variable for average customer lifespan in years

Calculate the average purchase value per customer

Calculate the Customer Lifetime Value using the formula

💡 Why This Matters

🌍 Real World

Businesses use CLV to decide how much to invest in acquiring and keeping customers, improving marketing strategies and profitability.

💼 Career

Marketing analysts, business managers, and data analysts often calculate CLV to guide decisions and measure customer value.

1

Set up customer purchase data

Create a dictionary called customer_purchases with these exact entries: 'Alice': 120, 'Bob': 80, 'Charlie': 150, 'Diana': 100. The numbers represent total purchase amounts in dollars.

Digital Marketing

# Create the customer_purchases dictionary with exact entries
# Your code here

Hint

Use curly braces to create a dictionary with customer names as keys and purchase amounts as values.

2

Add average customer lifespan

Create a variable called average_lifespan_years and set it to 5, representing the average number of years a customer stays active.

Digital Marketing

customer_purchases = {'Alice': 120, 'Bob': 80, 'Charlie': 150, 'Diana': 100}
# Create average_lifespan_years variable and set it to 5
# Your code here

Hint

This is a simple number variable representing years.

3

Calculate average purchase value

Create a variable called average_purchase_value that calculates the average purchase amount per customer by summing all values in customer_purchases and dividing by the number of customers.

Digital Marketing

customer_purchases = {'Alice': 120, 'Bob': 80, 'Charlie': 150, 'Diana': 100}
average_lifespan_years = 5
# Calculate average_purchase_value below
# Your code here

Hint

Use sum() to add all purchase amounts and len() to count customers.

4

Calculate Customer Lifetime Value (CLV)

Create a variable called customer_lifetime_value that multiplies average_purchase_value by average_lifespan_years to find the total value a customer brings over their lifetime.

Digital Marketing

customer_purchases = {'Alice': 120, 'Bob': 80, 'Charlie': 150, 'Diana': 100}
average_lifespan_years = 5
average_purchase_value = sum(customer_purchases.values()) / len(customer_purchases)
# Calculate customer_lifetime_value below
# Your code here

Hint

Multiply the average purchase value by the average lifespan to get CLV.

Practice

1. What does Customer Lifetime Value (CLV) represent in digital marketing?

easy

A. The cost of acquiring a new customer

B. The total revenue a customer is expected to generate during their relationship with a business

C. The number of purchases a customer makes in a month

D. The average price of a single product

Solution

1. Step 1: Understand the definition of CLV

   CLV estimates the total money a customer will spend over their entire relationship with a business.

2. Step 2: Compare options to the definition

   Only The total revenue a customer is expected to generate during their relationship with a business matches this definition exactly, describing total expected revenue from a customer.

3. Final Answer:

   The total revenue a customer is expected to generate during their relationship with a business -> Option B

4. Quick Check:

   CLV = Total expected revenue [OK]

Hint: CLV = total money from customer over time [OK]

Common Mistakes:

• Confusing CLV with acquisition cost
• Thinking CLV is just one purchase value
• Mixing CLV with purchase frequency

2. Which formula correctly calculates Customer Lifetime Value (CLV)?

easy

A. CLV = Average Purchase Value x Purchase Frequency x Customer Lifespan

B. CLV = Purchase Frequency ÷ Average Purchase Value x Customer Lifespan

C. CLV = Customer Lifespan - Purchase Frequency + Average Purchase Value

D. CLV = Average Purchase Value + Purchase Frequency + Customer Lifespan

Solution

1. Step 1: Recall the CLV calculation formula

   CLV is calculated by multiplying average purchase value, purchase frequency, and customer lifespan.

2. Step 2: Match the formula with options

   Only CLV = Average Purchase Value x Purchase Frequency x Customer Lifespan correctly multiplies all three factors to calculate CLV.

3. Final Answer:

   CLV = Average Purchase Value x Purchase Frequency x Customer Lifespan -> Option A

4. Quick Check:

   CLV = Avg Purchase x Frequency x Lifespan [OK]

Hint: Multiply value, frequency, and lifespan for CLV [OK]

Common Mistakes:

• Using addition instead of multiplication
• Dividing instead of multiplying factors
• Mixing up the order of operations

3. A customer spends $50 on average per purchase, buys 4 times a year, and stays for 5 years. What is their CLV?

medium

A. $500

B. $250

C. $200

D. $1000

Solution

1. Step 1: Identify given values

   Average Purchase Value = $50, Purchase Frequency = 4 times/year, Customer Lifespan = 5 years.

2. Step 2: Calculate CLV using formula

   CLV = 50 x 4 x 5 = 1000.

3. Final Answer:

   $1000 -> Option D

4. Quick Check:

   50 x 4 x 5 = 1000 [OK]

Hint: Multiply all three numbers for total CLV [OK]

Common Mistakes:

• Forgetting to multiply by lifespan
• Adding instead of multiplying values
• Using wrong units for frequency or lifespan

4. Identify the error in this CLV calculation: CLV = Average Purchase Value + Purchase Frequency x Customer Lifespan. What is wrong?

medium

A. Addition is used instead of multiplication for all factors

B. Purchase Frequency should be divided, not multiplied

C. Customer Lifespan is missing from the formula

D. Average Purchase Value should be subtracted, not added

Solution

1. Step 1: Analyze the given formula

   The formula uses addition for Average Purchase Value but multiplication for the other two factors.

2. Step 2: Understand correct CLV formula

   All three factors should be multiplied, not added or mixed operations.

3. Final Answer:

   Addition is used instead of multiplication for all factors -> Option A

4. Quick Check:

   CLV needs multiplication of all factors [OK]

Hint: All factors must be multiplied, not added [OK]

Common Mistakes:

• Mixing addition and multiplication incorrectly
• Ignoring customer lifespan in calculation
• Misunderstanding purchase frequency role

5. A company wants to increase CLV by 20%. If the current average purchase value is $40, purchase frequency is 3 times/year, and lifespan is 4 years, which change will achieve this goal?

hard

A. Increase purchase frequency to 3.6 times/year

B. Increase average purchase value to $48

C. Any one of the above changes

D. Increase customer lifespan to 4.8 years

Solution

1. Step 1: Calculate current CLV

   Current CLV = 40 x 3 x 4 = 480.

2. Step 2: Calculate target CLV with 20% increase

   Target CLV = 480 x 1.2 = 576.

3. Step 3: Check each option's effect

   Increase purchase frequency to 3.6 times/year: 40 x 3.6 x 4 = 576; Increase average purchase value to $48: 48 x 3 x 4 = 576; Increase customer lifespan to 4.8 years: 40 x 3 x 4.8 = 576.

4. Step 4: Determine which changes meet the target

   All three changes achieve exactly 576, so any one of the above changes will achieve the goal.

5. Final Answer:

   Any one of the above changes -> Option C

6. Quick Check:

   Increasing any factor by 20% raises CLV by 20% [OK]

Hint: Increase any factor by 20% to raise CLV by 20% [OK]

Common Mistakes:

• Assuming only one factor can increase CLV
• Not calculating target CLV correctly
• Ignoring multiplication effect on CLV