30 Claude Prompts for Churn Analysis
Paste your cancellation data, support tickets, or cohort numbers and get back a coded reason breakdown, a save play script, or a test plan you can hand to your team the same day.
In short: This page contains 30 copy-paste ready prompts, organized into 6 categories with a description and pro tip for each. The first 5 prompts are free instantly, no signup needed. Hand-curated and tested by the AI Academy team.
Cohort Analysis
5 promptsMonthly cohort retention breakdown
1/30โจ What it does
Turns a raw cohort retention table into a plain-language analysis of which signup months are churning fastest and why.
You are a senior retention analyst at a subscription software company. <context> I have monthly signup cohorts and want to see how retention decays across each one so I can spot which cohort or which month is dragging the average down. </context> <inputs> - Cohort data: [PASTE COHORT TABLE, ROWS ARE SIGNUP MONTH, COLUMNS ARE MONTHS SINCE SIGNUP] - Plan tiers included: [LIST OF PLAN TIERS] - Date range: [START MONTH] to [END MONTH] - Known events during this window: [PRICING CHANGE, FEATURE LAUNCH, OUTAGE, ETC] </inputs> <task> Produce a written cohort retention analysis. Identify which cohorts retain best and worst, call out the month where retention drops fastest across most cohorts, and connect any drop to the known events I listed if the timing lines up. </task> <constraints> Keep the analysis under 400 words. Do not restate the raw numbers back to me in full, only reference the ones that matter to the conclusion. Flag if the sample size in any cohort is too small to trust, using [MINIMUM COHORT SIZE] as the threshold. </constraints> <format> Return three sections: Headline Finding, Cohort-by-Cohort Notes, and Recommended Next Check. </format>
Pro tip: Paste the cohort table as tab-separated text, Claude reads that far more reliably than a pasted spreadsheet screenshot description.
Compare retention across acquisition channels
2/30โจ What it does
Ranks acquisition channels by real retained-customer economics instead of raw signup counts.
You are a growth analyst who reports on channel quality, not just channel volume. <context> Marketing wants to know which acquisition channel brings in customers who actually stick around, not just the ones with the lowest cost per signup. </context> <inputs> - Channel retention data: [PASTE TABLE: CHANNEL, SIGNUPS, RETAINED AT 30/60/90 DAYS] - Cost per acquisition by channel: [CPA FIGURES] - Target retention benchmark: [TARGET PERCENT] at [DAY MARK] - Channels under review: [PAID SEARCH, ORGANIC, REFERRAL, PARTNERSHIP, ETC] </inputs> <task> Rank the channels by retained-customer quality rather than raw volume, and flag any channel where the CPA looks cheap but the retention curve makes it expensive per retained customer. </task> <constraints> Use plain numbers, not vague terms like good or bad. Show the math for cost per retained customer for at least the top and bottom channel. Avoid recommending budget changes, that is not this task, stick to the analysis. </constraints> <format> Return a ranked table (channel, retention rate, cost per retained customer) followed by a short paragraph explaining the ranking. </format>
Pro tip: Feed it at least three months of channel data, single-month comparisons are too noisy for the ranking to hold up.
Spot the cohort inflection point
3/30โจ What it does
Finds the exact week in the customer lifecycle where retention drops fastest and links it to a plausible product milestone.
You are a data analyst specializing in subscription lifecycle curves. <context> I need to find the exact point in the customer lifecycle where churn risk spikes, so the team can time an intervention before that point instead of after. </context> <inputs> - Weekly retention curve: [PASTE PERCENT RETAINED BY WEEK, WEEK 1 THROUGH WEEK N] - Product usage milestones: [LIST KEY ACTIONS LIKE FIRST EXPORT, FIRST INTEGRATION, ETC] - Current intervention timing, if any: [DESCRIBE EXISTING OUTREACH SCHEDULE] </inputs> <task> Identify the week or weeks where the retention curve bends most sharply downward, and suggest which usage milestone from my list most plausibly correlates with customers who make it past that point. </task> <constraints> Be explicit about correlation versus proof, this is a hypothesis to test, not a confirmed causal link. Keep the output to one page. Do not suggest specific email copy, that is a separate task. </constraints> <format> Return: Inflection Point (with the week number), Suspected Driver, and Suggested Test to confirm it. </format>
Pro tip: Cross check the suggested driver against actual usage logs before building a whole campaign around it, this only produces a hypothesis.
Segment cohorts by plan tier and company size
4/30โจ What it does
Breaks a blended churn number into plan tier and company size segments to reveal which segment carries the most revenue risk.
You are a B2B SaaS analyst who segments retention data for board reporting. <context> Our churn rate looks fine in aggregate but I suspect it is hiding a big difference between small accounts and larger ones. </context> <inputs> - Retention by segment: [PASTE TABLE: PLAN TIER, COMPANY SIZE BAND, RETAINED PERCENT AT 90 DAYS] - Overall blended churn rate: [BLENDED CHURN PERCENT] - Revenue contribution by segment: [REVENUE SHARE PER SEGMENT] - Reporting audience: [BOARD, LEADERSHIP TEAM, OR INTERNAL OPS] </inputs> <task> Show how much the blended churn number is masking segment-level differences, and identify which segment poses the biggest revenue risk given both its churn rate and its revenue share. </task> <constraints> Write for the audience I specified, adjust technical depth accordingly. Length should fit on one slide, under 150 words of body text plus a table. Do not editorialize about causes unless the data supports it directly. </constraints> <format> Return a short table of segments ranked by revenue risk, followed by a two sentence takeaway for the stated audience. </format>
Pro tip: Run this quarterly and keep the segment definitions identical each time, so the ranking is comparable across periods.
Cohort health dashboard summary
5/30โจ What it does
Writes a concise, honest weekly cohort retention update that separates real signal from normal week to week noise.
You are an analytics lead who writes the weekly retention summary for the executive team. <context> I pull cohort numbers every week and need a consistent, honest summary that does not sugarcoat bad weeks or overreact to noisy ones. </context> <inputs> - This week's cohort numbers: [PASTE CURRENT WEEK DATA] - Trailing four week average: [PASTE PRIOR AVERAGE] - Notable events this week: [PRODUCT CHANGES, OUTAGES, PRICE CHANGES, CAMPAIGNS] - Recipient: [WHO READS THIS SUMMARY] </inputs> <task> Write a short weekly retention summary comparing this week to the trailing average, explaining whether any deviation looks like signal or noise, and naming what I should watch next week. </task> <constraints> Keep it under 120 words. No hype language, no exclamation points. If the week is unremarkable, say so plainly instead of manufacturing a story. </constraints> <format> Return as three short lines: This Week, Compared to Trend, Watch Next. </format>
Pro tip: Run this every week with the same input format, the value comes from the consistency, not from any single week's write-up.
Cancellation Reason Coding
5 promptsCode open-text cancellation reasons into categories
6/30โจ What it does
Sorts a batch of raw cancellation survey responses into consistent, auditable reason categories.
You are a customer research analyst who codes free-text survey responses into clean categories. <context> Our cancellation survey has an open text field and I have a pile of raw responses that nobody has categorized yet. </context> <inputs> - Raw responses: [PASTE LIST OF OPEN TEXT CANCELLATION REASONS, ONE PER LINE] - Existing category list, if any: [LIST CATEGORIES LIKE PRICE, MISSING FEATURE, SWITCHED TO COMPETITOR, NOT ENOUGH USE] - Minimum category size to keep separate: [MINIMUM COUNT] </inputs> <task> Assign each response to one category from my list, or propose a new category if none fit well, then merge any category that falls below my minimum size into an Other bucket. </task> <constraints> Do not force a response into a category it does not fit just to keep the list short. Keep each response tied to its original text so I can audit the coding. Avoid vague catch-all categories like general dissatisfaction unless truly nothing else fits. </constraints> <format> Return a table with columns: Original Response, Assigned Category, Confidence (high, medium, low). End with a category count summary. </format>
Pro tip: Run this in batches of 50 to 100 responses at a time, larger batches make the category assignments drift and lose consistency.
Detect the real reason behind a vague cancellation comment
7/30โจ What it does
Turns a short, unhelpful cancellation comment into a testable hypothesis about the real reason for leaving.
You are a churn researcher who reads between the lines of vague customer feedback. <context> Many of our cancellation comments are short and unhelpful on the surface, like 'not what I needed' or 'moving on', and I want a first pass guess at what is really going on before I decide if it is worth a follow-up call. </context> <inputs> - Vague comment: [PASTE THE SHORT CANCELLATION COMMENT] - Account context: [PLAN TIER, TENURE IN MONTHS, LAST LOGIN DATE, SUPPORT TICKET HISTORY IF ANY] - Usage pattern before cancellation: [DESCRIBE RECENT LOGIN FREQUENCY OR FEATURE USE] </inputs> <task> Give your best hypothesis for the underlying reason behind the vague comment, using the account context as evidence, and rate how confident you are in that guess. </task> <constraints> Be explicit that this is an inference, not a confirmed reason. List the specific piece of context that most supports your guess. If the context contradicts the comment, say so instead of forcing an answer. </constraints> <format> Return: Likely Reason, Supporting Evidence, Confidence Level, and Suggested Follow-Up Question if a call happens. </format>
Pro tip: Only use this for accounts worth a save call, running it on every low-value cancellation wastes time on guesses nobody will act on.
Build a churn reason taxonomy from scratch
8/30โจ What it does
Builds a starter churn reason taxonomy with clear definitions and example phrasing when a company has none yet.
You are a customer insights lead building a reason coding system for a company that has never had one. <context> We are about to start tracking why customers cancel but have no existing taxonomy, and I want a clean starting structure before the survey goes live. </context> <inputs> - Product type: [DESCRIBE PRODUCT, EG PROJECT MANAGEMENT SOFTWARE] - Customer type: [B2B, B2C, OR BOTH] - Sample of past support tickets or exit interviews, if any: [PASTE EXAMPLES OR WRITE NONE AVAILABLE] - Number of top-level categories wanted: [NUMBER, EG 6 TO 8] </inputs> <task> Propose a top-level churn reason taxonomy with the number of categories I specified, each with a one sentence definition and two example phrasings a customer might actually use for that reason. </task> <constraints> Categories must be mutually exclusive enough that a coder rarely has to guess between two of them. Avoid categories that are really symptoms of another category, for example price sensitivity is often actually a value perception problem, note that distinction if relevant. </constraints> <format> Return a numbered list: Category Name, Definition, Example Phrase 1, Example Phrase 2. </format>
Pro tip: Pilot the taxonomy on 30 real responses before rolling it out company-wide, categories that look clean on paper often overlap in practice.
Find the reasons hiding behind price complaints
9/30โจ What it does
Splits price-related cancellation reasons into genuine budget constraints versus low-usage value perception problems.
You are a pricing and retention analyst who does not take price as the final answer. <context> Most of our exit survey responses say the price was too high, but I suspect a chunk of those are really about perceived value, not the number itself. </context> <inputs> - Price-coded cancellation responses: [PASTE LIST OF RESPONSES CODED AS PRICE] - Usage data for these accounts: [DESCRIBE LOGIN FREQUENCY OR FEATURE ADOPTION FOR THESE ACCOUNTS] - Plan tier these accounts were on: [PLAN TIER] </inputs> <task> For each response, judge whether the complaint looks like a genuine budget constraint or a value perception problem, meaning they were not using enough of the product to justify the cost, using the usage data as evidence. </task> <constraints> Do not assume every low-usage account is a value problem, some genuinely could not afford it regardless of usage. State the specific usage signal you used for each judgment. Keep each explanation to one sentence. </constraints> <format> Return a table: Response, Usage Signal, Judgment (Budget Constraint or Value Perception), Reasoning. </format>
Pro tip: Value perception cases are the ones worth showing to product and onboarding teams, budget constraint cases usually are not fixable by them.
Summarize churn reasons for a leadership update
10/30โจ What it does
Converts a quarter of coded cancellation reasons into a leadership-ready summary with quarter over quarter movement and clear ownership.
You are a customer insights manager preparing the quarterly churn reasons summary for leadership. <context> I have a full quarter of coded cancellation reasons and need to turn that into a summary leadership can act on, not just a pie chart with no context. </context> <inputs> - Coded reason counts this quarter: [PASTE CATEGORY, COUNT, PERCENT OF TOTAL] - Same data from last quarter for comparison: [PASTE PRIOR QUARTER NUMBERS] - Revenue lost by top reason category: [REVENUE FIGURES IF AVAILABLE] </inputs> <task> Summarize which reasons grew or shrank versus last quarter, name the single reason category responsible for the most lost revenue, and suggest one owner or team that should look into it. </task> <constraints> Keep the summary to one page. Use specific percentage point changes, not vague language like slightly up. Do not suggest more than one action item per reason category, this needs to be actionable, not a wish list. </constraints> <format> Return: Top Movers table (category, this quarter, last quarter, change), Revenue Impact Note, and one Recommended Owner per top reason. </format>
Pro tip: Keep the category list identical quarter to quarter or the comparison numbers will not mean anything, log any taxonomy change separately.
Save Plays and Win-Back
5 promptsDraft a save play call script for a specific cancel reason
11/30โจ What it does
Produces a save call script matched to the customer's specific stated cancellation reason instead of a generic retention pitch.
You are a customer success lead who writes call scripts for at-risk account save conversations. <context> One of my reps has a save call scheduled with a customer who flagged a specific cancellation reason, and I want a script tailored to that reason rather than a generic retention pitch. </context> <inputs> - Stated cancellation reason: [REASON, EG MISSING INTEGRATION, TOO EXPENSIVE, LOW USAGE] - Account details: [PLAN TIER, TENURE, KEY CONTACT ROLE] - What we can actually offer: [DISCOUNT LIMIT, ROADMAP ITEM, DOWNGRADE OPTION, ETC] - Rep experience level: [NEW OR EXPERIENCED] </inputs> <task> Write a call script structured around acknowledging the stated reason, asking one clarifying question, then presenting only the offers I listed that are relevant to that reason. </task> <constraints> Do not offer anything outside what I listed as available. Keep the script conversational, not a rigid word for word read. Include a clear point where the rep should stop pushing if the customer says no twice. </constraints> <format> Return the script in four labeled sections: Opening, Clarifying Question, Offer, and Graceful Exit. </format>
Pro tip: Give the rep the graceful exit section explicitly, scripts that only cover the pitch tend to make reps oversell when the answer is still no.
Write a win-back email for lapsed customers
12/30โจ What it does
Writes a targeted win-back email that speaks to the exact reason a lapsed customer left and what has changed since.
You are a lifecycle marketer who writes win-back emails for former subscribers. <context> I am building a win-back sequence for customers who canceled between three and twelve months ago and have not returned. </context> <inputs> - Product changes since they left: [LIST NEW FEATURES OR IMPROVEMENTS] - Original cancellation reason segment being targeted: [REASON SEGMENT, EG MISSING FEATURE NOW SHIPPED] - Incentive available: [DISCOUNT, EXTENDED TRIAL, OR NONE] - Sender name and role: [SENDER NAME, ROLE] </inputs> <task> Write one win-back email that references the specific gap that made them leave and shows it has been addressed, then makes a low-friction ask to come back. </task> <constraints> Under 150 words. No exclamation points, no fake urgency language like last chance. Do not apologize excessively, one honest acknowledgment is enough. </constraints> <format> Return subject line, preview text, and email body as plain text. </format>
Pro tip: Segment win-back emails by original cancellation reason rather than sending one generic version, the reference to their specific gap is what makes people open and read.
Decide whether an account is worth a save attempt
13/30โจ What it does
Scores a canceling account's save-worthiness so limited retention team capacity goes to the accounts most likely to actually be saved.
You are a customer success operations analyst who triages which cancellations deserve a save attempt. <context> We get more cancellation notices than the team has time to call, so I need a quick way to decide which accounts are worth the outreach. </context> <inputs> - Account value: [MONTHLY OR ANNUAL CONTRACT VALUE] - Tenure: [MONTHS AS CUSTOMER] - Recent usage trend: [INCREASING, FLAT, OR DECLINING] - Stated cancellation reason: [REASON] - Rep capacity this week: [NUMBER OF SAVE CALLS THE TEAM CAN MAKE] </inputs> <task> Score this account's save-worthiness on a simple scale and give a one sentence reason, considering that a customer with declining usage and a structural reason like company shutdown is not worth pursuing even at high value. </task> <constraints> Use a consistent three-point scale: High Priority, Attempt If Time Allows, Skip. Do not recommend High Priority purely based on contract value if the reason given is unfixable, like they were acquired or shut down. </constraints> <format> Return: Priority Level, One Sentence Reason, and Suggested Outreach Channel (call, email, or none). </format>
Pro tip: Feed this the same five inputs every time and log the outcome, after a few dozen calls you can check whether the scoring actually predicted saves correctly.
Design a downgrade offer instead of losing the account entirely
14/30โจ What it does
Checks whether a downgrade tier can retain a price-sensitive customer while still covering their actual usage and a minimum revenue bar.
You are a revenue retention strategist who prefers a smaller deal over a lost customer. <context> A customer wants to cancel because the plan is too expensive for their current usage, and I want to offer a downgrade path that keeps them as a customer rather than losing them completely. </context> <inputs> - Current plan and price: [CURRENT PLAN NAME AND PRICE] - Available lower tiers: [LIST LOWER TIER OPTIONS AND WHAT THEY REMOVE] - Customer's actual usage: [DESCRIBE WHICH FEATURES THEY ACTUALLY USE] - Minimum acceptable retained revenue: [MINIMUM DOLLAR AMOUNT PER MONTH] </inputs> <task> Recommend which lower tier, if any, still covers the features this customer actually uses, and confirm whether it clears my minimum retained revenue threshold. </task> <constraints> If no available tier meets both the usage needs and the revenue minimum, say so plainly instead of forcing a recommendation. Do not suggest a custom one-off price, work only with the tiers I listed. </constraints> <format> Return: Recommended Tier or None, Feature Fit Check, Revenue Check, and a one sentence talking point for the rep to use. </format>
Pro tip: Have the actual usage data pulled before running this, guessing at what a customer uses defeats the point of the fit check.
Write an internal escalation note for a high-value save
15/30โจ What it does
Writes a fast, decision-ready escalation memo for leadership when a high-value account needs a non-standard save offer approved quickly.
You are a customer success manager who escalates high-stakes save situations to leadership. <context> A large account is about to cancel and I need to write a tight internal note so a director can approve a non-standard offer quickly. </context> <inputs> - Account name and value: [ACCOUNT NAME, ANNUAL VALUE] - Cancellation reason: [REASON] - What the customer is asking for: [SPECIFIC ASK, EG CUSTOM DISCOUNT OR FEATURE COMMITMENT] - Deadline for a decision: [DATE OR TIME] </inputs> <task> Write an escalation note that gives the director everything needed to decide fast: the stakes, the ask, the alternative if we say no, and my recommendation. </task> <constraints> Under 120 words. Lead with the deadline and the dollar amount, do not bury them in paragraph three. State a clear recommendation, do not just present options with no opinion. </constraints> <format> Return as a short memo with bolded labels: Deadline, Stakes, Ask, Alternative If No, Recommendation. </format>
Pro tip: Always state a recommendation even if you expect the director to overrule it, a note with no opinion just adds a round trip to an already tight deadline.
These prompts give you the what. Tutorials give you the why.
Learn when to use extended thinking, how to build Claude Projects, and workflows that compound. 300+ tutorials and growing.
Retention Experiments
5 promptsDesign an A/B test for a retention intervention
16/30โจ What it does
Sketches a full A/B test design for a retention intervention, including a rough sample size and run time estimate.
You are an experimentation lead who designs tests for a subscription product team. <context> We have a hypothesis that a proactive check-in email at day 20 will reduce cancellations, and I need a proper test design before we build it. </context> <inputs> - Hypothesis: [YOUR HYPOTHESIS IN ONE SENTENCE] - Eligible population size per month: [NUMBER OF CUSTOMERS WHO WOULD QUALIFY] - Primary metric: [METRIC, EG DAY 30 RETENTION] - Current baseline rate: [BASELINE PERCENT] - Minimum detectable effect we care about: [PERCENTAGE POINTS] </inputs> <task> Design the test structure, including how to split the population, how long to run it, and roughly how many customers per arm are needed to detect the effect size I specified. </task> <constraints> Use a simple two-arm test unless there is a clear reason for more. State your sample size estimate as an approximation and note the assumption behind it, do not present it as an exact statistical calculation. Flag if the monthly eligible population is too small to reach significance in a reasonable time. </constraints> <format> Return: Test Design, Arms, Estimated Sample Size Needed, Estimated Run Time, and Risks to Watch. </format>
Pro tip: Treat the sample size estimate as a planning input, run the real power calculation in your stats tool before locking the test length.
Write the experiment brief for a save flow change
17/30โจ What it does
Turns a retention feature idea into a one page experiment brief ready for stakeholder sign-off before development starts.
You are a product manager writing an experiment brief for the team before development starts. <context> We want to test adding a one-click pause option to the cancellation flow instead of forcing a full cancel, and I need a brief the engineering and design team can work from. </context> <inputs> - Current cancellation flow: [DESCRIBE CURRENT STEPS] - Proposed change: [DESCRIBE THE PAUSE OPTION FEATURE] - Success metric: [METRIC, EG PERCENT WHO CHOOSE PAUSE OVER CANCEL] - Target launch window: [DATE RANGE] - Stakeholders who need to sign off: [LIST NAMES OR ROLES] </inputs> <task> Write a one page experiment brief covering the problem, the proposed change, what success looks like, and what could go wrong, ready to send to the stakeholders for sign-off. </task> <constraints> Under 350 words. Include at least one risk that is not obvious, such as pause option cannibalizing an otherwise recoverable churn conversation. Avoid restating the whole current flow step by step, summarize it. </constraints> <format> Return as a memo with headers: Problem, Proposed Change, Success Metric, Risks, Sign-Off Needed From. </format>
Pro tip: List the non-obvious risk explicitly in the brief, it is the detail that gets skipped when teams rush an experiment out and it usually surfaces later as a support complaint.
Interpret a retention experiment result that is not statistically significant
18/30โจ What it does
Explains an inconclusive retention test result in plain language and gives a ship, extend, or scrap recommendation based on cost and effect direction.
You are a data scientist who explains inconclusive experiment results honestly to a product team eager for a clear answer. <context> We ran a retention experiment and the result did not reach statistical significance, but the team is asking me whether we should ship the change anyway. </context> <inputs> - Test group result: [PERCENT RETAINED, SAMPLE SIZE] - Control group result: [PERCENT RETAINED, SAMPLE SIZE] - Statistical significance level reached: [P VALUE OR CONFIDENCE LEVEL] - Cost or effort to keep the change permanently: [LOW, MEDIUM, OR HIGH] </inputs> <task> Explain plainly what the result does and does not tell us, and give a recommendation on whether to ship, extend the test, or scrap it, factoring in the cost of keeping the change. </task> <constraints> Do not claim the test proved anything it did not. If the effect direction is positive but not significant and the cost to keep it is low, say that is a reasonable case for shipping anyway, and explain why. Avoid statistics jargon the team would need to look up. </constraints> <format> Return: What We Actually Know, What We Don't Know, Recommendation, Reasoning. </format>
Pro tip: Ask for this before the readout meeting, not during it, teams push hard for a yes or no answer live and this framing helps you hold the line on nuance.
Prioritize a backlog of retention experiment ideas
19/30โจ What it does
Ranks a messy backlog of retention experiment ideas by impact on the current top churn driver against available effort.
You are a growth lead who ranks experiment ideas by expected impact versus effort. <context> The team has a long list of retention experiment ideas from different meetings and I need to prioritize which ones to run first this quarter. </context> <inputs> - List of experiment ideas: [PASTE LIST OF IDEAS, ONE PER LINE] - Rough effort estimate for each, if known: [LOW, MEDIUM, HIGH, OR UNKNOWN] - Current biggest churn driver from our data: [TOP CHURN REASON] - Number of experiments we can realistically run this quarter: [NUMBER] </inputs> <task> Rank the ideas by likely impact on the biggest churn driver weighed against effort, and select the top ones up to the number we can run this quarter. </task> <constraints> For ideas with unknown effort, flag them as needing an estimate before they can be prioritized properly, do not guess an effort level for them. Do not include more experiments than the number I specified in the final selection. </constraints> <format> Return a ranked table: Idea, Estimated Impact, Effort, Selected (yes or no), followed by the reasoning for the top three picks. </format>
Pro tip: Get real effort estimates from engineering before running this again next quarter, unknown-effort ideas that keep getting flagged are usually the ones nobody wants to scope.
Write the post-experiment readout for a shipped retention change
20/30โจ What it does
Compares a retention experiment's predicted lift against its real post-launch performance and explains any gap.
You are an analyst who writes the readout after a retention experiment concludes and the winning variant ships. <context> Our retention experiment finished, a variant won, and it has now been live for a few weeks. I need a readout that documents the result and whether the real-world impact matches what the test predicted. </context> <inputs> - Original test result: [LIFT PERCENTAGE AND CONFIDENCE LEVEL FROM THE TEST] - Post-launch actual metric: [ACTUAL METRIC SINCE FULL ROLLOUT] - Time since full rollout: [NUMBER OF WEEKS] - Any confounding events since rollout: [SEASONALITY, PRICING CHANGE, OTHER LAUNCHES] </inputs> <task> Compare the predicted lift from the test to the actual post-launch metric, note whether they match, and explain any gap using the confounding events I listed if relevant. </task> <constraints> Under 250 words. Do not claim certainty about the cause of a gap if a plausible confounder exists, present it as the likely explanation, not a fact. Include a one line takeaway for future experiment design if there is a lesson here. </constraints> <format> Return: Predicted vs Actual, Gap Explanation, Lesson for Future Tests. </format>
Pro tip: Always check for confounding events before assuming an experiment's real-world result underperformed the test, seasonality alone explains a lot of these gaps.
Churn Reporting and Forecasting
5 promptsTurn a churn spreadsheet into a board slide
21/30โจ What it does
Condenses a year of churn and revenue retention data into a tight, board-ready slide with a preemptive answer to the likely question.
You are a finance and operations analyst who prepares board materials. <context> I have a full churn data export and need to condense it into one slide the board will actually read in the two minutes they spend on it. </context> <inputs> - Monthly churn rate for the last 12 months: [PASTE 12 MONTHLY FIGURES] - Net revenue retention for the same period: [PASTE NRR FIGURES] - Biggest change this period: [DESCRIBE, EG PRICE INCREASE, NEW COMPETITOR] - Board's usual focus areas: [WHAT THEY TYPICALLY ASK ABOUT] </inputs> <task> Write the slide content: a headline number, a one sentence trend statement, and a short note connecting the trend to the biggest change this period. </task> <constraints> No more than 60 words of text total, boards read slides, not memos. Do not include every monthly number, just the current figure and the trend direction. Anticipate the one question the board's usual focus area would raise and answer it preemptively in the note. </constraints> <format> Return: Headline Number, Trend Statement, Context Note, Anticipated Question and Answer. </format>
Pro tip: Ask a colleague who sits in on board meetings what gets asked most, feed that into the board's usual focus area field for a sharper anticipated question.
Build a simple churn forecast for next quarter
22/30โจ What it does
Produces a directional churn forecast range for next quarter from historical trend data plus known upcoming changes.
You are a revenue operations analyst who forecasts churn for planning purposes, not a data scientist building a formal model. <context> Finance wants a rough churn forecast for next quarter to plan revenue targets, and I only have historical trend data, not a sophisticated model. </context> <inputs> - Churn rate last four quarters: [PASTE FOUR QUARTERLY FIGURES] - Known upcoming changes: [PRICE CHANGE, NEW COMPETITOR LAUNCH, SEASONAL PATTERN, ETC] - Current customer base size: [NUMBER OF ACTIVE CUSTOMERS] </inputs> <task> Project a churn rate range for next quarter based on the historical trend, adjusted for the known upcoming changes, and translate that into an estimated number of customers lost. </task> <constraints> Give a range, not a single precise number, this is a directional estimate. State explicitly which assumption drives the low end versus the high end of the range. Do not present this as a substitute for a proper statistical forecasting model if finance needs one. </constraints> <format> Return: Forecast Range, Low End Assumption, High End Assumption, Estimated Customers Lost. </format>
Pro tip: Revisit this forecast monthly against actuals and adjust the range, a single quarterly forecast set once tends to drift stale fast.
Explain a sudden churn spike to leadership
23/30โจ What it does
Drafts an honest, appropriately hedged explanation of a sudden churn spike for a leadership meeting happening before the full investigation is done.
You are a customer analytics manager who has to explain an unexpected churn spike before the next leadership meeting. <context> Churn jumped noticeably last month and leadership wants to know why before I have done a full investigation, so I need a preliminary explanation based on what I know so far. </context> <inputs> - Churn rate this month versus prior average: [THIS MONTH PERCENT, PRIOR AVERAGE PERCENT] - Events that happened this month: [LIST ANY OUTAGES, PRICE CHANGES, SUPPORT ISSUES, COMPETITOR NEWS] - What the cancellation reasons show so far: [PRELIMINARY REASON BREAKDOWN IF AVAILABLE] - Time until the leadership meeting: [HOURS OR DAYS] </inputs> <task> Write a preliminary explanation that is honest about what is confirmed versus what is still a guess, and state what additional analysis is needed before a final answer. </task> <constraints> Do not present a guess as a confirmed cause. Keep it to one paragraph plus a short next steps list. Match the tone to the short timeframe, this is a preliminary update, not a final report. </constraints> <format> Return: Preliminary Explanation, Confidence Level, Next Steps Before Final Report. </format>
Pro tip: Send the confidence level explicitly, leadership tends to remember whatever you say as fact even when you call it preliminary, so state it twice if needed.
Compare our churn rate to industry benchmarks
24/30โจ What it does
Gives a directional read on whether a company's churn rate looks high, typical, or low against general industry patterns for its segment.
You are a SaaS metrics analyst who contextualizes a company's churn rate against typical industry ranges. <context> I want to know whether our churn rate is actually a problem or roughly normal for a company like ours, before I raise an alarm internally. </context> <inputs> - Our annual churn rate: [PERCENT] - Company type: [B2B OR B2C, PLUS INDUSTRY, EG PROJECT MANAGEMENT SAAS] - Average contract value: [DOLLAR AMOUNT] - Customer segment: [SMB, MID MARKET, OR ENTERPRISE] </inputs> <task> Give a general sense of where a company like ours typically sits on churn based on well known industry patterns, such as SMB churning faster than enterprise, and say whether our rate looks notably high, roughly typical, or notably low relative to that pattern. </task> <constraints> Be clear you are giving general industry patterns, not citing a specific verified benchmark study, since exact current benchmark data is not something to state with false precision. Do not claim certainty about our exact percentile ranking. </constraints> <format> Return: General Pattern for Our Segment, Our Position (High, Typical, or Low), Caveat on Data Limits. </format>
Pro tip: Treat this as a sanity check only, pull an actual current benchmark report for your segment before using a number in an external pitch.
Draft the executive summary for a quarterly churn report
25/30โจ What it does
Writes a tight three sentence executive summary for a quarterly churn report that leads with the real trend and driver.
You are the head of customer analytics writing the quarterly churn report executive summary. <context> The full quarterly churn report has all the detail already, I just need a tight executive summary at the top that busy executives will actually read. </context> <inputs> - Overall churn rate this quarter versus last: [THIS QUARTER PERCENT, LAST QUARTER PERCENT] - Top churn driver this quarter: [DRIVER NAME] - One initiative already in progress to address it: [DESCRIBE INITIATIVE] - Any metric that improved this quarter: [METRIC AND IMPROVEMENT] </inputs> <task> Write a three sentence executive summary covering the headline trend, the top driver, and one balancing positive so the report does not read as purely bad news if there is a genuine improvement to report. </task> <constraints> Exactly three sentences, no more. Do not manufacture a positive if the improvement I gave you is minor, describe it proportionally to its actual size. Skip generic phrases like 'we remain focused on the customer'. </constraints> <format> Return just the three sentence executive summary as plain text, nothing else. </format>
Pro tip: Write the rest of the report first, then use this prompt last, a summary written before the details exist tends to bury the actual top driver.
Most people use 10% of Claude. Tutorials unlock the rest.
AI Academy: 300+ hands-on tutorials on Claude, ChatGPT, Midjourney, and 50+ AI tools. New tutorials added every week.
Customer Health and Early Warning
5 promptsDesign a customer health score formula
26/30โจ What it does
Proposes a starter weighted health score formula and risk band cutoffs from a company's existing usage signals.
You are a customer success operations lead building a health score from scratch. <context> We track a handful of usage signals but have never combined them into one health score, and I want a starting formula before I build it into our dashboard. </context> <inputs> - Available signals: [LIST SIGNALS, EG LOGIN FREQUENCY, FEATURE ADOPTION COUNT, SUPPORT TICKETS, NPS SCORE] - Which signal correlates most with past churn, if known: [SIGNAL NAME OR UNKNOWN] - Desired score range: [EG 0 TO 100] - Number of health bands wanted: [EG 3: HEALTHY, AT RISK, CRITICAL] </inputs> <task> Propose a weighted formula combining the signals I listed, giving more weight to the signal most correlated with churn if I identified one, and define the cutoff points for each health band. </task> <constraints> Keep the formula simple enough to explain to a non-technical rep in one sentence. If I marked the top correlated signal as unknown, weight the signals evenly and flag that correlation analysis should happen before finalizing weights. Avoid more than five signals total, more than that becomes unmanageable for a first version. </constraints> <format> Return: Formula with weights, Band Cutoffs, and One Sentence Explanation for reps. </format>
Pro tip: Backtest the proposed weights against six months of past churned accounts before rolling it out, a formula that looks sensible on paper can still miss obvious past churners.
Flag accounts showing early churn warning signs
27/30โจ What it does
Screens a batch of accounts against known past-churner warning patterns to catch risk before a cancellation request comes in.
You are a customer success analyst who screens accounts for early churn risk signals. <context> I want to catch at-risk accounts before they hit the cancellation flow, using recent behavior changes rather than waiting for a health score to update. </context> <inputs> - Accounts with recent activity change: [PASTE LIST, ACCOUNT NAME, PLAN VALUE, USAGE CHANGE DESCRIPTION] - Known warning patterns from past churners: [LIST PATTERNS, EG LOGIN DROP OF 50 PERCENT OVER TWO WEEKS, ADMIN USER LEFT COMPANY] - Account manager assigned to each, if any: [NAMES OR UNASSIGNED] </inputs> <task> Flag which accounts on the list match one or more known warning patterns, and recommend whether each flagged account needs immediate outreach or just monitoring. </task> <constraints> Only flag an account if it matches a pattern I listed, do not invent new warning signals not grounded in the patterns given. Sort flagged accounts by plan value, highest risk to the business first. If an account has no assigned manager, note that as an action item itself. </constraints> <format> Return a table: Account, Matched Pattern, Recommended Action (Immediate Outreach or Monitor), Assigned Manager. </format>
Pro tip: Keep the known warning patterns list updated from actual past churners quarterly, patterns that mattered a year ago can stop predicting anything as the product changes.
Write a proactive check-in message for a declining-usage account
28/30โจ What it does
Writes a natural, non-invasive check-in message for a declining-usage account that avoids revealing you are tracking their activity.
You are a customer success manager reaching out to an account before they show up in the cancellation queue. <context> One of my accounts has had declining login activity for a few weeks and I want to check in without sounding like a sales pitch or making them feel watched. </context> <inputs> - Account name and contact: [CONTACT NAME] - What changed in their usage: [DESCRIBE THE DECLINE, EG STOPPED USING REPORTING FEATURE] - Relationship history: [HOW LONG THEY HAVE BEEN A CUSTOMER, ANY PAST ISSUES] - Tone preference: [FORMAL OR CASUAL] </inputs> <task> Write a short check-in message that references our relationship naturally, asks an open question about how things are going without mentioning the usage drop directly, and offers a low-pressure way to get help if something changed. </task> <constraints> Under 100 words. Do not mention that we noticed their usage dropped, that reads as surveillance and puts people on the defensive. No sales language, this is a relationship check-in, not a pitch. </constraints> <format> Return subject line and message body as plain text. </format>
Pro tip: Send this before the account manager's own memory of the relationship gets stale, a check-in that references a specific real detail lands far better than a generic one.
Prioritize which at-risk accounts a rep should call this week
29/30โจ What it does
Ranks a rep's flagged at-risk accounts by value, renewal timing, and time since flagged to fill a limited weekly call capacity.
You are a customer success team lead planning a rep's outreach priorities for the week. <context> My rep has a list of flagged at-risk accounts and only enough time to call a handful this week, so I need help ranking who gets the call. </context> <inputs> - Flagged accounts: [PASTE LIST, ACCOUNT NAME, PLAN VALUE, RISK REASON, DAYS SINCE FLAGGED] - Number of calls the rep can make this week: [NUMBER] - Renewal date proximity for each, if relevant: [DATES OR NOT APPLICABLE] </inputs> <task> Rank the accounts by a combination of plan value, how close the renewal date is, and how long the account has been sitting flagged without contact, then select the top accounts up to the number of calls available. </task> <constraints> An account flagged for many days with no contact should move up the list even if its plan value is moderate, stale flags are a risk on their own. Do not select more accounts than the rep can actually call. State the reasoning for the ranking, not just the final list. </constraints> <format> Return a ranked table: Account, Plan Value, Days Flagged, Renewal Proximity, Priority Rank, then a short reasoning paragraph. </format>
Pro tip: Track how many of the stale flagged accounts convert to actual cancellations versus fresh flags, that comparison tells you if the days-flagged weighting is calibrated right.
Audit whether our health score actually predicts churn
30/30โจ What it does
Checks whether an existing customer health score actually separates churners from non-churners by comparing churn rates across health bands.
You are a data analyst auditing whether an existing customer health score is actually doing its job. <context> We have had a health score in place for a while but nobody has checked whether accounts we scored as healthy ever churn anyway, which would mean the score is not trustworthy. </context> <inputs> - Accounts that churned last quarter with their health score at time of cancellation: [PASTE LIST, ACCOUNT, HEALTH SCORE, HEALTH BAND] - Total accounts per health band during that period: [NUMBERS PER BAND] - Score formula summary: [BRIEFLY DESCRIBE WHAT GOES INTO THE SCORE] </inputs> <task> Calculate the churn rate within each health band for the quarter and tell me whether the healthy band actually churned less than the at-risk band, which is the basic thing a working health score should show. </task> <constraints> If the healthy band churned at a similar or higher rate than the at-risk band, say plainly that the score is not predictive and needs rework, do not soften that conclusion. Show the math for each band's churn rate, do not just assert the conclusion. </constraints> <format> Return: Churn Rate by Band table, Verdict (Predictive or Not Predictive), and One Suggested Fix if not predictive. </format>
Pro tip: Run this audit every two quarters, a health score that was predictive at launch can quietly stop working as the product and customer base change.
Free tool
Prompt Optimizer
Turn a rough idea into a structured, professional AI prompt.
Frequently Asked Questions
Prompts are the starting line. Tutorials are the finish.
A growing library of 300+ hands-on tutorials on ChatGPT, Claude, Midjourney, and 50+ AI tools. New tutorials added every week.
7-day free trial. Cancel anytime.
Related guides