Amazon Marketing Cloud (AMC)

Snapshot

Features	Details
Release Status	Released
Source API Version	v1
Table Selection	Yes
Column Selection	Not available because the columns selected in the SQL query will be added
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	OAuth using Amazon Ad Console login
Replication Type	Key Based Incremental
Replication Key	Date
Suggested Replication Frequency	12 hours
Supports attribution	Yes

Instructions to Integrate Amazon Marketing Cloud (AMC) with Daton

Prerequisites

1. Advertiser ID

   • Click here OR log in to the Amazon Ad console and move to the Marketing Cloud section.

   • Click on the brand name in the upper right-hand corner next to the notification icon.

   • Here you will find your advertiser ID.

     
2. MarketPlace ID Click here to retrieve the list of marketplace IDs for each region:

North America

Country	Marketplace ID	Country code
Canada	A2EUQ1WTGCTBG2	CA
United States of America	ATVPDKIKX0DER	US
Mexico	A1AM78C64UM0Y8	MX
Brazil	A2Q3Y263D00KWC	BR

Europe

Country	Marketplace ID	Country code
Spain	A1RKKUPIHCS9HS	ES
United Kingdom	A1F83G8C2ARO7P	UK
France	A13V1IB3VIYZZH	FR
Belgium	AMEN7PMS3EDWL	BE
Netherlands	A1805IZSGTT6HS	NL
Germany	A1PA6795UKMFR9	DE
Italy	APJ6JRA9NG5V4	IT
Sweden	A2NODRKZP88ZB9	SE
South Africa	AE08WJ6YKNBMC	ZA
Poland	A1C3SOZRARQ6R3	PL
Egypt	ARBP9OOSHTCHU	EG
Turkey	A33AVAJ2PDY3EV	TR
Saudi Arabia	A17E79C6D8DWNP	SA
United Arab Emirates	A2VIGQ35RCS4UG	AE
India	A21TJRUUN4KGV	IN

Far East

Country	Marketplace ID	Country code
Singapore	A19VAU5U5O7RUS	SG
Australia	A39IBJ37TRP1C6	AU
Japan	A1VC38T7YXB528	JP

1. Instance ID

   • Click here OR log in to Amazon and move to the marketing cloud section and on the following page.

     
   • Save the Instance ID for the respective brand name, for later use.

Integrate Amazon Marketing Cloud (AMC) with Daton

1. Sign in to Daton.
2. Select Amazon Marketing Cloud(AMC) from the Connectors page.

3. Provide the necessary configuration parameters - Integration Name, Replication Frequency, History, Region/Marketplace, Advertiser ID, Instance ID, Marketplace ID, and the queries. Please Note, the Integration Name would be used in creating tables for the integration and cannot be changed later.
4. You will be redirected to the Amazon Advertising login page to authorize Daton to extract data periodically. Log in with your seller account.
5. After authentication, select the tables for which you have entered a query.

6. Then select the required fields for each table.

7. Submit the integration.

How to write the queries?

1. For AMC the queries have to be written in a particular format:

   1. No comments in the query

   2. No line breaks

2. To remove line breaks you can use: https://codebeautify.org/remove-line-breaks
3. Enter your query in the upper box and you will have a query without any line breaks in the lower box, please use this query as input on Daton.

Tables Supported

• The tables are based on the query a user inputs.

• In the second step of the integration creation please enter the queries you want to run against your AMC database and select those tables in the next step. For instance, If you add 3 queries namely, query1, query2, and query3 in the text inputs, you will select those tables in the subsequent step in the table selection.