·use case / MCP / ChatGPT / AI agent / data connection

Give ChatGPT Your Store's Numbers, and It Answers for Your Store

Most people export channel revenue from GA4 and attach the Excel to ChatGPT, hoping for store-specific advice. But a raw GA4 export is bot-polluted and leaves AI-referral revenue unattributed — garbage in, garbage out. Connect your numbers to the AI instead, and it reads bot-excluded, AI-attributed, always-current data, changing the answer to the very same question. A use-case piece comparing the hand-made-Excel answer with the connected one.

Give ChatGPT Your Store's Numbers, and It Answers for Your Store

"Garbage in, garbage out" — we all know the line. What's harder to see is that the numbers you hand the AI might be the garbage.

"My online store — where should I focus next?" You know a bare question gets generic advice, so like most people you export your channel revenue from GA4 and attach the Excel. But a raw GA4 export is polluted: bots are 53% of web traffic, and AI-referral revenue hides under "unknown source," understated. The table you handed over as "your numbers" is actually dirty — and ChatGPT can't question it, so it answers, confidently, on dirty data. This article puts the same question to "ChatGPT with a hand-made Excel attached" and "ChatGPT with your numbers connected," and shows how the conclusion changes.

The Same Question, Before and After Connecting#

Just one question: "My online store — where should I focus next?" Like most people, you first attach your channel-revenue Excel and ask a plain ChatGPT.

① Plain ChatGPT

ChatGPTno data connected
You
📎 channels.xlsxHere's my store's revenue by channel. Which channel should I focus on next?
Thanks — I can see Google Search and Direct are your biggest revenue sources. I'd strengthen Google Search (SEO, branded) and dig into what's driving Direct (repeat, branded lookups). But to really judge, I'd also need revenue per visit (RPS), the bot-excluded figures, and how AI-referral revenue breaks down. Can you pull those?

Sounds reasonable. But — you rebuild this Excel by hand every week. And a raw GA4 export is polluted: bots are 53% of web traffic, and AI-referral revenue hides under "unknown source," understated. Garbage in, garbage out — ChatGPT can't question the table you handed it, so dirty numbers get a confident, wrong answer. And by next week it's already stale.

Put the same question to a ChatGPT reading connected numbers — clean (bots excluded, AI attributed) and always current — and the conclusion changes.

② ChatGPT connected to RevenueScope

RevenueScope MCP🔗 RevenueScope
You
My online store — which channel should I focus on next?
Over the last 90 days, your largest source of traffic is Google Search (814 sessions), but its revenue per visit (RPS) is just ¥304. Claude, meanwhile, has only 19 sessions yet an RPS of ¥2,336 — a different league. ChatGPT referrals: 210 sessions at RPS ¥622. So Google Search is your volume, but AI referrals are your efficiency. The next move: thicken the growing AI-referral traffic (GEO) while fixing your Google Search landing pages to lift conversion. Note: Claude's sample is small and swings on a single order, so treat it as something to keep watching.📊 RPS by channel · last 90 days📊 sample store · demo data

Same question. What differs is whether the numbers you handed it are a "dirty, stale, hand-made table" or "bot-excluded, AI-attributed, always-current data." That alone flips the answer from a conclusion by volume to a conclusion by efficiency. The weekly chore of rebuilding that Excel is covered in stop rebuilding your GA4 data in Excel.

What to Look at in This Answer#

Look where volume and efficiency disagree. Google Search wins on session count (volume), but on revenue per visit (RPS) the AI channels come out ahead — a twist you only see with clean numbers side by side.

And "clean" is the precondition. The Excel in ① had bots in it and AI referrals unattributed, so ChatGPT returned a volume-pulled conclusion ("Google Search is your pillar"). Only after excluding bots and attributing AI referrals does the efficiency picture appear. How bot contamination distorts channel judgment is in exclude bots to see the real numbers.

One more: don't take a low-volume channel at face value. Claude's RPS above is off the charts, but on just 19 sessions — a single order sends it flying, so keep watching rather than concluding. That the connected AI adds this caveat itself is proof it's reading real numbers.

RevenueScope — just connect it

None of the "after" required custom development. You connect your own traffic data to the AI you already use, read-only. From then on — no rebuilding an Excel every week, no hand-correcting bots or AI referrals — the AI answers on the latest, clean numbers anytime. The idea of starting from using before building is laid out in start using AI without building.

Let me draw the line honestly. What ChatGPT asked for in ① — RPS, the bot-excluded figures, and the AI-referral breakdown — is exactly what connecting RevenueScope hands over; that's what ② answered with. What it can pass is revenue, sessions, RPS, AOV, CVR (at site and channel level), the breakdowns by channel and page (revenue and traffic), and AI-referral revenue. What it does not pass is CAC, LTV, and gross margin — those belong to other tools. Passing only the numbers it can, correctly and always live, is the shortest path to answering "your store" without the garbage.

The sample store is open with no sign-up. First, see for yourself how an AI answers once it's reading clean numbers.

See which ads actually drive revenue, at a glance

Free up to 5,000 sessions/month, AI analyst included. No credit card required. Up and running in 5 minutes.

Ready to analyze yoursite.com

No credit card·Live in 5 minutes