Weekly

Get last week's campaign numbers on Monday

A table of every campaign sent last week with sends, opens, clicks and unsubscribes.

Runs: Weekly
Apps: ActiveCampaign
AI: Not needed
Access: API key

Send this to your assistant

Create a ClickRuntime automation: every Monday at 9am, email me each ActiveCampaign campaign sent last week with sends, opens, clicks and unsubscribes.

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 marketers who send several ActiveCampaign campaigns a week often compare results one campaign at a time, clicking through the reports page. It takes time, the numbers are not side by side, and they are rarely shared with people who do not have a login. The founder asks how last week's newsletter did, and the answer is a screenshot taken Thursday. Without a regular report, wins and misses are only remembered, not measured.

Every week the automation finds the campaigns whose send date (sdate) falls in the last seven days, reads their counters for sends, opens and clicks, and emails a table. Each row is one campaign, so comparing subject lines, audiences and send times takes a glance.

It fits marketing teams that report upward on a weekly rhythm, and agencies that send a regular summary to clients.

What you get out of it

Results arrive without anyone assembling them
The table is ready each week, so nobody spends Monday morning copying numbers from ActiveCampaign into a spreadsheet. That time goes back to writing the next campaign, and the numbers in the table come straight from ActiveCampaign, so they are not retyped or rounded by hand.
Campaigns can be compared side by side
Seeing open and click counts in one table shows which subject lines and topics performed, so next week's campaign is written with evidence. When two campaigns went to the same audience on different days, the difference in clicks is visible immediately, and a pattern in what works emerges within a few weeks.
Stakeholders without logins stay informed
The report is an email. Executives and clients see results without needing access to ActiveCampaign. Board members, clients and sales leads can read it on a phone without a login or training, and forward it to anyone who needs the numbers.
Trends build up in your inbox
Weekly emails stack into a history. Looking back across a quarter shows whether engagement is rising or sliding. A forgotten month-end report is replaced by a reliable weekly record, so a decline in clicks is spotted in week three, not discovered in a quarterly review.
Weak sends are noticed early
A campaign with a low open count stands out. You can test a different subject or send time the next week instead of finding out at month end. That gives you a week, not a month, to correct course on subject lines, timing or audience.

How it works

What happens, step by step

Every Monday ClickRuntime looks up the ActiveCampaign campaigns sent in the last 7 days.
For each campaign it reads how many emails were sent, unique opens, unique clicks and unsubscribes.
You get one email with a table, one line per campaign. If nothing was sent, the email says so.

Before it runs live

Connect ActiveCampaign

What you get

RunsWeekly

Get last week's campaign numbers on Mondaytoday, 9:00Succeeded

Email · Campaigns last weekOctober product news sent 8,420 opens 3,105 clicks 612 unsubs 21

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 ActiveCampaign 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_report.pyexample

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

BASE = "https://acme.api-us1.com/api/3"

@on_trigger
def run(event):
    h = {"Api-Token": credentials.secret("ACTIVECAMPAIGN_API_KEY")}
    since = datetime.now(timezone.utc) - timedelta(days=7)
    campaigns = http.get(f"{BASE}/campaigns", params={"orders[sdate]": "DESC", "limit": 50}, headers=h).json()["campaigns"]
    sent = [c for c in campaigns if c.get("sdate") and datetime.fromisoformat(c["sdate"]) >= since]
    lines = [f"{c['name'][:30]:<30} sent {c['send_amt']:>6}  opens {c['uniqueopens']:>5}  "
             f"clicks {c['uniquelinkclicks']:>4}  unsubs {c['unsubscribes']:>3}" for c in sent]
    notify.email_me("ActiveCampaign campaigns last week", "\n".join(lines) or "No campaigns sent last week.")
    return {"campaigns": len(sent)}

FAQ

Common questions

Does it include revenue or only opens and clicks?

It reads the counters ActiveCampaign provides on each campaign, such as sends, opens, clicks and unsubscribes. Revenue attribution is not part of those counters, so it is not included in the table. For revenue, use ActiveCampaign's deal and e-commerce reports alongside this email.

What counts as last week's campaign?

Any campaign whose send date is within the past seven days at the time the report runs. A campaign sent eight days ago is not listed, so each campaign appears in exactly one weekly report.

Can the report go to my whole team?

Yes. The email can have several recipients, or it can be posted to Slack instead. Tell your AI assistant who should get it and you will see the updated delivery step before it goes live.

What permissions does it need?

API key. 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.

Weekly