Analyse cancellation reasons and spot patterns

Prompt that sorts cancellation reasons into clear groups, counts them, separates avoidable reasons and derives actions. Paste it into an AI tool of your choice, which then analyses the cancellation reasons.

Topic: Spreadsheets & data
Type: Prompt
Level: Intermediate
Time: about 8 min

Results depend on the tool, the model and what you enter.

Result preview

Example: written by our editors, not real AI output.

Analysis: 80 answers, last quarter 1. Price too high for the usage: 22 (avoidable) 2. Missing feature "export to Excel": 15 (avoidable) 3. Business closed or moved: 12 (not avoidable) 4. Setup too much effort: 11 (avoidable) 5. Unclear: 9 Typical for 1: "We only use two features but pay for all of them." Action for 1: check a small plan for low usage. How we will see it: share of price-related cancellations in three months.

Fill in

What you type stays in this browser window. We store and send nothing.

OfferWhat is it about?

PeriodWhich period, how many answers?

AnswersPaste the answers, without names, email addresses or customer numbers

Your prompt

Analyse the following cancellation reasons.
Offer: [Offer]
Period and number of answers: [Period]
Answers:
<answers>
[Answers]
</answers>
Approach: 1. Create five to eight groups of reasons with a short description, such as price, missing feature, quality, service, changed needs. 2. Assign each answer to exactly one main group and count the groups. 3. Separate avoidable reasons from those we cannot influence, such as a move or closing a business. 4. Quote two typical answers per group word for word, but without names or other personal details. 5. Suggest one action each for the two largest avoidable groups and say how we will see in three months whether it works. Count only what is in the answers and list unclear answers as their own group.

Take particular care to count only what is in the answers and quote without personal details.

Before you answer, check: Are all instructions met? If key information is missing or a placeholder in square brackets is still in the text, ask instead of guessing. Mark assumptions as assumptions.

Analyse the following cancellation reasons.
Offer: [Offer]
Period and number of answers: [Period]
Answers:
<answers>
[Answers]
</answers>
Approach: 1. Create five to eight groups of reasons with a short description, such as price, missing feature, quality, service, changed needs. 2. Assign each answer to exactly one main group and count the groups. 3. Separate avoidable reasons from those we cannot influence, such as a move or closing a business. 4. Quote two typical answers per group word for word, but without names or other personal details. 5. Suggest one action each for the two largest avoidable groups and say how we will see in three months whether it works. Count only what is in the answers and list unclear answers as their own group.

Take particular care to count only what is in the answers and quote without personal details.

Before you answer, check: Are all instructions met? If key information is missing or a placeholder in square brackets is still in the text, ask instead of guessing. Mark assumptions as assumptions.

This is an instruction for an AI, not the result itself.

Where this prompt works

These AI tools are a good fit for this prompt:

How to use it

Fill in the fields or tap a suggestion. Leave out names, addresses and other personal data.
Copy the finished prompt into an AI tool of your choice.
Spot-check a few assignments before you share the numbers with the team.

Why does this work?

Fixed groups turn many single voices into a ranking. Separating avoidable from unavoidable focuses the work on what you can actually change.

Tips

With only a few answers, give counts instead of percentages so small groups do not look bigger than they are.

You may use our prompts freely, including at work. Please do not republish them as your own collection. We give no warranty for AI results; check them yourself. Terms of use

Analyse cancellation reasons and spot patterns

Result preview

Fill in

Your prompt

Where this prompt works

How to use it

Why does this work?

Tips

Part of these agents

Also a good fit

Check the unit of analysis in tests New

Find cardinality explosions in metrics New

Estimate customer lifetime value simply New