Weekly Constant Contact performance digest in Slack

Every Monday at 8am in my timezone, build a written digest of last week's Constant Contact email marketing performance and post it as a single message into a Slack channel I choose. Use an agent workflow so it can decide which campaigns are worth highlighting.

Trigger: cron, weekly on Mondays at 8am. The lookback window is the previous seven days ending at the trigger time.

Step 1. Pull the universe of campaigns. Call Constant Contact's List Email Campaigns to enumerate campaigns, and Get Email Campaign Summaries to pull the aggregate send, open, click, bounce, and unsubscribe stats. Keep only campaigns that were actually sent in the last seven days.

Step 2. Identify standouts. Rank the week's sends by open rate and by click-through rate. Pick the top three and bottom three subject lines on open rate, and the top three by click-through rate. For each winner and loser, drill into the underlying campaign activity using Get Campaign Activity Tracking Opens and Get Campaign Activity Tracking Clicks to confirm the totals, and Get Campaign Activity Tracking Opt-outs to see how many unsubscribed.

Step 3. Find the most-clicked links across the week. For each campaign activity in the window, call Get Campaign Activity Links to pull per-link click counts, then aggregate across campaigns and surface the top five links by total clicks.

Step 4. Write the digest in Slack mrkdwn so it renders cleanly. Keep it to one message. Structure it as: a one-line headline with the date range and number of sends; an overall block with send count, average open rate, average click-through rate, and total unsubscribes; a winners block listing the three best subject lines with their open rates; a losers block listing the three weakest subject lines and any sends that drove notable unsubscribes; a most-clicked-links block listing the top five links with their click counts and source campaign; and a short recommendations block of two to four bullets suggesting what to try next week based on what worked (subject line styles, send times, link placement).

Step 5. Post the message. Use Slack Bot's Send a Message to post into the channel the user selects at setup. The bot must already be a member of that channel, or have chat:write.public if it isn't.

Inputs to collect at setup: the Slack channel to post into, the timezone for the 8am schedule, and an optional override for the lookback window (default seven days).

Edge cases to handle gracefully: if there were zero sends in the window, post a short message saying so and skip the rankings; if a campaign has fewer than ten recipients, exclude it from the rate-based rankings so a tiny test send doesn't top the list; if Constant Contact rate-limits, back off and resume rather than crashing the digest.

Keep the message concise. Aim for something a marketer can read in under a minute, not a wall of numbers.