November 12, 2026

How to Build an Amazon Sales Dashboard in Claude Data, Step by Step

Build an Amazon sales dashboard in Claude Data: connect the data, write the prompt, check each query, set the refresh cadence and share it safely.

An Amazon sales dashboard usually means one of two things. Either the Sales Dashboard inside Seller Central, which shows one account and stops at revenue, or a Looker Studio report that someone built two years ago and nobody dares to touch. Since 10 November 2026 there is a third way: describe the page to Claude and let Claude Data write the queries.

This guide walks through that, step by step, following the flow Anthropic documents for Claude Data (the product that was called Claude Dashboards until this week).

What you need before you start

  • A paid Claude plan. Claude Data is included on every paid plan. On Team it is on by default. On Enterprise an owner controls it under Organization settings → Artifacts, and it turns on by default on 19 November 2026.
  • A source for your Amazon data. Claude Data does not read Amazon by itself. It needs a data connector, such as a warehouse.
  • A question. "Show me a dashboard" gets you charts. "Are we growing, and which products explain it?" gets you a page you will open again.

Step 1: Get your Amazon data into one place

Connect Seller Central, Vendor Central and Amazon Ads to DataDoe. Each account is authorised once, on Amazon's own consent screen. From then on DataDoe fetches daily at 2:00 in the seller's local time, with some tables updated during the day, and keeps the history. Upload your product costs as well, because without them every profit chart later in this guide is a revenue chart with a different title.

Step 2: Give Claude a route to that data

There are two routes, and you only need one.

Route A: the DataDoe connector

In Claude, open Customize → Connectors → Add and paste the DataDoe server address. This is the usual way to ask Claude questions about an Amazon account, described on our page about Amazon in Claude. Anthropic says Claude Data works with the apps connected to Claude, and once DataDoe is added it is one of yours.

Route B: BigQuery

BigQuery is on Anthropic's list of Claude Data sources. In DataDoe, turn on the BigQuery integration and subscribe to the listing in Google's Analytics Hub. You choose Integrated data (cleaned and joined, the right choice for dashboards) or Raw. The result is a linked, read-only dataset in your own Google Cloud project. There is no monthly fee for it on the Base plan; queries use AI Tokens and Google charges for compute. Then connect BigQuery in Claude with a Google account that can see that project. Our post on Seller, Vendor and Ads data in BigQuery explains the dataset.

Both routes are laid out side by side on the Claude Data for Amazon page.

Step 3: Open Claude Data

You can start in two places. In any chat, ask for what you need. Or open the Artifacts tab, choose Data and describe the page. Everything you make is saved under Artifacts, so the dashboard is still there tomorrow.

Step 4: Ask for the sales dashboard

Anthropic's guidance is to describe the question you want answered, not only the chart, and to name the table or app if you know it. For a first sales page, a prompt along these lines works as a brief:

"Build a sales dashboard for my Amazon business from the DataDoe data. I want to know if we are growing and what explains it. Top row: sales, units, ad spend and profit for the last 30 days, each against the 30 days before. Then sales by week for the last 12 months, split by marketplace. Then the 15 parent ASINs with the largest change in sales against the previous period. Use amazon_profit_by_date for account totals and amazon_profit_by_sku_and_date for anything by product. Keep each currency separate."

Three parts of that prompt do the heavy lifting. It states the question. It names the two tables, so Claude does not have to guess between account-level and product-level data. And it tells Claude what not to do with currencies, which is the most common way a multi-country dashboard goes wrong.

Step 5: Check every number before you trust it

Claude writes one SQL query per chart and runs it against your source. Each chart shows its query and the time its data was last refreshed. Open the query behind the headline figures and read what it counts. You do not need to write SQL to do this. You need to check four things:

  • the date range is the one you asked for;
  • it filters or groups by marketplace_country_code and currency;
  • account totals come from the account-level table, not from adding up products;
  • today is not included as if it were a full day.

If something looks off, tell Claude in the chat, or ask it to explain the number. You can also edit titles and captions directly on the page.

Step 6: Decide how fresh it needs to be

Claude Data does not refresh on a clock. It refreshes when someone opens a dashboard and its data is due, and you can set the cadence per dashboard. A Refresh data button asks for new results on the spot. For Amazon sales, a daily cadence fits the data: yesterday is complete after the early-morning fetch, and refreshing every few minutes buys nothing except usage. Claude Data counts toward your Claude plan's usage limits, and on the DataDoe side queries draw AI Tokens.

Step 7: Share it, and know what viewers see

A new dashboard is private. Open it and click Share to give colleagues access. By default a shared dashboard loads data through each viewer's own connections, so a colleague without the source sees no numbers.

Live sharing, which is in beta, changes that. In the dashboard's Sources menu you choose "Your access" next to the connector, and people in your organisation then see results from your access, limited to the exact queries the dashboard needs. Those queries cannot change without an editor's approval. Anthropic's own warning applies: anyone you share with sees those results even if they have no access to the source, so look at what the page shows first. People with view-only access cannot edit a dashboard or restore an old version.

If you run an agency: sharing Amazon data outside your own organisation is governed by Amazon's data rules and your client agreement, and no buyer personal data belongs in a dashboard.

Step 8: Keep it honest over time

Claude Data keeps a version history. You can preview an earlier version and restore it, and the restore applies for everyone. If your team settles on one definition of profit or of TACoS, an editor can certify that query, and every chart built on it then carries a certified badge. Editing a certified query removes the badge, which is the point: nobody changes the definition quietly.

Four dashboards to build next

PPC

"Where does ad spend pay for itself? By campaign and by search term for the last 30 days: spend, ad sales, ACoS, and profit after ads. Flag terms above $50 of spend with no orders. One section per ad type." Background on the ads data is on our Amazon Ads page.

Profit

"What do we keep after everything? Monthly waterfall from sales to profit: Amazon fees, ad spend, cost of goods, refunds. Then the 20 SKUs with the lowest margin that still sell more than 50 units a month."

Inventory

"What will run out, and what is sitting too long? Days of cover per SKU from current FBA stock and four-week sales velocity, inbound units next to it, and stock older than 180 days."

Vendor Central

"How healthy is the vendor business? Purchase orders by week, units ordered against units confirmed, and the ASINs with the widest gap. Add shipped revenue by month against last year."

Three mistakes that make an Amazon dashboard wrong

  1. Adding up SKU profit to get account profit. Some costs and adjustments exist only at account level. In DataDoe the account totals in amazon_profit_by_date are Amazon's own figures, and they are not the sum of the rows in amazon_profit_by_sku_and_date. Use the first for totals and the second for rankings.
  2. Mixing currencies. A total across the US, the UK and Germany that adds dollars, pounds and euros is meaningless. Keep one currency per chart, or ask Claude to convert at a rate you name and to say so in the caption.
  3. Reading early traffic numbers as final. Sessions and Featured Offer percentage can arrive later than sales and change after they first appear. A conversion chart for the last three days will often move. The reason is in our guide to Amazon Business Reports.

Where to go next

The wider picture of this week's launch is in Claude Data, Sheets and Whiteboards for Amazon sellers, and the general explanation of certified queries and live sharing is in our Claude Data explainer.

Questions people ask

Do I need to know SQL?

No. Claude writes the queries. It helps to be able to read one well enough to see which dates and which table it uses, and Claude will explain any query if you ask.

How fresh are the numbers?

As fresh as the later of two things: DataDoe's last fetch, which is daily at 2:00 seller time for most tables, and the dashboard's last refresh, which is shown on each chart.

Can my business partner open it without a DataDoe login?

With live sharing turned on, people in your Claude organisation see the results on your access. Without it, they need their own connection to the source.

Can the dashboard change prices or listings?

No. A dashboard only reads. Changes on Amazon go through DataDoe Actions: Actions stay off until you enable them, most AI clients ask before a change, and every change is logged.

What does it cost?

Claude Data is part of paid Claude plans and counts toward their usage limits. DataDoe is $97 a month with a 14-day trial.

DataDoe has no affiliation with Anthropic or Amazon and is not endorsed by either. The Claude Data steps follow Anthropic's Help Center as read on 11 November 2026; certified queries and live sharing are beta features and may change.

• Get started

Put this to work on your own Amazon data.

Connect Seller Central, Vendor Central and Amazon Ads in about 5 minutes, then ask your AI about your own numbers instead of the examples in this post.

  • Seller, Vendor and Ads
  • Any AI client
  • An account manager for every customer
  • $97/mo, 14-day free trial