Sponsored Brands Keyword Placement mapping

Equivalent to v3 Sponsored_Brands_Keyword_Placement_report — 25 v3 columns mapped to v1 fields

Summary

This template replicates the v3 Sponsored Brands Keyword Placement report on the Amazon Ads API v1 cross-product reporting endpoint (CreateReport). Of the 25 v3 columns, 22 map cleanly to v1 fields and 2 are derived client-side (ACOS and % of units new-to-brand). One v3 column ('14 Day Conversion Rate') has two valid v1 mappings depending on definition; both are included so the warehouse can pick.

This is the first SB report in the series that does NOT require a supplemental Top-of-search Impression Share query — that metric isn't on the v3 report, and the placementClassification.value dimension already exposes top-of-search performance directly (filter or pivot the result on placementClassification.value = TOP_OF_SEARCH).

The 26-field payload was validated against the packaged v1 catalog: zero unknown fields, zero missing required, zero incompatible pairs.

Single-report architecture

Unlike the regular SB Keyword report and the SP Targeting report, this template is a single CreateReport call. metric.topOfSearchImpressionShare isn't requested here, so the adGroup-incompatibility constraint that forced two-report architectures elsewhere doesn't apply. Submit one report and consume.

Field list (grouped by role)

Time dimension (exactly one required)

• date.value

Level-of-detail dimensions

• portfolio.portfolioId

• portfolio.name

• campaign.id

• campaign.name

• campaign.currencyCode

• target.value

• target.matchType

• placementClassification.value

Required supporting field

• budgetCurrency.value

Delivery metrics

• metric.impressions

• metric.clicks

• metric.ctr

• metric.cpc

• metric.totalCost

All-attribution conversion (14-day)

• metric.sales

• metric.purchases

• metric.unitsSold

• metric.purchaseRateOverClicks

• metric.purchaseRate

• metric.roas

New-to-brand

• metric.newToBrandPurchases

• metric.newToBrandSales

• metric.newToBrandUnitsSold

• metric.percentOfPurchasesNewToBrand

• metric.percentOfSalesNewToBrand

• metric.newToBrandPurchaseRate

Filter (limits the report to SB)

• adProduct.value = SPONSORED_BRANDS

v3 → v1 field mapping

Yellow rows highlight columns that don't have a clean one-to-one v1 mapping (derived client-side or definition-dependent).

Critical differences from the v3 report

Operational notes

• Conversion rate: SB UIs typically use orders/clicks → metric.purchaseRateOverClicks. Drop metric.purchaseRate if you don't need the impressions-denominated alternative.

• Derivations to materialize in the warehouse: acos = totalCost / NULLIF(sales, 0); percentOfUnitsNewToBrand = newToBrandUnitsSold / NULLIF(unitsSold, 0). Persist the raw inputs alongside the views.

• Reusing this template: this report is essentially a slim version of the SB Keyword report with placementClassification.value added and the video / viewable / click-only / brand-engagement metric blocks dropped. If you need to pivot to TOP_OF_SEARCH performance only, filter the result on placementClassification.value = TOP_OF_SEARCH.