Dormant Customer Calculator: How Much Revenue Are You Sitting On?

If you have been running a business on WhatsApp for more than six months, you are sitting on a revenue pile you cannot see. Every contact who stopped replying, every lead who ghosted after a quote, every customer who used to come monthly and now does not -- each of them has a numeric value, and most businesses have no idea what that number is.

This post is the formula you need to put a rupee amount (or dollar amount) on your dormant list. We will walk through the math, then apply it to three worked examples across salon, gym, and retail so you can match the closest one to your business.

The Core Formula

Three inputs. Each one is where businesses go wrong. Let us break down exactly how to measure each correctly.

Input 1: Dormant Contacts

A dormant contact is any contact in your WhatsApp database who has not engaged with you in longer than your "healthy cycle" window. The window depends on your business:

• Salons / barbershops: 30 days (hair cycle is 4-6 weeks)
• Gyms / fitness: 14 days (if a member skips two weeks, they are at risk)
• Retail / D2C: 60-90 days (depends on product replenishment cycle)
• Real estate: 30 days post-last-message (leads decay fast)
• B2B SaaS: 45 days
• Restaurants: 45 days

If you are not sure, halve your average time-between-purchases. That is usually a good dormancy trigger.

Input 2: Average Customer LTV

Use historical-cohort LTV, not active-customer LTV. The number you want is: total revenue ever received from a customer cohort, divided by the number of customers in that cohort. If you only calculate LTV for currently-active customers, you will systematically underestimate because dormant customers tend to have had shorter (lower LTV) relationships.

A simple way: sum your last 24 months of revenue, divide by the number of unique paying customers in that period. That number is close enough.

Input 3: Realistic Recovery Rate

This is where most calculators lie to you. The recovery rate depends on two things: how dormant the customer is, and how good your re-engagement sequence is.

• 0-30 days dormant, 3-message sequence: 22-28% recovery (benchmark)
• 30-60 days dormant, 3-message sequence: 15-22%
• 60-90 days dormant, 3-message sequence: 10-15%
• 90+ days dormant, 5-message sequence: 8-14%
• 180+ days dormant: 4-8%

For a conservative estimate, use 15%. For a sequence you have actually tested (or one of the proven patterns), use 20%.

Worked Example 1: Hair Salon (300 Contacts)

Priya was running her salon on WhatsApp for 18 months before she ran this calculation. She had never once sent a win-back message. Twenty-three customers is not a huge win-back number -- but over a year, that is over roughly $3,200 that were invisible.

Worked Example 2: Boutique Gym (850 Members)

Gyms have two cohorts you need to calculate separately. The at-risk cohort (active but drifting) has a much higher save rate -- these people are still paying, they just need a reason to come in. The fully-lapsed cohort has a lower rate but a larger pool.

Worked Example 3: D2C Skincare Brand (4,200 Customers)

Your Numbers: The 10-Minute Version

Common Mistakes That Inflate Your Estimate

This formula is conservative if used correctly, but three errors inflate results:

• Using active-only LTV: Dormant customers historically had lower LTV than active ones (they churned sooner). Using active-only LTV overstates by 30-50%. Use historical cohort LTV.
• Double-counting contacts who never paid: Leads who ghosted before paying are not "dormant revenue at risk." Filter to only customers who have made at least one payment.
• Using discount offers in your LTV baseline: If 70% of your recoveries come through a 25% discount, your realized revenue is 25% lower than the LTV number suggests. Discount the discount.

How This Connects to the App-ening Dashboard

The Revenue Recovery dashboard runs this calculation automatically, against your live contact database. It shows you the at-risk / dormant / lost cohort counts, estimates your revenue at risk by cohort, and tracks how much revenue each sequence has actually recovered. If you want to skip the manual export-and-spreadsheet version, the dashboard gives you a live number refreshed daily.

The feature gate lives on the Pro plan and above. The calculation covers all seven cohort buckets (0-30, 30-60, 60-90, 90-120, 120-180, 180+ day dormancy, plus at-risk active).