Automated Campaign Monitor Results Export
Every Monday, WebRun opens Campaign Monitor, reads the opens, clicks, bounces, and unsubscribes for every campaign sent in the last seven days, writes one row per campaign into an Airtable results table, and publishes a short Notion readout comparing this week against your running average.
How do I track Campaign Monitor results in a spreadsheet every week?
WebRun opens Campaign Monitor every Monday and reads the opens, clicks, bounces, and unsubscribes from every campaign you sent in the last seven days. It logs one row per campaign in Airtable and writes a Notion readout against your running average, so email performance is tracked without a manual export.
- Every send is logged in Airtable without a manual export
- Open and click rates are compared to your running average each week
- Bounce and unsubscribe spikes get flagged the Monday after they happen
Built for email marketers · marketing managers · agencies · ecommerce marketing teams
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.campaignmonitor.comin a real browser with your saved login - no setup, no API keys. -
1
Campaign Monitor - read last week's campaign results
campaignmonitor.com
WebRun opens Campaign Monitor to read last week's campaign results. - Sign in to Campaign Monitor and open your sent campaigns
- Select every campaign sent in the last seven days
- Capture the subject line, list, send date, recipients, opens, clicks, bounces, and unsubscribes
- Note the segment or list each campaign went to
Done when Every campaign sent last week has its full result set captured.
-
2
Airtable - log one row per campaign
airtable.com
WebRun opens Airtable to log one row per campaign. - Open your campaign results table in Airtable
- Add one row per campaign with subject, list, send date, and every metric
- Skip campaigns already logged from a previous run so nothing is duplicated
- Keep the historical rows so month-on-month trends stay available
Done when Airtable holds one clean row for every campaign sent last week.
-
3
Notion - write the performance readout
notion.so
WebRun opens Notion to write the performance readout. - Create this week's marketing readout page in Notion
- Show open rate, click rate, and unsubscribe rate against your running average
- Name the best and worst performing subject lines of the week
- Flag any campaign whose bounce or unsubscribe rate ran above your normal range
Done when The weekly readout is published in Notion with the comparison to your average.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it send or schedule campaigns?
No. WebRun only reads results from campaigns you already sent. It never sends, schedules, edits, or deletes a campaign in Campaign Monitor, and it never touches your subscriber lists.
Where does the data end up?
In your own Airtable base and your own Notion workspace. One Airtable row per campaign with every metric, plus a Notion page summarising the week. Nothing is stored anywhere else.
What if a campaign was already logged?
It checks the Airtable table before writing, so a campaign that appeared in a previous run is skipped rather than duplicated. Late-arriving open and click data updates the existing row.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.