Amazon Ads
Amazon Ads is an advertising service that uses the pay-per-click model. Sellers only pay when shoppers click sellers' ads. We support the following Amazon Ads services:
- Sponsored Products are the standard product listings that appear in the search results and product detail pages. They’re pay-per-click, keyword-targeted display ads for individual products. The link leads to the product details listing page.
- Sponsored Brands showcase your brand and multiple products in a single ad unit.
- Sponsored Display extends your reach beyond search results to target audiences both on and off Amazon.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | AD_GROUP_THEME_BASED_BID_RECOMMENDATION, AD_GROUP_BID_RECOMMENDATION_CLICK, AD_GROUP_BID_RECOMMENDATION_ORDER, AD_GROUP_BID_RECOMMENDATION_VALUE, AD_GROUP_SUGGESTED_KEYWORD, ASIN_THEME_BASED_BID_RECOMMENDATION, ASIN_BID_RECOMMENDATION_CLICK, ASIN_BID_RECOMMENDATION_ORDER, ASIN_BID_RECOMMENDATION_VALUE, BUDGET_RULE, SB_CREATIVE_HISTORY, SB_KEYWORD, SB_KEYWORD_RECOMMENDATION_ASIN, SB_KEYWORD_RECOMMENDATION_URL, SB_NEGATIVE_KEYWORD, SB_NEGATIVE_PRODUCT_TARGET, SB_PRODUCT_TARGETING_CATEGORY, SB_PRODUCT_TARGET, SB_STORE, SB_STORE_ASSET, SB_TARGETING_RECOMMENDATION_CATEGORY, SB_TARGETING_RECOMMENDATION_BRAND_CATEGORY, SB_TARGETING_RECOMMENDATION_PRODUCT, SB_BRAND, SB_BUDGET_RULE_RECOMMENDATION, SD_CREATIVE, SD_CREATIVE_MODERATION, SD_NEGATIVE_TARGETING_EXPRESSION, SD_NEGATIVE_TARGETING_RESOLVED_EXPRESSION, SD_TARGETING_EXPRESSION, SD_TARGETING_RESOLVED_EXPRESSION tables. |
| History mode | check | _HISTORY suffix |
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | |
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Amazon Ads setup guide to connect Amazon Ads with your destination using Fivetran connectors.
Sync overview
Amazon Ads uses the time zone set by the profile to request the report. Reports are only available for a limited number of days ago. Therefore, we synchronize each historical report only within the allowed period.
| Reports | Retention period |
|---|---|
| Sponsored Products | 95 days |
| Sponsored Display | 60 days |
| Sponsored Brands Version 2 | 60 days |
| Sponsored Brands Version 3 | 95 days |
| SB_BENCHMARK_BRAND_AND_CATEGORY_REPORT | 90 days |
Rollback sync
A rollback sync is a sync that automatically runs once a day. Rollback syncs capture the changes that happen outside the incremental sync time frame.
Rollback syncs for Sponsored Display and Sponsored Products reports depend on the Attribution Window setting.
Rollback syncs for Sponsored Brands reports always use 14 days and don't depend on the Attribution Window setting. According to the Amazon's documentation:
Sponsored Brands reporting data cannot be combined with Sponsored Products data into one report. Only 14-day data is available for Sponsored Brands. Attribution windows of 1, 7, and 30-day intervals are not available.
Schema information
This schema applies to all Amazon Ads connectors.
To zoom, open the ERD in a new window.Syncing empty tables and columns
The Amazon Ads connector doesn't support the creation of empty tables and columns in your destination.
We create a table in the destination only if we can retrieve the relevant data from the source. If Amazon Ads doesn’t return data for the source table, we don’t create the table in your destination.