Database Reference
In-Depth Information
Table 4.18 The rate plan history table.
Field name
Field type
Field description
Customer_ID
Int
The customer ID
MSISDN
Int
The MSISDN (mobile phone/SIM number)
Rate_Plan
Int
The rate plan linked with the MSISDN
Paymethod
Char
The most recent payment method (cash, standing
order, credit card, etc.)
Opening_Date
Datetime
The opening date of the rate plan
Closing_Date
Datetime
The closing date of the rate plan (a future control
date is used when the rate plan is still open)
Opening_Type
Int
The opening type of the rate plan (e.g., new opening,
transfer, portability, etc.)
Closing_Type
Int
The closing type of the rate plan (e.g., voluntary
churn, portability, transfer, involuntary churn,
etc.)
If the rate plan is still open, the current status of the
rate plan is recorded (e.g., active, barred, etc.)
Customer_ID, MSISDN, Rate_Plan and Opening_Date are the primary keys (PKs) of this table.
MONTHLY INFORMATION
The next proposed tables include monthly aggregations of key usage data. They
can be used for summarizing and monitoring usage information such as traffic by
call type, day, time zone, type of origin, and destination network. The availability of
historical information allows customer usage to be tracked throughout the period
covered by the data mart.
According to the requirements of each organization, a specific subset of key
usage attributes could be monitored by weekly or even daily aggregations. For
example, daily aggregations of the total number and duration of calls can be used
for daily monitoring and reporting as well as for reactive campaigning. The daily
information on top-ups (purchase of new credit) by prepaid customers, apart for
reporting, can also be used for recency, frequency, monetary (RFM) monitoring
in order to identify early churn signals.
Outgoing Usage
One of the key objectives of a data mart should be the identification of the usage
patterns of each customer. The next proposed table (''M_Out_Usage''), Table 4.19,
Search WWH ::




Custom Search