Amazon Attribution
Amazon Attribution ETL for data replication

Snapshot

Features
Details
Release Status
Beta
Source API Version
V1
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Login Id and Password
Replication Type
Full Replication Key Based Incremental
Replication Key
Date
Suggested Replication Frequency
24 hours
Supports attribution
Yes
Tables/APIs Supported
Profile
Publisher
NonMacroTemplateTag
MacroTag
Advertiser
PerformanceReport
ProductReport

Authentication Credentials

  1. 1.
    Attribution APIs work only for Attribution accounts. Remaining Amazon ad accounts do not have access to these APIs
  2. 2.
    User account used for authentication must have access to Campaign Manager and all Reports

Integrate Amazon Attribution Ads with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Amazon Attribution from Connectors page
  3. 3.
    Provide all required configuration parameters - Integration Name, Replication Frequency, History, Region/Marketplace, Attribution lookback. Integration name would be used while creating tables in the warehouse and cannot be changed later
  4. 4.
    You will be redirected to Amazon Advertising login page for authorizing Daton to extract data periodically. Login with your seller account
  5. 5.
    After authentication, you will be prompted to choose from the list of available Amazon Advertising Accounts/ProfileIds
  6. 6.
    After account selection, you'll be prompted to select the Tables/APIs for replication
  7. 7.
    Then select required fields for each table
  8. 8.
    Submit the integration

Workflow

  1. 1.
    Integrations would be in configuring state initially. They would be moved to active state when selected tables are created in the warehouse.
  2. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    Users can view job status and process logs from the integration details page by clicking on the integration name from the active list.

Amazon Attribution Data

TABLES

Profile
Purpose: Retrieve all profiles associated with the Amazon Attribution account
Source API Documentation: Amazon Attribution - Profile
Replication Type: Full Load
Replication Key: N/A
Publisher
Purpose: Gets a list of all available publishers.
Source API Documentation: Amazon Attribution - Publisher
Replication Type: Full Load
Replication Key: N/A
NonMacroTemplateTag
Purpose: Gets a list of attribution tags for third-party publisher campaigns that do not support macros.
Source API Documentation: Amazon Attribution - Attribution Tags
Replication Type: Full Load
Replication Key: N/A
MacroTag
Purpose: Gets a list of attribution tags for third-party publisher campaigns that support macros.
Source API Documentation: Amazon Attribution - Attribution Tags
Replication Type: Full Load
Replication Key: N/A
Advertiser
Purpose: Gets a list of advertisers associated with an Amazon Attribution account. For sellers, an attribution profile has one associated advertiser. For vendors, an attribution profile may have more than one associated advertiser.
Source API Documentation: Amazon Attribution - Advertiser
Replication Type: Full Load
Replication Key: N/A
PerformanceReport
Purpose: Retrieves performance report for Campaign, Adgroup and Creative dimensions
Source API Documentation: Amazon Attribution - Reports
ReportName in Seller Central: Campaign
Replication Type: Key Based Replication
Replication Key: Date
ProductReport
Purpose: Retrieves product performance report for Campaign, Adgroup dimensions
Source API Documentation: Amazon Attribution - Reports
ReportName in Seller Central: Promoted product
Replication Type: Key Based Replication
Replication Key: Date
Last modified 9mo ago