The Mining Data Mart - Data Mining Techniques in CRM: Inside Customer Segmentation - page 175

Table 4.28 ( continued )

Field name Field description

WAP_CALLS Number of WAP calls

TOTAL_OUT_CALLS Total number of outgoing calls (includes all call types)

DAYS_OUT Number of days with outgoing usage

VOICE_IN_CALLS Number of incoming voice calls

SMS_IN_CALLS Number of incoming SMS calls

MMS_IN_CALLS Number of incoming MMS calls

TOTAL_IN_CALLS Total number of incoming calls (includes all call types)

DAYS_IN Number of days with incoming usage

Minutes/traffic by service type:

VOICE_OUT_MINS Total number of minutes of outgoing voice calls

EVENTS_TRAFFIC Total events traffic

MMS_OUT_VOLUME Total outgoing MMS volume

GPRS_TRAFFIC Total GPRS traffic

VOICE_IN_MINS Total number of minutes of incoming voice calls

ACD_OUT Outgoing average call duration (minutes/outgoing calls)

ACD_IN Incoming average call duration (minutes/outgoing calls)

Usage by destination/source network:

OUT_CALLS_ONNET Number of outgoing calls on-net (internal network)

OUT_CALLS_A Number of outgoing calls to mobile competitor A

OUT_CALLS_B Number of outgoing calls to mobile competitor B

OUT_CALLS_C Number of outgoing calls to mobile competitor C

OUT_CALLS_FIXED Number of outgoing calls to fixed networks

OUT_CALLS_INTERNATIONAL Number of outgoing calls to international networks

OUT_CALLS_ROAMING Number of outgoing roaming calls (voice calls made in a

foreign country)

OUT_MINS_ONNET Total number of outgoing on-net minutes

OUT_MINS_A Total number of outgoing minutes to competitor A

OUT_MINS_B Total number of outgoing minutes to competitor B

OUT_MINS_C Total number of outgoing minutes to competitor C

OUT_MINS_INTERNATIONAL Total number of outgoing minutes to international

networks

OUT_MINS_FIXED Total number of outgoing minutes to fixed networks

OUT_MINS_ROAMING Total number of outgoing roaming minutes

IN_CALLS_ONNET Number of incoming calls on-net (internal network)

( continued overleaf )