Sponsored Brands Campaign mapping

Equivalent to v3 Sponsored_Brands_Campaign_report — 56 v3 columns mapped to v1 fields (largest report in the series)

Summary

This template replicates the v3 Sponsored Brands Campaign report on the Amazon Ads API v1 cross-product reporting endpoint (CreateReport). With 56 v3 columns this is the largest report in the series — it combines the full SB Keyword metric set with NTB DPV breakdown, ATC suite, Branded Search breakdown, Brand Store page views, and Long-Term Sales/ROAS at the campaign grain.

53 of 56 v3 columns map cleanly to v1 fields; 3 are derived client-side (ACOS, click-only ACOS, % of units NTB).

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

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

• country.code

• country.name

Required supporting field

• budgetCurrency.value

Delivery metrics

• metric.impressions

• metric.viewableImpressions

• metric.clicks

• metric.ctr

• metric.vctr

• metric.cpc

• metric.vcpm

• metric.totalCost

• metric.roas

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

Brand engagement (all-attribution)

• 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

NTB DPV breakdown (click-attributed only in this report)

• metric.newToBrandDetailPageViews

• metric.newToBrandDetailPageViewsFromClicks

• metric.newToBrandDetailPageViewRate

• metric.costPerNewToBrandDetailPageView

Brand Store page views

• metric.brandStorePageViews

Add to Cart suite (click-attributed only in this report)

• metric.addToCart

• metric.addToCartFromClicks

• metric.addToCartRate

• metric.costPerAddToCart

Branded Searches breakdown (click-attributed only in this report)

• metric.brandedSearchesFromClicks

• metric.brandedSearchRate

• metric.costPerBrandedSearch

Long-term metrics

• metric.longTermSales

• metric.longTermRoas

Filter (limits the report to SB)

• adProduct.value = SPONSORED_BRANDS

v3 → v1 field mapping

Yellow rows are derived client-side or have 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 the impressions-denominated alternative.

• Long-Term Sales / ROAS: these are PROJECTED 12-month metrics derived from NTB shopper-engagement modeling. Treat as forward-looking estimates rather than realized revenue.

• Adding view-attributed variants: this v3 report omits the view-attributed columns of NTB DPV, ATC, and Branded Search, but v1 has them — metric.newToBrandDetailPageViewsFromViews, metric.addToCartFromViews, metric.brandedSearchesFromViews are all valid additions to symmetrize the breakdowns. Useful if downstream consumers want full click+view comparison alongside the click-only columns the v3 report carries.

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

• Reusing this template: this is the canonical SB campaign-grain template. The SB Campaign Placement report is essentially this report with placementClassification.value added; the SB Keyword report is this report at finer grain (target.value + target.matchType added, country dropped if not needed).