Ask Sellforte MCP: Which markets missed their ROI target last week?
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 check of every market against its own target
If you run performance marketing across several markets, each one probably has its own efficiency target. Before the weekly review, you need to know who missed it last week, by how much, and why. Doing that by hand means pulling each market, lining it up against a target sheet, and then digging into channels for the ones that fell short.
What you ask
For last full week, show ROI and spend by country against our targets: Germany 3.8, US 3.6. Flag every market below target, show how far below it is, and explain the main reason compared with the week before.
Is Germany's miss new, or has it been below target for a while? Show the last eight weeks.
What Sellforte MCP does
We ran this on our demo account. Demo data runs to 2026-11-01 and weeks start on Sunday, so the last full week is 2026-10-25 to 2026-10-31, compared with 2026-10-18 to 2026-10-24. The targets are example values we typed into the prompt. All figures are illustrative demo data in USD.
Checks each market against its target
| Market | Spend | ROI last week | ROI week before | Target | Status |
|---|---|---|---|---|---|
| Germany | 149 765 | 3.60 | 3.56 | 3.8 | Below, by 0.20 |
| US | 72 951 | 3.84 | 3.87 | 3.6 | Above |
Sellforte doesn't store per-market targets, so the assistant only knows them because they're in the prompt. The ROI figures come from Sellforte. The gap to target is a simple subtraction of your number from Sellforte's, which is worth a quick glance before it goes into a slide.
Explains Germany's miss
Germany is slightly better than the week before, but still short. So the assistant split Germany by media group and compared the two weeks:
| Media group (DE) | Spend | ROI | ROI week before | Change in incr. sales |
|---|---|---|---|---|
| Cross-network | 56 020 | 4.73 | 4.13 | +25 882 |
| Paid Social | 34 866 | 4.47 | 4.96 | -14 743 |
| 27 395 | 1.04 | 1.09 | +3 134 | |
| Paid Search | 12 942 | 3.45 | 4.05 | -5 602 |
| Affiliates | 9 755 | 2.33 | 1.91 | +1 205 |
The picture is mixed. Cross-network got clearly more efficient and added 25 882 in incremental sales. That gain was mostly cancelled out by Paid Social and Paid Search, which both returned less on roughly the same spend. And Email, at an ROI of 1.04, took 18.34% more spend than the week before. Email is a big line in Germany, so it pulls the market average down whatever the paid channels do.
Puts it in context
The follow-up showed that Germany's weekly ROI has moved around a lot over the last eight weeks:
- 4.46 in the week of 2026-09-06
- 3.28, 3.32 and 3.22 over the next three weeks
- 4.09 and 4.47 in the two weeks from 2026-10-04
- 3.56 and 3.60 in the last two weeks
So this isn't a one-off. Germany has been below 3.8 in five of the last eight weeks. The US, meanwhile, was at 3.87 and 3.84 in the last two weeks, above its 3.6 target both times.
Why it matters
A weekly target check turns a long report into a short agenda: start with the market that missed, and with the two or three channels that explain it. Here that's Germany, Paid Social and Paid Search, plus a question about how much Email spend belongs in a paid-media efficiency target at all.
One thing to flag before anyone reacts: the most recent days of any week are still maturing. Some of the effect of last week's spend shows up in sales over the following days, so the latest week tends to look a little worse than it'll end up. Read a small miss like 0.20 with that in mind, and look at the trend rather than one week.
If your model has a margin-based KPI, you can run the same check on margin ROI. On our demo account, media ROI is sales-based.
Try these follow-ups
- Run the same check, but leave Email out of each market's ROI.
- Which Paid Social campaigns in Germany lost the most incremental sales last week?
- Show Germany's ROI against target for every week this quarter as a chart.
- Add a third market with a target of 4.0 and rerun the check.
- Which of last week's days are still likely to change as carryover comes in?
Related
- Sellforte Performance
- Marketing mix modeling
- Sellforte dashboard
- Ask Sellforte MCP: Where should we move budget mid-month?
Try it yourself
Want a Monday target check for your own markets? Book a demo, or if you're already on Sellforte, see how to connect Sellforte MCP to your LLM client. We keep adding new use cases to this library.
