Churn: Credit Rating and Mean Number

The Teradata Center for Customer Relationship Management
Cell2Cell: The Churn Game
Database Documentation
Note:
Position
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

Variables whose description begins with "Mean" are averages calculated over the four months previously to observing churn.

Variable Name revenue mou recchrge directas overage roam changem changer dropvce blckvce unansvce custcare threeway mourec outcalls incalls peakvce opeakvce dropblk callfwdv callwait churn months uniqsubs actvsubs csa phones models eqpdays customer age1 age2 children credita creditaa creditb

Variable Descriptiion
Mean monthly revenue
Mean monthly minutes of use
Mean total recurring charge
Mean number of director assisted calls
Mean overage minutes of use
Mean number of roaming calls
% Change in minutes of use
% Change in revenues
Mean number of dropped voice calls
Mean number of blocked voice calls
Mean number of unanswered voice calls
Mean number of customer care calls
Mean number of threeway calls
Mean unrounded mou received voice calls
Mean number of outbound voice calls
Mean number of inbound voice calls
Mean number of in and out peak voice calls
Mean number of in and out off-peak voice calls
Mean number of dropped or blocked calls
Mean number of call forwarding calls
Mean number of call waiting calls
Churn between 31-60 days after obs_date
Months in Service
Number of Uniq Subs
Number of Active Subs
Communications Service Area
# Handsets Issued
# Models Issued
Number of days of the current equipment
Customer ID
Age of first HH member
Age of second HH member
Presence of children in HH
Highest credit rating - a
High credit rating - aa
Good credit rating - b

N

Minimum Maximum Mean
Standard Deviation
70831
-6.1675
1223.38 58.852803
44.24358324
70831
0
7667.75 525.72839
530.1342588
70831
-11.29