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

This was last published in June 2006

## Content

Find more PRO+ content and other member only offers, here.

#### Have a question for an expert?

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

#### Start the conversation

Send me notifications when other members comment.

• ### Tableau vs. Qlik Sense: Pros and cons of the rival analytics tools

Products from the two top data visualization vendors are starting to resemble each other as the need for strong visualizations ...

• ### AI functionality limited today but could be a game-changer

Limited AI capabilities could soon give way to technology that is truly transformative for enterprises, surpassing the overhyped ...

## SearchDataManagement

In big data news, we find Google TPUs, or Tensor Processing Units, offered as a cloud service, while LinkedIn is open sourcing a ...

• ### Hyperledger Fabric offers path to enterprise blockchain future

Blockchain arose from bitcoin, but it's looking to find a place in the enterprise. Frameworks like Hyperledger Fabric could ...

• ### MongoDB 4.0 takes ACID transactions to multi-document level

MongoDB is taking a deeper step into SQL-style processing waters with a 4.0 update that brings increased support for ...

## SearchSAP

• ### SAP's Barry Padgett on future of SAP Ariba Network

In this Q&A, new SAP Ariba President Barry Padgett discusses the future of procurement and the experience he will bring to Ariba ...

• ### Avoiding SAP indirect access woes requires good faith

Some customers are concerned that SAP will hit them for indirect access licensing fees, but they can avoid trouble if they act in...

• ### ControlPanelGRC app eases Steelcase's compliance pain

When Steelcase's SAP environment grew in size and complexity, it turned to Symmetry ControlPanelGRC to save time, have more ...

## SearchOracle

• ### How to use Oracle DBSAT to do a database security assessment

The Oracle Database Security Assessment Tool is free software that checks the security of databases. Here are the steps involved ...

• ### Oracle Blockchain Cloud Service: What it is and what it does

Oracle's cloud-based blockchain service uses Hyperledger Fabric to support distributed transaction ledgers for corporate users on...

• ### Using Oracle 12c Unified Auditing to set database audit policies

Oracle Database 12c's built-in Unified Auditing feature streamlines the database auditing process, including creation and ...

## SearchAWS

• ### Azure and AWS continue their race for public cloud dominance

In the battle between public cloud vendors, Microsoft hopes its large enterprise customer base and a focus on hybrid cloud can ...

• ### Direct Connect gateway grants your network global access

Large global enterprises will welcome AWS Direct Connect gateways, which enable multi-region connections to VPCs. However, some ...

• ### DynamoDB features recharge AWS database service

Developers who got sick of AWS' roundabout backup method for DynamoDB can breathe a sigh of relief. Backup and Restore, as well ...

## SearchContentManagement

• ### Content management in the cloud a main theme in 2018

The future of content management resides in the cloud and with AI, as several 2018 conferences will assure you.

• ### Six things to know about today's SharePoint implementations

As companies migrate their on-premises Microsoft SharePoint sites to the cloud, here are some things they should know about the ...

• ### Upgrades for the SharePoint Online portal

As more organizations migrate SharePoint sites to the cloud, Microsoft has increased at-a-glance dashboard data and analytics to ...

## SearchSalesforce

• ### Helpshift offers five Salesforce GDPR tips for customer support

How much does the service and support team affect GDPR privacy mandates? Turns out, more than a little. A chat app developer's ...

• ### Colorado modernizes with Salesforce for government projects

Colorado licenses Service Cloud and other Salesforce technologies to improve its citizens benefit program.

• ### Salesforce gets a blockchain distributed ledger tool

Blockchain technology is the ultimate connectivity layer, and it can be used to help solve thorny customer service issues when ...

Close