Welcome to Manning India!

We are pleased to be able to offer regional eBook pricing for Indian residents.
All eBook prices are discounted 40% or more!
Fighting Churn with Data
Carl S. Gold
  • MEAP began June 2019
  • Publication in Summer 2020 (estimated)
  • ISBN 9781617296529
  • 350 pages (estimated)
  • printed in black & white

This book is priceless source of hands-on gained insights in analyzing and dealing with churn-related problems. The case studies are pure gold.

Milorad Imbra
Don’t let your hard-won customers vanish from subscription services, taking their money with them. In Fighting Churn with Data you’ll learn powerful data-driven techniques to maximize customer retention and minimize actions that cause them to stop engaging or unsubscribe altogether. This hands-on guide is packed with techniques for converting raw data into measurable metrics, testing hypotheses, and presenting findings that are easily understandable to non-technical decision makers
Table of Contents detailed table of contents

Part 1: Building an Arsenal

1 The World of Subscriptions and Churn

1.1 Why You are Reading this book

1.1.1 Terminology for Customers

1.1.2 The Typical Churn Scenario

1.1.3 What this book is about (How it works)

1.2 Why Churn is Hard to Fight

1.2.1 Predicting Churn is Hard

1.2.2 Preventing Churn is Harder

1.2.3 Preventing Churn is The Job of “The Business”

1.2.4 The Role of Data in Supporting the Business

1.3 Products with Recurring User Interactions

1.3.1 Paid Consumer Products

1.3.2 Business to Business Services

1.3.3 Ad Supported Media and Apps

1.3.4 Consumer Feed Subscriptions

1.3.5 Freemium Business Models

1.3.6 In-App Purchase Models

1.4 Non-Subscription Churn Scenarios

1.4.1 Inactivity as Churn

1.4.2 Free Trial Conversion

1.4.3 Upsell/Downsell

1.4.4 Other Yes/No (Binary) Customer Predictions

1.4.5 Customer Activity Predictions

1.4.6 Use Cases That Are Not Like Churn

1.5 Customer Behavior Data

1.5.1 Common Customer Events

1.5.2 The Most Important Events

1.6 Companies that Fought Churn With Data and Won

1.6.1 Klipfolio

1.6.2 Broadly

1.6.3 Versature

1.7 Metrics that Matter: Weapons in The Fight Against Churn

1.7.1 Utilization

1.7.2 Success Rates

1.7.3 Value

1.8 Why This Book is Different

1.8.1 Full Stack Analytics

1.8.2 Data Set Creation and Metric Design

1.8.3 Parsimony and Agility

1.8.4 Interpretability and Communication

1.9 What this book is not about

1.9.1 Intervention Playbooks

1.9.2 Passive Churn Minimization

1.10 Summary

2 Measuring Churn

2.1 The Definition of the Churn Rate

2.1.1 Calculating The Churn Rate and Retention Rate

2.1.2 The Relationship Between the Churn Rate and Retention Rate

2.2 Subscription Databases

2.3 Basic Churn Calculation: Net Retention

2.3.1 Net Retention Calculation

2.3.2 Net Retention Calculation SQL

2.3.3 Interpreting Net Retention

2.4 Standard Account Based Churn

2.4.1 Standard Churn Rate Definition

2.4.2 Outer Joins for Churn Calculation

2.4.3 Standard Churn Calculation SQL

2.4.4 When to Use the Standard Churn Rate

2.5 Activity (Event) Based Churn for Non-Subscription products

2.5.1 Defining an Active Account and Churn from Events

2.5.2 Activity Churn Calculation SQL

2.6 Advanced Churn: Monthly Recurring Revenue (MRR) Churn

2.6.1 MRR Churn Definition and Calculation

2.6.2 MRR Churn Calculation SQL

2.6.3 MRR Churn versus Account Churn vs Net (Retention) Churn

2.7 Churn Rate Measurement Conversion

2.7.1 Survivor Analysis (Advanced)

2.7.2 Churn Rate Conversions

2.7.3 Converting any churn measurement window in SQL

2.7.4 Picking the Churn Measurement window

2.7.5 Seasonality and Churn Rates

2.8 Summary

3 Measuring customers

3.1 From events to metrics

3.2 Event data warehouse schema

3.3 Counting events in one time period

3.4 Details of Metric Period Definitions

3.4.1 Weekly behavioral cycles

3.4.2 Timestamps for metric measurements

3.5 Making measurements at different points in time

3.5.1 Overlapping measurement windows

3.5.2 Timing metric measurements

3.5.3 Saving metric measurements

3.6 Measuring totals and averages of event properties

3.7 Metric quality assurance

3.7.1 Testing how metrics change over time

3.7.2 Checking how many accounts receive metrics

3.8 Event quality assurance

3.8.1 Checking how events change over time

3.8.2 Checking events per Account

3.9 Selecting the measurement period for behavioral measurements

3.10 Measuring account tenure

3.10.1 Account tenure definition

3.10.2 Recursive common table expressions for account tenure

3.10.3 Account tenure SQL program

3.11 Measuring monthly recurring revenue (MRR) and other subscription metrics

3.11.1 Calculating MRR as a metric

3.11.2 Subscriptions for specific amounts

3.11.3 Calculating subscription unit quantities as metrics

3.11.4 Calculating the billing period as a metric

3.12 Metric calculation with a software framework

3.12.1 Saving metrics for the simulation examples with the listing framework

3.12.2 General purpose metric calculation frameworks

3.13 Summary

4 Observing Renewal and Churn

4.1 How to Observe Customers

4.1.1 Observation Lead Time

4.1.2 Observing Sequences of Renewals and a Churn

4.1.3 Overview of Creating A Dataset From Subscriptions

4.2 Identifying active periods From Subscriptions

4.2.1 Active periods

4.2.2 Schema for Storing active periods

4.2.3 Finding active periods that are Still Ongoing

4.2.4 Finding active periods Ending in Churn

4.3 Identifying active periods for Non-Subscription Products

4.3.1 Active period Definition

4.3.2 Process for dataset Formation From Events

4.3.3 SQL For Calculating Active Weeks

4.4 Picking Observation Dates

4.4.1 Balancing Churn and Non-Churn Observations

4.4.2 Observation Date Picking Algorithm

4.4.3 Observation Date SQL Program

4.5 Exporting a Churn Dataset

4.5.1 Dataset Creation SQL Program

4.6 Exporting the current customers for segmentation

4.6.1 Selecting active accounts and metrics

4.6.2 Segmenting customers by their metrics

4.7 Summary

Part 2: Waging the War

5 Analyzing Churn and Behavior

6 Behavioral Grouping

7 Advanced Customer Metrics

Part 3: Special Weapons and Tactics

8 Analyzing Churn with Statistics

9 Accuracy and Calibration

10 Descriptive Data (Demo/Firmographics)

11 Machine Learning for Churn

About the Technology

Churn is the bane of any subscription business, such as content subscriptions, software as a service, and even ad-supported freemium apps. You can improve customer retention through product changes and targeted engagement campaigns based on data-driven interventions. Data scientists and business analysts employ huge datasets of user behaviour to determine why customers leave and implement processes to stop them from doing so.

About the book

Fighting Churn with Data is your guide to keeping your customers for the long haul. Chief Data Scientist at Zuora Carl S. Gold provides a clear overview of churn concepts, along with hands on tricks and tips he has developed through years of experience analyzing customer behavior. Packed with project-based examples, this book teaches you to convert raw data into measurable customer metrics, develop and test hypotheses about churn rates, and present your findings clearly to non-technical decision makers in marketing and sales. Using this book, anyone with a modest data analysis background can get churn analysis right and reap the revenue benefits of high customer retention.

What's inside

  • Calculate churn metrics from a subscription database
  • Spot the user behavior that is most predictive of churn
  • Master churn reduction tactics with customer segmentation
  • Apply churn analysis techniques to other business areas
  • Communicate data-based findings to non-technical stakeholders

About the reader

For readers with basic data analysis skills, including Python and SQL.

About the author

Carl Gold is the Chief Data Scientist at Zuora, Inc, a comprehensive subscription management platform and newly public Silicon Valley “unicorn”. Zuora is widely recognized in a leader in all things pertaining to subscription and recurring revenue, with 1,000 customers across a range of industries worldwide. Carl joined Zuora in 2015 and created the predictive analytics system for Zuora’s subscriber analysis product, Zuora Insights.

Manning Early Access Program (MEAP) Read chapters as they are written, get the finished eBook as soon as it’s ready, and receive the pBook long before it's in bookstores.
MEAP combo $49.99 pBook + eBook + liveBook
MEAP eBook $39.99 pdf + ePub + kindle + liveBook
Prices displayed in rupees will be charged in USD when you check out.

placing your order...

Don't refresh or navigate away from the page.

FREE domestic shipping on three or more pBooks