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

Table 4.21 The outgoing network table.

Field name Field type Field description

Year_Month Int The number that indicates the year and

month of data

MSISDN Int The MSISDN (the number that made the calls)

Called_Num Int The B-number (the number that received

the calls)

Network_Code Int The network code that calls were terminated

(destination)

Number_of_Calls Int Number of calls

Duration_of_Calls Real Duration of calls (in seconds, for voice calls)

Year_Month, MSISDN, Network_Code, and Called_Number are the primary keys (PKs) of this table.

number and duration/volume of incoming calls by call type, date/time, and type of
source network.

Outgoing Network
The proposed outgoing network table (''M_Out_Network''), Table 4.21, can be
used to extract the outgoing community size of each customer, which is the number
of distinct telephone numbers called. The community size can also be examined
by network destination, revealing the on-net and the off-net community of each
MSISDN. The on-net community refers to internal calls made to other MSISDNs
of the same network. The off-net community refers to calls made to external
networks and can be further broken down to reveal the community belonging to
major competitors.

Incoming Network
The proposed incoming network table (''M_Inc_Network''), Table 4.22, deals with
incoming traffic and indicates the sources (networks and telephone numbers) of
received calls.

LOOKUP INFORMATION

The main use of the lookup tables in the case of the mobile telephony mining data
mart is to decode and describe the different types of calls (voice, SMS, etc.), rate
plans (the type of contract that the customer has with the operator), and network
types (international, fixed line destination, internal network, external network,