What Amazon DSP questions can I ask Claude or ChatGPT?

With Marketplace Ad Pros connected via MCP, you can ask ASIN-level attribution questions ('which ASINs is DSP driving sales for?'), creative performance ('Video vs Display CTR'), audience reach, conversion source breakdowns (Amazon Retail vs other), and funnel gap analysis (high DPV but low purchase line items). Each prompt in this library explicitly names the underlying report_type so the AI returns the right data first try.

Which DSP report types does Marketplace Ad Pros support?

MAP pulls six DSP report types automatically per advertiser: dsp_campaign_performance (order + line item, daily), dsp_products (ASIN-level attribution), dsp_campaign_creative (creative-level CTR/CVR), dsp_geography (country breakdown), dsp_audience (reach per line item, SUMMARY mode), and dsp_conversion_source (attribution by Amazon Retail vs other sources).

Can I see ASIN-level DSP attribution through AI?

Yes. The dsp_products report exposes per-ASIN purchases, sales, detail page views, new-to-brand purchases, and asinConversionType (Promoted vs Halo). You can ask 'which ASINs is DSP actually moving sales for?' and get a ranked answer, or find halo-lift ASINs you aren't directly advertising but are getting DSP-attributed sales for.

Do I need a separate DSP account or agency profile?

You need an Amazon Ads agency-type profile with DSP access. MAP auto-discovers the advertisers under your agency profile and maps them to your brands. DSP reports are pulled automatically per advertiser with up to 90 days of historical data via admin-triggered backfills.

Do these prompts work with ChatGPT or only Claude?

These prompts work with any AI client connected to Marketplace Ad Pros via MCP — including Claude (Desktop, Code, and web), ChatGPT, n8n, and any other MCP-compatible tool. Each prompt names the report_type explicitly so the AI doesn't guess stale names.

Back to Home

Marketplace Ad Pros

Amazon DSP Prompts
for Claude & ChatGPT

Programmatic display was a black box. Now it's just a conversation. Ask ASIN-level attribution, creative-level CTR, audience reach, and conversion source questions in plain English.

Click any prompt to copy Six DSP report types ASIN-level attribution

How to Use This Library

Connect your Amazon Ads agency profile to Marketplace Ad Pros via the Integrations page. MAP auto-discovers your DSP advertisers and maps them to your brands.
Add MAP to your AI client — Claude, ChatGPT, Claude Code, n8n, or any MCP-compatible tool.
Copy a prompt below (click the prompt text), replace <YOUR_BRAND> with your actual brand name, paste into your AI, and go.

Each prompt explicitly names the report_type (dsp_campaign_performance, dsp_products, etc.) so the AI doesn't guess. DSP data is pulled automatically per advertiser and historical backfills cover up to 90 days.

Top-Line DSP Performance

Start here. Get a snapshot of DSP spend, sales, and efficiency before drilling into specifics.

Monthly top-line

For <YOUR_BRAND>, show me DSP performance over the last 30 days using the `dsp_campaign_performance` report type. Include total spend (totalCost), totalSales14d, totalPurchases14d, impressions, clickThroughs, eCPM, eCPC, totalROAS14d, and detail page views (dpv14d).

READ One-sentence health check. Confirms DSP data is flowing and gives a baseline.

Week-over-week

For <YOUR_BRAND>, compare DSP performance between the last complete week and the previous week using the `dsp_campaign_performance` report. Show totalCost, totalSales14d, totalROAS14d, dpv14d, and totalNewToBrandPurchases14d side-by-side with percent change. Flag any metric that moved more than 15%.

READ Best run every Monday. WoW deltas tell you which dials are moving.

ASIN-Level Attribution

The question DSP usually can't answer without a data scientist: "which of my products is DSP actually moving sales for?" Answered by the dsp_products report.

Top ASINs by DSP sales

For <YOUR_BRAND>, give me the top 20 ASINs by DSP-attributed sales14d over the last 30 days using the `dsp_products` report. Include amazonStandardId, parentASIN, brandName, totalPurchases14d, totalSales14d, dpv14d, and totalNewToBrandPurchases14d. Sort by totalSales14d descending.

READ Your first real answer to "which products is DSP driving?"

Promoted vs Halo split

For <YOUR_BRAND> last 30 days, use the `dsp_products` report to break out totalSales14d and totalPurchases14d by asinConversionType (Promoted vs Halo). Show the Promoted:Halo ratio. Which ASINs have the highest halo effect?

READ Halo = sales of products you didn't directly advertise. High halo = DSP is lifting the whole catalog.

ASIN funnel gap

For <YOUR_BRAND>, find ASINs with heavy DSP detail page views but few purchases. Use the `dsp_products` report for the last 30 days. Return ASINs where dpv14d > 500 and (totalPurchases14d / dpv14d) < 1%. Sort by dpv14d descending. These are candidates for price tests, listing fixes, or pausing DSP spend.

READ Traffic without conversion means the creative is working but the listing (or price) isn't.

Featured ASINs performance

For <YOUR_BRAND>, compare performance of featuredASIN='Y' vs featuredASIN='N' ASINs in the `dsp_products` report for the last 30 days. Do featured ASINs drive proportionally more sales and NTB purchases? Include totalSales14d, totalPurchases14d, and percentOfPurchasesNewToBrand14d for each group.

READ Tests whether your line-item featured-ASIN selection is working.

Line Items & New-to-Brand

DSP's most actionable unit is the line item. Find the ones driving acquisition vs the ones burning budget.

Top line items by spend

For <YOUR_BRAND> last 7 days, show the top 20 DSP line items by totalCost from the `dsp_campaign_performance` report. Include orderName, lineItemName, impressions, clickThroughs, totalCost, totalSales14d, and a computed ROAS (totalSales14d / totalCost). Sort by totalCost descending.

READ The top 10 usually drive 80% of the budget — know them cold.

High-NTB line items

For <YOUR_BRAND> last 30 days, use `dsp_campaign_performance` to find line items where totalNewToBrandPurchases14d > 40% of totalPurchases14d. Include lineItemName, totalPurchases14d, totalNewToBrandPurchases14d, NTB%, and totalCost. These are your best prospecting channels.

READ NTB% is the single cleanest prospecting signal DSP exposes.

Creative Performance

Which ad units are carrying the campaign? Uses the dsp_campaign_creative report (CAMPAIGN type with the CREATIVE dimension).

Video vs Display

For <YOUR_BRAND> last 30 days, use the `dsp_campaign_creative` report to compare Video vs Display creatives by creativeType. Aggregate impressions, clickThroughs, totalCost, totalSales14d, and compute CTR (clickThroughs / impressions) and CVR (totalPurchases14d / clickThroughs) per type.

READ Video and display answer different funnel questions. Don't optimize them with one number.

Best creative size by ROAS

For <YOUR_BRAND> last 30 days, rank creativeSize (e.g. 300x250, 1920x1080) by totalROAS14d using the `dsp_campaign_creative` report. Include totalCost per size so I can see volume alongside efficiency. Ignore sizes with fewer than 10,000 impressions.

READ Useful for creative-budget reallocation conversations with designers.

Geography

Country-level breakdown via the dsp_geography report. Useful for multi-market brands and anyone running pan-EU campaigns.

Country breakdown

For <YOUR_BRAND> last 30 days, use the `dsp_geography` report to break out DSP performance by country. Include impressions, clickThroughs, totalCost, totalSales14d, dpv14d. Compute CTR and implied ROAS per country. Sort by totalCost descending.

READ Note: eCPM / eCPC / totalROAS14d aren't available in the GEOGRAPHY report — compute client-side from cost & impressions.

Audience Reach

Reach metrics per line item from the dsp_audience report. This one is a SUMMARY report — one row per line item aggregated over the whole window, no time series.

Reach per line item

For <YOUR_BRAND>, pull the latest `dsp_audience` report. Show impressions, clickThroughs, totalCost, and dpv14d by orderName and lineItemName. Compute CTR and dpv-per-thousand-impressions per line item. Which line items deliver reach most efficiently?

READ No time-series: data reflects the most recent weekly pull only. Purchase metrics aren't available in AUDIENCE — pair with #07 for a full picture.

Conversion Source

How much of DSP's attributed sales come from Amazon Retail vs other conversion sources? Uses the dsp_conversion_source report.

Amazon Retail vs other

For <YOUR_BRAND> last 30 days, break down totalPurchases14d and totalSales14d by conversionSourceName and conversionSourceOwner using the `dsp_conversion_source` report. What percent of DSP-attributed sales come from Amazon Retail vs other conversion sources?

READ If you sell DTC alongside Amazon, this tells you what DSP is doing for each channel.

Attribution-type mix by line item

For <YOUR_BRAND> last 30 days, use the `dsp_conversion_source` report to find line items whose sales mix skews heavily toward a single conversionSourceAttributionType. List top 10 line items by totalSales14d with their conversionSourceAttributionType breakdown.

READ A 90/10 mix says the line item is doing one job well — useful for audience strategy conversations.

Funnel Gap Analysis

Find where the funnel is leaking. Cross-references detail page views against purchase conversion.

High-DPV low-purchase line items

For <YOUR_BRAND> last 30 days, use `dsp_campaign_performance` to find DSP line items with dpv14d > 500 but totalPurchases14d < 10. Include lineItemName, impressions, clickThroughs, dpv14d, totalPurchases14d, totalCost. These are targeting-optimization candidates — users are landing on the PDP but not buying.

READ Combine with #05 to see whether the issue is at the line-item level (wrong audience) or ASIN level (wrong listing).

Ready to Try These?

Connect your Amazon Ads agency profile. Your DSP data pulls automatically per advertiser and becomes queryable through Claude, ChatGPT, or any MCP client.

Connect Your Accounts

Free to connect · AI access from $10/week · Cancel anytime

Amazon DSP Promptsfor Claude & ChatGPT