Marketing & Sales
Churn Reason Analysis for Beginners | Sort Cancellations by Timing and Reason, Pick Fixes
Beginner | 4 whiteboard pages · Task board: 5 columns (4 parent tasks, 12 subtasks)
Beginner: No technical terms. Just answer the whiteboard's questions, following the examples, and it takes shape.
Start churn analysis with cancellation voices: sort by timing and reason, pick two fixes.
Read more Show less
After a month, you compare how many customers cancelled. First, copy what lost customers said, word for word, from cancellation surveys, last inquiries, usage records, and what staff heard. Timing goes into first 3 months, before renewal, after use stopped, and unknown; reasons into unclear value, hard to use, moved elsewhere, and money. This shows what to fix at which timing, beyond the total.
Built for a small team running a monthly class or service. The example follows five people at an online yoga class for adults reviewing 28 cancellations over three months. Each fix gets an owner and a deadline, and the signals to keep, change, or stop are set before trying it.
The whiteboard has four A4 pages: collect voices, fill the timing-by-reason table, pick fixes, and test and compare. The task board has 5 columns, with 4 parent tasks matching the pages and 3 subtasks under each.
Once you have a free account, you can copy this template from the marketplace
Whiteboard preview
Read the whiteboard text as plain text
Churn Reason Analysis for Beginners
How to use (4 pages): ① Write last round's result and copy in voices of people who left (boards①–⑥) → ② Place voices in the timing-by-reason table (boards⑦–⑩) → ③ Compare fixes on criteria and pick 2 (boards⑪–⑬) → ④ Set owners and deadlines, compare cancellations in 1 month (boards⑭–⑱)
1/4 Review and gather voices
① Last result and scope (start here)
- Last round's result e.g. Leave blank if this is your first round e.g. We kept the pause notice we picked last time. 4 people chose a pause
- Review period and cancellations e.g. 28 cancellations in Sep–Nov. Review before the renewals in the new year
- Who meets and for how long e.g. The 5 people running the class copy the voices, then talk for 60 minutes
② Survey voices (blue: as written)
- How to fill in: copy free-text answers from the cancellation form, one per line, unedited
- e.g. "I stuck with it for 3 months but feel no change in my body"
- e.g. "Evening classes were cut, so I can't come after work"
- e.g. "A yoga studio opened nearby, so I'm switching"
③ Last inquiries (blue: as written)
- How to fill in: copy the last inquiry before leaving, with its date
- e.g. Oct 2 "The video keeps freezing. How do I fix it?"
- e.g. Oct 20 "When is my renewal date?"
- e.g. Nov 5 "Do you have a cheaper monthly plan?"
④ Usage records (blue: last class)
- How to fill in: copy each person's class count and last class date
- e.g. Person A took 4 classes in 5 weeks after joining. Last class was 3 weeks before leaving
- e.g. Person B took 0 classes the month before renewal
- e.g. 5 of the 28 people did not attend once in the month before leaving
⑤ Staff-heard voices (blue: as heard)
- How to fill in: copy what instructors or the front desk heard, with who heard it
- e.g. Instructor "After the first class, they said they couldn't decide what to take next"
- e.g. Front desk "Heard by phone that the monthly fee is a strain because of family circumstances"
- e.g. Instructor "They said they would go to another studio with a friend"
⑥ 4 reason types (where unsure voices go)
Value unclear
- How to fill in: add voices from people who left before feeling any benefit or fun
- e.g. "I couldn't decide what to take" goes here unless it is about the screen
- e.g. "No reason to continue" goes here too
Hard to use
- How to fill in: add voices about the effort of continuing, such as time, screen, or booking
- e.g. "Evening classes were cut" goes here as a schedule problem
- e.g. "The screen freezes" goes here even if it is only one case
Moved elsewhere
- How to fill in: add voices from people who moved to another studio or service
- e.g. "A studio opened nearby" goes here if price is not mentioned
- e.g. "Another studio" goes here even if where they went is unknown
Money
- How to fill in: add voices about heavy fees or household finances
- e.g. "Any cheaper plan?" goes here as a wish to pay less
- e.g. "Fees are a strain because of family circumstances" goes here too
2/4 Place voices in the table
⑦ Timing × reason table (count, words)
| Value unclear | Hard to use | Moved elsewhere | Money | |
|---|---|---|---|---|
| First 3 months | e.g. 6 voices "unsure" "no change" | e.g. 4 voices "evening classes cut" | e.g. 1 voice "moving with a friend" | e.g. 1 voice "fees are a strain" |
| Before renewal | e.g. 2 voices "no reason to continue" | e.g. 0 voices | e.g. 2 voices "one opened nearby" | e.g. 5 voices "any cheaper plan?" |
| After stopping use | e.g. 3 voices "can't stay motivated" | e.g. 1 voice "video keeps freezing" | e.g. 0 voices | e.g. 1 voice "family situation" |
| Unknown | e.g. 0 voices | e.g. 0 voices | e.g. 1 voice "another studio" (timing not recorded) | e.g. 1 voice "fees are high" (timing not recorded) |
⑧ Busiest timing (red: when they left)
- How to fill in: total each row of ⑦ and list them, most first
- e.g. First 3 months, 12 voices (about 40% of 28)
- e.g. Before renewal, 9 voices
- e.g. After stopping use 5 voices, unknown 2 voices
⑨ Busiest reasons (red: why they left)
- How to fill in: total each column of ⑦ and list them, most first
- e.g. Value unclear, 11 voices
- e.g. Money, 8 voices
- e.g. Hard to use 5 voices, moved elsewhere 4 voices
⑩ Surprises (green: insights)
- How to fill in: write voices that were not what you expected, with what was different
- e.g. Many first-3-months "value unclear" voices are about not knowing what to take
- e.g. Many before-renewal "money" voices come from people who do not know a cheaper plan exists
- e.g. Only 1 voice about the video freezing, fewer than expected
3/4 Pick two fixes
⑪ A fix per timing in ⑧ (time order)
- Right after signup What to do in the first 2 weeks e.g. Month-1 outreach. The day after joining, suggest 3 classes suited to beginners
- First 3 months Help them feel the benefit of continuing e.g. Week-3 1-on-1. A 15-minute talk with the instructor to check body changes together
- Before renewal A time when they wonder whether to continue e.g. Renewal notice. Two weeks before renewal, share their class count and the cheaper plan
- When use stops For people who stopped coming e.g. Contact no-shows. Suggest a short class to anyone with no class for 2 weeks
⑫ Compare ⑪ (3 criteria, 2 dots/person)
| Busy timing? | Effort and time | Start next month? | Dots | |
|---|---|---|---|---|
| Month-1 outreach | e.g. Yes. First 3 months, 12 voices | e.g. Small. Write one notice | e.g. Yes | e.g. 4 dots |
| Week-3 1-on-1 | e.g. Yes. First 3 months, 12 voices | e.g. Large. 10 instructor hours a month | e.g. No. Instructor schedule not set | e.g. 1 dot |
| Renewal notice | e.g. Yes. Before renewal, 9 voices | e.g. Small. Send once a month | e.g. Yes | e.g. 4 dots |
| Contact no-shows | e.g. No. After stopping use, 5 voices | e.g. Medium. Check the roster weekly | e.g. Yes | e.g. 1 dot |
⑬ Chosen and skipped fixes, with reasons
- Chosen fixes and reasons e.g. Month-1 outreach and Renewal notice. 4 dots each; they cover the 2 busiest timings and can start next month
- Skipped fixes and reasons e.g. Week-3 1-on-1 takes too much instructor time. Contact no-shows covers only 5 voices
- Date to revisit skipped fixes e.g. At the March regular meeting, reconsider the 1-on-1 once instructor schedules are set
4/4 Test and compare
⑭ Fix 1: Month-1 outreach (gold: to do)
- How to fill in: write when, to whom, and what you send
- e.g. The front desk emails the day after joining
- e.g. Suggest 3 classes for beginners, with times
- e.g. In week 2, ask just one question about how it is going so far
⑮ Fix 2: Renewal notice (gold: to do)
- How to fill in: write when, to whom, and what you tell them
- e.g. Two weeks before renewal, email everyone due to renew
- e.g. Tell them their class count and the classes they took most
- e.g. Add a line about the cheaper plan and the pause option
⑯ Records to compare (blue: records)
- How to fill in: write which record, and who counts it and when
- e.g. Add a question to the cancellation survey about when they started to doubt
- e.g. From usage records, count people who took 2 or more classes in month 1
- e.g. At month end, the studio head adds cancellations, timing, and reasons to table ⑦
⑰ Set owners and deadlines
| Owner | Deadline | What to record | |
|---|---|---|---|
| Month-1 outreach | e.g. Front desk staff | e.g. Send the first email on Dec 5 | e.g. Number sent and number of replies |
| Renewal notice | e.g. Operations lead | e.g. First send on Dec 20 | e.g. Number sent and number who switched to the cheaper plan |
| Compile records | e.g. Studio head | e.g. Last day of each month | e.g. Cancellations, timing, and reasons |
⑱ Review date and signals (in 1 month)
- Review date and numbers to check e.g. Regular meeting at end of January. Compare January's cancellations with the Sep–Nov monthly average (about 9)
- Voices to carry to the next round e.g. The 5 voices from after they stopped using it. Check them again in table ⑦ in March
- Signals and where to go back e.g. Keep = 7 or fewer cancellations in January. Change = 8 to 9. Stop = 10 or more, or 2 or more complaints about outreach. If you stop, go back to (board⑫) and pick other fixes
Task board contents
Collect voices 16 items
Collect voices
On page 1, write last round's result and the review period, then copy in the voices of people who left from 4 sources. Once you have them, you can place them in the timing-by-reason table on page 2. Press Ctrl+F (⌘F on Mac) and type "3/4" to jump to page 3.
Log result, period
On board ①, write the result of what you decided last time, the review period and cancellation count, and who meets and for how long. Done when all 3 notes are filled (if it is your first time, leave last result blank).
Copy 4 voice sources
On boards ②–⑤, copy the cancellation survey, last inquiries, usage records, and what staff heard, unedited, one per line. Done when you have as many voices as cancellations in the review period.
Check reason types
Read board ⑥ and look for voices from ②–⑤ that you cannot place in a reason type. Done when you have decided where each goes and added it as an example in that column of ⑥.
Place in the table
On page 2, place the voices you copied on page 1 in a table of when they left and why. Once the table is done, you know which timing to work on for page 3.
Put voices in cells
In the table on board ⑦, place each voice in the cell where its timing row and reason column meet, and write a count and a few words in each cell. Done when the cell counts add up to the cancellation count.
Rank timing, reasons
Total each row and column of board ⑦, then write timings on board ⑧ and reasons on board ⑨, most first.
Note surprises
On board ⑩, write at least one voice that was not what you expected, with what was different.
Pick two fixes
On page 3, come up with fixes for each busy timing and narrow them to 2 using 3 criteria. The 2 you pick here are the fixes you test on page 4.
Fix idea per timing
In the 4 stages of board ⑪, write one fix each, in order from right after signup to when use stops.
Compare, place dots
In the table on board ⑫, compare the fixes from ⑪ on 3 criteria (busy timing, effort, and whether you can start next month). Each person places 2 dot stamps. Done when the dot counts are in the last column.
Write picks and why
On board ⑬, write the 2 fixes with the most dots and why, the fixes you skipped and why, and the date to revisit the skipped ones.
Test and compare
On page 4, write what the 2 chosen fixes involve and how to record results, and set owners and deadlines. One round ends when you compare cancellation counts after a month and decide with the signals whether to continue.
Plan fixes, records
On boards ⑭ and ⑮, write when, to whom, and what you send for each chosen fix. On board ⑯, write the records for the 1-month comparison and who counts them.
Assign owner, dates
In the table on board ⑰, write each fix's owner, deadline, and what to record. Done when every cell is filled and you move the card to the Testing column on the task board.
Keep, change, stop
After 1 month, read the signals on board ⑱ and decide to keep, change, or stop, then write the result in "Last round's result" on board ① of the next round. If you stop, go back to board ⑫ and pick another fix.