Amazon Ads API to Snowflake

  • Get data from Amazon Ads API to Snowflake
  • Our high-performance solution supports any data volume
  • Ready-to-query datasets
Get in touch

Available Datasets

Sponsored Products

Amazon Ads Report Type ID
Description
spCampaigns
Campaign reports contain performance data broken down at the campaign level. Campaign reports include all campaigns of the requested sponsored ad type that have performance activity for the requested days. For example, a Sponsored Products campaign report returns performance data for all Sponsored Products campaigns that received impressions on the chosen dates.
spTargeting
Targeting reports contain performance metrics broken down by both targeting expressions and keywords.
spSearchTerm
Search term reports contain search term performance metrics broken down by targeting expressions and keywords. Note that search term reports only include impressions that resulted in at least one ad click.
spAdvertisedProduct
Advertised product reports contain performance data for products that are advertised as part of your campaigns.

Sponsored Brands

Amazon Ads Report Type ID
Description
sbCampaigns
Campaign reports contain performance data broken down at the campaign level. Campaign reports include all campaigns of the requested sponsored ad type that have performance activity for the requested days. For example, a Sponsored Products campaign report returns performance data for all Sponsored Products campaigns that received impressions on the chosen dates.
sbTargeting
Targeting reports contain performance metrics broken down by both targeting expressions and keywords.
sbSearchTerm
Search term reports contain search term performance metrics broken down by targeting expressions and keywords. Note that search term reports only include impressions that resulted in at least one ad click.
sbCampaignPlacement
Placement reports contain performance data broken down by ad placement.
sbAds
Advertised product reports contain performance data for campaigns at the ad level.

Sponsored Dislay

Amazon Ads Report Type ID
Description
sdCampaigns
Campaign reports contain performance data broken down at the campaign level. Campaign reports include all campaigns of the requested sponsored ad type that have performance activity for the requested days. For example, a Sponsored Products campaign report returns performance data for all Sponsored Products campaigns that received impressions on the chosen dates.
sdTargeting
Targeting reports contain performance metrics broken down by both targeting expressions and keywords.
spAdvertisedProduct
Advertised product reports contain performance data for products that are advertised as part of your campaigns.

Amazon Marketing Stream

Stream Dataset
Description
sp-traffic
The sp-traffic dataset contains click, impression, and cost data related to Sponsored Products campaigns.
sp-conversion
The sp-conversion dataset contains conversion data attributed to Sponsored Products campaigns.
sd-traffic
The sd-traffic dataset contains click, impression, and cost data related to Sponsored Display campaigns.
sd-conversion
The sd-conversion dataset contains conversion data attributed to Sponsored Display campaigns.
sb-traffic
The sb-traffic dataset contains click, impression, and cost data related to Sponsored Brands campaigns.
sb-conversion
The sb-conversion dataset contains conversion and new-to-brand data related to Sponsored Brands campaigns.
sb-clickstream
The sb-clickstream dataset contains detail page views and branded searches data related to Sponsored Brands campaigns.
sb-rich-media
The sb-rich-media dataset contains video data related to Sponsored Brands campaigns.

How it works

Request
Get in touch with us and discuss integration opportunities for your business.
Receive
We will prepare an optimal solution to meet your needs.
Act
Take action on new insights delivered from better visibility.
Get in touch

Markets