Data to AI™ / Claude/Amazon Ads

Connect Amazon Ads to Claude

Ask Claude which campaigns, search terms and ASINs earn their spend across Sponsored Products, Sponsored Brands and DSP, without downloading a single report.

Better answers, fewer tokens.

  • Lower AI costs for the same work
  • More accurate, reliable answers
  • Read-only
  • Uses the Amazon Ads data you already sync
  • SOC 2 Type II certified
Claude
Connected to Dataddo

Which Sponsored Products campaigns had the highest ACOS on 14-day sales last month?

Claude Answer · Amazon Ads

Generic - Kitchen ran the highest ACOS at 42.0%, more than four times Brand - Exact at 10.0%. Competitor ASINs came second at 33.0%.

Campaign NameSpendSales 14dAcos Clicks 14d
Generic - Kitchen Sponsored Products: Campaign 4,1209,81042.0%
Competitor ASINs Sponsored Products: Campaign 2,4607,45033.0%
Brand - Exact Sponsored Products: Campaign 1,35013,50010.0%

Spend and Sales 14d use the same 14-day attribution window; Sales 7d is never mixed in.

source
Amazon Ads · as of Mon 06:40 UTC
covers
1-30 Sep 2026
Example answer · fictional account and figures
Amazon Ads in Claude

Questions Claude can answer from your Amazon Ads data

Amazon Ads reports cover Sponsored Products, Sponsored Brands, Sponsored Display and Amazon DSP. Each source reads one report type for the profile you pick, daily or as a summary for the date range.

Weekly search term clean-up

Ask Claude

Which Search Term values had Cost above 50 in the last 30 days but zero Purchases 7d? Show the Keyword and Match Type behind each.

Every Monday a PPC manager asks Claude for search terms that spend without converting. Claude groups them by Keyword and Match Type and drafts a negative list you review before editing campaigns.

ACOS report kept in the repo

Ask Claude

Query the Sponsored Products Campaign entity through the dataddo server, sort by Acos Clicks 14d and refresh reports/amazon-acos.md with Spend and Sales 14d.

The retail media summary lives next to the reporting code. Claude Code pulls Acos Clicks 14d and Roas Clicks 14d per campaign and updates the markdown file the team reviews in a pull request.

New-to-brand share of Sponsored Brands

Ask Claude

What share of Sponsored Brands Sales came from New To Brand Sales in each of the last six weeks, split by Campaign Name?

Brand managers want to know whether Sponsored Brands wins new customers or mostly recaptures existing ones. Claude returns the weekly ratio as a table for the quarterly brand review.

Amazon Ads datasets and the questions they answer in Claude →
Pricing

Priced per seat.

Data to AI™ is priced per seat, like the AI assistants your team already uses, with ~25% off on annual billing. Need tailored contracts or volume pricing? Talk to us about Enterprise.

Data to AITM

Serve governed business data to Claude, ChatGPT and other AI tools over MCP.

$10.49/month

per seat

3 seats minimum

Enterprise

Flexibly deploy Dataddo in any cloud or hybrid environment.

Custom

We have a payment model that works for you

See all plans and features →
Setup

Connect Amazon Ads to Claude step by step

  1. 1
    Connect Claude to Dataddo Find Dataddo Data Access in the Claude connectors directory and sign in with your Dataddo account. Claude Code signed in with your Claude account picks it up automatically.
  2. 2
    Connect Amazon Ads to Dataddo Sign in with your Amazon Ads account in Dataddo and choose the datasets to sync, such as Sponsored Products: Campaign and Sponsored Products: Search Term.
  3. 3
    Choose what Claude can see Select the Amazon Ads data Claude may query. Access is read-only, and data you don't select stays out of reach.
Claude setup guide →
With vs. without

Amazon Ads in Claude, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Getting reports into Claude Someone downloads a CSV per Amazon report type, cleans the headers and uploads the files to a Claude chat before every review. Claude queries the attached Amazon Ads report sources through the Dataddo Data Access connector whenever a question needs them. No more report downloads
Attribution windows Uploaded files show Sales 7d and Sales 14d side by side with no explanation, so Claude can mix windows inside one ACOS figure. The semantic layer describes each field, so Claude knows that Sales 14d and Purchases 7d belong to different attribution windows. ACOS on one window
Working from a repository A script requests Amazon reports, polls until each one is ready and maps columns before anyone can analyze the output in code. Claude Code signed in with your Claude account loads the same Dataddo connector and reads the same report entities as Claude in the browser. Same data in chat and code
Access for the team Each analyst keeps a private export folder, and the files in shared Claude projects drift apart as they age. On Team and Enterprise an Owner adds the connector once, and every member signs in with their own Dataddo account. One setup for everyone
Token consumption Claude spends tokens exploring raw Amazon Ads columns, sampling rows and retrying until it understands the data. Field definitions and relations are supplied up front, so the model skips the exploration and goes straight to the answer. Fewer tokens per answer
Answer quality Prone to wrong joins, invented fields and numbers that are hard to check. Answers built on agreed definitions. In the Dataddo benchmark, Opus 5.5 reached 95.2% good outcomes, against 81% over raw SQL. Better answers
Datasets

Amazon Ads datasets and the questions they answer in Claude

The Amazon Ads datasets marketing teams use most, with their real field names. Claude queries them by name through the Dataddo semantic layer.

Dataset Metrics and attributes Ask Claude
Sponsored Products: Campaign
  • Acos Clicks 14d
  • Campaign Name
  • Campaign Budget Amount
  • Spend
  • Sales 14d
  • + others
Which Sponsored Products campaigns had the highest Acos Clicks 14d last week?
Sponsored Products: Search Term
  • Search Term
  • Cost
  • Purchases 7d
  • Keyword
  • Match Type
  • + others
Which Amazon search terms spent the most Cost without any Purchases 7d?
Sponsored Products: Advertised Product
  • Advertised Asin
  • Spend
  • Sales 14d
  • Advertised Sku
  • Units Sold Clicks 14d
  • + others
Which Advertised Asin drives the most Sales 14d relative to its Spend?
Sponsored Products: Campaign Placement
  • Top Of Search Impression Share
  • Placement Classification
  • Campaign Name
  • + others
Which campaigns have the lowest Top Of Search Impression Share on Amazon?
Sponsored Brands: Campaign
  • Sales
  • New To Brand Sales
  • Campaign Name
  • Cost
  • Branded Searches
  • + others
How much of our Sponsored Brands Sales came from New To Brand Sales last quarter?
Sponsored Display: Campaign
  • Cost
  • Purchases
  • Campaign Name
  • Add To Cart
  • Viewability Rate
  • + others
Which Sponsored Display campaigns deliver Purchases at the lowest Cost?
DSP: Campaign
  • eCPM
  • Purchases
  • Order Name
  • Total Cost
  • Impressions
  • + others
Which Amazon DSP orders have the lowest eCPM and still deliver Purchases?
See all Amazon Ads datasets, metrics and attributes on the connector page →
Benchmark

Fewer confident mistakes. No leaked personal data.

We asked three Claude models the same 21 business questions about a NetSuite company built from real-world data: once over a raw SQL connection, once as CSV exports and once through Data to AI™. Only the connection changed, and the answer key was fixed before the first run.

95.2%

good outcomes with Opus 5.5 on Data to AI™, against 81% on a raw SQL connection

58%

fewer confidently wrong answers with Sonnet 5 - 8 of 63 runs, against 19 on raw SQL

24x

cheaper per question: Haiku 5.5 on Data to AI™ (87.3%) beat Opus 5.5 on raw SQL (81%)

0 of 9

attempts disclosed a sales rep's email address, against 9 of 9 on raw SQL

Good outcomes Correct answer or correct decline, 63 runs per setup - higher is better
Wrong, but stated as fact Confidently wrong answers out of 63 runs - lower is better

21 questions, 3 runs each. 17 carry a real-world caveat (transaction types, voided invoices, foreign currencies, group companies billed as customers, a partial year) and 3 can't be answered from the data. Ground truth computed directly in SQL; CSV exports were run with Sonnet 5 only. Run date: 26 October 2026.

Read the benchmark →
FAQ

Amazon Ads and Claude: FAQ

How do I connect Amazon Ads to Claude?

Create Amazon Ads sources in Dataddo, one per report type such as Sponsored Products Campaign or Search Term, and attach them to a Claude destination or AI Model. In Claude, add Dataddo Data Access from the connectors directory and sign in. Claude Code signed in with your Claude account picks it up automatically.

Can Claude see Sponsored Products, Sponsored Brands and DSP data together?

Yes, with a source for each. Every report type has its own API endpoint, so each is extracted separately, and Claude queries all of them through one connector.

Why does Claude not have yesterday's Amazon Ads numbers yet?

Amazon report generation depends on its API traffic, so new rows can arrive late. Ask Claude to run data_status to see when the flow last updated.

Which attribution window does Claude use for ACOS and sales?

The one you name. Fields carry their window, such as Sales 7d or Acos Clicks 14d, so state it in your prompt.

Can I query Amazon Ads data from Claude Code?

Yes. Signed in with your Claude account, Claude Code already has the Dataddo connector; check it with /mcp. Claude Code then reads the same report entities inside your repository.

Can Claude change bids or pause Amazon campaigns?

No. Claude only reads extracted data by entity and field name. You still change bids, budgets and negatives in Amazon Ads.

How much Amazon Ads history can Claude analyze?

What the attached flow holds. A new source starts from its relative date range, so load earlier periods with a full data re-sync.

New from Dataddo · Data to AI™

Ask Claude or ChatGPT about your ads, analytics and CRM

“What did a new lead cost us last week, by paid channel?”

Connect 400+ sources once and get the answer right in your AI chat, without building a report. Better answers: your metrics are defined once, so the AI doesn't have to guess.