Ask or search…
K
Links

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. 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. 2.
    MarketPlace ID Click here to retrieve the list of marketplace IDs for each region:
North America
Europe
Far East
Country
Marketplace ID
Country code
Canada
A2EUQ1WTGCTBG2
CA
United States of America
ATVPDKIKX0DER
US
Mexico
A1AM78C64UM0Y8
MX
Brazil
A2Q3Y263D00KWC
BR
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
Country
Marketplace ID
Country code
Singapore
A19VAU5U5O7RUS
SG
Australia
A39IBJ37TRP1C6
AU
Japan
A1VC38T7YXB528
JP
  1. 3.
    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. 1.
    Sign in to Daton.
  2. 2.
    Select Amazon Marketing Cloud(AMC) from the Connectors page.
  3. 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. 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. 5.
    After authentication, select the tables for which you have entered a query.
  6. 6.
    Then select the required fields for each table.
  7. 7.
    Submit the integration.

How to write the queries?

  1. 1.
    For AMC the queries have to be written in a particular format:
    1. 1.
      No comments in the query
    2. 2.
      No line breaks
  2. 2.
    To remove line breaks you can use: https://codebeautify.org/remove-line-breaks
  3. 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.