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).

## SearchContentManagement

• ### Best enterprise content management software of 2021

When it comes to ECM, there are myriad vendors to choose from. Delve into 10 tools on the market to understand their capabilities...

• ### What is the future of ECM?

ECM isn't dead; it has evolved from a technology into an approach. Learn about the history of the ECM and look forward into the ...

## SearchUnifiedCommunications

• ### Massive Slack outage caused by AWS gateway failure

An AWS Transit Gateway failure led to Slack being down for nearly five hours earlier this month. The companies said they made ...

• ### Harnessing diversity and inclusion in technology key in 2021

Prioritizing diversity and inclusion in collaboration technology can help companies maintain their cultural touchpoints -- even ...

• ### AR and VR in video conferencing offer post-pandemic benefits

In a post-COVID-19 world, understanding the differences between AR and VR video conferencing will help companies determine which ...

## SearchDataManagement

• ### Enterprise data lakes hold the key to actionable insights

Technological pillars of sound business decisions, AI, machine learning and advanced analytics depend on the quantity, quality ...

• ### Data fabrics help data lakes seek the truth

Data fabrics can play a key role in aligning business goals with the integration, governance, reliability and democratization of ...

• ### Kyligence builds out data cloud for OLAP and big data

Kyligence is advancing the Apache Kylin project with a cloud-native offering that can help organizations more efficiently execute...

## SearchEnterpriseAI

• ### Google launches a suite of retail AI products

Google released AI products for online retailers as the tech giant increases its focus on industry verticals. The new products ...

• ### Diverse talent pools and data sets can help solve bias in AI

Bringing historically underrepresented employees into critical parts of the design process while creating an AI model can reduce ...

• ### The power and limitations of enterprise AI

A panel at CES 2021, held virtually this year, discusses the areas in which modern-day AI and automation shine, and where they ...

## SearchERP

• ### Supply chain trends for 2021 include reshoring, digitization

The diversifying of manufacturing, including reshoring to the U.S. and the adoption of new technologies, will be top supply chain...

• ### 9 supplier relationship management benefits COVID-19 emphasized

The benefits of effective supplier management include less price volatility for businesses and the possibility of future ...

• ### ERP alternatives poised to take the stage in 2021

The momentum for companies to adopt cloud-first and industry-specific ERP systems has created an opening for alternative ERP ...

Close