Weekly Kit newsletter performance digest to Slack
Every Monday at 8am, get last week's Kit sends ranked by click rate and posted to Slack, so you can stop digging through the dashboard.
Every Monday at 8am, post a Kit (ConvertKit) newsletter performance digest to a Slack channel so I can see how last week's sends actually landed. This is a deterministic pipeline (no reasoning required): list, fetch stats, format, post.
Trigger: cron, weekly on Monday at 8am (my local time zone).
Step 1: Call Kit's List Broadcasts and filter to broadcasts whose send time falls in the last 7 days (the current-week window). Also pull the prior 7-day window (days 8 through 14 ago) in the same call or a second call so we can compute a baseline. If no broadcasts were sent in the current window, skip to Step 4 and post a short 'no sends last week' note instead of an empty table.
Step 2: For each broadcast returned in the current window, call Kit's Get Broadcast Stats and collect: subject line, total recipients, open rate, click rate, and unsubscribes. Do the same for the prior-window broadcasts, but only keep their click rates so we can average them into a baseline.
Step 3: Compute the prior-week average click rate across all prior-window broadcasts. Then format the current-window broadcasts into a ranked table, sorted best-to-worst by click rate, with columns: subject, recipients, open rate, click rate, unsubscribes. Under each row (or as a trailing column) show a one-line delta vs. the prior-week baseline (for example: '+1.2 pts vs. last week's 3.4% avg' or '-0.8 pts vs. last week's 3.4% avg'). Format the table using Slack mrkdwn (backtick-wrapped code block is fine so columns align).
Step 4: Use Slack's Send a Message to post the digest to a channel I pick during setup. The message should have a short header line ('Kit newsletter digest — week of <date range>'), the ranked table, and a one-line footer with the total sends and total recipients across the week. Substitute the em dash in the header with an en dash or a colon if the platform prefers.
Integrations: convertkit (List Broadcasts, Get Broadcast Stats), slackbot (Send a Message). Prefer the slackbot integration over user-token Slack because this is an automated recurring post, not a message sent 'as me'.
Keep the pipeline strictly deterministic. No LLM step, no summarization, no editorializing. Just fetch, rank, format, post.
Additional information
What does this prompt do?
- Pulls every Kit (ConvertKit) broadcast you sent in the last seven days.
- Grabs open rate, click rate, unsubscribes, and total recipients for each one.
- Ranks them best to worst by click rate with subject lines and a one-line delta vs. the prior week's average.
- Posts the finished table to a Slack channel of your choice every Monday morning.
What do I need to use this?
- A Kit (formerly ConvertKit) account that sends broadcasts.
- A Slack workspace and the channel you want the digest posted in.
- Roughly five minutes to connect both accounts and pick a channel.
How can I customize it?
- Change the schedule to daily, biweekly, or any other cadence that fits your send rhythm.
- Point it at a different Slack channel, a private channel, or even a direct message to yourself.
- Tweak the lookback window or the ranking metric (open rate instead of click rate, for example).
Frequently asked questions
Does this work with the free Kit (ConvertKit) plan?
What if I did not send any newsletters last week?
Can I post it to a private Slack channel?
How is the 'delta vs. the previous week's average' calculated?
Will it double count broadcasts that went out over multiple days?
Related templates
Stop refreshing the Kit dashboard every Monday.
Get a ranked, plain-English recap of last week's newsletter performance the moment your week starts.