Stack Overflow
Stack Overflow

Questions tagged [churn]

Code churn measures quantify how much change is occurring in your project.

Code churn measures quantify how much change is occurring in your project. In general, high levels of churn indicate project instability. You should expect high rates of churn at the start of a product cycle or after the team has implemented many changes. Toward the end of an iteration or before a release, you should expect the level of churn to decrease, which indicates that your project is more stable.

See http://msdn.microsoft.com/en-us/library/ms244661%28v=vs.110%29.aspx

45 questions
0
votes
1 answer

Calculate retention rate split by year

Calculate retention rate / churn by year split Dear Community, I am working on a data mining project where I would like to transform prior thinking from excel into R. I have a customer database with contracts data and would like to calculate the…
Lebowski
  • 49
  • 6
0
votes
1 answer

SQL - Trying to find customer by their shopping channel

Hello I am trying to find the customers who just shop online and just shop in store and the customers who shop both online and in store. So when I add them up they should be equal to my total customers. I am trying to find the new and returning…
Somiya L
  • 55
  • 8
0
votes
1 answer

prediction and time series

how to decide how in advance my prediction is? i am following the featuretools churn tutorial https://github.com/Featuretools/predict-customer-churn what i don't quite understand how did it decide that the prediction is for one month in advance..…
Musab Hajabi
  • 3
  • 2
0
votes
1 answer

postgresql - cumul. sum active customers by month (removing churn)

I want to create a query to get the cumulative sum by month of our active customers. The tricky thing here is that (unfortunately) some customers churn and so I need to remove them from the cumulative sum on the month they leave us. Here is a sample…
user10026035
  • 1
  • 1
0
votes
1 answer

LDA(n_components = 2) + fit_transform return 1-dim matrix instead of 2-dim

While applying some LDA on my Churn_Modelling.csv file, eveything goes well until the point where my X_train return (8000, 1) except of (8000, 2) as expected : lda = LDA(n_components = 2) X_train = lda.fit_transform(X_train, y_train) X_train is…
Cédric
  • 21
  • 3
0
votes
0 answers

Using Oversim SimpleUnderlay network with different Churn generator types

I'm using SimpleUnderlay.ned network in Oversim20121206 and OMNet++ ver 4.6 to implement a hierarchical overlay network (2 layers). In the configuration (.ini) file I used the following (sample): **.churnGeneratorTypes = "oversim.common.NoChurn…
WAG
  • 1
0
votes
1 answer

Calculate customer activity in specific periods (example : 7 days)

I have managed to calculate if a customer is active in a monthly period, and not active in the next period (churn) using CTEs. This has proven to be very straight forward so far. My code snippet used to do so (for others looking around on how to do…
Mez
  • 4,365
  • 4
  • 24
  • 52
0
votes
1 answer

Druid Cohort Analysis?

We collect data on our website traffic, which results in about 50k to 100k unique visits a day. Cohort analysis: Find the percentage of users within a 24-hour period which register at the website and then actually go to our purchasing page…
7H3 IN5ID3R
  • 620
  • 7
  • 23
0
votes
0 answers

Customer churn and survival analysis in R

I have my data frame like this Product_ID min_date max_date 1 2014-09-09 2014-09-09 2 2014-08-18 2014-09-16 3 2012-03-11 2014-11-01 4 2013-01-10 2014-05-02 5 2013-01-23 …
Hindol Ganguly
  • 323
  • 1
  • 3
  • 13
0
votes
1 answer

Criteria to classify retail customers as churn Y or N

I have retail transactions data set. some of the attributes are CUSTID, BILL_DT, ITEM_Desc, VALUE. I want to classify the custid as churn y or n. Should i use the days between last purchase date till now as a criteria to classify? Can i say anything…
Raj
  • 1
  • 1
0
votes
1 answer

Time series normalization, how to handle zeros

I'm working on a player churn prediction model for a game. I have number of rounds played time series for 60 days. Before I feed the time series to classification algorithms, I need to normalize the time series. I was thinking about using min-max…
user2858366
  • 1
  • 1
-1
votes
1 answer

How to create churn table from transactional data?

Currently my Transaction Table has customer's transaction data for each month. Account_ID identifies the customer's ID. Order_ID is the number of orders that the customer had made. Reporting_week_start_date is the week which begins on Monday where…
Shang Rong
  • 57
  • 1
  • 5
-1
votes
1 answer

Classifying customer churn

For an academic project I have to analyse a customer database of an insurance company. This insurance company would like to identify a couple things, first of all classifying customers who leave the company in order to make them some offers or…
DeusExMachina
  • 1
  • 1
-2
votes
1 answer

Calculate churn in R given data variables

I'm trying to calculate the number of retained students using R. The two variables I'm working with are 'registration_date' (mm/dd/yr) and 'date_of_last_login' (mm/dd/yr). A student is considered retained if they logged-in in the preceding 30…
Zet
  • 9
  • 2
-3
votes
3 answers

Calculate Retention Rate on one column in R

I would need your advice as I am struggling to find out the right command in R. Basically I would like to calculate the retention rate for the specific customers. The customer_math is the snapshot of when the customer was active, which includes a…
Mr. Google
  • 13
  • 2
1 2
3