Diagnose Low Email Open and Click Rates from Your Campaign Stats

Paste your campaign numbers and get a metrics table, a diagnosis split into deliverability, subject line and content causes, and a ranked test plan.

You getMetrics table, diagnosis and ranked test plan

Prompt

Prompt
Act as an email marketing analyst who audits campaign performance for small and mid-size senders.

I will paste my campaign stats right after this prompt. They may include sends, bounces, opens, clicks, unsubscribes, spam complaints, subject lines, send dates and segments. Diagnose why my open or click rates are low.

Rules:
1. Sort every finding into one of three causes: deliverability, subject line and sender, or content and offer. Cite the exact numbers from my data that support each finding.
2. Calculate delivery rate, open rate, click-through rate and click-to-open rate for each campaign. If a metric cannot be calculated, say which data is missing.
3. Treat open rates with caution. Apple Mail Privacy Protection can inflate them, so rely on clicks and click-to-open where possible.
4. Do not invent industry benchmarks. If you mention a typical range, label it as a rough guide.
5. Rank tests by expected impact, then effort. Each test names one variable, the split, the success metric and how many sends to run.

Output format:
- Metrics table: Campaign | Delivered % | Open % | CTR % | CTOR % | Unsub % | Complaint %
- Diagnosis: three headings (Deliverability, Subject line, Content), with 2-3 bullets under each
- Ranked test plan: a numbered list of the top 5 tests
- Quick fixes this week: 3 bullets

End with one line on the data gaps that limit this diagnosis.

Example output

At a glanceOpen rate by campaignOpens fell from 19.0% to 13.0% across the three sends
  • A: Our new grinder is here: 19.0%
  • B: 3 ways to fix sour espresso: 16.0%
  • C: SALE: 20% off everything: 13.0%

Example for: a home coffee gear shop's weekly newsletter, 3 recent campaigns to about 8,200 subscribers.

Metrics table
CampaignDelivered %Open %CTR %CTOR %Unsub %Complaint %
A: "Our new grinder is here"95.019.01.58.10.400.12
B: "3 ways to fix sour espresso"95.216.01.811.30.280.08
C: "SALE: 20% off everything this weekend only!!"94.813.00.96.90.510.18
Diagnosis

Deliverability

  • About 5% of every send bounces (410, 390 and 430). As a rough guide, anything above 2% suggests stale or unverified addresses. This hurts sender reputation.
  • Complaint rates of 0.12% and 0.18% on A and C are above the 0.1% that Gmail's sender guidance recommends staying under.

Subject line

  • Opens fell from 19.0% to 13.0% across the three sends. C's all-caps "SALE" and double exclamation marks look promotional and may route to the Promotions tab or spam.
  • A's product-news line drew the most opens but the weakest engagement after the open.

Content

  • B has the best CTOR at 11.3%. Readers click more on how-to content than on announcements.
  • C's CTOR of 6.9% and 0.51% unsubscribe rate suggest a store-wide discount without a featured product gave readers no clear reason to click.
Ranked test plan
  1. List cleanup. Remove hard bounces and subscribers with no opens or clicks in 6 months. Track delivered % and complaint % over the next 3 sends.
  2. Subject style. Split 50/50 between a how-to subject and a promo subject on the same email. Success metric: clicks per delivered. Run for 2 sends.
  3. One featured product in sales emails. Split 50/50 between a single hero product and a full catalog grid. Success metric: CTOR. Run for 2 sends.
  4. Remove caps and exclamation marks. Split 50/50 on the next promo. Success metric: complaint %. Run for 1 send.
  5. Send time. Split 50/50 between Tuesday 7am and Saturday 9am. Success metric: CTR. Run for 3 sends.
Quick fixes this week
  • Suppress the roughly 1,200 bounced addresses before the next send.
  • Move the unsubscribe link higher so annoyed readers leave instead of reporting spam.
  • Open every promo with one how-to tip, as in B, before the offer.

Data gaps: there is no split by inbox provider and no click data per link, so this is not a full deliverability or content audit.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Forcing every finding into deliverability, subject line or content stops the vague mix of tips you get from a plain request.
  • Requiring click-to-open and an Apple Mail caveat keeps the diagnosis from resting on inflated open counts.
  • Each test must name one variable, split, metric and run length, so the plan can be acted on the same day.

Use this after a few weak sends. Export stats for 3-10 campaigns from your email platform, including subject lines, and paste them into ChatGPT, Claude or Gemini right after the prompt.

Common edits

  • Add your platform name (Mailchimp, Klaviyo, Beehiiv) to get setup steps for each test.
  • Ask for a one-paragraph summary you can share with your manager or client.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Marketing