How a modern database system works

1. Using Lifetime Value to Increase Customer Retention and Repeat SalesACCM BostonWednesday, May 23 2007 10:45 a.m. - 12:00 p.m. Arthur Middleton Hughes Vice President / Solutions Architect KnowledgeBase Marketing

2. Marketing Staff -Access By Web Data Access And Analysis Software Customer Transactions Marketing Database Website Appended Data Modeling Inputs from Retail, Phone, Web How a modern database system works

3. Why retention is important • Repeat buyers: • Buy more per year • Buy higher priced options • Buy more often • Are less price sensitive • Are less costly to serve • Are more loyal • Have a higher lifetime value

4. Repeat sales is the way to measure loyalty

5. Keys to Retention • Recruit loyal relationship buyers rather than price cutting transaction buyers. • How? Emphasize service and quality rather than price • Greet customers when they come back • Find out more about your customers. Use this info in your messages • Give them a reason to come back soon. • We will cover 16 possible strategies…

6. Recruit relationship buyers • Transaction buyers only interest is price • Relationship buyers want a firm that gives good service to whom they can be loyal

7. How to find relationship buyers • Lowball offers will attract transaction buyers • You cannot make a profit from them • Relationship buyers are interested in good service, high value and two way loyalty • They will stick with you and provide a profitable bottom line

8. Two Kinds of Database People • Constructors People who build databases Merge/Purge, Hardware, Software • Creators People who understand strategy Build loyalty and repeat sales • You need both kinds!

9. We are going to explore ways of increasing catalog customer retention • We will list sixteen different things that you can try with your customer database to increase sales. • The beauty of a customer database is that it permits many tests with control groups. • We can test each new idea to see how well it will work before we roll it out. • First, we will develop a base line customer lifetime value…

10. What is Lifetime Value? • The net profits that you expect to receive from the average new customer during the next three or four years. • It includes the revenue, the costs, the profit and the discount rate. • Revenue includes the retention rate, number of orders per year, average order size.

11. Typical Catalog Customer Lifetime Table

12. Computing the discount rate • D = (1 + (Interest rate X 2) ^ n • Where n = years to wait. • If interest rate is 6%, then after 2 years • D = (1.12)^2 • D = 1.2544

13. How to get them to order more • You have a very narrow time window • People are in a buying mood, or they are not. • Give them a reason for buying more while they are in that mood. • Use the order confirmation process to get info and create a second sale • Here is how one company does this:

14. Get customers to register

15. When they register, use their name when they return

16. Shoeline.com provides 10% off on your next order • Coupon in the box when your shoes arrive. Coupon has a number. • Just use that number when you order

17. The Magic Coupon

18. I got 10% off on my second order. Nothing to send in. Just order with discount code, and they keep track of it.

19. Next step: Get customers to rate their ordering process From: ShoeLine.com Customer Service [ Sent: Monday, November 06, 2006 11:08 AM To: Hughes, Arthur Subject: Write a review for your purchase! Dear Arthur: We at ShoeLine.com would like to thank you for your purchase of the Supremes Grand Prix - Black. We hope you enjoy the product and that it met all your expectations! We would love to know what you thought of the shoe/accessory. Please visit our Customer Reviews page for your product and submit a review! The link is below: http://www.ShoeLine.com/asp/writereview.asp?style=G350001&Email=arthur.hughes@kbm1.com

20. The rating form Comments

21. From rating form, get testimonials. Put them on your website

22. Provide personalized order status

23. Improve the Search box

24. Provide Gift Wrapping.

25. Analyze the database • See which is worth more: Peak Season buyers or Off Peak Season Buyers. • Which customers buy more: Sale item buyers vs. Regular Price Customers • Which spend more by merchandise categories • Let the answers dictate marketing strategy.

26. Test use of emails with catalog mailing • Objective: understand incremental sales from catalog plus emails • Method: Send three different catalogs to test and control group with and without emails. • Measure: increased sales and reduced costs from use of emails.

27. Case Study: look in your mailbox for our catalog

28. Email advance of catalog test • Randomly selected 2 panels of 20,000 • All purchased on line • All received 3 print catalogs: Winter, Winter Remail and Spring. • Second panel also received three email newsletters: two after the catalog arrived, one before the catalog mailing.

29. Results – Email & Catalog vs. Catalog Only • Email & Catalog had total increase in sales of 18% over catalog only. • Email & Catalog increased number orders by 6% • Average order size increased by 11.8%

30. Total contribution* increase from emails plus catalogs • Increase in sales and decrease in operating expense resulted in: • Increase in total contribution by 43% • Increased contribution per order increased by 35% • Response rate increased by 5.9% * Contribution includes income from S&H plus sales

31. Provide a personalized gift organizer

32. A linen gift registry?

33. Use a gift registry Outfit new college students

34. College Student Segment – will they need linens?

35. Identify customer segments.An ideal segment… • Has definable characteristics • Is large enough to justify a custom marketing strategy with appropriate rewards and budget • Has members who can be motivated • Makes efficient use of availabledata • Can be measured in performance • Justifies an organization devoted to it. Can be part of a person’s time, but there should be someone who “owns” each segment.

36. Strategy for each segment: • Communications to the segment (direct mail, email, on-location personal attention) • Rewards designed to modify behavior • Controls to measure the success of the strategy • A budget for implementation of the strategy • Specific goals and metrics for engagement: for behavior modification • An organization that accepts responsibility for the segment

37. Marketing to Customer Status Levels Spend Service Dollars Here • GOLD Your Best Customers - 80% of Revenue Spend Marketing Dollars Here Your Best Hope for New Gold Customers Move Up 1% of Total Revenue Reactivate or Archive These may be losers

38. Segments and Status Levels

39. How one women’s chain segments their customers

40. How Sears Determines Segments

41. Next Best Product • Collaborative Filtering can be used to determine for each customer her next most likely product. • Customer service and the web have this info available whenever a customer visits or calls. • Tests with GUS, largest cataloger in the UK, resulted in doubling the cross sale rate (from 20% to 40%) using the next best product on the telemarketers screens

42. Amazon’s Next Best Product

43. Who offers collaborative filtering? • www.tornago.com/ : Users: Brylane, GUS, J C Penney • http://recommendations.loomia.com/ • http://eecs.oregonstate.edu/iis/CoFE/ Collaborative filtering (CF) is the method of making automatic predictions (filtering) about the interests of a user by collecting taste information from many users (collaborating). The underlying assumption of CF approach is that: Those who agreed in the past tend to agree again in the future. Study Netflix.com – Masters of Collaborative Filtering

44. Creating a club on the internet • A company selling sporting goods created an internet member club. • When database was built they learned that: • Club members bought 11 times more than non club members. • In two years, 81% of club members became multi-buyers. • The club boosted retention

45. Another example of a club

46. Gold Customer Loyalty Test • Selected 4,000 highly loyal customers • Divided into 2,000 test and 2,000 control • Sent a discontinued item as a gift to the 2,000 test with a thank you letter. • Included a catalog in the box. • Also sent same catalog without the letter or gift to the controls.

48. Results of Gold Customer Gifts • Test group placed 3% more orders than the control group. • Items per order increased by 2% • Average order size increased by 6% • Total dollars spent increased by 19% • Loyalty program was an outstanding success.

49. One Click Ordering • With the web we use cookies to say, “Welcome back Susan”. • We keep her credit card on file if she wants so she can do one click ordering • Result, compared to controls, is 18% higher annual revenue from those who have one click ordering available.

50. Summary of the possible strategies. Test the increase in LTV with…