Skip to content

Weekly

Get last week's MailerLite results every Monday

A Monday email shows opens, clicks and unsubscribes for each campaign sent last week.

Runs
Weekly
Apps
MailerLite
AI
Not needed
Access
read

Send this to your assistant

Create a ClickRuntime automation: every Monday at 8am, email me the opens, clicks and unsubscribes for each MailerLite campaign sent in the past 7 days.

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

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

Why use it

Why teams use this automation

Every Friday a small online shop owner promises themselves to look at how the week's MailerLite campaigns did. By Friday afternoon there are customer emails to answer and orders to pack, and the report stays unopened. Two months on, nobody can say whether the new subject-line style helped, whether the Tuesday send time beats Thursday or whether unsubscribes have been climbing.

On a weekly schedule, ClickRuntime lists the campaigns you sent, keeps those from the past week, pulls open, click and unsubscribe figures for each, formats them into a readable summary and emails it to you. Drafts and campaigns that have not been sent yet are skipped.

It works especially well for solo operators and small agencies who want a standing report without logging into MailerLite or building their own sheet.

What you get out of it

  • The numbers reach you without a reminder

    Habits fail when a task depends on memory. A scheduled email arrives whether or not the week was calm, so you always have the data in front of you when you plan the next send.

  • Small shifts are visible over weeks

    An open rate that falls from 42 to 36 percent over two months is easy to miss when you only look occasionally. Weekly emails stack up into a record where gradual declines are plain to see.

  • Better decisions on timing and subject lines

    With results from each send arriving in one message, you can compare what you tried on which day. Over a quarter that is real evidence for choosing a send time instead of guessing.

  • Easy to share with partners or clients

    The summary is already written in email form, so forwarding it to a business partner or a client takes seconds. They get proof that the newsletter is doing its job.

  • Unsubscribe trouble is noticed sooner

    If one campaign triggers a spike in unsubscribes, you see it the following week at the latest. That is time to adjust topic or frequency before the damage spreads across the list.

How it works

What happens, step by step

  1. Once a week, ClickRuntime gets your sent campaigns from MailerLite.

  2. It keeps only the campaigns that finished sending in the last 7 days.

  3. You get one email with the opens, clicks and unsubscribes for each campaign. If none were sent, the email says so.

Before it runs live

  • Connect MailerLite

What you get

RunsWeekly
Get last week's MailerLite results every Mondaytoday, 9:00Succeeded
Email · Weekly campaign statsOctober product update: 1,204 opens, 188 clicks, 9 unsubscribes

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 MailerLite 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_stats_email.pyexample
from datetime import datetime, timedelta, timezone
from clickruntime import on_trigger, credentials, notify, http

@on_trigger
def run(event):
    resp = http.get("https://connect.mailerlite.com/api/campaigns",
                    headers={"Authorization": f"Bearer {credentials.secret('MAILERLITE_API_KEY')}"},
                    params={"filter[status]": "sent", "limit": 100})
    resp.raise_for_status()
    cutoff = (datetime.now(timezone.utc) - timedelta(days=7)).strftime("%Y-%m-%d")
    lines = []
    for c in resp.json()["data"]:
        if (c.get("finished_at") or "") < cutoff:
            continue
        s = c["stats"]
        lines.append(f"{c['name']}: {s['opens_count']} opens, {s['clicks_count']} clicks, "
                     f"{s['unsubscribes_count']} unsubscribes")
    notify.email_me("MailerLite campaigns, last 7 days", "\n".join(lines) or "No campaigns sent in the last 7 days.")
    return {"campaigns": len(lines)}

FAQ

Common questions

Which date range does the weekly email cover?
It includes sent campaigns from the past seven days, filtered on the send date MailerLite reports. If you want a different window, such as the last 14 days or the calendar month, that can be set up instead.
What if I did not send any campaign last week?
The email will show that no campaigns went out in the period, so you still get a message confirming the run and a nudge to schedule something. Nothing is invented, and the dashboard log shows the run completed.
Are automation emails included, or only regular campaigns?
The summary is built from the campaigns MailerLite lists as sent. Automated workflow emails are reported separately by MailerLite and are not part of this list unless you ask for them to be added. Say so when you set it up.
What permissions does it need?
read. 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.

Set up “Get last week's MailerLite results every Monday” from your assistant

Copy the prompt above, or connect your assistant first. Free plan, no credit card.