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

Get users churn rate grouped by years in SQL request

I need to get users churn rate value grouped by years and user types in single SQL request. Churn rate = Users lost this year (archived) / (Users count at start of this year + Users count registered in this year) Users lost this year - users who…
Dmitry
  • 499
  • 1
  • 3
  • 19
0
votes
1 answer

How to calculate churn based on customer ID / emails?

I'm trying to calculate customer churn on a monthly basis using the following data. However, unfortunately I do not have a boolean value which takes the value 1/True or 0/False when customers churned or not. You can assume that when a customer…
PeterPost
  • 1
  • 1
0
votes
0 answers

Need to divide a Dataframe in various tables using multiple categories and date time

this is my first time asking a question here, so if I'm doing something wrong please guide me to the right place. I have a big and clean dataset. (29000+ , 24). The thing is that I have to calculate the churn rate based on 4 different categorical…
Juan Pablo Clavijo
  • 1
0
votes
0 answers

How to filter and group data imported from several tables in Redshift?

Nice to meet you, dear community! I want to select users from several tables who performed their last event not later than 7 days since registration day and group them by their start version. However, the number of select users is quite low, could…
Liliia Lutsenko
  • 1
  • 1
0
votes
1 answer

Using bartCause package to predict uplift

I'm trying to use the bartCause package to build an uplift model in R. Unfortunately I have trouble to integrate the data frame in the right way - error message: $<-.data.frame`(`*tmp*`, "lift", value = c(0.159231848781688, : replacement has 160…
Marcel
  • 1
  • 1
0
votes
2 answers

How to count monthly retention user in bigquery?

I have raw data as below. With each line is the record of an transaction of user, and the month when they made the transaction What I want is to calculate the number of user who made order in a month and the number of repeated user (RETENTION)…
Anh Hoang
  • 79
  • 8
0
votes
1 answer

Churn model in Python?

Churn rate - in its broadest sense, is a measure of the number of individuals or items moving out of a collective group over a specific perio. My question is what can I investigate in churn model by using logistic regression using Python?
dingaro
  • 2,156
  • 9
  • 29
0
votes
0 answers

ValueError : Pandas data cast to numpy dtype of object. Check input data with np.asarray(data)

I am trying to predict churn of telecom user by logistic regression model, I am getting ValueError: Pandas data cast to numpy dtype of object. Check input data with np.asarray(data). # Putting feature variable to X X =…
Kalyan Mohanty
  • 95
  • 1
  • 10
0
votes
1 answer

When should one use time series analysis vs. non-time series analysis?

I am trying to predict churn and for this my dependent variable is a binary variable. The independent variables can be categorical, integer or timeseries data. I am in the feature selection mode and will like to know if I am running correlation,…
Eva Shah
  • 11
  • 2
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
  • 51
  • 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
  • 9
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
1 2
3
4