Resources
What MCP changes about asking AI for marketing numbers.
It gives an assistant a way in to each tool. It does not give it a way to compare them.
- 6 minute read
- 5 sections
Part 1
What the protocol actually does
MCP is a common interface between an assistant and a tool that holds data. Before a standard existed, every pairing of one assistant with one platform was built by hand, which meant the number of integrations to maintain grew with the number of pairs.
A tool now publishes a server that describes what it can be asked for, and any assistant that speaks the protocol can ask. That is the whole of it. It standardises the call, not the answer, and understanding that distinction is what keeps expectations in the right place.
Part 2
The half it genuinely solves
Access, which used to be the expensive part. Three things get easier and they are worth having.
One way in per tool
Connecting an assistant to a platform stops being a bespoke project. The work moves to whoever publishes the server, which is usually the platform rather than you.
A described surface
The server states what it can be asked for. The assistant stops guessing at parameter names and field names, which is where a lot of the wrong answers used to come from.
Permission in one place
Access is granted per server rather than per script, so read-only is something you can actually enforce and later revoke.
Part 3
The half it does not solve
Every server answers about its own tool, in its own vocabulary. Ask what a client spent across all channels last month and the assistant makes one call per platform, gets back several differently shaped results, and adds them up inside its own context.
That is a join, performed by a language model, at the moment of asking. There is no key, no check that the two sides share a grain, and no currency conversion unless the model decides to do one. It will return a number, and the number will look exactly like a correct one.
There is a second cost that shows up later. Every question re-reads the platforms, so nothing is kept. Ask the same question twice a fortnight apart and you cannot tell whether the answer changed because performance changed or because a platform restated a closed day.
Part 4
When per-tool access is enough
When the question lives inside one tool. What is the status of this campaign, which ad sets are not delivering, what is in this account. These are lookups against a single source, the vocabulary problem never arises, and going through a warehouse to answer them would be a detour.
The line is the second source. As soon as a question needs two platforms compared, or this period set against the same period last year, the assistant needs somewhere the two already agree. Reconciling them in the moment is the thing that cannot be made reliable by a better model.
For an agency there is a further case past that line. A question across clients, such as which accounts underspent this month, is a join across every client's accounts, and no single server holds it.
In practice
Where SightShark fits
Every source lands modelled in a warehouse you own: one name per metric, one type, one grain and one currency. The reconciling happens in SQL, before anybody asks a question, rather than in a model's context afterwards.
The chatbot reads those same tables on your own model key, and so do the client dashboards, so the two cannot disagree. Because the tables are added to rather than replaced, a comparison with last quarter is a query against history you hold rather than a fresh call to a platform that may have revised it.
See how the platform worksQuestions
Questions people ask
What is MCP?
A common interface between an AI assistant and a tool that holds data. The tool publishes a server describing what it can be asked for, and any assistant that speaks the protocol can ask, which removes the need to build every assistant and platform pairing by hand. It standardises how the call is made, not how the answer is shaped.
Can AI answer marketing questions without a data warehouse?
For questions that live inside a single platform, yes, and connecting directly is the shorter path. For a question spanning two platforms, the assistant has to reconcile differently named metrics at different grains in its own context while answering, with no key to join on and no currency conversion. It will produce a number either way, which is the risk.
Does MCP replace a data pipeline?
No. It replaces the integration work of connecting an assistant to each tool, which is the access problem. A pipeline exists to make sources comparable and to keep history, and neither of those happens by giving something read access to each platform separately.
Also worth reading
- 6 min read
What a semantic layer is, and whether you need one.
One definition, read by every tool that asks, for every client. Worth the service at a certain size, overhead below it.
Read it - 7 min read
How to report a client's visibility inside AI answers.
Most of it never becomes a visit. What is left is a sample, and a sample is only worth reporting if it has a method.
Read it - 6 min read
How to set up alerts across client accounts, and keep them worth reading.
An alert that fires every day becomes a filter rule. Four things are worth interrupting somebody for.
Read it
Pricing
Priced by the clients you report on.
Starter
$499 /month
Up to 20 clients
Growth
$999 /month
Up to 50 clients
Enterprise
Custom
No cap on clients
Get started
Want this running on your own data?
Book a call with someone who can answer the technical questions.