Ask Sellforte MCP: Can I just get the campaign 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

Getting a clean campaign table without building a dashboard view

A flight has ended, the monthly report is due, and you need numbers for a specific set of campaigns and dates. Not a dashboard, not an analysis, just a table you can paste in. Campaign managers and agency contacts do this every week, and it's usually the bit of reporting that takes longest for the least insight.

What you ask

Make a table of campaigns containing "Prospecting" for 2026-10-01 to 2026-11-10 with spend, impressions, CPM, incremental sales, ROI and platform ROAS. No analysis, only the table.

Same campaigns, by ad platform, October against September. Only the table.

What Sellforte MCP does

Finds the campaigns first

Campaign names aren't something you'd want to type out in full, so the assistant matches the word "Prospecting" against the campaign list and shows what it found: six campaigns across Meta, TikTok and Pinterest, each running in Germany and the US. You can see exactly what's in scope before any numbers appear.

Clamps the dates and says so

The requested end date, 2026-11-10, is past the latest data on the demo account. Instead of quietly returning a shorter period, the assistant clamps the window to 2026-10-01 to 2026-11-01 and tells you. That's the kind of thing you want to know before the table goes into a report labelled "October to date".

Returns the table, and nothing else

Here's what comes back (illustrative demo data, USD):

You said no analysis, so you don't get any. You get the rows, the total and a one-line note on the date window.

Repeats it for a new cut

The follow-up asks for the same campaigns rolled up by platform, October (2026-10-01 to 2026-11-01) against September (illustrative demo data, USD):

Same deal: a table, the window, done. Pinterest shows a dash for September because those campaigns didn't spend that month, not because data is missing.

Why it matters

The time you save is nice, but the bigger win is which numbers end up in the report. Look at the Meta rows: the platform reports a ROAS of 18 to 22, while the model puts incremental ROI at 4.2 to 5.1. Pinterest reports no platform revenue at all here, yet the model still credits it with incremental sales. When both columns sit side by side, the platform figure stops being the headline and becomes a claim the model can check. That's a better conversation to have with your agency or your CFO.

And because the prompt is fixed (same name fragment, same metrics, "only the table"), it's easy to rerun every month. One practical tip: a table tops out at 100 rows, so if you ask for months times many campaigns, ask for fewer campaigns, a coarser period or one metric per table.

Try these follow-ups

• Same table for campaigns containing "Retargeting", with months as columns and a total column.
• Only the Meta Prospecting campaigns, week by week for October, spend and ROI only.
• Add GA4-attributed sales and ROI next to the MMM columns for the same campaigns.
• Drop every campaign that spent less than 2 000 and show the table again.

Related

• Sellforte MCP
• Sellforte dashboard
• Sellforte AI
• Use case: Can you fill our quarterly review deck?

Try it yourself

Tired of rebuilding the same table every month? Book a demo, or read how to connect Sellforte MCP to your LLM client. The launch post covers the rest.

More use cases are on their way to this library soon.