Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Read: Using MIS Chapter 3 To Do: Suppose you run an e-commerce platform, and you want to segment your customers to better target your marketing

image text in transcribedimage text in transcribed Read: Using MIS Chapter 3 To Do: Suppose you run an e-commerce platform, and you want to segment your customers to better target your marketing efforts. Here's a dataset of customer transactions: Let's perform RFM analysis: Recency (R): Calculate the number of days since each customer's last purchase and assign a score: Customer 1: Last purchase on 2023-09-25 (1 day ago) => High recency score. Customer 2: Last purchase on 2023-08-10 (46 days ago) => Customer 3: Last purchase on 2023-09-20 (6 days ago) => Customer 4: Last purchase on 2023-06-05 (112 days ago) => Customer 5: Last purchase on 2023-09-15 (11 days ago) => Frequency (F) : Count the number of purchases each customer made during the specified time period and assign scores: Monetary (M): Calculate the total spending for each customer and assign scores based on monetary value: Customer 1: >> Customer 2: Customer 3: Customer 4: Customer 5: What to Submit: After calculating the individual scores for Recency, Frequency, and Monetary, you can create customer segments: Example Customer 1: 555 Example: High-Value and Active Customers: High recency, high frequency, and high monetary value (e.g., Customer 1 and Customer 4). Create three different segments

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Organization Theory And Public Management

Authors: Jonathan R. Tompkins

1st Edition

053417468X, 978-0534174682

More Books

Students also viewed these General Management questions

Question

3. What should a contract of employment contain?

Answered: 1 week ago

Question

1. What does the term employment relationship mean?

Answered: 1 week ago