Friday, June 19, 2009

Social network analysis from Call Detail Records ( CDR) transactions in Telecom industry

"Who talks to whom ?" is an important question marketers in the telecom industry can ask to discern customer behavior. Social network analysis can be done by analyzing call behavior data. There are 4 essential steps in doing this
Step-1:
Extract CDR information and summarize it for each unique combination of caller and called number

Step-2:
For each caller and called number, count the frequency of calls made, the number of smses sent, the number of prime time calls etc

Step-3:
Use this model to develop call behavorial profiles to target . Example : Friends and families program

Step-4 :
Interrogate the social network database for specific behavior . For example : Who are my existing customers who make more than 20 % of calls to competitive networks during peak time and either the call duration for day exceeds 90 minutes or number of calls per day exceeds 12 ?
Can we target them with a ‘friends and families’ scheme to bring their most frequent called numbers into our network fold and incentivise them in the process

No comments: