Here's one of two queries I like to run to identify customer reactivation / lapsed buyer problems.
Step 1 = Identify all customers who purchased in September 2014.
Step 2 = For all customers who purchased in September 2014, count the number who are not first-time buyers, and who had not purchased in the twelve months from September 2013 - August 2014. This is the number of customers who are "reactivated".
Step 3 = Re-run this query, shifting all dates back exactly one month. Count the number of reactivated buyers.
Step 4 = After running this query, going back in time several years, calculate the difference in the number of reactivated customers, year-over-year. For instance, if there were 900 reactivated customers in September 2014, and there were 1,000 reactivated customers in September 2013, then you have (900 / 1,000) - 1 = -10% change in reactivated buyers.
The image above is what I see, repeated over and over again for catalogers, and for retailers. In the past two years, the sky is falling. In retail, the more we encourage customers to sit at home and use devices, the more we're going to see this outcome. In cataloging, the more we ignore customers under the age of 50 by offering merchandise that appeals to customers over the age of 50, the more we're going to see this problem.
First, run the queries and quantify if you have a problem. Or contact me (firstname.lastname@example.org ... pricing details are found by clicking here) and I'll run this for you. This query yields results, folks, helping explain why lapsed buyers and new buyers are the Story of Fall 2014.
October 27, 2014
Ok, let's look at a practical example of Primary / Secondary / Tertiary categorization of merchandise categories. In this case, we ...
Look at the first four rows of our life table (values of 0/1/2/3). These are the first 12-15 weeks after a customer buys for the firs...
We spent the past two weeks talking about the events and influences that shaped what I call "The Great Eight". My Influence...
If you don't like geeky math, please skip this post, because I am about to show you how the sausage is made! I have eight variables in...