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
Get started with Amazon Ads SQL Templates
Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Amazon Ads.