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

Table 4.28 ( continued )

Field name Field description

IN_CALLS_A Number of incoming calls from mobile

competitor A

IN_CALLS_B Number of incoming calls from mobile

competitor B

IN_CALLS_C Number of incoming calls from mobile

competitor C

IN_CALLS_FIXED Number of incoming calls from fixed networks

IN_CALLS_INTERNATIONAL Number of incoming calls from international networks

IN_CALLS_ROAMING Number of incoming roaming calls (voice calls received in

a foreign country)

IN_MINS_ONNET Total number of incoming on-net minutes

IN_MINS_A Total number of incoming minutes from

competitor A

IN_MINS_B Total number of incoming minutes from

competitor B

IN_MINS_C Total number of incoming minutes from

competitor C

IN_MINS_INTERNATIONAL Total number of incoming minutes from international

networks

IN_MINS_FIXED Total number of incoming minutes from fixed networks

IN_MINS_ROAMING Total number of incoming roaming minutes

Usage by day/hour:

OUT_CALLS_PEAK Number of outgoing calls in peak hours

OUT_CALLS_OFFPEAK Number of outgoing calls in off-peak hours

OUT_CALLS_WORK Number of outgoing calls in work days

OUT_CALLS_NONWORK Number of outgoing calls in non-work days

IN_CALLS_PEAK Number of incoming calls in peak hours

IN_CALLS_OFFPEAK Number of incoming calls in off-peak hours

IN_CALLS_WORK Number of incoming calls in work days

IN_CALLS_NONWORK Number of incoming calls in non-work days

Revenue:

OUTGOING_REVENUE Total amount of revenue from outgoing usage

INCOMING_REVENUE Total amount of revenue from incoming usage (inter-

connection costs paid by other operators to recipient's
operator)

MARPU Total MARPU (Marginal Average Revenue Per User)

value index