Amazon Marketing Cloud (AMC)
Last updated
Last updated
| 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 |
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.
MarketPlace ID Click here to retrieve the list of marketplace IDs for each region:
| Country | Marketplace ID | Country code |
|---|---|---|
Canada | A2EUQ1WTGCTBG2 | CA |
United States of America | ATVPDKIKX0DER | US |
Mexico | A1AM78C64UM0Y8 | MX |
Brazil | A2Q3Y263D00KWC | BR |
Sign in to Daton.
Select Amazon Marketing Cloud(AMC) from the Connectors page.
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.
You will be redirected to the Amazon Advertising login page to authorize Daton to extract data periodically. Log in with your seller account.
After authentication, select the tables for which you have entered a query.
Then select the required fields for each table.
Submit the integration.
For AMC the queries have to be written in a particular format:
No comments in the query
No line breaks
To remove line breaks you can use: https://codebeautify.org/remove-line-breaks
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.
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.
