Use casesReporting

See how each newsletter did against your own average

Mitra reports how your last newsletter did against your own average. Every Wednesday at 10am the agent reads the send from Mailchimp and adds its numbers to your sheet. The comparison goes to Slack with the subject line beside it.

Runs: Wednesdays at 10am
Used by: Marketers

The prompt

Every Wednesday at 10am, add last week's Mailchimp numbers to my 'Newsletter log' sheet. Post to #marketing in Slack how the send compares to my average.

Mailchimp

Google Sheets

Slack

Build this agent

200 credits to start · no credit card

What the agent actually does.

Read the last send
The agent opens Mailchimp and takes the recipients, opens, clicks, unsubscribes and subject line.
Add it to the log
One row goes into your 'Newsletter log' sheet, in the columns you already use.
Work out your average
The agent averages the rows already in the sheet, so the send is measured against your own list rather than an industry benchmark.
Post the comparison
Opens, clicks and unsubscribes go to #marketing, each with a direction against the average.
Leave a record
Every number read and every row written is recorded, so you can check where a figure came from.

Make it yours.

For the marketer who sees the numbers for one send, with nothing beside them to say whether it went well. Change any of this by saying so — there is nothing to rewire.

Break clicks down by link, to see which section pulled.
Post only when a number moves more than 10% from the average.
Email the summary to the founder instead of posting it in Slack.

Questions, answered.

How do I compare a newsletter to my past sends?

Mitra keeps every send in one sheet, then measures the newest one against the rows already there. The agent averages your own history rather than an industry benchmark, so a 32% open rate reads as up or down for your list. Mitra posts that comparison to Slack.

Can Mitra tell me which subject line worked?

Yes. Mitra reads the subject line with the numbers for each send and prints it beside the open rate in the Slack post. Because every send is logged in the same sheet, the subject lines that beat your average stay visible instead of being forgotten.