Amazon Sponsored Product Ads

Amazon Sponsored Product ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	V3
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

All the tables that can be supported in Daton for the Amazon Sponsored Product Ads connector are listed below:

Profile	Portfolio
Store	SponsoredProducts_ProductMetadata
SponsoredProducts_Campaign	SponsoredProducts_CampaignEx
SponsoredProducts_AdGroup	SponsoredProducts_AdGroupEx
SponsoredProducts_BiddableKeyword	SponsoredProducts_BiddableKeywordsEx
SponsoredProducts_NegativeKeyword	SponsoredProducts_NegativeKeywordEx
SponsoredProducts_CampaignNegativeKeyword	SponsoredProducts_CampaignNegativeKeywordEx
SponsoredProducts_ProductAd	SponsoredProducts_ProductAdEx
SponsoredProducts_TargetingClause	SponsoredProducts_TargetingClauseEx
SponsoredProducts_KeywordBidRecommendations	SponsoredProducts_TargetBidRecommendations
SponsoredProducts_SuggestedKeywords	SponsoredProducts_ProductTargetingRecommendations
SponsoredProducts_NegativeTargetingClause	SponsoredProducts_CampaignsReports
SponsoredProducts_PlacementCampaignsReport	SponsoredProducts_AdGroupReport
SponsoredProducts_KeywordReport	SponsoredProducts_SearchTermKeywordReport
SponsoredProducts_ProductAdsReport	SponsoredProducts_TargetingReport
SponsoredProducts_SearchTermTargetingReport	SponsoredProducts_AsinsReportWithTargetId
SponsoredProducts_AsinsReportWithKeywordId	InvoiceDetails
StoresInsights	Store_AsinEngagement

Reports Mapping

The following table represents how Daton maps tables with respect to the reports you see in the Amazon Ad console interface.

Report in Ad console	Report in Daton
Search term	SponsoredProducts_SearchTermKeywordReport
Targeting	SponsoredProducts_SearchTermTargetingReport
Advertised product	SponsoredProducts_ProductAdsReport
Campaign	SponsoredProducts_CampaignsReport
Budget	-
Placement	SponsoredProducts_PlacementCampaignsReport
Purchased product	SponsoredProducts_AsinsReportWithTargetId SponsoredProducts_AsinsReportWithKeywordId
Performance Over Time	-
Search Term Impression Share	-
Gross And Invalid Traffic	-

Authentication Credentials

1. Sponsored Product APIs work for 'Seller' type users. Agency users and Attribution accounts will not have access to APIs

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

Integrate Amazon Sponsored Product Ads with Daton

1. Sign in to Daton.

2. Select Amazon Sponsored Product from the Connectors page.

3. Provide all required configuration parameters - Integration Name, Replication Frequency, History, Region/Marketplace, and Attribution lookback. The integration name would be used while creating tables in the warehouse and cannot be changed later.

4. You will be redirected to the Amazon Advertising login page for authorizing Daton to extract data periodically. Log in 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 the required fields for each table.

8. Submit the integration.

Workflow

1. Integrations would be in configuring state initially. They would be moved to the 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.

Known Issues

1. Amazon reconciles data and may update metrics for up to 30 days. If you want to use 7-day attribution metrics, then you must select 8-day attribution offset in the configuration. Daton will repeat the report data for a given date depending on the attribution offset selected

2. Data would always be fetched for the previous day after 2 AM Seller time

3. There can be mismatches of <1% in metrics even with 30-day attribution selection in Daton

AmazonAds Data

TABLES

Profile

Purpose: Retrieve all profiles associated with the Amazon Advertising account

Replication Type: Full Load

Replication Key: N/A

Portfolio

Purpose: Retrieve a list of up to 100 portfolios

Replication Type: Full Load

Replication Key: N/A

Store

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

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
code	STRING
entityId	STRING
storeName	STRING
brandEntityId	STRING
storePageInfo	RECORD
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
storePageInfo.storePageId	STRING
storePageInfo.storePageUrl	STRING
storePageInfo.storePageName	STRING

InvoiceDetails

Purpose: All Invoice details for at a profile level.

Replication Type: Incremental Key

Replication Key: Invoice Date

Note: Invoices with the status "Accumulating" won't show up as the API does not support them.

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
promotions	RECORD
governmentInvoiceInformation	RECORD
payerContactInfo	RECORD
taxDetail	RECORD
adjustments	RECORD
invoiceLines	RECORD
invoiceSummary	RECORD
issuerContactInfo	RECORD
thirdPartyContactInfo	RECORD
payments	RECORD
portfolios	RECORD

StoresInsights

Purpose: Provides information about your store's performance.

Replication Type: Incremental Key

Replication Key: Date

Note: 'Sales' insight metric is being used, and the data is aggregated by date.

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
brandEntityId	STRING
dimension	STRING
date	DATE
sales	NUMERIC
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Store_AsinEngagement

Purpose: Provides information about your store asin performance.

Replication Type: Incremental Key

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
startDate	DATE
endDate	DATE
brandEntityId	STRING
dimension	STRING
asin	STRING
averageInStockPrice	NUMERIC
renders	NUMERIC
averageSalePrice	NUMERIC
inStockRate	NUMERIC
clickRate	NUMERIC
clicks	NUMERIC
orders	NUMERIC
conversionRate	NUMERIC
units	NUMERIC
views	NUMERIC
inStockViews	NUMERIC
addToCarts	NUMERIC
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_ProductMetadata

Purpose: The Amazon Product Selector API allows integrators to receive product metadata such as inventory status, price, eligibility status, and product details for SKUS or ASINs in their Product Catalog in order to launch, manage or optimize Sponsored Products, Sponsored Brands, or Sponsored Display advertising campaigns. The Product Selector API is available to Sellers, Vendors, and Authors

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
fetchDate	DATE
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
adId	STRING
campaignId	STRING
adGroupId	STRING
state	STRING
creationDate	STRING
lastUpdatedDate	STRING
servingStatus	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_Campaign

Purpose: Return a list of Sponsored Products campaigns

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Datatype
RequestTime	TIMESTAMP
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
profileId	STRING
campaignId	STRING
name	STRING
campaignType	STRING
targetingType	STRING
state	STRING
dailyBudget	NUMERIC
startDate	STRING
premiumBidAdjustment	BOOLEAN
bidding	RECORD
Level 2strategy	STRING
Level 2adjustments	RECORD
portfolioId	INTEGER
tags	STRING
endDate	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_CampaignEx

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

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_AdGroup

Purpose: Return a list of ad groups

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
adGroupId	STRING
campaignId	STRING
name	STRING
defaultBid	NUMERIC
state	STRING
daton_user_id	NUMERIC
daton_batch_runtime	NUMERIC
daton_batch_id	NUMERIC

SponsoredProducts_AdGroupEx

Purpose: Return a list of ad groups with additional properties

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_BiddableKeyword

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

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
targetId	INTEGER
campaignId	STRING
adGroupId	STRING
state	STRING
keywordText	STRING
matchType	STRING
bid	NUMERIC
nativeLanguageKeyword	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_BiddableKeywordsEx

Purpose: Return a list of ad group-level biddable keywords with additional properties

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
keywordId	INTEGER
campaignId	STRING
adGroupId	STRING
state	STRING
keywordText	STRING
matchType	STRING
creationDate	STRING
lastUpdatedDate	STRING
servingStatus	STRING
bid	NUMERIC
nativeLanguageKeyword	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_NegativeKeyword

Purpose: Return a list of negative ad group-level keywords

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
keywordId	INTEGER
campaignId	STRING
adGroupId	STRING
state	STRING
keywordText	STRING
matchType	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_NegativeKeywordEx

Purpose: Return a list of negative ad group-level keywords with additional properties

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_CampaignNegativeKeyword

Purpose: Return a list of campaign level negative keywords

Replication: Full Replication

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
profileId	STRING
keywordId	INTEGER
campaignId	STRING
state	STRING
keywordText	STRING
matchType	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_CampaignNegativeKeywordEx

Purpose: Return a list of campaign level negative keywords with additional properties

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_ProductAd

Purpose: Return a list of product ads

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
fetchDate	DATE
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
adId	STRING
campaignId	STRING
adGroupId	STRING
state	STRING
creationDate	STRING
lastUpdatedDate	STRING
servingStatus	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_ProductAdEx

Purpose: Return a list of product ads with additional properties

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_TargetingClause

Purpose: List targeting expressions

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
profileId	STRING
targetId	INTEGER
campaignId	STRING
adGroupId	STRING
state	STRING
resolvedExpression	RECORD
expression	RECORD
expressionType	STRING
bid	NUMERIC
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_TargetingClauseEx

Purpose: List targeting expressions with additional properties

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_KeywordBidRecommendations

Purpose: Gets a bid recommendation for keywords

Replication Type: Full Load

Replication Key: N/A

FIELDS

RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
adGroupId	STRING
recommendations	RECORD
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	auto-targetingNUMERIC

SponsoredProducts_TargetBidRecommendations

Purpose: Gets a list of bid recommendations for a keyword, product, or auto-targeting expressions

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
adGroupId	STRING
recommendations	RECORD
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_SuggestedKeywords

Purpose: Gets suggested keywords for a specified list of ASINs

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
keywordText	STRING
matchType	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_ProductTargetingRecommendations

Purpose: Gets a list of recommended products for targeting

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
recommendedProducts	RECORD
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_NegativeTargetingClause

Purpose: Gets a list of negative targeting clauses

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
targetId	INTEGER
campaignId	STRING
adGroupId	STRING
state	STRING
expression	RECORD
expressionType	STRING
resolvedExpression	RECORD
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_NegativeTargetingClauseEx

Purpose: Gets a list of negative targeting clauses

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_BudgetRecommendations

Purpose: Retrieves the estimated budget needed to keep the campaign within the budget for the full 24-hour period.

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
fetchDate	DATE
budgetRecommendationsSuccessResults	RECORD
budgetRecommendationsErrorResults	RECORD
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

SponsoredProducts_BudgetUsage

Purpose: Retrieves the budget usage for an advertised product.

Replication Type: Key Based Replication

Replication Key: Date

FIELDS