Search the site...

Jim Dedelow (JED) - Hammond, IN
  • Blog
    • About Jim
    • Home (Test)
  • Blog
    • About Jim
    • Home (Test)

2. List Segmentation - RFM

4/12/2019

2 Comments

 
Picture

Recency

            Frequency

Monetary

We now have a list that includes only females in the 18-25 age category. Although all of the women on the list have purchased from A Matter of School, the truth is that some have a better chance of contributing to the bottom line than others. Let's use the "3,3,3" method to find these people.

In the "3,3,3" method, we rate each candidate in terms of their Recency, Frequency and Monetary characteristics, attempting to narrow to those having:

1. bought in the last 29 days (Recency)
2. bought three or more times total (Frequency)
3. built up to a total purchase of $50 or more (Monetary)

Here's the parameters on spreadsheet.
Picture
As mentioned, we want to find only the candidates who rate a "3" in all categories. Here's what my analysis came up with.
Picture
We are left with seven women who fall into the "3,3,3" category:

Ami Stake
Anita Bath
Ester Bunni
Jan Edick
Mary Schultz
Nicole Dest
Tara Dactyl
2 Comments
Daifugoeyes link
12/18/2023 01:16:13 am

Awesome blog you havee here

Reply
Dudley Spanking link
6/7/2025 02:14:13 pm

This 3,3,3 method sounds like an effective way to identify valuable customers.

Reply



Leave a Reply.

    Assignment

    Develop an email marketing campain for
    A Matter of School, an online e-commerce retailer

    Archives

    April 2019

    Categories

    All

    RSS Feed

Picture
About   |  Advertise  |   Contact
7150 Indianapolis Blvd, Hammond, IN 46324 |   Map
Office: 219.844-1230 |  Studio: 219.845-1100
​[email protected]
Listen Live
© 2017 JED.tv and Vazquez Development LLC