Weekly Snov.io campaign digest in Slack

Build me a weekly outbound performance digest for our Snov.io drip campaigns that posts into Slack.

Trigger: run on a cron schedule, every Monday at 8:00 AM America/New_York.

On each run, the agent should do the following:

1) Call Snov.io List Campaigns to get every drip campaign. Keep only campaigns whose status is active (skip paused, draft, finished, and archived campaigns).

2) For each active campaign, call Snov.io Get Campaign Analytics twice: once for the last 7 days (the current window) and once for the 7 days before that (the prior window). Pull sends, opens, replies, and clicks for each window, and compute open rate, reply rate, and click rate from those counts.

3) For each active campaign, call Snov.io Get Campaign Link Clicks for the last 7 days and aggregate clicks by destination URL so we can identify the most-engaged links per campaign and overall.

4) Rank the active campaigns by reply rate over the current 7-day window. Then flag any campaign that meets either condition: reply rate dropped more than 30 percent week over week, or open rate is below 15 percent in the current window. Brand-new campaigns with no prior-window data should be reported as-is and never flagged as a drop.

5) Write a short Slack post via Slack Send a Message to the channel the user specifies during setup. The message must be tight and use bullet points, not paragraphs. Use Slack mrkdwn (single asterisks for bold, not double). Structure the message as:

- A one-line headline, for example *Outbound weekly recap, week of <Mon Date>*.

- *Top performers*: the two campaigns with the highest reply rate this week, each as one bullet showing campaign name, reply rate, open rate, and sends.

- *Needs attention*: the single worst flagged campaign, with its current numbers and the week-over-week change.

- *Most-clicked link this week*: the destination URL with the highest click count and which campaign it came from.

- *Recommended tweak*: one concrete subject-line or call-to-action change the agent recommends based on the actual metrics (for example, if open rate is the weak spot, recommend a subject-line change; if open rate is fine but reply rate is low, recommend a CTA change).

- *What changed*: a single one-line note summarizing the biggest week-over-week movement across the account.

Keep the entire Slack post under roughly 15 lines. No paragraphs, no filler, no emoji walls. If there are zero active campaigns, post a single line saying there were no active Snov.io campaigns this week and stop.

Ask me at setup for: the Slack channel to post into, my open-rate floor (default 15 percent), my week-over-week drop threshold (default 30 percent), and whether the recommended tweak should focus on subject lines, opening lines, calls to action, or send time (default: let the agent pick based on the numbers).

Additional information

What does this prompt do?

Runs every Monday at 8am ET and pulls the last seven days of sends, opens, replies, and clicks from every active Snov.io drip campaign.
Ranks campaigns by reply rate and flags any that dropped more than 30 percent week over week or fell below a 15 percent open rate.
Posts a short, bullet-style Slack message highlighting the two top performers, the one campaign that needs attention, and the most-clicked links.
Recommends one concrete subject-line or call-to-action tweak based on what the numbers actually show.

What do I need to use this?

A Snov.io account on a paid plan with at least one active drip campaign.
A Slack workspace and the channel you want the digest posted to.
About two minutes to confirm the day, time, and channel during setup.

How can I customize it?

Change the day or time the digest runs (for example, Friday afternoon instead of Monday morning).
Swap the Slack channel, post to a private channel, or send it as a direct message to your sales lead.
Adjust the alert thresholds, like the 30 percent drop or the 15 percent open-rate floor, to match your own benchmarks.

Frequently asked questions

Does this cost Snov.io credits to run?

No. The campaign analytics, link click, and campaign list reads this uses are free Snov.io operations, so a weekly digest does not eat into your credit balance.

Can I get this for only a few specific campaigns?

Yes. During setup you can tell the agent to look at only campaigns whose names contain a keyword, or to skip any campaign that is paused or archived.

Will it post in a private Slack channel?

Yes, as long as the person who connects Slack is a member of that private channel. You can also send the digest as a direct message instead.

What if a campaign is brand new and has no prior week to compare to?

The agent will still report its current numbers and note that there is no prior week for a week-over-week comparison, so it will not be flagged as a drop.

Can I change the recommendation style, for example to focus only on subject lines?

Yes. Tell the agent during setup whether the recommended tweak should focus on subject lines, opening lines, calls to action, or send time, and it will stick to that.