Snapshot

Integrate AmazonAds with Daton

1. Signin to Daton.

2. Select AmazonAds from Integrations page

3. Provide Integration Name, Replication Frequency, History and Region/Marketplace associated with your Amazon Advertising account. Integration name would be used in creating tables for the integration and cannot be changed later.

4. You will be redirected to Amazon Advertising login for authorizing Daton to extract data periodically.

5. Post successful 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 which you need daton to pull.

7. Then select required fields for each table.

8. Submit the integration.

Workflow

1. Integrations could be seen Active tab of Integration List while the job loads data on to the configured 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.

AmazonAds Data

TABLES

Profile

Purpose: Retrieve all profiles associated with the Amazon Advertising account.

Replication: Full Replication

Replication Key: N/A

Fields

Portfolio

Purpose: Retrieve a list of up to 100 portfolios.

Replication: Full Replication

Replication Key: N/A

Fields

Store

Purpose: List store information for all registered stores under an advertiser.

Replication: Full Replication

Replication Key: N/A

Fields

SponsoredProducts_Campaign

Purpose: Return a list of Sponsored Products campaigns.

Replication: Full Replication

Replication Key: N/A

Fields

SponsoredProducts_CampaignEx

Purpose: Return a list of Sponsored Products campaigns with additional properties.

Replication: Full Replication

Replication Key: N/A

Fields

SponsoredProducts_AdGroup

Purpose: Return a list of ad groups.

Replication: Full Replication

Replication Key: N/A

Fields

SponsoredProducts_AdGroupEx

Purpose: Return a list of ad groups with additional properties

Replication: Full Replication

Replication Key: N/A

Fields

SponsoredProducts_BiddableKeyword

Purpose: Return a list of ad group-level biddable keywords.

Replication: Full Replication

Replication Key: N/A

Fields