Why Do the Campaign Tables Not Contain Sponsored Brands or Sponsored Display Campaign Data?

Issue

My campaign tables only contain Sponsored Products campaign data. Why do they not contain Sponsored Brands or Sponsored Display campaign data?

Environment

Connector: Amazon Ads

Resolution

We don't sync Sponsored Brands and Sponsored Display campaign data to the campaign tables. Instead, we sync Sponsored Brands and Sponsored Display data to tables with the SB_ and SD_ prefixes, respectively. For example, we sync Sponsored Brand campaign cost data to the cost field in the SB_CAMPAIGN_REPORT table. See our Amazon Ads release notes for more information.