Amazon Ads: upgrade Sponsored Brands reports to Reporting API v3 (unitsSold)
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.
Related ticket: https://support.fivetran.com/hc/en-us/requests/399488
Please sign in to leave a comment.
Comments
0 comments