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)
The Greatest Marketing Analytics Equation of All Time
It's 1992 at Lands' End, and I'm responsible for analyzing mail/holdout tests ... you execute email and/or print mail/holdout te...

-
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...
-
It's the story of 2015 among catalogers. "Our housefile performance is reasonable, but our co-op customer acquisition efforts ar...
-
This is where we're headed: Let's say you want to invest an additional $100,000 in paid search. You should be able to see a p&l,...
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.