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

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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

Accepted Solutions
Solution
‎01-31-2018 12:07 PM
Super User
Posts: 23,778

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.

View solution in original post


All Replies
Super User
Posts: 23,778

Re: Prepare Data for prediction churn analysis

Posted in reply to qbeg00_gmail_com
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: 61

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: 376

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

 

Solution
‎01-31-2018 12:07 PM
Super User
Posts: 23,778

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.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1162 views
  • 0 likes
  • 4 in conversation