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. Attribution APIs work only for Attribution accounts. Remaining Amazon ad accounts do not have access to these APIs

2. User account used for authentication must have access to Campaign Manager and all Reports

Integrate Amazon Attribution Ads with Daton

1. Signin to Daton

2. Select Amazon Attribution from Connectors page

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. You will be redirected to Amazon Advertising login page for authorizing Daton to extract data periodically. Login with your seller account

5. After authentication, you will be prompted to choose from the list of available Amazon Advertising Accounts/ProfileIds

6. After account selection, you'll be prompted to select the Tables/APIs for replication

7. Then select required fields for each table

8. Submit the integration

Workflow

1. Integrations would be in configuring state initially. They would be moved to active state when selected tables are created in the warehouse.

2. Users would be able to edit/pause/re-activate/delete integration anytime

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