Q
Problem solve Get help with specific problems with your technologies, process and projects.

Measuring customer churn rate to calculate customer lifetime value

Read advice on how to measure, define and calculate customer churn rate in this expert Q/A.

Can you provide some advice on measuring customer churn rate for an Internet company? For example, in the business of online money transfer, how would you define churn or customer drop-out?

In this case, would churn be:
* Permanent account closures, or
* Significant drop in activity (say, more than 90% in average transaction volume over a two-month period), or
* Zero activity in the last three-month period?

My plan is to attain the customer churn rate so that I can then determine the customer lifetime (N) using the relationship customer retention (CR) = 1- 1/N. (This is a calculation I found in Peppers and Roger's book, The One to One Future). Once I have found N, I can calculate the net present value (NPV) of future cash flow stream on a per customer basis.

Please let me know if this approach makes sense and how should I go about finding/defining customer churn rate and therefore calculating customer retention ratio (CR).

Because companies must be aware of both risk and significant declines in activity as precursors to customer churn rate, my suggestion would be to profile these back-end elements of the customer lifecycle as follows:

* Zero three month activity = risk
* Significant drop in activity = probable churn (midway between risk and true churn)
* Permanent account closure = true churn

For estimating purposes in calculating customer lifetime value, these might be weighted as risk = .50, probable churn = .75, and true churn = 1.00. Once these numbers are applied, it will be possible to back into customer retention ratio (CR).

Start the conversation

Send me notifications when other members comment.

SearchContentManagement

• Choosing the right collaboration suite for business

Collaboration suites are an essential component of remote work, enabling teamwork throughout a distributed enterprise. Decide ...

• Acquia Drupal, Marketing Cloud get feature boosts

Acquia users get Drupal migration tools and marketing automation features built with technology from recent acquisitions as the ...

• How automated content tagging improves findability

Companies that use AI to automatically tag their metadata can improve findability of content across the entire organization. AI ...

SearchUnifiedCommunications

• UC presence evolves amid remote work revolution

UC presence technology must evolve to be effective in today's world of remote work and multi-device communication. Learn how ...

• Speech recognition use cases enable touchless collaboration

For companies bringing workers back to the office, touchless collaboration is key. These three speech recognition use cases can ...

• Zoom opens marketplace to apps that run within its platform

Zoom plans to introduce by the end of the year nearly three dozen third-party extensions to its video conferencing platform. Zoom...

SearchDataManagement

• MongoDB Atlas now enables multi-cloud database clusters

Multi-cloud data portability comes to MongoDB Atlas with a new capability that will enable users to run a database application ...

Enterprises benefit in many ways from AI data privacy tools that reduce the need for manual efforts from data professionals. Read...

• The new normal for enterprise data governance

Mastercard data exec highlights the foundational role of enterprise data governance during the pandemic era with more people ...

SearchEnterpriseAI

• COVID-19 to drive more AI in retail for small retailers

Retailers were hit hard by the COVID-19 economic fallout, especially small, local businesses. Amid a shift online, AI could help ...

• New AI system to give Microsoft Seeing AI a boost

A new object captioning AI model from Microsoft strengthens the tech giant's accessibility services, which the vendor has ...

• The imperative of establishing AI governance

It's hard to ethically manage data for AI models, but AI governance, as well as a strong ethics framework, can help enterprises ...

SearchERP

• Celonis expands to action with Execution Management System

Celonis released the Execution Management System, which enables companies to automate actions in operational processes, improving...

• Unit4 plans to release next-gen ERP platform, Unit4 ERPx

Unit4 said people-focused companies need people-centric ERP platforms. Unit4 ERPx, due out in March, aims to be just that.

• EAM vs. CMMS: A guide to their differences

When it comes to EAM vs. CMMS, making the right choice comes down to understanding what each software type does. Here's an ...

Close