Ask Sellforte MCP: Can I get our campaign report every Monday?
Welcome to the Sellforte MCP Use Case Library. Each post takes one question that marketing teams really ask their AI assistant through Sellforte MCP, which is now in general availability and accessible to all marketers worldwide. It strips out anything customer-specific and walks through what the assistant does with it, step by step. We run every question on our demo account so the numbers you see are illustrative, not anyone's real results. The idea is simple: steal the prompts, try them on your own model, and see what you get back. We hope you find this series inspiring!
-Juha, CEO at Sellforte
A Monday campaign report that's ready before the weekly meeting
If you own campaign spend, Monday morning probably starts the same way: open the dashboards, export last week, paste it into a sheet, and write two lines on what changed before the weekly review. The question here is simple. Can the assistant just have it waiting for you?
What you ask
Give me a performance report per campaign every Monday morning, covering the previous full week. Rank campaigns by spend and highlight the top 5.
Also show which campaigns changed most compared with the week before.
What Sellforte MCP does
Picks the right week
The demo account's weeks run Sunday to Saturday, and its data ends on 2026-11-01. So the last full week is 2026-10-25 to 2026-10-31, and the assistant compares it with 2026-10-18 to 2026-10-24. It states both windows at the top of the report, so nobody reads it as "the last seven days".
Pulls every campaign, then summarizes
It queries spend, incremental sales and ROI from the marketing mix model for every campaign in both weeks. There are 52 campaign rows, more than a quick summary can show, so it asks for all of them first and only then picks the top ones. It doesn't summarize from a partial slice.
The headline for the week: spend of 222 717 (+2.58%), incremental sales of 818 238 (+3.05%) and an ROI of 3.67, almost the same as the week before (3.66).
| Top 5 campaigns by spend, 2026-10-25 to 2026-10-31 (illustrative demo data, USD) | Spend | Incremental sales | ROI | ROI week before |
|---|---|---|---|---|
| Google Performance Max, DE | 56 020 | 264 948 | 4.73 | 4.13 |
| Email, DE | 27 395 | 28 415 | 1.04 | 1.09 |
| Google Performance Max, USA | 24 649 | 107 977 | 4.38 | 3.81 |
| Adtraction, DE | 8 975 | 18 876 | 2.10 | 2.21 |
| Meta Advantage+, USA | 8 791 | 41 142 | 4.68 | 5.09 |
Both Performance Max campaigns spent about 3% less and still brought in more incremental sales, so their ROI went up. Email in Germany is the second-biggest line by spend but returns about 1 dollar per dollar, which is worth a comment in the meeting.
Flags the movers
Ranking by spend hides the biggest changes, which is why the follow-up matters. Sorting by week-on-week change, the assistant picks out:
- Performance Max Brand, US: spend up from 1 813 to 7 446 (+310.81%), incremental sales up 21 629, ROI up from 2.82 to 3.59.
- Meta Sales, DE: spend down 24.41%, incremental sales down 10 542, while ROI rose from 6.92 to 7.87. It's still the most efficient big campaign on the list, so the cut is worth a second look.
- Meta Prospecting, DE: spend up 48.12%, ROI down from 4.37 to 3.36.
- Stopped campaigns: Google YouTube, Meta Awareness and TikTok Awareness had spend the week before and none this week, in both markets. The assistant lists them as stopped, not as zero performers.
Turns it into a weekly routine
The scheduling part happens on the assistant's side, not in Sellforte. In Sellforte's own AI, you can set this up as a scheduled briefing. With your own assistant connected through Sellforte MCP, you schedule the prompt there. In this demo run we only ran the report itself. A routine that holds up well usually starts each run by checking the data is in for the whole week, and says so when the last day is missing, instead of quietly reporting six days as a week.
Why it matters
A weekly report built on incremental sales shows what media actually added last week, not what each platform claims. That's a better basis for the Monday conversation than a pile of platform exports, and it's ready before the meeting starts.
One thing to keep in mind: the most recent days in any model are still settling. If your team acts on last week's numbers, agree on a "mature" window, for example judging a week only once the following week's data is in, so nobody overreacts to a dip that fills in later.
Try these follow-ups
- Add GA4 attributed sales and platform ROAS next to the MMM figures for the top 10 campaigns.
- Rank by incremental sales instead of spend, and show a six-week trend for the top 3.
- Which of last week's top campaigns have a bid or budget recommendation right now?
- Split last week's incremental sales by country and flag any market below an ROI of 3.5.
Related
- Sellforte MCP
- Sellforte dashboard
- Sellforte AI
- Ask Sellforte MCP: What should our agency change this week?
Try it yourself
Want your own Monday report? Book a demo, or see how to connect Sellforte MCP to your LLM client. New use cases show up in this library regularly.
