Sponsored Brands Campaign Placement mapping

Equivalent to v3 Sponsored_Brands_Campaign_placement_report — 42 v3 columns mapped to v1 fields

Summary

This template replicates the v3 Sponsored Brands Campaign Placement report on the Amazon Ads API v1 cross-product reporting endpoint (CreateReport). 39 of 42 v3 columns map cleanly to v1 fields; 3 are derived client-side (ACOS, click-only ACOS, % of units new-to-brand).

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

Single-report architecture — Top-of-search Impression Share isn't on the v3 report, so no supplemental query is needed. Filter or pivot on placementClassification.value = TOP_OF_SEARCH downstream if you need the top-of-search slice.

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

• campaign.costType

• placementClassification.value

Required supporting field

• budgetCurrency.value

Delivery metrics

• metric.impressions

• metric.viewableImpressions

• metric.clicks

• metric.ctr

• metric.vctr

• metric.cpc

• metric.vcpm

• metric.totalCost

Video metrics

• metric.firstQuartileVideoAd

• metric.midpointVideoAd

• metric.thirdQuartileVideoAd

• metric.completeViewsVideoAd

• metric.unmutesVideoAd

• metric.5secondViewsVideoAd

• metric.5secondViewRateVideoAd

• metric.completionRateVideoAd

All-attribution conversion (14-day)

• metric.sales

• metric.purchases

• metric.unitsSold

• metric.purchaseRateOverClicks

• metric.purchaseRate

• metric.roas

Brand engagement

• metric.brandedSearches

• metric.detailPageViews

New-to-brand

• metric.newToBrandPurchases

• metric.newToBrandSales

• metric.newToBrandUnitsSold

• metric.percentOfPurchasesNewToBrand

• metric.percentOfSalesNewToBrand

• metric.newToBrandPurchaseRate

Click-only attribution variants

• metric.salesFromClicks

• metric.purchasesFromClicks

• metric.unitsSoldFromClicks

• metric.roasFromClicks

Filter (limits the report to SB)

• adProduct.value = SPONSORED_BRANDS

v3 → v1 field mapping

Yellow rows highlight columns derived client-side or with multiple valid mappings.

Critical differences from the v3 report

Operational notes

• VTR definition: confirm with consumers whether VTR means completion (full play) or 5-second view. The template carries both metric.completionRateVideoAd AND metric.5secondViewRateVideoAd. Drop whichever isn't needed.

• Conversion rate definition: SB UIs typically use orders/clicks → metric.purchaseRateOverClicks. Drop metric.purchaseRate if you don't need it.

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

• Reusing this template: the field set is functionally a superset of the SB Keyword Placement report. Drop video / NTB / brand-engagement / click-only blocks if you only need basic placement performance.