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

57 questions
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,666
  • 4
  • 29
  • 57
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…
gwthm.in
  • 638
  • 9
  • 24
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
  • 363
  • 1
  • 4
  • 16
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
  • 2
-1
votes
1 answer

Churn prediction with time series. Analyze client behavior in dynamic

Typically, when assessing customer churn, static data is used, for example, recent or average customer spending data, customer characteristics, etc. This approach does not allow tracking the activity of one client in dynamics: decrease/increase in…
Sabrina Kadirova
  • 1
-1
votes
1 answer

Turning metric values into buckets in Power bi

I have two columns of data like this: Now I want to turn tenure into buckets like this: I've searched but none of those works in Power bi. What should I do?
Ghost
  • 49
  • 6
-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
  • 77
  • 1
  • 1
  • 6
-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
0 answers

Churn prediction model

I'm getting back to you regarding the client churn topic. After a lengthy data preparation process, I've constructed a training dataset by creating monthly timestamps. However, a significant issue has arisen: there's a substantial data imbalance…
Walid Ibnoucheikh
  • 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
4