The following is from the July 2009 Drilling Down Newsletter. Got a question about Customer Measurement, Management, Valuation, Retention, Loyalty, Defection? Just ask your question. Also, feel free to leave a comment.
Q: I’m involved in a loyalty program analytics project. This client is a local pharmacy. All sales are done directly in store, the web site is just for communication purposes. The general problem we are trying to solve is the manager doesn’t have any detailed ideas about shoppers behavior apart from human observation.
The idea is to launch a card-based loyalty program which will track sales activity and give insight into customer behavior. The program will be points-based calculated on amount spent. Points can be redeemed as rebates, coupons, gift certificates, or use points to buy items in loyalty program catalog.
The task is to segment customers according to their recent purchase behavior and determine the customer lifecycle. I’ve been able to do some basic analysis using the R package and MySQL database, but am unable to detect customer lifecycle.
Can you please give me guidance on this?
A: What is the Objective of detecting the LifeCycle, to create a more “active” customer retention program? Loyalty programs can be quite “passive” and often benefit from a more active overlay. But there can be many reasons to want to understand the LifeCycle…
Q: My 2nd task is to use the behavioral data with demographics to build a direct marketing strategy and provide management with insight into the customer base, for example: percent new customers, % of Gold customers who passed to Silver in last quarter.
A: Again, it would be helpful to understand how management would take action on this data. But I suppose you are in the common position of not knowing the tactical approach, and nobody will lay it out for you (a.k.a. they are clueless)…and you don’t know the right questions to ask or how to ask them.