Custora Blog  /

Visualizing "good retention" and "bad retention" in retail

The "layer cake" cohort visualization is one of our favorite forms of historical customer analysis.  Instead of just focusing on top-line revenue numbers, we color-code monthly revenue based on the "acquisition cohort" it belongs to.  Each color represents the revenue earned from a group, or "cohort," of customers who joined in a given month (hat tip to Roberto Medri from Etsy who suggested this visualization to us).

The layer-cake cohort graph provides three valuable pieces of information:

  1. What % of revenue comes from newer and older users.
  2. How quickly a group of new customers fades away.
  3. Aggregate revenue trends.
A few examples:

low-ret3

This is a layer-cake diagram of Firm A, a retailer who does not have strong customer retention.  Notice how quickly each cohort fades away.  In an average month, roughly 90% of revenue earned comes from new customers.

med-ret4

Firm B is a retailer with much better customer retention.  Notice how each cohort band remains strong over time.  In this graph, roughly 70% of monthly revenue comes from new customers with 30% coming from repeat business.  The cohort bands shrink down quite a bit after their initial month because customers don't make orders every month - but the customers clearly stick around for a while.

high-ret1

Firm C is a retailer with great customer retention and customers who purchase with high frequency.  Nearly 80% of monthly revenue comes from repeat business.

Taking things further

The layer-cake graph is an informative way to kick off retention analysis, but it doesn't paint the whole picture.

If we define retention as how long customers stick around, Firm B and Firm C actually have very similar retention.  However, Firm C's customers purchase with much greater frequency.  Drawing out retention for users who order at different frequencies can provide further insights.  For example, we might discover that retention revenue numbers are all derived from a small pocket of high-value, sticky customers.  Or, we might discover that many customers stick around, each ordering once per quarter.  If it turns out we have a pocket of all-star customers, we'd most certainly want to zoom in on those customers to learn how we can find more of them!

Finally, and perhaps most obviously, the layer-cake graphs don't provide answers on what to do next - they don't shed insight as to how we might improve customer retention.  To change the shape of your layer-cake graph, we need to drill beyond aggregate cohort metrics and hone in on individual-level insights.  The more we know about specific customers, the better chance we have to keep our customers engaged and happy.

We'll write more soon on some of the most effective forms of individual-level insights we've seen with retention marketing - from churn detection to behavioral segmentation to customer lifetime value prediction.

If you're interested in automating these graphs - and drilling from aggregate cohort analysis all the way down to individual-level customer insights, get started with Custora today!

Tagged : Story

Like this? You might also enjoy these.

Story

Be careful how you average - a retail example

Companies often want to track things like the size of first orders and the size...
Read...
Story

Setting Up Control Groups - Designing a Marketing ...

Welcome to Part Three of our series on designing and implementing a successful...
Read...
Story

Setting a baseline – Designing Marketing ...

In Part Two of our series on designing and implementing a successful marketing...
Read...
,

What Are Your Customer Data Sources — And Which Ones Actually Matter?

A customer-first approach is a critical component of every successful retail...
Read...
,

Using Predictive Analytics to Optimize Your Multichannel Marketing Campaigns

Multichannel marketing is a must in the digital age, but executing it...
Read...
, ,

The Benefits of Customer Insights in Retail: The Guide for Marketing Leaders

In the age of Amazon, traditional retailers need to leverage actionable...
Read...