• SAS - Business Intelligence - Churn and Campaign Management Solution For Telecom Industry

    SAS - Business Intelligence - Churn and Campaign Management Solution For Telecom Industry 


    In the advanced Telecommunication with the challenge mounting up between the specialist organizations, client securing and maintenance is a significant test. For the new contestants, securing the new clients is the most elevated need, though for the occupants, holding the income acquiring clients is basic.

    The telecom organizations can build benefit by making a prescient demonstrating for recognizing potential beat applicants and non-income winning clients; and can expand income and gainfulness by focused battling and limited time offers which won't just hold these clients yet additionally convert the non-income acquiring clients to productive income procuring clients.

    This article features the need of stir and crusade the executives and the use of SAS - Telecommunication Intelligence programming (TIS) for the reason. It additionally incorporates different usage challenges for SAS - TIS in the continuous situation.

    Beat Management

    Client obtaining and maintenance is a huge test in all businesses. In the Telecom business, it influences the gainfulness of the organization if a client beats before the organization can win back the venture it brought about in securing the client. Accordingly, it is exceptionally basic to recognize beneficial clients and hold them.

    With the telecom market winding up progressively aggressive, deciding the reasons of the client leaving the administration of the organization is progressively troublesome. In this condition, it is considerably progressively hard to foresee the likelihood of the client to leave in not so distant future. It is progressively testing to devise a cost-impact motivation to focus on the correct client to persuade him to remain with the organization.

    Prescient displaying of beat examination and the executive's targets producing scores delineating the likelihood of the clients to produce in the future. This mulls over various parts of the client's vulnerability to beat, including the historical backdrop of individuals the individuals who have stirred previously and assemble an information model that creates a straightforward reference numbers (scores) allotted to every client. These clients are then focused on motivators to deflect their retraction. As it were, Churn examination decides the plausible explanations behind a future retraction relying upon the past records which will assist the organizations with customizing their offer. For instance: if examination uncovers that numerous clients have agitated from a specific region a month ago and further examination has recognized that there are continuous call drops (disturbances in administration) in that trade (or BTS zone). It very well may be presumed that because of the specialized insufficiency of that specific trade, visit call drops are experienced which has added to the client disappointment and their moving out of the organization. So further specialized answer for that trade can anticipate future potential agitates.

    Business Definition of Churn Management

    Characterizing stir is as a matter of first importance movement in Churn Management planning. Various organizations characterize stir as indicated by their business encounters.

    Stir definition contrasts from a Pre-paid to Post-paid situation.

    In prepaid situation, a client can be considered as stirred in the accompanying cases:

    an) If the client leaves organize (deactivated)

    b) If the client is a functioning nonclient (ANU)

    A client can be considered as ANU when:

    I. the client has no cordial or approaching use for last (X) moving days

    ii. the client has just approaching use yet no out-going use for last (X) moving days iii. On the off chance that the client's utilization is underneath a pre-decided (business chose) sum for last (X) moving days.

    In post-paid situation, a client pays a rental on month to month premise. So if there should be an occurrence of non-utilization or lower-use, the organization gains fixed income from each post-paid client. In this manner, the client is considered as stirred just when he/she leaves arrange (Deactivated).

    Agitate Parameters for business examination

    After characterizing beat, the next action is distinguishing the right parameters for the commitment of agitating. The beat likelihood or stir scores for singular clients can be created based on following downright subtleties:

    1. Client socioeconomics Customer socioeconomics related information are utilized for sectioning the whole client base contingent upon:

    an) Age

    b) Sex

    c) Income

    d) Customer Account Information

    e) Subscription life cycle

    2. Charging and Usage:

    Charging and use related data that is gotten from switch (Call Data Records) is for the most part utilized for discovery of stir likelihood. The accompanying subtleties are utilized:

    a. Value plan

    b. Month to month use rundown (Charged call tally, Charged information volume, Free call, and Data sum)

    c. Month to month benefit commitment

    d. Bobbed installment

    e. Overseeing channel data

    f. Revive channel data

    g. System Product data ( Voice, Messaging, Data)

    3. Specialized Quality:

    The nature of administration is a potential beat driver as consider drops or substandard assistance quality builds the client disappointment and in this manner agitate likelihood. If there should be an occurrence of CDMA, as the client is firmly combined with the handset gear, the maturing of handset impacts the likelihood of the client stir.

    The accompanying subtleties are utilized:

    a. Dropped call checks

    b. Administration quality

    c. Gear age (Handset age if there should arise an occurrence of CDMA)

    4. Agreement Details: At the finish of the agreement time frame or elegance period, the likelihood of the client leaving the association is high, along these lines it has a high effect in the assurance of beat. The accompanying subtleties are utilized:

    a. Duty period

    b. Check of agreement restoration

    c. Current agreement and end date

    5. Occasion related:

    Dedication plan or reliability advantages are key drivers for maintenance. The Loyalty plan-related information is utilized for stir scoring.

    Distinguishing the source frameworks:

    After choosing the Churn parameters, the following stage is to distinguish the source frameworks from where the separate information will be extricated.

    For instance:

    Customer subtleties from the CRM framework

    Utilization and Billing related subtleties from Billing framework

    Specialized Quality from Exchange and CellSite

    Actuation subtleties from Provisioning framework

    Information Management

    Information the executives is the establishment of a business investigation. Right information ought to be available in the right spot.

    Information Management has three sections:

    Extraction: Involves separating of information from source framework and stacking to information exchange layer

    Change: Involves approval of the separated information (eg: Validation for exceptional keys), making of joining conditions among the tables, cleaning of invalid information and so on.

    Burden: Involves stacking the information in the Business Intelligence Data Warehouse

    Information Modeling and Churn Score age

    Once the verified information is accessible in the information distribution center, the information demonstrating is performed. It is an iterative procedure. The nature of the model is gotten to and the model which returns the best business worth is considered. This model gives brings about the type of beat score of individual clients which can be utilized for deciding effort targets.

    Utilizing the beat scores for Retention Campaigns

    The information model produces a singular client's stir score which reaches from 0 to 1.

    0 - Signifies least likelihood of the client to agitate

    1 - Signifies the most noteworthy likelihood of the client to agitate.

    These scores are weighted segments of different parameters, for example,

    Utilization data

    Equalization data

    Revive data

    Decrement (Promotional and Core) data

    Handset include

    System inclusion

    Nature of administration

    Client assistance/objections

    Value plan affectability

    Business choice should be taken to decide the upper edge of the stirring score. The clients over this limit should be broke down further (eg: clients with score 0.7 or more). The main two parameters adding to the agitate score to be created on a singular client level (for clients having stir scores more prominent than the edge). Contingent upon these parameters maintenance crusade can be done. The parameters can be as per the following:

    Utilization insights: The use of conduct can be gotten from the blend of decrement (promotion and center), balance and revive data. The client who has a higher score in "lesser use" can be focused on limited-time value plan offers to improve his/her use and convert that client from non-income gaining to income procuring.

    Higher Off-net use: The higher score on "off-net utilization" implies that the specific client has called habitually to different systems. A focused on battle can be performed with the value plan helpful to call different systems. A further examination of the canceled net numbers can bring about distinguishing every now and again canceled net numbers which can be focused by crusades as an applicant of securing.

    Handset Features: The handset utilized by the client can be old and be inadequate with regards to the cutting edge highlights. For this situation, the likelihood of the client to change to a more up to date handset is high and there is a significant defenselessness of that client to move to another specialist co-op having a packaged handset offer. A maintenance crusade can be focused (to this gathering of clients having high Handset beat score) with new assistance offer packaged with handset.

    Client assistance/Complaints: The higher score in Customer administration/Complaints implies that the client has called the client care as often as possible and the likelihood of that client disappointed with the administration is higher. Further examination of the client call cooperation subtleties can uncover the reason for every now and again calling to client assistance. After the execution of battles based on the agitate score and stir drivers.

    Executing Churn Management Solution Implementation Steps

    The accompanying stages are associated with Churn Management arrangement usage:

    1. Prerequisite Analysis: In this stage, the business necessities are accumulated and examined and business definitions for beat are chosen

    2. Arrangement Assessment: In this stage, the business knowledge arrangements are evaluated with the significant level prerequisite of the actualizing organization. The attainability test is finished relying upon the elevated level of business prerequisite and information accessibility.

    3. Definite Analysis/Detailed plan: In this stage, the business prerequisites for the Churn Management venture are broke down inside and out for structure, advancement, and upgrade of the task. An activity is performed to comprehend the accessibility/inaccessibility of data required to satisfy the business prerequisites and information mapping from the source framework.

    4. Information Analysis - ETL: In this stage, the information is removed from the source framework, changed (cleaned/adjusted for missing fields and information quality is broke down) and afterward stacked into Data Warehouse of the business knowledge device.

    5. Information Modeling: In this stage, the explanatory information models are made by measurable strategies (eg: Logistic relapse strategy) on chronicled information for agitating score forecast and Analytical Base tables are populated by information.

    6. Announcing: The beat score (0-1: 0 - implies less likelihood of stir, 1 - Maximum likelihood of agitate) is produced at every client/account/membership level and relating report is created.

    7. Client Acceptance Test and Roll-out: On consummation of fruitful UAT, the product is turned out for the business clients.

    Execution Challenges

    There are a few difficulties when a business insight arrangement is executed in a tremendous size of a large number of clients.

    The significant time of the usage is devoured by information from the executives. Information the executives uses 75% of the all-out usage time. Information Management incorporates:

    Distinguishing proof of source frameworks from where information should be removed:

    Because of the association of numerous source frameworks (CRM, Provisioning framework, Billing, Mediation frameworks and so forth.), it turns out to be progressively hard to recognize the right source framework for different information fields. ID of the right information source and mapping to DIL fields expends the dominant part of the usage time. On the off chance that the information source mapping isn't right, at that point, the resulting steps of execution (demonstrating, examination) will likewise be wrong. Accordingly, uncommon consideration should be taken during the information social occasion work out.

    Information Quality: Data acquired from the source frameworks should be of high caliber and mistake-free. The significant test in executing a business investigation arrangement is getting excellent information. Tidying up of information and filling the missing fields devour impressive measures of execution time.

    Change the board: With the execution of a BI arrangement, the clients need to change how they used to direct agitate expectations and crusade the executives. Along these lines, client flexibility and client mindfulness should be developed through appropriate instructional courses

    To make the Business Intelligence framework operational: After the execution, an explicit hierarchical structure for dealing with the BI activities should be arranged and the assets should be prepared in the necessary territories.

    SAS in business investigation

    SAS is a main business investigation programming and specialist co-op in the business knowledge area. It has conveyed demonstrated answers for getting to applicable, dependable, steady data all through the associations helping them to settle on the correct choices and accomplish feasible execution improvement just as relieve dangers.

    SAS has an all-encompassing ability to take care of information of a huge scale (with the assistance of SAS-SPDS - adaptable execution information server). This joined with a solid programming language and enhanced graphical interface has separated it from the other expository apparatuses accessible in the market. This makes SAS superbly reasonable for big business utilization where it requests the treatment of immense information stores.

    SAS - Telecommunication Intelligence Solution (TIS)

    SAS has a few industry explicit arrangements. SAS has bundled its business examination information as models, forms, business rationale, questions, reports, and investigation.

    TIS is the telecom business explicit business logical arrangement that has been assembled explicitly to the telecom industry needs. This arrangement helps the telecom specialist co-ops with explicit modules, for instance:

    SAS Campaign Management for Telecommunication

    SAS Customer division for Telecommunication

    SAS Customer maintenance for Telecommunication

    SAS Strategic Performance Management for Telecommunication

    SAS Cross-sell and Upsell for Telecommunication

    SAS Payment chance for Telecommunication

    SAS agitate the board and battle the board arrangement incorporates Segmenting the whole client base

    Identifying the reasons for stir

    Scoring the individual client based on their beat likelihood

    This beat score is additionally utilized as a contribution to battle the executives.

    SAS Datastream (Architecture)

    The information should be gathered from different source frameworks.

    CRM framework: Customer/Account/Subscription related information

    Provisioning framework: Activation date, gear (Handset) age Billing System: Billing information

    Intervention System: Call record subtleties

    The information is gathered in the Data Interchange Layer (DIL). The information is then extricated, changed and stacked into Detailed Data Store (DDS).

    The information is utilized for:

    1. Dimensional Data Modeling: This is utilized for question, detailing and OLAP (Online Analytical Processing)

    2. ABT (Analytical Base Table): This is the arrangement explicit model created which can be utilized for a specific investigation. For instance: The ABT for stir model.

    3. Crusade Data Mart: This information is utilized for focusing on explicit client portions for focused battle.


    Along these lines, it is basic that beat administration is a basic test in the cutting edge Indian media transmission industry. Recognizing the best possible explanation of beat and foreseeing stir ahead of time can spare the organization from significant income misfortune.

    Business Intelligence instruments help the telecom specialist organizations to perform information examination and to anticipate the agitate likelihood of a specific client. Aside from the beat prescient investigation, the devices can be utilized for different examination to help the business choices.

    SAS can possibly deal with the immense volume of information. As a business insight apparatus, SAS engages the business to effectively deal with the colossal volume of information and perform an investigation on the accessible data for many clients. Also, SAS with its media transmission explicit arrangement (TIS - Telecom Intelligence Solution) helps with building the information distribution center to hold the necessary parameters for further examination.

    Along these lines, SAS-TIS can be an effective device for business knowledge exercises in the telecom business.

    No comments