Sponsored Brands Prompts partial mapping

Partial replacement for v3 Sponsored_Brands_Prompts_report — 25 of 26 columns reproducible at Ad grain

Summary

This template is a PARTIAL replacement for the v3 Sponsored Brands Prompts report on the Amazon Ads API v1 cross-product reporting endpoint.

CRITICAL: The v3 'Prompt details' dimension has NO v1 equivalent. The v1 catalog returns zero hits for 'prompt' or 'rufus' across all categories. Amazon Rufus AI-shopping prompt-level performance has not been added to the v1 reporting catalog as of catalog parse 2026-04-18. The closest reproducible level of detail is Ad (ad.id / ad.name / ad.format).

The 31-field payload was validated against the packaged v1 catalog: zero unknown fields, zero missing required, zero incompatible pairs. The result reproduces 25 of 26 v3 columns at Ad grain.

Why prompt-level dimensions are missing

The v3 SB Prompts report is part of Amazon's Rufus integration — generative-AI shopping prompts that drive Sponsored Brands placements when shoppers ask Rufus product questions. v3 exposes the prompt text or category as a dimension; v1 does not yet. Validator probes for prompt.value, promptDetails.value, rufusPrompt.value, and similar all return unknown.

This is likely a catalog-completeness gap rather than a deliberate omission — the underlying telemetry exists and v3 surfaces it, but the v1 cross-product reporting catalog has not been extended to cover it. Track Amazon's Ads API release notes for additions to the dimension family.

Recommended recovery paths

• Continue using the v3 Sponsored Brands Prompts report endpoint until v1 adds prompt dimensions.

• Hybrid: use this v1 partial template for steady-state Ad-grain Rufus reporting, and run the v3 endpoint at a lower cadence (e.g. weekly) for prompt-level breakdowns.

• If you only need to know which ads use Rufus prompt creatives vs traditional ads, ad.format may carry a distinguishing format value — verify by inspecting a sample of returned rows.

Field list (grouped by role) — partial replacement only

Time dimension (exactly one required)

• date.value

Level-of-detail dimensions (Ad grain — closest to v3 prompt grain)

• portfolio.portfolioId

• portfolio.name

• campaign.id

• campaign.name

• campaign.currencyCode

• adGroup.id

• adGroup.name

• country.code

• country.name

• ad.id

• ad.name

• ad.format

Required supporting field

• budgetCurrency.value

Delivery metrics

• metric.impressions

• metric.viewableImpressions

• metric.clicks

• metric.ctr

• metric.cpc

• metric.totalCost

All-attribution conversion (7-day)

• metric.sales

• metric.purchases

• metric.unitsSold

• metric.purchaseRateOverClicks

• metric.purchaseRate

• metric.roas

Advertised-SKU vs Other-SKU split

• metric.salesPromoted

• metric.salesHalo

• metric.purchasesPromoted

• metric.purchasesHalo

• metric.unitsSoldPromoted

• metric.unitsSoldHalo

Filter (limits the report to SB)

• adProduct.value = SPONSORED_BRANDS

v3 → v1 field mapping

Red rows highlight columns NOT REPRODUCIBLE in v1. Yellow rows are derived or definition-dependent.

Critical differences from the v3 report

Operational notes

• Attribution window: this v3 report uses a 7-day window (not the SB-typical 14-day). Set the window on the report request explicitly to match.

• Reusing this template: this is essentially a slim version of the SB Keyword report at Ad grain instead of keyword grain. If you also want Branded Searches and DPV, add metric.brandedSearches and metric.detailPageViews — both are compatible with the Ad grain.