Back to resources

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 works

Questions

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.

Pricing

Priced by the clients you report on.

Compare plans
  • 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.