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

Table 4.22 The incoming 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 received the calls)

Caller_Num Int The number that called the MSISDN

Network_Code Int The network code from where the calls originated

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 Caller_Number are the primary keys (PKs) of this table.

Table 4.23 A lookup table for rate plan codes.

Field name Field type Field description

Rate_Plan_Code Int The rate plan code

Rate_Plan_Desc Char The rate plan description

Rate_Plan_Group Char The rate plan group

Monthly_Fee Int The monthly fee of the rate plan

Free_Minutes Int The free minutes offered by the rate plan

Free_SMS Int The free SMSs offered by the rate plan

Free_MMS Int The free MMSs offered by the rate plan

Free_Data Int The free volume of data offered by the rate plan

Rate_Plan_Code is the primary key (PK) of this table.

competitor, etc.). Quite often the call and destination type are handled together
with a single code also used for rating - billing. The lookup tables presented below
complement the proposed data mart tables presented in the previous sections.

Rate Plans

The rate plan table (''L_Rate_Plan''), Table 4.23, provides a description of the
rate plan codes offered by the network operator. Information specific for each rate
plan (monthly fee, free airtime, etc.) should also be included in this table. The
table should also enable the categorization of customers as prepaid or postpaid,
according to their rate plan group.

Service Types

Usage behavior by service (call) type is monitored through a respective service
code field included in the usage tables presented above. Now a lookup table
(Table 4.24), decodes this information into understandable call types.