Blog

How To Observe Churn

How To Observe Churn

The scenario in this blog post assumes you have already created some behavioral metrics (as described in User Metrics 101) and calculated some kind of churn rate measurement (How to Calculate Churn With SQL.)  This post describes a preparation step for the churn analysis: You are going to collect together observations of customer metrics at…

Read More Read More

User Metrics 101

User Metrics 101

If you are operating any kind of product or service with repeated interactions with users or customers then you should be collecting data about those interactions in some kind of data warehouse.  Interactions in this context means interactions between the user and the product, service or platform (it may also include interactions with other users…

Read More Read More

Fighting Churn with Data: How it Works

Fighting Churn with Data: How it Works

What is this about, Fighting Churn with Data?  I’m not an artist (disclaimer), but I drew a picture AKA “the mental model” for the book.   My publisher told me that it’s okay to draw pictures on a napkin and they’ll have a designer touch it up later, but I drew stick figures in PowerPoint instead…

Read More Read More

How to Calculate Churn with SQL

How to Calculate Churn with SQL

Lots of people talk about churn, but not everyone knows how to calculate it! In this post I’ll show you how to calculate churn with SQL for a typical subscription database. Why Calculate Churn with SQL? The usual scenario is that subscription data is stored in a database, and we need to figure out which…

Read More Read More

How to stop churn with data science

How to stop churn with data science

How to stop churn with data science The answer will surprise you.  Over the last few years I have analyzed churn at more than 50 companies, in my roles as Chief Data Scientist at Zuora*.   What I have found is that way to stop churn with data science doesn’t involve using the latest AI technology……

Read More Read More

Top 3 Lessons from Zuora’s Subscription Economy Index

Top 3 Lessons from Zuora’s Subscription Economy Index

Top 3 Lessons from Zuora’s new update to the Subscription Economy Index which I created: 1.  Subscription companies are Killing It. Subscription sales expanded at a record 24% for the year ending in March.   In comparison, traditional economy sales growing in the low single digits. 2.  But the laws of physics still apply. In Q2…

Read More Read More