Question: Can you help me turn the data and answer what causes the churn (attrition)? Let's say it is due to unanswered calls, can you include
Can you help me turn the data and answer what causes the churn (attrition)? Let's say it is due to unanswered calls, can you include /show the data where you pulled it to support the answer. Thank you!
| customer | revenue | dropvce | blckvce | unansvce | custcare | threeway | mourec | outcalls | incalls | peakvce | opeakvce | dropblk | callfwdv | callwait | months | uniqsubs | actvsubs | phones |
| 1032537 | 37.41 | 15 | 0 | 49 | 7 | 0 | 59 | 47 | 1 | 112 | 60 | 19 | 0 | 0 | 21 | 1 | 1 | 2 |
| 1032542 | 33.395 | 1 | 0 | 0 | 0 | 0 | 27 | 12 | 0 | 9 | 16 | 2 | 0 | 0 | 25 | 1 | 1 | 1 |
| 1032546 | 32.78 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 12 | 6 | 1 | 0 | 0 | 19 | 2 | 2 | 1 |
| 1032549 | 28.075 | 1 | 0 | 8 | 6 | 0 | 1 | 6 | 1 | 50 | 21 | 1 | 0 | 0 | 21 | 2 | 2 | 1 |
| 1032551 | 81.555 | 2 | 2 | 16 | 1 | 0 | 97 | 16 | 15 | 71 | 35 | 4 | 0 | 0 | 23 | 3 | 3 | 2 |
| 1032552 | 15.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 25 | 1 | 1 | 2 |
| 1032557 | 34.64 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 4 | 5 | 2 | 0 | 0 | 23 | 2 | 2 | 1 |
| 1032562 | 85.765 | 9 | 4 | 113 | 3 | 2 | 358 | 132 | 77 | 194 | 378 | 17 | 0 | 3 | 21 | 1 | 1 | 2 |
| 1032565 | 29.55 | 1 | 16 | 7 | 0 | 0 | 9 | 15 | 0 | 60 | 17 | 17 | 0 | 0 | 21 | 1 | 1 | 2 |
| 1032567 | 32.445 | 3 | 0 | 11 | 0 | 0 | 76 | 24 | 1 | 68 | 29 | 3 | 0 | 0 | 19 | 1 | 1 | 1 |
| 1032568 | 83.96 | 2 | 5 | 47 | 3 | 0 | 91 | 9 | 0 | 357 | 25 | 7 | 0 | 2 | 25 | 1 | 1 | 2 |
| 1032572 | 56.185 | 2 | 0 | 8 | 0 | 0 | 58 | 32 | 3 | 66 | 54 | 2 | 0 | 0 | 25 | 2 | 2 | 1 |
| 1032574 | 90.545 | 16 | 19 | 96 | 11 | 1 | 773 | 231 | 114 | 474 | 506 | 38 | 0 | 45 | 21 | 1 | 1 | 8 |
| 1032580 | 32.1 | 1 | 0 | 10 | 0 | 0 | 20 | 4 | 0 | 32 | 25 | 2 | 0 | 0 | 21 | 2 | 2 | 2 |
| 1032584 | 60.365 | 3 | 3 | 19 | 1 | 0 | 69 | 26 | 11 | 77 | 55 | 6 | 0 | 2 | 25 | 2 | 2 | 3 |
| 1032585 | 30.535 | 2 | 0 | 12 | 1 | 0 | 16 | 10 | 3 | 42 | 9 | 2 | 0 | 0 | 21 | 2 | 2 | 1 |
| 1032586 | 39.895 | 1 | 8 | 10 | 0 | 0 | 180 | 5 | 0 | 94 | 33 | 10 | 0 | 0 | 23 | 1 | 1 | 5 |
| 1032587 | 66.81 | 3 | 1 | 34 | 0 | 0 | 278 | 84 | 32 | 128 | 152 | 4 | 0 | 2 | 21 | 1 | 1 | 1 |
| 1032593 | 57.555 | 13 | 7 | 55 | 0 | 0 | 82 | 39 | 7 | 102 | 78 | 25 | 0 | 1 | 21 | 4 | 3 | 4 |
| 1032604 | 69.11 | 9 | 3 | 65 | 5 | 2 | 256 | 92 | 10 | 201 | 256 | 16 | 0 | 2 | 21 | 1 | 1 | 1 |
| 1032609 | 32.195 | 2 | 0 | 8 | 1 | 0 | 0 | 4 | 0 | 52 | 6 | 3 | 0 | 0 | 21 | 1 | 1 | 1 |
| 1032611 | 29.82 | 1 | 0 | 0 | 0 | 0 | 3 | 2 | 0 | 34 | 10 | 1 | 0 | 0 | 19 | 1 | 1 | 1 |
| 1032616 | 29.55 | 3 | 14 | 10 | 11 | 1 | 89 | 0 | 0 | 71 | 30 | 17 | 0 | 0 | 21 | 1 | 1 | 1 |
| 1032617 | 101.555 | 28 | 98 | 20 | 8 | 2 | 163 | 22 | 0 | 145 | 77 | 133 | 0 | 6 | 19 | 1 | 1 | 2 |
| 1032619 | 75.48 | 3 | 8 | 34 | 0 | 0 | 74 | 23 | 39 | 122 | 37 | 12 | 0 | 1 | 23 | 4 | 4 | 4 |
| 1032620 | 45.255 | 5 | 0 | 27 | 0 | 0 | 92 | 1 | 0 | 78 | 45 | 6 | 0 | 1 | 19 | 1 | 1 | 1 |
| 1032625 | 52.09 | 1 | 6 | 54 | 1 | 0 | 30 | 18 | 1 | 75 | 41 | 6 | 0 | 1 | 23 | 1 | 1 | 2 |
| 1032629 | 49.84 | 3 | 0 | 304 | 1 | 0 | 50 | 1 | 4 | 62 | 29 | 3 | 0 | 0 | 19 | 1 | 1 | 2 |
| 1032631 | 29.55 | 3 | 0 | 15 | 0 | 0 | 17 | 6 | 0 | 36 | 14 | 3 | 0 | 0 | 21 | 1 | 1 | 1 |
| 1032634 | 29.82 | 1 | 1 | 5 | 0 | 0 | 3 | 3 | 0 | 15 | 17 | 2 | 0 | 0 | 19 | 2 | 2 | 1 |
| 1032648 | 73.72 | 5 | 0 | 1 | 5 | 0 | 232 | 22 | 3 | 97 | 147 | 6 | 0 | 3 | 25 | 1 | 1 | 2 |
| 1032652 | 76.145 | 1 | 1 | 10 | 0 | 0 | 0 | 0 | 0 | 34 | 12 | 3 | 0 | 0 | 25 | 1 | 1 | 1 |
| 1032653 | 29.55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21 | 1 | 1 | 1 |
| 1032654 | 26.06 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 1 | 0 | 0 | 19 | 2 | 1 | 1 |
| 1032656 | 55.075 | 5 | 0 | 24 | 2 | 0 | 86 | 26 | 9 | 59 | 60 | 7 | 0 | 1 | 19 | 1 | 1 | 2 |
| 1032658 | 50.225 | 3 | 0 | 12 | 0 | 0 | 2 | 3 | 1 | 15 | 25 | 3 | 0 | 0 | 21 | 1 | 1 | 1 |
| 1032663 | 31.99 | 1 | 2 | 2 | 0 | 0 | 38 | 12 | 6 | 50 | 8 | 3 | 0 | 1 | 23 | 3 | 2 | 1 |
| 1032666 | 29.975 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 4 | 0 | 0 | 0 | 25 | 1 | 1 | 1 |
| 1032677 | 32.125 | 3 | 11 | 46 | 4 | 0 | 118 | 11 | 10 | 79 | 49 | 13 | 0 | 0 | 23 | 2 | 2 | 3 |
| 1032678 | 30.705 | 0 | 0 | 7 | 0 | 0 | 0 | 4 | 0 | 23 | 15 | 0 | 0 | 0 | 19 | 1 | 1 | 1 |
| 1032680 | 29.55 | 2 | 2 | 16 | 0 | 1 | 40 | 8 | 10 | 50 | 16 | 5 | 0 | 1 | 21 | 3 | 3 | 1 |
| 1032690 | 28.59 | 0 | 3 | 15 | 0 | 0 | 6 | 5 | 0 | 14 | 11 | 3 | 0 | 0 | 21 | 1 | 1 | 1 |
| 1032691 | 28.325 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 1 | 1 | 1 |
| 1032707 | 96.075 | 6 | 1 | 25 | 0 | 0 | 180 | 28 | 1 | 125 | 90 | 9 | 0 | 2 | 25 | 1 | 1 | 1 |
| 1032710 | 28.075 | 1 | 15 | 3 | 0 | 0 | 7 | 5 | 2 | 14 | 23 | 16 | 0 | 0 | 25 | 5 | 3 | 2 |
| 1032715 | 29.55 | 0 | 1 | 38 | 1 | 0 | 0 | 11 | 0 | 27 | 24 | 1 | 0 | 0 | 25 | 2 | 2 | 1 |
| 1032716 | 29.55 | 1 | 1 | 4 | 0 | 0 | 1 | 2 | 0 | 19 | 6 | 2 | 0 | 1 | 21 | 1 | 1 | 1 |
| 1032720 | 46.76 | 1 | 1 | 12 | 0 | 0 | 6 | 2 | 0 | 26 | 18 | 2 | 0 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
