# Amazon Marketing Cloud (AMC)

### Snapshot

<table data-full-width="true"><thead><tr><th>Features</th><th>Details</th></tr></thead><tbody><tr><td>Release Status</td><td>Released</td></tr><tr><td>Source API Version</td><td>v1</td></tr><tr><td>Table Selection</td><td>Yes</td></tr><tr><td>Column Selection</td><td>Not available because the columns selected in the SQL query will be added</td></tr><tr><td>Edit Integration</td><td>Yes</td></tr><tr><td>Replication Type Selection</td><td>No</td></tr><tr><td>Authentication Parameters</td><td>OAuth using Amazon Ad Console login</td></tr><tr><td>Replication Type</td><td>Key Based Incremental</td></tr><tr><td>Replication Key</td><td>Date</td></tr><tr><td>Suggested Replication Frequency</td><td>12 hours</td></tr><tr><td>Supports attribution</td><td>Yes</td></tr></tbody></table>

## Instructions to Integrate Amazon Marketing Cloud (AMC) with Daton

### Prerequisites

1. **Advertiser ID**
   * Click [here](https://advertising.amazon.com/solutions/products/amazon-marketing-cloud) **OR** log in to the [Amazon Ad console](https://advertising.amazon.com/) 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.**

     <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2Fqz1MA3bRyD6Hd4T31UdB%2FScreenshot%202023-05-19%20at%203.57.31%20PM.png?alt=media&#x26;token=6aba9f49-5618-475d-a043-9b5ee397eb4c" alt=""><figcaption></figcaption></figure>
2. **MarketPlace ID**\
   Click [here](https://developer-docs.amazon.com/sp-api/docs/marketplace-ids) to retrieve the list of marketplace IDs for each region:&#x20;

{% tabs %}
{% tab title="North America" %}

<table><thead><tr><th width="173">Country</th><th>Marketplace ID</th><th>Country code</th></tr></thead><tbody><tr><td>Canada</td><td>A2EUQ1WTGCTBG2</td><td>CA</td></tr><tr><td>United States of America</td><td>ATVPDKIKX0DER</td><td>US</td></tr><tr><td>Mexico</td><td>A1AM78C64UM0Y8</td><td>MX</td></tr><tr><td>Brazil</td><td>A2Q3Y263D00KWC</td><td>BR</td></tr></tbody></table>
{% endtab %}

{% tab title="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           |
| {% endtab %}         |                |              |

{% tab title="Far East" %}

<table><thead><tr><th width="127">Country</th><th>Marketplace ID</th><th>Country code</th></tr></thead><tbody><tr><td>Singapore</td><td>A19VAU5U5O7RUS</td><td>SG</td></tr><tr><td>Australia</td><td>A39IBJ37TRP1C6</td><td>AU</td></tr><tr><td>Japan</td><td>A1VC38T7YXB528</td><td>JP</td></tr></tbody></table>
{% endtab %}
{% endtabs %}

3. **Instance ID**
   * Click [here](https://advertising.amazon.com/solutions/products/amazon-marketing-cloud) **OR** log in to [Amazon](https://advertising.amazon.com/?ref_=logo) and move to the marketing cloud section and on the following page.<br>

     <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FMSudCnlXFz2KQ4tt3gCt%2FScreenshot%202023-05-19%20at%204.05.53%20PM.png?alt=media&#x26;token=a0349c6b-dd3c-487c-9421-802a06c4ccd2" alt=""><figcaption></figcaption></figure>
   * **Save the Instance ID** for the respective brand name, for later use.

### Integrate Amazon Marketing Cloud (AMC) with Daton

1. [Sign in](https://daton.sarasanalytics.com/login) 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**](#a-dvertiser-id), [**Instance ID**](#instance-id), [**Marketplace ID**](#marketplace-id)**,** and the **queries**.\
   \&#xNAN;*Please Note, the **Integration Name** would be used in creating tables for the integration and cannot be changed later.*&#x20;
4. You will be redirected to the Amazon Advertising **login page** to authorize Daton to extract data periodically. [Log in](https://sellercentral.amazon.in/ap/signin?openid.pape.max_auth_age=0\&openid.return_to=https%3A%2F%2Fsellercentral.amazon.in%2Fhome\&openid.identity=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0%2Fidentifier_select\&openid.assoc_handle=sc_in_amazon_v2\&openid.mode=checkid_setup\&language=en_IN\&openid.claimed_id=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0%2Fidentifier_select\&pageId=sc_in_amazon_v2\&openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0\&ssoResponse=eyJ6aXAiOiJERUYiLCJlbmMiOiJBMjU2R0NNIiwiYWxnIjoiQTI1NktXIn0.0Nczj6vqViwgBSE0EnF0-RP1AzFInm3Rf9y-5d4ErZnMbSDl7mqbVg.XRhB176hxBzz1NS2.jxTpFDrf7MDBDXWL7DpJKuI3fvwrr4HYmw7sJ5ZpPy-PCW9ILHvSCQgMgm42CtFusb8uIGXHC-y2YuC20Aj4xSWW2osE9tTmi9LX8HmePnmCoLkMNK3_K9KztrjsQlAu0lo7FWt5eP6IF275AFIrow7ERVBoHxOkCUzQ-mJHgyeRnHk2d_u3exDiYvNi0AehA0Rwmun-8yMmU0qZQhDZ89lwgfKhwrz3oiMbnB_U9YpI3ZaeMuBcyvPsPfd-cNAVBjcSh3E0we1myzFJsv3U3n7_HwSd8txzxL6rgdQ5nvT5-kaVYQc2yUfradoVHLgZ7t6qtW9hJmm70Y4N0_p3oeYRyLsoDcrBm8MA639WJEXfzrYexU3TtJfC55h-7UM-_U6IicglNb2Kt8vXNaC-MP2OfJh0AePCxImoK00Kd7r3mmQNaZ1BUpyngi_lhrYi7u4FoLb9dBUMTEDWMxKC-Dh9zteb7ToJnvt_Wqwn1wdvmqFj0mYvRnhZeAJfTPghDaBPm3fQo5r9NqOpU65dCzqTYNOG.Uj4_FE18rAc-A30wlieDUg) 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.&#x20;
* 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.