Category
AI
Last updated
July 2026
Related
Shopify integration

Stress test your store AI: five questions to evaluate your MCP setup

Five real operator questions, asked through your single-source MCPs and through the Polar MCP: two your store tools answer well, three that reach across channels, margin, and identity.

Quick refresher first. Claude is the assistant; MCP, the Model Context Protocol, is how it reads your tools. Shopify ships an MCP, Klaviyo ships one, Meta Ads and Google Ads connect through their own MCP servers, and Polar ships the official Polar MCP. Connect them in Claude and you can ask your stack questions in plain English.

So the fair question a $5M+ operator asks is: is that setup enough? The honest way to answer is not a pitch, it is a test. Ask the same five questions through your single-source MCPs and through Claude reading Polar, and watch exactly where each one runs out of data. Not because any of these tools is weak, but because the answer lives outside the data that tool holds.

Below is the test, run end to end on a ~$31M/yr DTC brand. Then how to run it on yours.

The worked example, on a ~$31M/yr brand

Same model brand as the rest of this series: ~$31M/yr DTC, Shopify plus Klaviyo plus Meta and Google, reconciled in Polar. Every question below was asked twice, once through the single-source MCPs and once through the Polar MCP. Here is the scorecard:

The read: your existing MCPs pass the first two questions, and for the store questions they are genuinely the right tool. The last three fail for a reason no assistant can fix from inside one tool: the inputs are not there. Net profit, blended ROAS, LTV by channel, and deduplicated reach all cross sources, and crossing sources on consistent definitions is exactly what the Polar MCP exists for.

One honest note on this example: the brand is a model built on illustrative synthetic data, because we do not publish client numbers. The boundary it maps is real: run the same five questions on your own stack and you will hit it at the same three places.

What you are building

A side-by-side stress test: five real operator questions, asked through your single-source MCPs and through Claude reading Polar's governed model, with the boundary made visible. The first two questions your store tools answer well. The last three reach across channels, margin, and identity, where a single-source setup hits the edge of its data and Polar keeps going. The output is an honest map of which job each tool is for.

What you need

  • Claude (Desktop or Cowork) with connectors enabled.
  • Your existing MCPs for the single-source side of the test: Shopify, Klaviyo, and your ad platforms through their own MCP servers.
  • Shopify connected to Polar (native connector), ad platforms, Klaviyo, and your finance sheet connected, and the Polar Pixel installed.
  • The Polar MCP connected to Claude, for the Polar side of the test.

Question 1: What were my top products by net profit last month?

Ask the Shopify MCP and you get a clean ranking by revenue in seconds. That part lives entirely in the store and works well. But net profit per product needs COGS, shipping, payment fees, returns, and the ad spend attributed to each product, and none of that is in Shopify.

On the model brand, the difference is the whole point: the revenue number one, Hydra Serum at $412K, ranks third by net profit at $87K, while Collagen Peptides at $301K of revenue is the real winner at $126K. Rank the reorder on revenue and you celebrate the wrong SKU.

Question 2: Which orders are unfulfilled, and why?

Both sides answer, and honestly the store MCP is the better tool here. Fulfillment status, locations, stock levels, and the fix all live inside Shopify, so ask there and act there. Credit where due: for in-store questions, the built-in path is right there and it is good. A stress test that pretends otherwise is not honest.

Question 3: What is my blended ROAS by channel?

Here the boundary appears. Blended ROAS needs Meta, Google, and TikTok spend next to Shopify revenue. That spend is not in Shopify, and each ad platform MCP only sees its own walled garden, so no single tool can do the division. You can ask Claude to stitch the MCPs together in the chat, but then it is inferring how numbers that were never designed to reconcile should join, and a subtly wrong join reads exactly like a right one.

On Polar the spend is unified and revenue is pixel-attributed on one governed model: Meta 2.4, Google 2.9, blended paid 2.6 on the model brand. One question, one number, same number every run.

Question 4: Which acquisition channel brings my highest-LTV customers?

This needs cross-channel attribution and full-history LTV, and neither lives in any single tool. Shopify knows orders, Klaviyo knows profiles, and each ad platform claims its own conversions; nobody holds the joined picture. Polar's pixel, identity resolution, and cohorts answer it directly: on the model brand, 90-day LTV runs $131 for organic and referral, $112 for Google, $86 for Meta. Meta buys volume, organic buys value. That is a budget-shaping fact you cannot see from inside one tool.

Question 5: How many unique recipients received a campaign in the last 90 days?

This sounds like a Klaviyo question, so ask the Klaviyo MCP. You get per-campaign recipient counts, which is what the tool exposes, and for a single campaign that is exactly right. But unique recipients over 90 days needs deduplication at the profile level across every campaign, and you cannot get there by summing what the API returns: on the model brand, 38 campaigns sent 3.1M emails to 214K unique profiles, so adding the per-campaign counts overstates reach 14 times over.

Polar answers with the deduplicated number, because the semantic layer computes at the grain the question actually asks, profiles, not sends.

What the test shows

The boundary is not quality, it is scope and architecture. Scope: each MCP sees its own tool, so questions 3 to 5 have no data to stand on, no matter how good the assistant reading it is. Architecture: tools that generate a query on the fly infer how tables join and can return a metric that is subtly wrong, while Polar answers only from metrics defined once in a governed semantic layer, deduplicated and attributed, so the answer is deterministic and the same every time.

Use the store MCP to run the store, and Klaviyo's to run email. Bring in Polar the moment the question reaches across the business.

Polar upgrade

One MCP that carries the whole business

Not optional for questions 3 to 5. The inputs live outside any single tool.

The exact thing Polar fixes: the last three questions all require data that lives outside any one tool, unified and defined once. Polar joins Shopify to 45+ sources on a governed model, so the cross-channel, attributed, margin questions become answerable, and answerable consistently.

The honest limitation without it: there is no way to answer them from one tool's data, because the inputs are not there. That is a boundary of the data, not a shortcoming of any assistant working inside it. And stitching MCPs in the chat does not close the gap: the AI infers how sources join, while the semantic layer defines each metric once, deduplicated and attributed, so the answer is deterministic.

Connect the Polar MCP and rerun the five questions:

Prompt
Answer the five stress test questions using the Polar MCP: top products by net profit last month, unfulfilled orders and why, blended ROAS by channel, highest-LTV acquisition channel, and unique campaign recipients over the last 90 days. For each answer, name the sources it crosses.

With Polar the last three stop being unanswerable, and every number comes from a metric defined once in the semantic layer, so the granular cuts, per SKU, per channel, per profile, stay consistent on every run.

Polar Analytics

Starter prompts to extend it

  • Ask blended ROAS, true CAC, and MER by channel, and note which of these a single-source MCP cannot reach.
  • Which acquisition channel brings my highest 90-day LTV customers, and which sources does the answer cross?
  • Compute true contribution margin after ad spend and returns for my top collection.
  • Rerun the cross-channel questions across Polar's attribution models and show how the answer shifts.

A few honest notes

  • Right tool for the store job. For in-store questions, orders, fulfillment, inventory, the store MCP is the best tool, and acting on the answer happens there. This test is about scope, not quality.
  • The last three questions are a boundary of the data, not of any assistant. No tool can compute with inputs it does not hold.
  • Read-side. Everything in this test reads. Polar does not write to Shopify or Klaviyo; you act in the tools themselves.