Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Amazon Ads: upgrade Sponsored Brands reports to Reporting API v3 (unitsSold)

Answered
Abid Gaidarov User

Connector name: Amazon Ads

Table name: sb_campaign_report (Sponsored Brands)

Column to add: unitsSold (Reporting API v3, report type sbCampaigns)

API documentation link: https://advertising.amazon.com/API/docs/en-us/guides/reporting/v3/columns

---

Context: the Sponsored Brands report currently comes from API v2, where the legacy unitsSold14d field is only valid for SB version 3 campaigns, not multi-ad-group (version 4) campaigns. All current SB campaigns are v4, so the column arrives empty. Sponsored Display in the same connector already reports units correctly via v3 — this gap is SB-specific.
 

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Abid,

    Thanks for the detailed request. You're right that sb_campaign_report currently pulls from the Amazon Ads Reporting API v2, where unitsSold14d is only valid for Sponsored Brands version 3 campaigns and returns empty for the multi-ad-group (version 4) campaigns that are now standard.

    The v3 sbCampaigns report type exposes a unitsSold metric with no such version restriction (https://advertising.amazon.com/API/docs/en-us/guides/reporting/v3/columns), and Amazon confirms v3 reports cover modern multi-ad-group (version 4) campaigns like yours. Sponsored Display in the same connector already uses v3 and reports units correctly; this gap is Sponsored Brands-specific.

    This work is already tracked under an internal effort to migrate Sponsored Brands and Sponsored Display reports to Reporting API v3 (Sponsored Display has already moved over), and I've linked your request to that effort so it's counted in prioritization. 

    I'll follow up here when I have a concrete update. Appreciate you flagging this.

    Cheers,
    Luke