Ask Sellforte MCP: Can I see every market and platform in one table?
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
One scorecard for every market and platform
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.
What you ask
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?
What Sellforte MCP does
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.
Pulls the cells and the totals separately
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.
Returns the matrix
| 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 |
Adds the comments
Then it pointed out what's worth a second look:
- Meta is the most efficient large platform in both markets, at 7.29 in Germany and 6.32 in the US, well above Google Ads.
- TV is the weakest large line, especially in Germany at 1.09. It does better in the US at 1.86, on less spend.
- Email returns 1.46 in both markets, which is low next to paid media, but it's an owned channel with a different cost logic.
- Direct Mail and Print only run in Germany, so the US column is empty for them rather than zero.
- The two markets land almost level overall, 4.08 versus 4.20, even though Germany carries most of the spend.
Checks whether the lead holds month by month
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.
Why it matters
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.
Try these follow-ups
- Same matrix, but with media groups as rows instead of ad platforms.
- Add a column for the same quarter last year, with the change in ROI.
- Which Meta campaigns have the highest marginal return right now?
- Show the matrix with months as columns, Germany only.
- Leave out Email and show paid media only, with the totals recalculated.
Related
Try it yourself
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.
