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

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

• ### Self-service analytics tools hand BI power to business users

Self-service BI software opens the door to wider analytics uses in organizations. This handbook compares top self-service tools ...

• ### Tableau vs. Power BI vs. Qlik: How the BI rivals stack up

Tableau, Power BI and Qlik Sense offer similar self-service BI functionality, consultant Rick Sherman says. But he points to some...

• ### Tibco analytics capabilities get upgrade in Spotfire X

New Tibco AI and natural language processing functions in the soon-to-be-released Spotfire X look to create a simpler and faster ...

## SearchDataManagement

• ### 5 trends driving the big data evolution

The speedy evolution of big data technologies is connected to five trends, including practical applications of machine learning ...

• ### Containers key for Hortonworks alliance on big data hybrid

Hortonworks is joining with Red Hat and IBM to work together on a hybrid big data architecture format that will run using ...

• ### Big data tooling rolls with the changing seas of analytics

Hadoop data tooling is expanding. A view holds that Hadoop is moving from alternate data warehousing to a full-fledged big data ...

## SearchSAP

• ### What CIOs should know about S/4HANA public cloud vs. private cloud

In addition to on-premises and hybrid models, SAP offers S/4HANA in public and private clouds. Here's a look at the differences ...

• ### Digital transformation goals spark new S/4HANA migration momentum

S/4HANA upgrades form the core of digital transformation for SAP organizations, but many underestimate the challenges, such as ...

• ### Greg Tomb: HANA underpins SuccessFactors, post-2025 SAP HCM

The cloud has loomed large in Greg Tomb's SAP career. Now, he has a year under his belt at SuccessFactors and much to say about ...

## SearchOracle

• ### Breaking down AI-infused Oracle Autonomous Cloud services

Oracle offers a variety of AI-infused cloud services that it says will automate common administrative and operational tasks for ...

• ### Oracle Autonomous Database Cloud gets transaction processing

Oracle launched a transaction processing version of Autonomous Database, a cloud-based platform that automates configuration and ...

• ### The future of SPARC/Solaris is cloudy -- in multiple ways

Cutbacks by Oracle have put the future of SPARC and Solaris in doubt, but the vendor says it's still committed to the ...

## SearchAWS

• ### AWS bare-metal instances target a niche market -- for now

AWS' addition of bare-metal instances runs counter to its heritage but is another example of how the vendor wants to keep users ...

• ### Centralize AWS account management with native SSO tool

Some third-party tools have longer track records, but AWS SSO offers an appealing alternative as a native service to handle cloud...

• ### Assess, manage AWS costs with third-party tools

An ecosystem of third-party products augment AWS' vast portfolio of cloud services, including cost management tools. Dig into ...

## SearchContentManagement

• ### New rules for WCM tools enhance the search experience

WCM used to mean platforms for webpages viewed on desktops. Today, it's morphing into digital experiences, and it taps AI as well...

• ### AI-assisted image and video search is next content frontier

You can search text, but it's harder to catalog images and video. New tools are automating those processes at the enterprise ...

• ### Box AI strategy looks to give users AI development tools

Box wants to be the hub of its enterprise users' software and AI content ecosystems with integrations and partnerships ranging ...

## SearchSalesforce

• ### Dreamforce 2018 conference highlights and key takeaways

Salesforce will reveal new features, tools and platform updates at Dreamforce 2018 in San Francisco Sept. 25-28. Use this guide ...

• ### Dreamforce brings Salesforce products upgrades

More than 150,000 attendees are expected at Dreamforce in San Francisco, where Salesforce will show how recent acquisitions fit ...

• ### Salesforce implementation offers window into partner management

Implementing Salesforce Sales Cloud, Service Cloud and Community Cloud has enabled a national window treatment company to ...

Close