Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Prepare Data for prediction churn analysis

Reply
New Contributor
Posts: 2

Prepare Data for prediction churn analysis

[ Edited ]

Hello,

 

I am a beginner in modeling and preparation of data for modeling.
Currently, we prepare the data for modeling churn customers in the TELCO and I have the following problem.
I churn for the period 201505 and to join these data variables for say 6-9 months before the churn rate and it will targer churn = 1.
The problem is with the TARGET = 0, which here should take contracts?
Is such a database only from the period 201411 and variable calculated from 201411 to 201505? (only those which do not churn)?
Should I take the entire database, or for example if I examine the commercial churn (201505) to take the base of such 201411,
which will EOP (End of period) in the coming months (eg 6 months)?

Apologizes for probably a trivial question, but as I wrote above, I am a beginner.
Thank you very much for your help, advice, suggestions on what I should pay attention to.

Thanks
Pete

Qb-eg
Super User
Posts: 17,905

Re: Prepare Data for prediction churn analysis

I'm having a hard time understanding your question.
But here's a paper on using survival analysis with churn from a telecom company, including their sampling specifications.

I like survival analysis for churn because it helps to account for customers who are still active as well as those that churn.
Contributor
Posts: 51

Re: Prepare Data for prediction churn analysis

where is the paper on this subject? Im interested in doing the same thing and I just want to get an idea on how the data should be structured. For example i want to get propensity to churn in the next 30 days in telco. So i have my customer base this month should i go 12 months back and have data for each month?

SAS Super FREQ
Posts: 272

Re: Prepare Data for prediction churn analysis

Here are a couple resources on survival data mining.

 

http://support.sas.com/rnd/app/video/index.html#txtmine

(See videos Introduction to Survival Data Mining and New Features in the SAS Enterprise Miner 12.3 Survival Node)

 

and this tip that gives a link to an example SAS Enterprise Miner template and accompanying documentation for survival data mining:

https://communities.sas.com/t5/SAS-Communities-Library/Survival-Data-Mining-by-Example-in-SAS-Enterp...

 

https://support.sas.com/resources/papers/proceedings12/132-2012.pdf

 

Super User
Posts: 17,905

Re: Prepare Data for prediction churn analysis

http://www2.sas.com/proceedings/sugi27/p114-27.pdf

 

You can search lexjansen.com with the terms: survival analysis with churn from a telecom company

 

You'll find many papers and hopefully something that works for you.

Ask a Question
Discussion stats
  • 4 replies
  • 603 views
  • 0 likes
  • 4 in conversation