wowprompt

Email Campaign Performance Report With Next Actions

Reads pasted email campaign metrics and returns a clear report on what worked, what failed and the tests to run next. Use it for monthly reporting, a post-Diwali campaign review or before planning the next quarter's sends.

An email performance report with a metrics table against benchmarks, a best and worst campaign comparison, diagnosis notes and a test plan
The output this prompt produced, unedited.

The prompt

Inputs

  • Campaign data: [paste a table with campaign name, send date, audience size, delivered, opens, clicks, conversions, revenue, unsubscribes, spam complaints]
  • Goal for the period: [for example revenue, sign-ups, event registrations]
  • Our usual results: [past averages, if known]

Task

Analyse the data and write a report a manager can act on. Work through this checklist.

Checklist

  1. Calculate delivery rate, click rate, click-to-open rate, conversion rate, unsubscribe rate and revenue per email sent for each campaign.
  2. Treat open rates with caution because privacy features inflate them; base conclusions on clicks and conversions.
  3. Compare each campaign with the period average and flag results 25 percent above or below.
  4. Pick the best and worst campaign and list what differed: audience, subject, timing, offer, length.
  5. Check list health: unsubscribe and complaint rates against safe limits.
  6. Note any data gaps or one-off events that distort the numbers.

Output format

  • Metrics table: | Campaign | Delivered | CTR | CTOR | Conversion | Revenue per send | Unsub rate | Flag |
  • Three key takeaways in one line each.
  • Best versus worst comparison table.
  • Test plan: | Test | Hypothesis | Metric | Sample needed |

Rules

  • Show the formula once for each calculated metric.
  • Do not claim a cause when only one send supports it; call it a hypothesis.
email marketing reportemail campaign analysisopen rate click rate analysisemail metricsnewsletter performance report

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity