Weekly Constant Contact Email Report in Slack | Free Template

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.

Additional information

What does this prompt do?

Pulls every Constant Contact campaign that went out in the last seven days and gathers send, open, click, and unsubscribe totals.
Calls out the three best subject lines and the three worst, plus the links that earned the most clicks across the week.
Writes a short, plain-language summary with rates, winners and losers, and a few recommendations for next week's sends.
Posts the whole digest as a single Slack message in the channel you choose, every Monday at 8am in your timezone.

What do I need to use this?

A Constant Contact account with permission to read campaign reports.
A Slack workspace where the Geni bot can post to the channel you want the digest in.
The name of the channel you want the report dropped into.

How can I customize it?

Change the schedule. Monday at 8am is the default, but swap it for Friday afternoons, daily, or every other week if that suits your team better.
Pick a different channel. Send the digest into a marketing standup channel, a leadership channel, or a private channel for the email team.
Tune the lookback window or the focus. Stretch to a 14-day rolling view, narrow to a single segment, or ask for more recommendations and fewer raw numbers.

Frequently asked questions

Do I need a paid Constant Contact plan to use this?

Any Constant Contact plan that lets you see campaign reports in the dashboard will work. The digest only reads the same numbers you already see when you open a campaign report.

Will the message be posted by a person or by a bot?

It posts as the Geni Slack bot, so the message is clearly automated and does not depend on any one teammate being around. You pick the channel during setup.

What if I did not send any campaigns last week?

The digest still runs, but it tells you there were no sends in the window and skips the rates and rankings. You can turn the schedule off any week you do not want it.

Can I get this on a day other than Monday?

Yes. The schedule is a knob you can change at any time. Friday wrap-ups and mid-week check-ins are both common.

Will it include unsubscribes and bounces, or only opens and clicks?

Unsubscribe counts are included in the digest by default. You can ask the workflow to call out bounces too if you want a full deliverability picture.