Weekly Mailjet campaign report in Slack and Google Sheets

Every Monday at 8am, build a written performance report on the Mailjet email campaigns we sent in the past seven days and share it with the marketing team.

Start in Mailjet. Use "List and retrieve sent campaigns" to find every campaign sent in the last seven days. Then pull the same list for the seven days before that, so you have a prior week baseline to compare against.

For each campaign in both windows, use "Get aggregated statistics counters" to collect delivered, open, click, bounce and unsubscribe numbers. Then use "Get link-click statistics" on this week's campaigns to see which individual links actually earned the clicks.

Write the analysis. Compare this week against the prior week and always express changes as week over week percentages rather than raw counts alone, since a raw count with no baseline tells the team nothing. Call out the best performing campaign and the worst performing campaign, and for each give a plausible reason grounded in what you can actually see in the data, such as the subject line, the send day or time, the audience size, or where the links sat in the email. Name the two or three links that drove the most engagement.

Post the write-up to our marketing Slack channel using "Send a Message". Keep it short enough to read without expanding the message: the headline numbers with their week over week percentage changes, the best and worst campaign with one line of reasoning each, and the top links. Detail belongs in the spreadsheet, not in Slack.

Then append one row per campaign to our Google Sheets tracking tab using "Append Values". Each row should carry the send date, the campaign name or subject, delivered, opens, clicks, bounces and unsubscribes, plus the derived open and click rates. This log is the durable value here: it lets us trend performance over months and it outlives Mailjet's own reporting window. Keep the column order stable from week to week, and always append rather than overwrite.

If no campaigns were sent in the past seven days, say so plainly in Slack and skip the spreadsheet append rather than posting an empty report.