Skill Tracer
Skills › Knowledge Work Plugins › review-reputation › churn-signals.md

churn-signals.md

110 lines · small-business/skills/review-reputation/reference/churn-signals.md at 2574e29

Open on GitHub
1# Quiet customers and win-backs
2
3Most customers do not complain before they leave. They just stop. Finding them
4is a data job, not a sentiment job.
5
6---
7

Quiet customers and win-backs

Most customers do not complain before they leave. They just stop. Finding them is a data job, not a sentiment job.


Raw lines 1 to 7
8## Set the rhythm per customer, not per business
9
10A customer is quiet when their gap has stretched well past *their own* normal
11interval. Comparing everyone to a single company-wide average produces a list
12full of annual customers who are perfectly happy.
14For each customer with three or more orders or jobs:
16```
17their normal interval = median gap between their own orders
18quiet = current gap > 2× their normal interval
19gone = current gap > 3× their normal interval
20```
22With fewer than three orders there is no rhythm to measure. Compare those to
23the business's median instead, and label them as an estimate in the report.
25| Customer | Normal interval | Current gap | Read |
26|---|---|---|---|
27| Dana R. | 3 months | 7 months | Quiet — worth a call |
28| Kirby St. LLC | 12 months | 13 months | Normal — leave alone |
29| M. Alvarez | 6 weeks | 5 months | Gone — win-back |
31---

Set the rhythm per customer, not per business

A customer is quiet when their gap has stretched well past their own normal interval. Comparing everyone to a single company-wide average produces a list full of annual customers who are perfectly happy.

For each customer with three or more orders or jobs:

their normal interval = median gap between their own orders
quiet                 = current gap > 2× their normal interval
gone                  = current gap > 3× their normal interval

With fewer than three orders there is no rhythm to measure. Compare those to the business's median instead, and label them as an estimate in the report.

CustomerNormal intervalCurrent gapRead
Dana R.3 months7 monthsQuiet — worth a call
Kirby St. LLC12 months13 monthsNormal — leave alone
M. Alvarez6 weeks5 monthsGone — win-back

Raw lines 8 to 32
33## Rank by what the relationship was worth
35Sort the quiet list by past value, not by length of silence. The owner has
36time for fifteen conversations, not two hundred, and the fifteen should be the
37ones that mattered.
39Value in order of usefulness: lifetime spend, then order frequency, then most
40recent order size. Use whatever the connected data actually supports and say
41which one you used.
43**The strongest signal is a pairing:** a customer who left a negative review
44and then stopped ordering. Flag those at the top regardless of value. They
45told the business exactly what was wrong and then left anyway, and they are
46the most winnable because the fix is already known.
48---

Rank by what the relationship was worth

Sort the quiet list by past value, not by length of silence. The owner has time for fifteen conversations, not two hundred, and the fifteen should be the ones that mattered.

Value in order of usefulness: lifetime spend, then order frequency, then most recent order size. Use whatever the connected data actually supports and say which one you used.

The strongest signal is a pairing: a customer who left a negative review and then stopped ordering. Flag those at the top regardless of value. They told the business exactly what was wrong and then left anyway, and they are the most winnable because the fix is already known.


Raw lines 33 to 49
50## Shopify order patterns as sentiment
52Behavior leads reviews by weeks. Reading it early is the only chance to fix
53something before it becomes public.
55Worth surfacing:
57- **Fulfillment time drifting up** across a period. Compare the window to the
58 prior one and report both numbers.
59- **Repeat refunds against one product** or one date range. Three refunds on
60 the same SKU is a product problem, not three unhappy people.
61- **Partial or split shipments** rising. These generate "where is the rest of
62 my order" contacts a week or two later.
63- **First-order customers who never came back,** as a share of the window.
65Report what the data shows and nothing beyond it. If refund reasons are not
66recorded in the data, say they are unavailable rather than inferring why
67people asked for money back.
69---

Shopify order patterns as sentiment

Behavior leads reviews by weeks. Reading it early is the only chance to fix something before it becomes public.

Worth surfacing:

  • Fulfillment time drifting up across a period. Compare the window to the prior one and report both numbers.
  • Repeat refunds against one product or one date range. Three refunds on the same SKU is a product problem, not three unhappy people.
  • Partial or split shipments rising. These generate "where is the rest of my order" contacts a week or two later.
  • First-order customers who never came back, as a share of the window.

Report what the data shows and nothing beyond it. If refund reasons are not recorded in the data, say they are unavailable rather than inferring why people asked for money back.


Raw lines 50 to 70
71## Designing the win-back
73One message per customer, referencing something real: what they bought, what
74was fixed, the season their equipment gets serviced. Generic "we miss you"
75mail is exactly what they already delete.
77Confirm what the owner can actually honor before drafting. Never invent a
78discount, credit, free service, or priority slot. Ask:
80```
81Before I draft these — what's actually on the table for a win-back?
83 Something like a discount or a free check-up
84 A straight personal note with no offer
85 A call from you rather than an email
87For the four highest-value names I'd suggest the call. An email to someone
88who spent USD 9,000 with you reads as a mailing list.
89```
91**Offer strength by segment:**
93| Segment | What usually works |
94|---|---|
95| High value, left a bad review | A personal call. No offer up front — the apology is the offer |
96| High value, no complaint | A note from the owner, naming the last job |
97| Mid value, seasonal business | A timely reminder, no discount needed |
98| Low value, one-time buyer | A single low-cost offer, then stop |
100**Stop after one.** A second and third win-back attempt to someone who has not
101replied damages the brand and, for email, damages deliverability for everyone
102else. One good message, then leave them alone.
104---

Designing the win-back

One message per customer, referencing something real: what they bought, what was fixed, the season their equipment gets serviced. Generic "we miss you" mail is exactly what they already delete.

Confirm what the owner can actually honor before drafting. Never invent a discount, credit, free service, or priority slot. Ask:

Before I draft these — what's actually on the table for a win-back?

  Something like a discount or a free check-up
  A straight personal note with no offer
  A call from you rather than an email

For the four highest-value names I'd suggest the call. An email to someone
who spent USD 9,000 with you reads as a mailing list.

Offer strength by segment:

SegmentWhat usually works
High value, left a bad reviewA personal call. No offer up front — the apology is the offer
High value, no complaintA note from the owner, naming the last job
Mid value, seasonal businessA timely reminder, no discount needed
Low value, one-time buyerA single low-cost offer, then stop

Stop after one. A second and third win-back attempt to someone who has not replied damages the brand and, for email, damages deliverability for everyone else. One good message, then leave them alone.


Raw lines 71 to 105
106## Approval
108Every win-back is drafted for approval and sent one at a time. The owner
109approves the message and the offer inside it. An offer that goes out before
110the owner has agreed to honor it turns a churn problem into a refund problem.

Approval

Every win-back is drafted for approval and sent one at a time. The owner approves the message and the offer inside it. An offer that goes out before the owner has agreed to honor it turns a churn problem into a refund problem.

Raw lines 106 to 110