The "Layer Cake" Analysis: Visualizing Customer Acquisition and Retention

If you've ever stared at a spreadsheet of numbers and felt like something important was right in front of you but invisible, you're not alone. Most ecommerce and subscription businesses track acquisition and retention separately. They see monthly revenue. They see retention rates. But they miss the story that's actually happening in their data.

The layer cake analysis changes that. This single chart type reveals how customer cohorts contribute to total revenue over time, and it shows you instantly whether you're building a sustainable business or chasing growth on a treadmill.

What Is a Layer Cake Analysis?

A layer cake chart visualizes revenue by stacking horizontal bars for each customer cohort. Each row represents a month (or quarter) of acquisition. Each column within that row represents months elapsed since acquisition. The height of each bar segment shows the revenue from that cohort in that month.

Think of stacking pancakes. Each pancake is divided into colored sections representing different acquisition cohorts. The bottom layer is your oldest customers. Each layer above is a newer cohort. The final stack shows your total revenue at each point in time.

What makes this visualization powerful: it answers questions that dashboards won't. You can see instantly whether your revenue growth comes from new acquisition or from existing customers. You can spot whether recent cohorts measure up to older ones. You can find where your revenue actually comes from, not just how much you made.

If only new customer layers keep growing while old customer layers shrink, you're running faster just to stay in place. If old customer layers stay thick while new customers layer on top, you've built retention and you're compounding growth.

A healthy layer cake shows consistent or improving cohort size over time. A concerning cake shows newer cohorts getting progressively thinner while older cohorts still contribute significantly.

In many ecommerce businesses, 60-70% of monthly revenue still comes from customers acquired 12+ months ago. If that number is 10%, you're spending heavily to maintain a leaky bucket.

How the Layer Cake Reveals What Other Metrics Hide

Monthly recurring revenue (MRR) is easy to track. It tells you total revenue. But it hides what matters.

Picture two businesses. Both have $100k MRR. Business A achieved this through high-quality cohorts acquired over two years. Those customers still comprise 70% of revenue. Business B spent aggressively on acquisition last month and is replacing 80% of its customer base monthly to maintain $100k.

Both have identical MRR. Only the layer cake shows you that Business A is sustainable and Business B is running a hamster wheel.

This is the real value of layer cake analysis. It transforms a single number (MRR) into a story with depth. You stop chasing the metric and start understanding the structure beneath it.

Building Your Layer Cake Analysis

Layer cake analysis requires cohort revenue data. The process is straightforward.

First, define your cohorts. Cohorts are groups of customers acquired in the same time period. Monthly cohorts are standard. Quarterly works for larger businesses. Use the customer's first purchase date as the cohort date.

Next, calculate cohort revenue over time. For each cohort, determine how much revenue they generated in each month after acquisition. Create a table where rows are cohort acquisition months and columns are months-since-acquisition (0, 1, 2, 3, etc.).

Your table might look like:

January 2024 cohort: $50k in month 0, $35k in month 1, $25k in month 2, etc.
February 2024 cohort: $55k in month 0, $38k in month 1, etc.

Then visualize as stacked bars. Create a horizontal stacked bar chart. Each bar represents a calendar month. Each bar segment's color represents a different cohort, and segment width shows that cohort's contribution to revenue that month.

Finally, review and interpret. A healthy layer cake shows thick, persistent layers from old cohorts. An unhealthy cake shows old layers rapidly thinning while new layers must grow constantly just to maintain overall revenue.

What Healthy vs. Unhealthy Layer Cakes Look Like

A Healthy Layer Cake

Imagine a January 2024 cohort that contributed $50k in month 0. By month 3, they're contributing $25k. By month 6, they're contributing $12k. Natural decay. But that cohort still generates revenue 12+ months later.

Stack all cohorts and you see the difference. The bottom layers (oldest cohorts) still take up 50-60% of the bar. New cohorts add volume on top. Total revenue grows, but it grows on a base of stable, retained revenue.

This business solved retention. It's reinvesting acquisition money into profitable growth, not chasing replacement revenue. That's the position you want to be in.

An Unhealthy Layer Cake

Now a different scenario. The January 2024 cohort contributed $50k in month 0, but by month 6 they contributed $1k. By month 12, they're nearly gone. Each month, acquisition spending must nearly duplicate to maintain overall revenue because retention is poor.

Stack all cohorts and you see a thin bottom layer and progressively thicker new layers. The visual tells you the problem instantly. This business is in a hamster wheel.

Using Layer Cake to Evaluate Marketing Spend

Layer cake analysis pairs beautifully with customer acquisition cost (CAC) metrics. Track your monthly customer acquisition spend alongside your layer cake. Then ask: what's the payback period for each cohort?

If the January cohort cost $50k to acquire and generated $50k in month 0, your payback was one month. If they're still generating $12k in month 6, you've gotten 6x return on that acquisition spend.

Compare this across cohorts. Did you spend more on acquisition in March? What was the quality difference? Do expensive cohorts return higher revenue-per-customer, or did you just overpay for worse customers?

Marketing spend suddenly becomes an investment decision with measurable returns, not a budget line item.

Identifying Retention Problems with Layer Cake

Layer cake analysis is a diagnostic tool. When you see your cake getting unhealthy, the chart itself points to the solution.

Are all cohorts decaying faster than they used to? Your product engagement or value proposition changed. Investigate recent changes.

Are only recent cohorts weak? Your acquisition strategy changed. You're attracting lower-quality customers. Review targeting and messaging.

Do seasonal cohorts perform differently? Holiday cohorts often behave differently than off-season cohorts. Understand the difference and adjust strategy accordingly.

Tools for Building Layer Cake Reports

Most analytics platforms require manual pivot tables and chart building. ORCA automates this. Input your cohort retention data, and ORCA generates professional layer cake visualizations that update as data changes.

You can also build layer cakes in Google Sheets or Tableau. The key is having accurate cohort data. If your customer database doesn't track acquisition date clearly, start there.

Stripe, Shopify, and other platforms provide historical revenue by customer, so you can export cohort revenue without manual calculations.

Actionable Insights from Layer Cake Data

A layer cake analysis isn't just pretty visualization. It directs action.

Your cake getting thinner at the top? Increase acquisition or improve retention. Your current path is unsustainable.

Recent cohorts thick but old cohorts gone? Your retention is poor. Calculate the payback period for recent cohorts. If it's longer than the cohort lifetime, you're losing money on acquisition.

Cake height flat despite more acquisition spend? You're acquiring more customers, but they're worse quality. They're staying shorter and contributing less. Reassess your targeting.

Cake getting wider but the same height? You're improving retention while maintaining acquisition volume. This is growth scaling. Reinvest profits into acquisition.

The Strategic Advantage of Layer Cake Thinking

Most businesses optimize for short-term MRR growth. Layer cake thinking flips that priority. When your goal becomes "build a thick, persistent layer cake," your strategy shifts fundamentally.

You focus on retention because retention compounds. You value acquisition quality over volume because quality cohorts stay longer. You measure marketing effectiveness by long-term payback, not immediate ROAS.

Businesses that master the layer cake often become market leaders. Not because they chase the hardest, but because they're building sustainable advantage while competitors chase growth that can't hold.

Ready to visualize your customer story? ORCA automates layer cake analysis, turning cohort data into clear strategic insights. See where your revenue really comes from and build retention that compounds.