The Scenario
You are the email marketing manager at a media company. The monthly marketing review is Thursday. Your director wants an Excel workbook showing every campaign sent in the past 60 days — name, send date, open rate, click rate, and unsubscribe count — ready for the deck.
You have forty-three campaigns in MailerLite from the past two months.
The bad version:
- You open MailerLite and go to Campaigns
- You click into the first campaign, find the stats tab, note down the numbers
- You switch to Excel, find the right row, paste them in
- You go back to MailerLite, click into the second campaign
- You do this forty-three times
- You transpose a number on campaign 31 and spend ten minutes at the review explaining why open rates went negative
- Your director stops trusting the data and asks for the raw CSV next time anyway.
The fast version is one prompt and the workbook populates itself.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads campaign data from MailerLite and writes it into the workbook so you never click through individual campaigns.
Open the SheetXAI sidebar and type:
List all sent MailerLite campaigns from the past 60 days and write campaign name, send date, sent count, open rate, click rate, and unsubscribe count into this workbook — one row per campaign, newest first.
SheetXAI calls the MailerLite campaigns API, retrieves all 43 campaigns, and writes them into the workbook. Every number comes directly from the API.
What You Get
A populated workbook ready for the monthly review:
- Campaign name — exactly as named in MailerLite
- Send date — formatted as a date, not a timestamp
- Sent count, open rate, click rate, unsubscribe count — one row per campaign
- Newest campaign first — so the most recent performance is at the top
No manual entry. No transposition errors. If the director wants to sort by click rate, the data is already there.
What If the Data Is Not Quite Ready
Campaign datasets rarely arrive in the format a review needs. SheetXAI handles reformatting and analysis in the same prompt.
When the date format needs to match your existing dashboard
Your ops workbook uses MM/DD/YYYY and MailerLite returns ISO dates.
Fetch all sent MailerLite campaigns from the past 60 days and write them into this workbook with the send date formatted as MM/DD/YYYY in column B. Use campaign name, sent count, open rate, click rate, and unsubscribe count in columns A and C–F.
When you only want campaigns above a certain send volume
The review focuses on campaigns with more than 1,000 recipients.
List all sent MailerLite campaigns from the past 60 days with a sent count above 1,000. Write campaign name, send date, open rate, click rate, and unsubscribe count into this workbook — one row per campaign.
When you need a summary row at the bottom
The director wants totals and averages across the period.
Fetch all sent MailerLite campaigns from the past 60 days and write them into this workbook. Then add a summary row at the bottom showing total sent count, average open rate, average click rate, and total unsubscribes across the period.
When you want bounce counts added and a performance flag column
The full audit needs bounce data and a quick visual flag for underperforming campaigns.
Fetch all sent MailerLite campaigns from the past 90 days. Write campaign name, send date, opens, unique opens, clicks, unsubscribes, and bounce count into this workbook — one row per campaign. Then add a column that says 'Review' if open rate is below 20% or unsubscribes exceed 50, and 'OK' otherwise.
The pattern: describe the shape of the output you need, not just the fetch. SheetXAI formats and annotates in the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull your MailerLite campaign stats for whatever date range you need. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to pull a MailerLite account health snapshot into Excel or the MailerLite in Excel overview.