Amazon Ads

Connect Amazon Ads to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.

Connect Amazon Ads

Open the catalogue. In the console, go to Data · Connections and press New connection.
Choose Amazon Ads. It is listed under commerce; you can also search for it by name.
Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.

What the connection form asks for. Required fields are marked; the rest are optional.

Field	Type	Required	Description
Client ID	string, secret	Yes	The client ID of your Amazon Ads developer application.
Client Secret	string, secret	Yes	The client secret of your Amazon Ads developer application.
Refresh Token	string, secret	Yes	Amazon Ads refresh token.
Region	string	No	Region to pull data from (EU/NA/FE). One of `NA`, `EU`, `FE`. Default `NA`.
Start Date	string	No	The Start date for collecting reports, should not be more than 60 days in the past. In YYYY-MM-DD format.
Profile IDs	array	No	Profile IDs you want to fetch data for. The Amazon Ads source connector supports only profiles with seller and vendor type, profiles with agency type will be ignored. Note: If Marketplace IDs are also selected, profiles will be selected if they match the Profile ID OR the Marketplace ID.
Marketplace IDs	array	No	Marketplace IDs you want to fetch data for. Note: If Profile IDs are also selected, profiles will be selected if they match the Profile ID OR the Marketplace ID.
Look Back Window	integer	No	The amount of days to go back in time to get the updated data from Amazon Ads. Default `3`.
Number of concurrent threads	integer	No	The number of worker threads to use for the sync. Default `14`.

Something unclear or out of date? Tell us, and we will fix the page.