April 04, 2021

The Master Sheet: Indexed Performance by Frequency Segment

When I review how well you perform at your Customer Development duties, I typically look at three key attributes.

  1. Comparison of first-time buyer response in months 1/2/3 vs. other months (i.e. the Welcome Period).
  2. Annual repurchase rates for 1x / 2x / 3x / 4x / 5x buyers, to determine "when" a customer becomes loyal.
  3. Gains in response after a 2nd purchase, after a 3rd purchase, after a 4th purchase, and after a 5th purchase. These gains are called "Indexed Performance".
Look at the top row of the farthest left columns in the Master Table.


At recency = 1 month, first-time buyers have a 7.4% chance of buying again.

At recency = 1 month, second-time buyers have a 10.0% chance of buying again.

Indexed Performance for 2x buyers vs. 1x buyers is 10.0/7.4 = 1.351.

For every recency level I calculate Indexed Performance for 2x-vs-1x buyers, for 3x-vs-2x buyers, for 4x-vs-3x buyers, and for 5x-vs-4x buyers. The salmon-colored cells in the table illustrate Indexed Performance.

Why do I care about Indexed Performance?

Simple. I get to compare your Indexed Performance against a baseline I've developed across many brands. I get to see how well you Develop Customers against the baseline. If you have weaknesses, I get to see your weaknesses. If you have strengths, I get to illustrate to you what your strengths are.

Your homework assignment is to look up and down the salmon-colored section of the table. Tomorrow we'll address the middle portion of the table ... the meaty section that determines if you do a good job at Customer Development or not!




No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

The Master Sheet: Customer Value

Here's the Master Sheet we've evaluated for more than a week. Today we'll look at the portion of the table on the far right, col...