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

Table 4.19 The outgoing usage table.

Field name Field type Field description

Year_Month Int The number indicating the year and month of the

data

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

Service_Code Int The service code that describes the type of call

(voice, SMS, etc.)

Network_Code Int The network code when calls were terminated (destination)

Roaming_Flag Bit A flag indicating if the calls originated from a foreign

country

Peak_Flag Bit A flag indicating if the calls started during peak hours

Working_Flag Bit A flag indicating if the calls started during working

days

Number_of_Calls Int Number of calls

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

Volume_of_Data Real Volume of data transferred (where applicable, for instance

Internet calls)

Rated_Amount Real The amount that was rated to the calls

Billed_Amount Real The actual amount to be billed for the calls

Intercon_Amount Real The interconnection cost of the calls

Year_Month, MSISDN, Service_Code, Network_Code, Roaming_Flag, Peak_Flag, and Working_Flag are the
primary keys (PKs) of this table.

contains monthly aggregations of outgoing traffic data. It records outgoing usage
behavior over time, summarizing the number and duration/volume of outgoing
calls by call type (voice, SMS, MMS, etc.), date/time, and type of destination
network (calls to fixed lines, international calls, calls to another mobile network
operator, etc.). This table is supplemented by a set of reference (lookup) tables
that decode the call characteristics. Traffic is summarized at an MSISDN level.
Further aggregations, for instance at a customer level, are also possible.

Top-up Information

Unlike postpaid customers who have a contract agreement and a billing
arrangement with the network operator, prepaid customers purchase services
in advance through top-ups. They can use their phone until they run out of
credit. The addition of more credit to their account is referred to as topping up