AI prompt to analyze retention and lapse rates

Keeping a client is usually easier than finding a new one, and renewal is when clients shop around. AI helps agents reach out before renewal, explain changes clearly and spot clients who may be about to leave.

Below is a ready-to-copy prompt to analyze retention and lapse rates, a detailed version that asks you clarifying questions first, and 1 specialized AI tool (HubSpot) with instructions for this task. It also works in ChatGPT, Claude, Gemini or Copilot.

Try it in the search box ›

The prompt

From these de-identified monthly counts (policies in force, cancellations, non-renewals), calculate retention and lapse rates and describe trends. Data: [paste]

Detailed version (asks clarifying questions first)

Act as an experienced assistant to a licensed insurance agent. Before answering, ask me up to 3 clarifying questions (the line of business, your relationship with the client, and tone). Then complete this task, and finish with a short checklist of statements I should verify with my compliance team.

Task: From these de-identified monthly counts (policies in force, cancellations, non-renewals), calculate retention and lapse rates and describe trends. Data: [paste]

What a good result looks like

A good analysis calculates retention and lapse rates from your monthly counts, shows the formula used, describes trends in plain language and suggests where to look next, such as a particular line or month.

Common mistakes and watch-outs

Check the math and definitions; retention can be measured by policies or households, and mixing them misleads. Don't let the AI invent reasons for trends. Use de-identified counts only. HubSpot or your AMS reports can supply the data.

How to adapt the prompt

Split the data by line of business or producer, and add last year's figures for comparison. Ask for a one-paragraph summary for your team meeting.

EXAMPLE output (placeholder data, not a real client)

Retention analysis - [Period]

Formula: retention = (policies at start - cancellations - non-renewals) / policies at start

| Month | Start | Cancels | Non-renewals | Retention |
| [Month 1] | [Number] | [Number] | [Number] | [Percent] |
| [Month 2] | [Number] | [Number] | [Number] | [Percent] |

Trend: cancellations rose in [Month]; most were [Line].
Next step: review [Line] renewals due next month and call those clients early.

How to use it

Copy the prompt. Copy the short prompt above, or the detailed version if you want the AI to ask clarifying questions first.
Fill in the placeholders. Replace [paste] with your own details. Use placeholders or de-identified details; never paste client personal information.
Run it in the right tool. Paste it into ChatGPT, Claude, Gemini or Copilot, or use HubSpot as described below.
Review before you use it. Use aggregated numbers, not individual client records, when you analyze results with AI. Check every fact, name and number yourself.
Take the next step. Next, see: Summarize monthly agency numbers.

Best AI tools for this task

Specialized tools first, ordered by fit for this task (never by payout), then any general AI assistant.

HubSpot site ↗

CRM and marketing platform with AI features.

How to use it

Build a HubSpot report of policies kept vs. cancelled or non-renewed by month (from a policy-status property or deal stage), then ask Breeze Assistant (HubSpot's AI) to summarize the trend and which lines or segments lapse most. Check the figures against your agency management system.

Any AI assistant

ChatGPT Claude Google Gemini Microsoft Copilot

Paste the prompt above (short or detailed) into any of these.

Before you use it

Use aggregated numbers, not individual client records, when you analyze results with AI.
Never paste client personal information (names, policy numbers, health or financial details) into AI tools your agency hasn't approved.
Review every AI output for accuracy and compliance before you use it.

Was this page helpful?