Prerequisites

• To connect Amazon Ads to Fivetran, you need a seller or vendor Amazon Ads account with access permissions for the Amazon Advertising services.
• To have access to metadata endpoints, you should have one of these roles: advertiser_campaign_view, advertiser_campaign_edit.
• To have access to reports, you should have one of these roles: nemo\_report\_view, nemo\_report\_edit.
  • NOTE: You must provide \*\_edit roles instead of \*\_view roles in some cases.

Setup Instructions

1. Select the Region of the country you selected when registering your account.
2. Click Authorize. This will redirect your browser to the Amazon Ads authorization page.
3. In Amazon's Ads authorization page, click Sign-In.
4. To grant access to the Amazon application, select Allow. This will redirect you back to the connector setup form.
5. Select the appropriate Sync Mode. If you select Sync Specific Accounts, choose the specific accounts you want to sync.
6. Select the Click Attribution window size.
7. Click Save & Test. Fivetran will take it from here and sync your data from Amazon Ads.

Additional Details

Supported Ad Services

The Amazon Ads connector supports the following services:

• Sponsored Brands (V2 & V3)
• Sponsored Display
• Sponsored Products

Historical Sync Limits

Amazon Ads connectors have a maximum historical sync limit set by Amazon.

This limit varies by ad type, but Prescient will only be able to access data up to the maximum limit upon the creation of the connector. After connecting, Prescient will store that data for you and persist it over time.

Here are the limitations for each ad type:

Will Amazon Prime Video ads appear automatically via our Amazon Ads integration?

No. Prime Video ads (Sponsored TV) are not included in the standard Amazon Ads API. Fivetran doesn’t ingest that data, so you’d need a manual feed (e.g., a spreadsheet) if you want the model to include Prime Video ad performance.