Amazon Ads Setup Guide

Follow our setup guide to connect Amazon Ads to Fivetran.

Prerequisites

NOTE: Fivetran supports the following services in the Amazon Ads API:
Sponsored Brands
Sponsored Display
Sponsored Products

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.

To know more information about permissions, read the Amazon Ads reference article.

NOTE: The seller and vendor accounts are associated with the Sponsored Brands, Sponsored Display and Sponsored Products APIs that Fivetran supports. The agency accounts are associated with the DSP and Data Provider APIs that Fivetran does not support.

Setup instructions

Begin Fivetran configuration

Enter your chosen Destination schema name in the connector setup form.
(Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice, and then select the same agent for your destination.
Select the Region of the country you selected when registering your account.
Click Authorize. This will redirect your browser to the Amazon Ads authorization page.

Authorize Fivetran in 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.

Finish Fivetran configuration

Choose your Sync mode: Sync All Profiles or Sync Specific Profiles.
If you choose Sync Specific Profiles, select the profiles you'd like to sync.
Select the Click Attribution window size.
Click Save & Test. Fivetran will take it from here and sync your data from Amazon Ads.

Connector Overview

Schema Information

Release Notes

API Connector Configuration