Ranking customers

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48267
interpreted = N
texte = We'd like a way to rank our customers so that we can target our better customers with select promotions. One way would be to rank solely based on $ amount, but that probably doesn't tell the whole story. For example, someone might have purchase $750 from us on one order, and then never returned.Accordingly, I imagine it should be a weighted mixture of total $ amount purchased (+ weight), average $ purchase amount (+ weight), total number of purchases made (+ weight), frequency of purchases (+ weight) and time since last purchase in days (- weight)Any statisticians out there care to weigh in (no pun intended)?Comments, ideas, suggestions appreciated... --Will Starck NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Ranking customers (Matthew Bohne 2003)
  2. Ranking customers (WJ Starck 2003)
We'd like a way to rank our customers so that we can target our better customers with select promotions. One way would be to rank solely based on $ amount, but that probably doesn't tell the whole story. For example, someone might have purchase $750 from us on one order, and then never returned.Accordingly, I imagine it should be a weighted mixture of total $ amount purchased (+ weight), average $ purchase amount (+ weight), total number of purchases made (+ weight), frequency of purchases (+ weight) and time since last purchase in days (- weight)Any statisticians out there care to weigh in (no pun intended)?Comments, ideas, suggestions appreciated... --Will Starck NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ WJ Starck

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

300 ticks (2003) 2 easy questions re: [showif] and [sendmail] (1997) Search results output problems.. (2000) [url] link (1998) WCS Newbie question (1997) WebCatalog for Postcards ? (1997) database size? (1997) [subtotal] and others (1997) Buying sans cart (1997) Emailer (1997) Resume Catalog ? (1997) WebMerchant when CC network is down (1998) os x server (2000) dates and hex formatting (1997) Pipe Conversions (1998) Searching an Email database (1997) Can't Update records (1997) shipcost (1997) PSC recommends what date format yr 2000??? (1997) price on detail, but not shoppingcart (1997)