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
If you look after several markets or brands, the dashboard shows you one filter at a time. That's fine for digging in, but for a quarterly review you want the whole picture on one page: every platform, every market, spend and ROI side by side, with totals. Building that by hand usually means a handful of exports and a pivot table nobody wants to maintain.
For Q3 2026, make one table with ad platforms as rows and our markets as columns. Show spend and ROI in each cell, add a total row and a total column, and comment on anything that stands out.
Now show Google Ads and Meta Ads by month for the same quarter. Is Meta's lead holding up?
We ran both prompts on our demo account, which has two markets, Germany and the US. All figures below are illustrative demo data in USD, for 2026-07-01 to 2026-09-30.
The assistant made three queries: one by platform and country for the cells, one by country for the total column, and one by platform for the total row. That way every total, including total ROI, comes from Sellforte's own calculation rather than being added up or averaged in the chat. Averaging ROIs across cells would give the wrong answer, since each cell has a different amount of spend behind it.
| Ad platform | DE spend | DE ROI | US spend | US ROI | Total spend | Total ROI |
|---|---|---|---|---|---|---|
| Google Ads | 880 699 | 4.93 | 388 238 | 4.43 | 1 268 937 | 4.77 |
| Meta Ads | 358 539 | 7.29 | 281 783 | 6.32 | 640 322 | 6.86 |
| Direct Mail | 502 857 | 4.19 | – | – | 502 857 | 4.19 |
| 325 462 | 1.46 | 100 242 | 1.46 | 425 705 | 1.46 | |
| TV | 291 240 | 1.09 | 129 191 | 1.86 | 420 431 | 1.32 |
| Adtraction | 106 716 | 2.28 | 46 955 | 2.19 | 153 671 | 2.26 |
| TikTok Ads | 68 490 | 4.39 | 36 636 | 4.35 | 105 126 | 4.38 |
| Criteo | 22 313 | 2.86 | 9 818 | 2.76 | 32 130 | 2.83 |
| Microsoft Advertising | 10 559 | 3.03 | 4 646 | 3.02 | 15 204 | 3.02 |
| Awin | 9 755 | 3.15 | 4 292 | 3.17 | 14 047 | 3.16 |
| 5 891 | 3.13 | – | – | 5 891 | 3.13 | |
| PriceRunner | 2 479 | 4.54 | 1 091 | 4.43 | 3 570 | 4.50 |
| Total | 2 584 999 | 4.08 | 1 002 892 | 4.20 | 3 587 891 | 4.11 |
Then it pointed out what's worth a second look:
The follow-up split Google Ads and Meta Ads by month. Google is steady: ROI of 4.73, 4.85 and 4.75 from July to September. Meta is still ahead, but it slipped from 7.61 in July to 6.55 in August and 6.53 in September, while its spend went up 25.4%, from 192 922 to 241 966.
A matrix like this is the fastest way to start a quarterly conversation, because it shows where the money is and where it works in one glance. It also invites the obvious next thought: "Meta returns more, so let's move budget there".
That's where you should slow down. A higher average ROI doesn't mean the next dollar earns more. Meta's monthly numbers already hint at it: as spend went up, ROI came down. Before shifting money between platforms, look at marginal return campaign by campaign, or run a scenario that moves part of the budget and see what it adds. The scorecard tells you where to look. It doesn't tell you where to move money.
Want this scorecard for your own markets? Book a demo. Already a customer? Here's how to connect Sellforte MCP to your LLM client. Check back soon, since new use cases land here regularly.