# 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="/files/GMfGs83RnvhLNoHudspF" 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="/files/4ZuHVSXAUbLNT6MOHJx3" 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/advertising/amazon-marketing-cloud-amc.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.