Want to identify the items that are associated with customers who do not repurchase at high rates in the future?
Pull a file that has one row for every item a customer purchased over the past two years, and store that file on your hard drive. Once you have this file, run the following SPSS code (SAS code would be amazingly easy to imitate, given this code --- and for that matter, your IT staffer could use SQL to replicate this code).
Seriously, it's this easy. Give it a try! If you want to add more sophistication, split your file into new customers and existing customers. And don't mock me for the simplistic code --- what do you want for four minutes of effort?!!
get file = 'h:\kevin\itemdetail.sav'.
select if (demand gt 0).
select if (quantity gt 0).
select if (order_date lt 20080800).
select if (order_date gt 20080700).
compute rebuy = 1.
aggregate outfile = 'h:\kevin\dummy.sav'
/presorted
/break = household_id
/rebuy = max(rebuy).
get file = 'h:\kevin\itemdetail.sav'.
select if (demand gt 0).
select if (quantity gt 0).
select if (order_date lt 20070800).
select if (order_date gt 20060800).
match files file = *
/table = 'h:\kevin\dummy.sav'
/by = household_id.
if missing(rebuy) rebuy = 0.
aggregate outfile = *
/break = item_number
/cases = n
/rebuy = mean(rebuy).
select if cases ge 200.
sort cases by rebuy(d).
formats cases(f8.0) rebuy(f6.4).
list.
execute.
Helping CEOs Understand How Customers Interact With Advertising, Products, Brands, and Channels
Subscribe to:
Post Comments (Atom)
Picklemall
Many of you have forwarded articles to me outlining how your local mall is considering taking empty space and turning it into pickleball cou...
-
It is time to find a few smart individuals in the world of e-mail analytics and data mining! And honestly, what follows is a dataset that y...
-
Sometimes you think "people already know this stuff". Sometimes you realize that Google Analytics give smart analysts almost no op...
-
If you want to understand why clients don't trust vendors and trade journalists, read this little peach from a week ago: Direct Mail is ...
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.