Weekly

Get a Monday summary of last week's email results

Every Monday I see opens and clicks for each email sent the week before.

Runs: Weekly
Apps: Constant Contact
AI: Not needed
Access: campaign_data

Send this to your assistant

Create a ClickRuntime automation: every Monday at 9am, email me the opens and clicks for each Constant Contact email sent in the past 7 days.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

Email performance data is only useful when someone looks at it. A campaign goes out on Wednesday, opens and clicks trickle in over the next few days, and by the time anyone remembers to check the report the next campaign is already drafted using the same instincts as before. Learning from results never gets built into the routine.

Each week, this lists your Constant Contact email campaigns, fetches the summary reports for those sent last week, and emails you the open and click rates for each. You get last week's results in one place without opening the reports one at a time.

It suits small marketing teams and solo operators who run a few campaigns per week and want a regular habit of reviewing them. Each figure comes from the summary report that Constant Contact keeps for the campaign, so the numbers match what you would read there, only gathered into a single email.

What you get out of it

Learn from every send
Seeing open and click rates for each campaign side by side shows which subject lines and offers worked. Next week's email can build on the evidence. Side-by-side open and click rates show which subject lines and offers worked, and next week's email can build on what you learn.
Spot weak campaigns quickly
A campaign with half the usual open rate stands out in the summary. You can investigate subject line, timing or list choice before repeating the mistake. A campaign with half the usual open rate stands out, and you can examine timing, subject line or list before repeating it.
Give stakeholders a simple recap
The summary can be forwarded to a boss or client as is. They get the numbers without needing a Constant Contact login or a lesson in reading reports. The email can be forwarded to a boss or client as it is, so they get the numbers without needing an account.
Build a rhythm of regular review
A fixed weekly email makes reviewing results a habit. Teams that review consistently tend to improve their campaigns steadily over several months. A fixed weekly email turns reviewing results into a habit, and teams that review consistently tend to improve steadily.
Compare campaign types fairly
When newsletters, promotions and announcements arrive in the same table, differences are visible. You can see which kind earns the most engagement for your audience. Newsletters, promotions and announcements in one table make differences visible, so you see which kind earns the most engagement.

How it works

What happens, step by step

Once a week, ClickRuntime gets your email campaigns and their results from Constant Contact.
It keeps only the emails sent in the last 7 days and matches each result to its campaign name.
You get one email with the unique opens and clicks for each campaign. If nothing was sent, the email says so.

Before it runs live

Connect Constant Contact

What you get

RunsWeekly

Get a Monday summary of last week's email resultstoday, 9:00Succeeded

Email · Weekly email resultsFall newsletter: 842 opens, 97 clicks Webinar invite: 410 opens, 63 clicks

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Run it at a different time, more or less often, or only on weekdays
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other Constant Contact steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

weekly_campaign_summary.pyexample

from datetime import datetime, timedelta, timezone
from clickruntime import on_trigger, credentials, notify, http

API = "https://api.cc.email/v3"

@on_trigger
def run(event):
    headers = {"Authorization": f"Bearer {credentials.connection('constant-contact', 'work')}"}
    names = {c["campaign_id"]: c["name"] for c in http.get(f"{API}/emails", headers=headers,
                                                           params={"limit": 500}).json()["campaigns"]}
    cutoff = (datetime.now(timezone.utc) - timedelta(days=7)).isoformat()
    summaries = http.get(f"{API}/reports/summary_reports/email_campaign_summaries",
                         headers=headers, params={"limit": 50}).json()["bulk_email_campaign_summaries"]
    lines = [f"{names.get(s['campaign_id'], s['campaign_id'])}: {s['unique_counts']['opens']} opens, "
             f"{s['unique_counts']['clicks']} clicks"
             for s in summaries if s.get("last_sent_date", "") >= cutoff]
    notify.email_me("Constant Contact emails, last 7 days", "\n".join(lines) or "No emails sent in the last 7 days.")
    return {"emails": len(lines)}

FAQ

Common questions

Which campaigns are included?

Campaigns that were sent during the previous week. Drafts and scheduled campaigns not yet sent are left out, so each email covers completed sends only. Only campaigns sent during the previous week are included, and drafts or scheduled campaigns are left out until they have gone out.

Are late opens counted?

The report reflects Constant Contact's totals at the time it runs. Opens and clicks arriving after the weekly email will not appear, though they do show in Constant Contact later. The figures reflect Constant Contact's totals when the report runs, so later opens and clicks only appear in Constant Contact itself.

Can it include bounce and unsubscribe rates?

Yes, if Constant Contact's summary report provides them for the campaign. Tell your AI assistant to add those columns and approve the updated layout before the next email. Bounce and unsubscribe rates can be added when the summary report provides them, and you can review it in the chat.

What permissions does it need?

campaign_data. Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run each time it runs (weekly). Checks that find nothing to do and stop right away aren't counted.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Daily