topic Re: What is the best method of Building Customer profile? in Statistical Procedures https://communities.sas.com/t5/Statistical-Procedures/What-is-the-best-method-of-Building-Customer-profile/m-p/153179#M8012 <HTML><HEAD></HEAD><BODY><P>Sounds good. Do you have any doubts? And what are the requirements for this profiling?</P></BODY></HTML> Wed, 04 Feb 2015 17:27:56 GMT LinusH 2015-02-04T17:27:56Z What is the best method of Building Customer profile? https://communities.sas.com/t5/Statistical-Procedures/What-is-the-best-method-of-Building-Customer-profile/m-p/153178#M8011 <HTML><HEAD></HEAD><BODY><P>o&nbsp; </P><P><SPAN style="color: black; mso-ascii-font-family: Calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman';">I am trying to build a customer profile and collected 12 months historical<BR />data. The data set contains CustID, 12 month avg number of deposits and average $ deposited. </SPAN></P><P><SPAN style="color: black; mso-ascii-font-family: Calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman';">The customer profile contains multivariate numerical summaries behavior pattern, so future<BR />behavior of the client can then be compared with his/her profile in order to<BR />exam the consistency with it (normal behavior) or any deviation from client<BR />profile on monthly basis. </SPAN></P><P></P><P><SPAN style="color: black; mso-ascii-font-family: Calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman';">Any thoughts on this?</SPAN></P><P></P><P></P><P><SPAN style="color: black; mso-ascii-font-family: Calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman';"> </SPAN></P></BODY></HTML> Wed, 04 Feb 2015 16:51:59 GMT https://communities.sas.com/t5/Statistical-Procedures/What-is-the-best-method-of-Building-Customer-profile/m-p/153178#M8011 Liban 2015-02-04T16:51:59Z Re: What is the best method of Building Customer profile? https://communities.sas.com/t5/Statistical-Procedures/What-is-the-best-method-of-Building-Customer-profile/m-p/153179#M8012 <HTML><HEAD></HEAD><BODY><P>Sounds good. Do you have any doubts? And what are the requirements for this profiling?</P></BODY></HTML> Wed, 04 Feb 2015 17:27:56 GMT https://communities.sas.com/t5/Statistical-Procedures/What-is-the-best-method-of-Building-Customer-profile/m-p/153179#M8012 LinusH 2015-02-04T17:27:56Z Re: What is the best method of Building Customer profile? https://communities.sas.com/t5/Statistical-Procedures/What-is-the-best-method-of-Building-Customer-profile/m-p/153180#M8013 <HTML><HEAD></HEAD><BODY><P>The type of customer profiles you build will depend on the purpose for these. It appears that so far you just focused on customer deposits. It would suggest you should also look at withdrawals and transactions in total, along with account balance. Whether the account as an overdraft facility (a limit) would also be useful.</P><P></P><P>If the profiles are to be used for marketing purposes, then you would also need to focus on account behaviour scores (if lending accounts) and also track over limit behaviour.</P><P></P><P>Don't forget customer personal attributes as well, like age, time with bank, employment status, income etc.&nbsp; </P></BODY></HTML> Wed, 04 Feb 2015 18:47:10 GMT https://communities.sas.com/t5/Statistical-Procedures/What-is-the-best-method-of-Building-Customer-profile/m-p/153180#M8013 SASKiwi 2015-02-04T18:47:10Z Re: What is the best method of Building Customer profile? https://communities.sas.com/t5/Statistical-Procedures/What-is-the-best-method-of-Building-Customer-profile/m-p/153181#M8014 <HTML><HEAD></HEAD><BODY><P>What if the client has a different periodicity for a behavior than monthly. For example self-employed and paying estimated income tax quarterly. You would see a "spike" in withdrawal totals every three months and those months would not "match" a monthly profile.</P><P>Also some type of payment may be received every 6 months or annually, especially if it is a big percentage of total deposits.</P><P></P><P>You might need to segment your client based on some criteria before using a simpler monthly comparison.</P><P></P><P>And don't forget that the average working stiff getting paid every two weeks has 2 months every year with 3 paychecks instead of 2.</P></BODY></HTML> Wed, 04 Feb 2015 20:30:42 GMT https://communities.sas.com/t5/Statistical-Procedures/What-is-the-best-method-of-Building-Customer-profile/m-p/153181#M8014 ballardw 2015-02-04T20:30:42Z