外文翻譯--數(shù)據(jù)挖掘在crm中運用

1、<p><b>　　附 錄 一</b></p><p><b>　　調(diào)研報告</b></p><p>　　數(shù)據(jù)挖掘在CRM中運用</p><p>　　(1)通過數(shù)據(jù)挖掘獲得新的客戶。</p><p>　　在CRM中首先應識別潛在客戶，然后將他們轉(zhuǎn)化為客戶。Big Bank and Cred

2、it Card(BB&CC)公司每年通過郵遞的方式開展25 次促銷活動，每次給一百萬人提供申請信用卡的機會，BB&CC 公司會將信用高的申請者接受為服務對象，最終只有1%的申請者成為用戶。</p><p>　　BB&CC公司所面臨的挑戰(zhàn)是如何讓郵遞促銷活動更加有效。首先，BB&CC公司抽取了一個50,000人的樣本，做了一個測試。在樣本測試結果分析的基礎上建立了兩個模型，一個用來預

3、測誰將填寫申請表（使用決策樹方法），另一個是信用評估模型（使用神經(jīng)網(wǎng)絡方法）。從剩下的950,000 個人中再次抽取700,000個樣本，使用模型找出哪些人會對促銷活動做出反應，并且具有良好的信用。結果如下：包括建模型時用的50,000 共抽取了750,000個樣本，其中9,000 個申請者被接受，接受率從1%上升到了1.2%。</p><p>　　數(shù)據(jù)挖掘雖然不能準確的識別哪10,000個申請者最終會成為用戶，

4、但是可以促使營銷活動更加有效。</p><p>　　(2)通過數(shù)據(jù)挖掘使用交叉銷售提高現(xiàn)有客戶的價值。</p><p>　　Guns and Rouses(G&R)公司銷售的產(chǎn)品是：仿迫擊炮與大炮的室外花盆和仿大口徑手槍與長槍的室內(nèi)花盆。產(chǎn)品表被發(fā)往12,000,000個家庭。當客戶電話定購某個產(chǎn)品時，(G&R)公司會積極的推銷其它的產(chǎn)品——交叉銷售。但是，(G&R

5、)公司發(fā)現(xiàn)只有1/3的客戶允許他們提出建議，最終的交叉銷售率不足1%，并招致了一片抱怨聲。為此B&R公司想確定到底是哪些人在定購某個產(chǎn)品的同時需要其他的產(chǎn)品。</p><p>　　G&R公司建立了兩個數(shù)據(jù)挖掘模型，一個是用來預測某個客戶是否會被建議觸怒，另一個用來預測什么樣的建議會被很好的接受。數(shù)據(jù)挖掘模型使用客戶信息數(shù)據(jù)庫中客戶的信息和新的客戶信息，告訴銷售代表哪種人可以采用交叉銷售的方式以及建

6、議什么產(chǎn)品。交叉銷售的成功率上升到了2%，而且很少有抱怨。</p><p>　　數(shù)據(jù)挖掘幫助B&R公司更好的了解了客戶的需求。當把數(shù)據(jù)挖掘模型與典型的CRM交叉銷售活動結合起來時，B&R 公司的景況完全改變了。</p><p>　　(3)通過數(shù)據(jù)挖掘提高現(xiàn)有客戶的價值</p><p>　　Big Sam’s Clothing 是一家制衣公司，它建立了

7、一個網(wǎng)站，提供了友好的用戶登陸界面;進行在線銷售。一旦你定購了某件商品或注冊為成員后，公司將會通過電子郵件的方式向你推薦一些你可能感興趣的新產(chǎn)品F當你在網(wǎng)站上查閱一件產(chǎn)品時，網(wǎng)站會向你推薦一些與該產(chǎn)品有關的你可能感興趣的產(chǎn)品。</p><p>　　當公司最初建立這個網(wǎng)站時，根本沒有考慮個性化，僅僅將它作為一個產(chǎn)品目錄的在線版。借助數(shù)據(jù)挖掘工具公司改善了網(wǎng)站的結構，使用聚類方法將以往按產(chǎn)品類型分類替換成按互補原則分

8、類。當客戶尋找某個商品時便可以使用這些分組提供建議，然后建立客戶數(shù)據(jù)，識別哪些客戶可能對產(chǎn)品目錄中添加的新產(chǎn)品感興趣。同時，Big Sam’s 公司用數(shù)據(jù)挖掘預測那些會引起客戶興趣的新產(chǎn)品，并通過電子郵件傳遞給客戶，客戶可以選擇是否接收。</p><p>　　Big Sam’s 公司確定了個性化戰(zhàn)略，通過提供主動性客戶服務指導客戶挑選商品，不僅增加了銷售額而且加強了與客戶之間的聯(lián)系?？蛻粢呀?jīng)將它看作購物時忠實的顧

9、問。</p><p>　　(4)通過數(shù)據(jù)挖掘保留忠實客戶。</p><p>　　Know Service公司是一家網(wǎng)絡服務公司，像其它的公司一樣也在不停地流失客戶。流失率每月8%，這意味著現(xiàn)有的一百萬個客戶中每個月會有80，000個客戶流失。Know Service公司重新尋找一個客戶的成本是$200，每個月公司要在尋找新客戶上投資$16,000,000，因此Know Service公司需

10、要數(shù)據(jù)挖掘的幫助。</p><p>　　Know Service公司掌握了客戶的大量上網(wǎng)信息和客戶的個人信息，構建了客戶信息數(shù)據(jù)庫。Know Service公司做的第一件事就是從客戶數(shù)據(jù)庫中選擇、轉(zhuǎn)變數(shù)據(jù)。接下來所作的就是根據(jù)客戶支出、生命周期對客戶進行劃分，并判定客戶的持久性，識別哪些客戶在將來會成為忠實的客戶然后在忠實的客戶中識別哪些有可能流失。第三步，確定最優(yōu)服務、保持客戶忠實。例如對上網(wǎng)支出大的客戶可以提

11、供包月的服務而不是提供更加大的主頁空間。</p><p>　　結果客戶流失率從原來的8%下降到7.5%，每個月節(jié)省了$1,000,000。</p><p>　　Research Report</p><p>　　The data mining is using in the CRM</p><p>　　(1)Acquire the new c

12、ustomers through data mining.</p><p>　　Should identify the latent customer first in the CRM, and then convert them as the customer. Annually the Big Bank and Credit Card (BB& CC) company opens the exhibi

13、tion in the way of postal delivery to promote sales the activity 25 times, the every time gives 1,000,000 people the opportunity that provides to apply for the credit card, the BB& CC company meeting accept high appl

14、icant of reputation for the service object, end only have 1% applicant to become the customer.</p><p>　　How the challenge that the BB& CC company face is let the postal delivery promotes sales the activi

15、ty more valid. First, the BB& CC Company sampled the sample of a 50,000 people, doing a test. Test the analytical foundation of result in the sample up built up two models, a uses to predict who will fill in the app

16、lication form (usage the decision tree method), the is the reputation valuation model. (Usage the nerve network method)From leave of 950,000 personal medium samples 700,000 samples agai</p><p>　　The data min

17、ing although can't identify accurately which 10,000 applicants end will become the customer, can urge the marketing activity more valid.</p><p>　　(2) Cross the value that the sale raises the existing cus

18、tomer through data mining.</p><p>　　The product of the Guns and Rouses (G& R) Company sale is: Imitate the outdoors flower pot of the trench mortar and big gun and imitate the big caliber revolver with i

19、ndoor flower pot of the long gun. The product watch is disheveled hair to go toward 12,000,000 families. When customer's telephone orders a certain product, (G& R) the company will promote other products actively

20、- cross the sale. But,( G& R) the company detection only have 1/3 of customer allow they put forward the suggestion, at l</p><p>　　The G& R Company built up two types model of data mining, the one is

21、 used to predict whether a certain customer will is suggest to infuriate or not, the another is used to predict what kind of suggestion would accept well. The data mining model uses the customer the information database

22、in the customer's information and new customer's information, tell the sales representative which grow the person to can adopt way and suggestions of cross the sale what product. The success rate that crosses the

23、</p><p>　　Data mining is to help the B& R Company better understood the customer's need. When cross the sales activity knot to the CRM that data mining model and typical model to put together, comple

24、tely change of the general condition of the B& R Company.</p><p>　　(3) Improve the value of customer through data mining.</p><p>　　The Big Sam's Clothing is a dress company, which built

25、up a website, providing the customer debarkation interface of the amity; carry on the on-line sale. Once you ordered a certain merchandise or register for the member, the company will recommend some your possible interes

26、ted in new product Fs to be you toward you in the way of E-mail to check a product on the website, the website will recommend some your possible interested in product for having something to do with that products toward

27、you.</p><p>　　When the company builds up this website at the beginning, it did not consider all characteristics, and to be an on-line version of catalogue only. Ask the data mining tool for help the company

28、improved the structure of the website, use gather a method and will press the product type classification to substitute before press to repair the principle classification with each other. When the customer looks for cer

29、tain merchandise can use the set of these cents to provide the suggestion then, then bu</p><p>　　The Big Sam's company made sure the characteristic strategy, passing to provide active sex customer the se

30、rvice guides the customer to choose the merchandise, not only increasing to sell the sum but also strengthening with the contact between customer. The customer has already seen it to adviser of make the allegiance of sho

31、pping.</p><p>　　(4) Reserve the faithful customer through data mining.</p><p>　　The company of Know Service is a network service company, which being like other companies also is at run off the

32、customer without intermission. The rate of running off is monthly 8%, this means that 1,000,000 existing customers win to there will be monthly 80,000 customers run off. The cost that the company of Know Service re- look

33、s for a customer is$200, the company want to invest in looking for the new customer monthly$16,000,000, therefore the company of Know Service demand the data mining f</p><p>　　The company of Know Service con

34、trolled the customer in great quantities get to the Internet personal information of information and customer, set up customer's information database. The first matter that the Know Service Company does is from custo

35、mer's database to win election to choose, change data. Connect down make according to the customer to expend, the life cycle carries on the demarcation to the customer, and judge the customer's last long, identif

36、y which customers will become the faithfu</p><p>　　At result, the rate of running off of the customer is descending to 7.5% from original 8%, saving monthly$1,000,000.</p><p><b>　　附 錄 二<

37、;/b></p><p><b>　　操作手冊</b></p><p>　?。?）首先，進入登入界面，根據(jù)不同的部門，輸入相應的用戶名與密碼，進入相應的權限限制。</p><p>　　進入用戶信息管理模塊，可以對用戶信息進行瀏覽，可以增加或刪除用戶，修改密碼。</p><p>　　進入客戶資料模塊，可以選擇查看客戶

38、基本信息、判斷客戶屬性資料(粗糙集數(shù)據(jù))、發(fā)掘潛在客戶資料(關聯(lián)規(guī)則數(shù)據(jù))和分析客戶流失資料(決策樹數(shù)據(jù))。</p><p>　　若選擇查看“客戶基本信息”</p><p>　　可以對客戶信息進行瀏覽，可以增加、修改、刪除，還可以按不同的方式進行查詢。</p><p>　　若選擇查看判斷客戶屬性資料、發(fā)掘潛在客戶資料和分析客戶流失資料，可以查看各個對應的數(shù)據(jù)表，進行

39、增加或刪除。</p><p>　?。?）進入客戶分析模塊，可以選擇判斷客戶價值(粗糙集)、發(fā)掘潛在客戶(關聯(lián)規(guī)則)、分析客戶流失(決策樹)和客戶價值優(yōu)化（遺傳算法）。</p><p>　　若選擇“判斷客戶價值”</p><p>　　在彈出的對話框中單擊“屬性約簡”，在下面的列表框中會輸出約簡后的核屬性和相對約簡簇</p><p>　　然后單擊

40、“值約簡”，在下面的列表框中也會輸出經(jīng)過值約簡后的信息表。</p><p>　　選擇一組屬性，就能判斷這個客戶是高價值的還是低價值的。</p><p>　　“顯示信息”可以將信息顯示到列表框中，同時我們還可以對列表框中的信息進行“刪除信息”和“刪除所有信息”等操作。</p><p>　　若選擇“發(fā)掘潛在客戶”</p><p>　　首先，選擇單

41、擊“參數(shù)設置”，彈出參數(shù)設置對話框，其中“產(chǎn)品總數(shù)”表示公司的產(chǎn)品個數(shù)，是一個大于0的數(shù)，“支持度”</p><p>　　是一個大于等于0小于等于1的數(shù)，表示產(chǎn)品被購買的頻率，“置信度”也是一個從0到1的數(shù)。設置好后點擊OK。</p><p>　　單擊“頻繁項目集”，輸出頻繁項目</p><p>　　單擊“輸出強關聯(lián)規(guī)則”，輸出強關聯(lián)規(guī)則到下面的列表框</p&

42、gt;<p>　　點擊“輸出潛在客戶”得到我們所需要的客戶</p><p>　　如果想進一步了解潛在客戶信息，可以按客戶ID查詢客戶信息。</p><p><b>　　若選擇客戶流失分析</b></p><p>　　在彈出的對話框中選擇單擊“決策樹導出”在下面的列表框中會輸出決策樹流失模型，單擊屬性前面的“+”可以打開樹的分支&l

43、t;/p><p>　　這樣我們選擇下面下拉框中的一組屬性，單擊“判斷是否流失”就能判斷這個客戶是否存在流失的可能或是無法根據(jù)屬性判斷。</p><p>　　“添加用戶信息”可以將選擇屬性信息顯示到列表框中，同時我們還可以對列表框中的信息進行“刪除用戶信息”和“清空用戶信息”的操作。</p><p><b>　　若選擇客戶價值優(yōu)化</b></p