2. List Segmentation - RFM

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.

As mentioned, we want to find only the candidates who rate a "3" in all categories. Here's what my analysis came up with.

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