Updated Integration
We have recently updated our Amazon Ads integration to align with the latest changes in the Amazon Ads API. Please refer to our blog post for detailed information on the changes made, including new table structures and field modifications.
Amazon Advertising
Amazon Ads is an advertising platform offered by Amazon, allowing sellers and vendors to promote their products on the Amazon marketplace. It provides businesses with various ad formats and targeting options to increase visibility, reach potential customers, and drive sales.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | |
| Custom data | False | |
| History | False | |
| ReSync | True | Table level |
| Templates | False |
Data Schema
Reporting Period
For sponsored ads reports data is only available up to 60 days back from the current date. This is a hard limit set by Amazon.
🔧 Setup Guide
Prerequisites An Amazon Ads account with permissions for the Amazon Advertising services.
Step 1 - Begin Configuration in Weld
- Enter your chosen destination schema name.
- Click Authorize. This will redirect your browser to the Amazon Ads authorization page.
Step 2 - Authorize Amazon Ads
- In Amazon's Ads authorization page, click Sign-In.
- To grant access to the Amazon application, select Allow. This will redirect you back to the connector setup form.
Step 3 - Data To Sync
- Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 4 - Configure Sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your Amazon Ads account.
📊 SQL Templates
View all →Extracts a comprehensive report of advertising performance for Amazon's Sponsored Products, grouped by campaigns and accounts. This report integrates data from the campaign report with the account and campaign tables to provide metrics such as cost, clicks, and impressions for each campaign.
This template extracts a comprehensive breakdown of advertising performance on Amazon, grouped by ad groups for sponsored products. It integrates data from the sponsored product ad group report with the profile and ad group tables to deliver metrics like cost, clicks, and impressions for each ad group.
This template extracts a comprehensive breakdown of advertising performance on Amazon, grouped by keywords for sponsored products. It integrates data from the sponsored product keyword report with the profile and keyword tables to deliver metrics like cost, clicks, and impressions for each keyword.
This template extracts a comprehensive breakdown of advertising performance on Amazon, grouped by product ads for sponsored products. It integrates data from the sponsored product product ad report with the profile and ad tables to deliver metrics like cost, clicks, and impressions for each product ad.
Changelog
RSSsponsored_campaign_reportsponsored_product_ad_groupsponsored_product_ad_group_v3