Schema Information for Amazon Sponsored Products

Saras Daton

Need help with something?

Talk to data expert

Schema Information for Amazon Sponsored Products

In this article, we will look at the schema information of the supported APIs and tables for Amazon Sponsored Products.

Find the links to other articles related to Amazon Sponsored Products Below:

Tables/APIs/Reports

The following is the list of tables or APIs associated with the connector:

APIs

Profile

Purpose: Retrieve all profiles associated with the Amazon Advertising account

Source API Documentation: Amazon Sponsored Product Ads - Profile

Replication Type: Full Load

Replication Key: N/A

Portfolio

Purpose: Retrieve a list of up to 100 portfolios

Source API Documentation: Amazon Sponsored Product Ads - Portfolio

Replication Type: Full Load

Replication Key: N/A

Store

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

Source API Documentation: Amazon Sponsored Product Ads - Store

Replication Type: Full Load

Replication Key: N/A

InvoiceDetails

Purpose: All Invoice details for at a profile level.

Source API Documentation: Amazon Ads- Invoice Details

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

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

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

Source API Documentation: Amazon Sponsored Product Ads - Product Metadata

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

Campaign

Purpose: Return a list of Sponsored Products campaigns

Source API Documentation: Amazon Sponsored Product Ads - Campaign

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

CampaignEx

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

Source API Documentation: Amazon Sponsored Product Ads - Campaign Extended

Replication Type: Full Load

Replication Key: N/A

AdGroup

Purpose: Return a list of ad groups

Source API Documentation: Amazon Sponsored Product Ads - Ad Group

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

AdGroupEx

Purpose: Return a list of ad groups with additional properties

Source API Documentation: Amazon Sponsored Product Ads - Ad Group Extended

Replication Type: Full Load

Replication Key: N/A

BiddableKeyword

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

Source API Documentation: Amazon Sponsored Product Ads - Keyword

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

BiddableKeywordsEx

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

Source API Documentation: Amazon Sponsored Product Ads - Keyword Extended

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

NegativeKeyword

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

Source API Documentation: Amazon Sponsored Product Ads - Negative Keyword

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

NegativeKeywordEx

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

Source API Documentation: Amazon Sponsored Product Ads - Negative Keyword Extended

Replication Type: Full Load

Replication Key: N/A

CampaignNegativeKeyword

Purpose: Return a list of campaign-level negative keywords

Source API Documentation: Amazon Sponsored Product Ads - Campaign Negative Keyword

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

CampaignNegativeKeywordEx

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

Source API Documentation: Amazon Sponsored Product Ads - Campaign Negative Keyword Extended

Replication Type: Full Load

Replication Key: N/A

ProductAd

Purpose: Return a list of product ads

Source API Documentation: Amazon Sponsored Product Ads - 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

ProductAdEx

Purpose: Return a list of product ads with additional properties

Source API Documentation: Amazon Sponsored Product Ads - Product Ads Extended

Replication Type: Full Load

Replication Key: N/A

TargetingClause

Purpose: List targeting expressions

Source API Documentation: Amazon Sponsored Product Ads - Product Targeting

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

TargetingClauseEx

Purpose: List targeting expressions with additional properties

Source API Documentation: Amazon Sponsored Product Ads - Product Targeting Extended

Replication Type: Full Load

Replication Key: N/A

KeywordBidRecommendations

Purpose: Gets a bid recommendation for keywords

Source API Documentation: Amazon Sponsored Product Ads - Bid Recommendations for 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
adGroupId	STRING
recommendations	RECORD

TargetBidRecommendations

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

Source API Documentation: Amazon Sponsored Product Ads - Bid Recommendations

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

SuggestedKeywords

Purpose: Gets suggested keywords for a specified list of ASINs

Source API Documentation: Amazon Sponsored Product Ads - Suggested 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
keywordText	STRING
matchType	STRING

ProductTargetingRecommendations

Purpose: Gets a list of recommended products for targeting

Source API Documentation: Amazon Sponsored Product Ads - Product Targeting Recommendations

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

NegativeTargetingClause

Purpose: Gets a list of negative targeting clauses

Source API Documentation: Amazon Sponsored Product Ads - 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

NegativeTargetingClauseEx

Purpose: Gets a list of negative targeting clauses

Source API Documentation: Amazon Sponsored Product Ads - Negative Targeting Clauses Extended

Replication Type: Full Load

Replication Key: N/A

BudgetRecommendations

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

Source API Documentation: Amazon Sponsored Product Ads - Budget recommendations and missed opportunities

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

BudgetUsage

Purpose: Retrieves the budget usage for an advertised product.

Source API Documentation: Amazon Sponsored Product Ads - Budget Usage

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
success	RECORD
error	RECORD

ConsolidatedRecommendations

Purpose: Gets the top consolidated recommendations across bid, budget, and targeting for campaigns given an advertiser profile id.

Source API Documentation: Amazon Sponsored Product Ads - Budget Usage

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
recommendations	RECORD

Invoices

Purpose: Gets invoices for advertisers.

Source API Documentation: Amazon Sponsored Product Ads - Invoices

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
invoiceSummaries	RECORD

KeywordRecommendations

Purpose: Gets Keyword Recommendations for advertisers.

Source API Documentation: Amazon Sponsored Product Ads - Keyword Recommendations

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
keywordTargetList	RECORD
impactMetrics	RECORD

ThemeBasedBidRecommendation

Purpose: Gets theme-based bid recommendations for new or existing ad groups for advertisers.

Source API Documentation: Amazon Sponsored Product Ads - Theme-Based Bid Recommendations

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
bidRecommendations	RECORD

Store_AsinEngagement

Purpose: Gets theme-based bid recommendations for new or existing ad groups for advertisers.

Source API Documentation: Amazon Sponsored Product Ads - StoreAsinEngagement

Replication Type: Incremental

Replication Key: N/A

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

StoresInsights

Purpose: Gets theme-based bid recommendations for new or existing ad groups for advertisers.

Source API Documentation: Amazon Sponsored Product Ads - StoresInsights

Replication Type: Incremental

Replication Key: N/A

FIELDS

Reports

CampaignsReport

Purpose: Retrieves campaign's performance report

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: Campaign

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
reportDate	DATE
bidPlus	NUMERIC
campaignName	STRING
campaignId	STRING
campaignStatus	BOOLEAN
campaignBudget	NUMERIC
impressions	INTEGER
clicks	INTEGER
cost	NUMERIC
attributedConversions1d	INTEGER
attributedConversions7d	INTEGER
attributedConversions14d	INTEGER
attributedConversions30d	INTEGER
attributedConversions1dSameSKU	INTEGER
attributedConversions7dSameSKU	INTEGER
attributedConversions14dSameSKU	INTEGER
attributedConversions30dSameSKU	INTEGER
attributedUnitsOrdered1d	INTEGER
attributedUnitsOrdered7d	INTEGER
attributedUnitsOrdered14d	INTEGER
attributedUnitsOrdered30d	INTEGER
attributedSales1d	NUMERIC
attributedSales7d	NUMERIC
attributedSales14d	NUMERIC
attributedSales30d	NUMERIC
attributedSales1dSameSKU	NUMERIC
attributedSales7dSameSKU	NUMERIC
attributedSales14dSameSKU	NUMERIC
attributedSales30dSameSKU	NUMERIC
attributedUnitsOrdered1dSameSKU	INTEGER
attributedUnitsOrdered7dSameSKU	INTEGER
attributedUnitsOrdered14dSameSKU	INTEGER
attributedUnitsOrdered30dSameSKU	INTEGER
applicableBudgetRuleId	STRING
applicableBudgetRuleName	STRING
campaignBudgetType	STRING
campaignRuleBasedBudget	NUMERIC
currency	STRING
costPerClick	NUMERIC
clickThroughRate	NUMERIC
attributedKindleEditionNormalizedPagesRead14d	INTEGER
attributedKindleEditionNormalizedPagesRoyalties14d	INTEGER
spend	NUMERIC

Reports

PlacementCampaignsReport

Purpose: Retrieves campaign's performance report with 'placement' segmentation

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: Placement

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
reportDate	DATE
campaignName	STRING
placement	STRING
bidPlus	NUMERIC
campaignId	STRING
campaignStatus	STRING
campaignBudget	NUMERIC
impressions	INTEGER
clicks	INTEGER
cost	NUMERIC
attributedConversions1d	INTEGER
attributedConversions7d	INTEGER
attributedConversions14d	INTEGER
attributedConversions30d	INTEGER
attributedConversions1dSameSKU	INTEGER
attributedConversions7dSameSKU	INTEGER
attributedConversions14dSameSKU	INTEGER
attributedConversions30dSameSKU	INTEGER
attributedUnitsOrdered1d	INTEGER
attributedUnitsOrdered7d	INTEGER
attributedUnitsOrdered14d	INTEGER
attributedUnitsOrdered30d	INTEGER
attributedSales1d	NUMERIC
attributedSales7d	NUMERIC
attributedSales14d	NUMERIC
attributedSales30d	NUMERIC
attributedSales1dSameSKU	NUMERIC
attributedSales7dSameSKU	NUMERIC
attributedSales14dSameSKU	NUMERIC
attributedSales30dSameSKU	NUMERIC
attributedUnitsOrdered1dSameSKU	INTEGER
attributedUnitsOrdered7dSameSKU	INTEGER
attributedUnitsOrdered14dSameSKU	INTEGER
attributedUnitsOrdered30dSameSKU	INTEGER
applicableBudgetRuleId	STRING
applicableBudgetRuleName	STRING
campaignBudgetType	STRING
campaignRuleBasedBudget	NUMERIC
currency	STRING
costPerClick	NUMERIC
clickThroughRate	NUMERIC
attributedKindleEditionNormalizedPagesRead14d	INTEGER
attributedKindleEditionNormalizedPagesRoyalties14d	INTEGER

AdGroupReport

Purpose: Retrieves ad-group performance report

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
reportDate	DATE
campaignName	STRING
campaignId	STRING
adGroupName	STRING
adGroupId	STRING
impressions	INTEGER
clicks	INTEGER
cost	NUMERIC
currency	STRING
attributedConversions1d	INTEGER
attributedConversions7d	INTEGER
attributedConversions14d	INTEGER
attributedConversions30d	INTEGER
attributedConversions1dSameSKU	INTEGER
attributedConversions7dSameSKU	INTEGER
attributedConversions14dSameSKU	INTEGER
attributedConversions30dSameSKU	INTEGER
attributedUnitsOrdered1d	INTEGER
attributedUnitsOrdered7d	INTEGER
attributedUnitsOrdered14d	INTEGER
attributedUnitsOrdered30d	INTEGER
attributedSales1d	NUMERIC
attributedSales7d	NUMERIC
attributedSales14d	NUMERIC
attributedSales30d	NUMERIC
attributedSales1dSameSKU	NUMERIC
attributedSales7dSameSKU	NUMERIC
attributedSales14dSameSKU	NUMERIC
attributedSales30dSameSKU	NUMERIC
attributedUnitsOrdered1dSameSKU	INTEGER
attributedUnitsOrdered7dSameSKU	INTEGER
attributedUnitsOrdered14dSameSKU	INTEGER
attributedUnitsOrdered30dSameSKU	INTEGER
campaignBudget	NUMERIC
campaignBudgetType	STRING
campaignStatus	STRING
costPerClick	NUMERIC
clickThroughRate	NUMERIC
attributedKindleEditionNormalizedPagesRead14d	INTEGER
attributedKindleEditionNormalizedPagesRoyalties14d	INTEGER
adStatus	STRING
biddingStrategy	STRING
spend	NUMERIC

KeywordReport

Purpose: Retrieves keyword performance report

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountId	STRING
reportDate	DATE
campaignName	STRING
campaignId	STRING
adGroupName	STRING
adGroupId	STRING
keywordId	STRING
keywordText	STRING
matchType	STRING
impressions	INTEGER
clicks	INTEGER
cost	NUMERIC
attributedConversions1d	INTEGER
attributedConversions7d	INTEGER
attributedConversions14d	INTEGER
attributedConversions30d	INTEGER
attributedConversions1dSameSKU	INTEGER
attributedConversions7dSameSKU	INTEGER
attributedConversions14dSameSKU	INTEGER
attributedConversions30dSameSKU	INTEGER
attributedUnitsOrdered1d	INTEGER
attributedUnitsOrdered7d	INTEGER
attributedUnitsOrdered14d	INTEGER
attributedUnitsOrdered30d	INTEGER
attributedSales1d	NUMERIC
attributedSales7d	NUMERIC
attributedSales14d	NUMERIC
attributedSales30d	NUMERIC
attributedSales1dSameSKU	NUMERIC
attributedSales7dSameSKU	NUMERIC
attributedSales14dSameSKU	NUMERIC
attributedSales30dSameSKU	NUMERIC
attributedUnitsOrdered1dSameSKU	INTEGER
attributedUnitsOrdered7dSameSKU	INTEGER
attributedUnitsOrdered14dSameSKU	INTEGER
attributedUnitsOrdered30dSameSKU	INTEGER
campaignBudget	NUMERIC
campaignBudgetType	STRING
campaignStatus	STRING
currency	STRING
keywordStatus	STRING
costPerClick	NUMERIC
clickThroughRate	NUMERIC
acosClicks7d	NUMERIC
acosClicks14d	NUMERIC

SearchTermKeywordReport

Purpose: Retrieves keyword performance report with 'query' segmentation

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: Search term

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
reportDate	DATE
query	STRING
campaignName	STRING
campaignId	STRING
adGroupName	STRING
adGroupId	STRING
keywordId	STRING
keywordText	STRING
matchType	STRING
impressions	INTEGER
clicks	INTEGER
cost	NUMERIC
attributedConversions1d	INTEGER
attributedConversions7d	INTEGER
attributedConversions14d	INTEGER
attributedConversions30d	INTEGER
attributedConversions1dSameSKU	INTEGER
attributedConversions7dSameSKU	INTEGER
attributedConversions14dSameSKU	INTEGER
attributedConversions30dSameSKU	INTEGER
attributedUnitsOrdered1d	INTEGER
attributedUnitsOrdered7d	INTEGER
attributedUnitsOrdered14d	INTEGER
attributedUnitsOrdered30d	INTEGER
attributedSales1d	NUMERIC
attributedSales7d	NUMERIC
attributedSales14d	NUMERIC
attributedSales30d	NUMERIC
attributedSales1dSameSKU	NUMERIC
attributedSales7dSameSKU	NUMERIC
attributedSales14dSameSKU	NUMERIC
attributedSales30dSameSKU	NUMERIC
attributedUnitsOrdered1dSameSKU	INTEGER
attributedUnitsOrdered7dSameSKU	INTEGER
attributedUnitsOrdered14dSameSKU	INTEGER
attributedUnitsOrdered30dSameSKU	INTEGER
api	STRING
campaignBudget	NUMERIC
campaignBudgetType	STRING
campaignStatus	STRING
currency	STRING
keywordStatus	STRING
costPerClick	NUMERIC

ProductAdsReport

Purpose: Retrieves performance reports for advertised products

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: Advertised product

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
reportDate	DATE
campaignName	STRING
campaignId	STRING
adGroupName	STRING
adGroupId	STRING
impressions	INTEGER
clicks	INTEGER
cost	NUMERIC
currency	STRING
asin	STRING
sku	STRING
attributedConversions1d	INTEGER
attributedConversions7d	INTEGER
attributedConversions14d	INTEGER
attributedConversions30d	INTEGER
attributedConversions1dSameSKU	INTEGER
attributedConversions7dSameSKU	INTEGER
attributedConversions14dSameSKU	INTEGER
attributedConversions30dSameSKU	INTEGER
attributedUnitsOrdered1d	INTEGER
attributedUnitsOrdered7d	INTEGER
attributedUnitsOrdered14d	INTEGER
attributedUnitsOrdered30d	INTEGER
attributedSales1d	NUMERIC
attributedSales7d	NUMERIC
attributedSales14d	NUMERIC
attributedSales30d	NUMERIC
attributedSales1dSameSKU	NUMERIC
attributedSales7dSameSKU	NUMERIC
attributedSales14dSameSKU	NUMERIC
attributedSales30dSameSKU	NUMERIC
attributedUnitsOrdered1dSameSKU	INTEGER
attributedUnitsOrdered7dSameSKU	INTEGER
attributedUnitsOrdered14dSameSKU	INTEGER
attributedUnitsOrdered30dSameSKU	INTEGER
adId	STRING
campaignBudget	NUMERIC
campaignBudgetType	STRING
campaignStatus	STRING
costPerClick	NUMERIC
clickThroughRate	NUMERIC
acosClicks7d	NUMERIC
acosClicks14d	NUMERIC

ProductTargetingReport

Purpose: Retrieves targets performance report

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: Targeting

Replication Type: Key Based Replication

Replication Key: Date

SearchTermProductTargetingReport

Purpose: Retrieves targets performance report with 'query' segmentation

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

AsinsReportWithTargetId

Purpose: Retrieves purchased product performance report

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: Purchased product

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
reportDate	DATE
campaignName	STRING
campaignId	STRING
adGroupName	STRING
adGroupId	STRING
asin	STRING
otherAsin	STRING
sku	STRING
currency	STRING
matchType	STRING
attributedUnitsOrdered1d	INTEGER
attributedUnitsOrdered7d	INTEGER
attributedUnitsOrdered14d	INTEGER
attributedUnitsOrdered30d	INTEGER
attributedUnitsOrdered1dOtherSKU	NUMERIC
attributedUnitsOrdered14dOtherSKU	NUMERIC
attributedUnitsOrdered30dOtherSKU	NUMERIC
attributedSales1dOtherSKU	NUMERIC
attributedSales7dOtherSKU	NUMERIC
attributedSales14dOtherSKU	NUMERIC
attributedSales30dOtherSKU	NUMERIC
targetingText	STRING
attributedUnitsOrdered7dOtherSKU	INTEGER
targetingExpression	STRING
attributedSales1d	NUMERIC
attributedSales7d	NUMERIC
attributedSales14d	NUMERIC
attributedSales30d	NUMERIC
attributedConversions1d	INTEGER
attributedConversions7d	INTEGER
attributedConversions14d	INTEGER
attributedConversions30d	INTEGER
targetingType	STRING
attributedConversions1dOtherSKU	INTEGER
attributedConversions7dOtherSKU	INTEGER
attributedConversions14dOtherSKU	INTEGER
attributedConversions30dOtherSKU	INTEGER
attributedKindleEditionNormalizedPagesRead14d	INTEGER
attributedKindleEditionNormalizedPagesRoyalties14d	INTEGER
portfolioId	STRING
keywordText	STRING
targetId	STRING

AsinsReportWithKeywordId

Purpose: Retrieves purchased product performance report

ReportName in Seller Central: Purchased product

Source API Documentation: Amazon Sponsored Product Ads - Reports

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
reportDate	DATE
campaignName	STRING
campaignId	STRING
adGroupName	STRING
adGroupId	STRING
keywordId	STRING
keywordText	STRING
asin	STRING
otherAsin	STRING
sku	STRING
currency	STRING
matchType	STRING
attributedUnitsOrdered1d	INTEGER
attributedUnitsOrdered7d	INTEGER
attributedUnitsOrdered14d	INTEGER
attributedUnitsOrdered30d	INTEGER
attributedUnitsOrdered1dOtherSKU	NUMERIC
attributedUnitsOrdered14dOtherSKU	NUMERIC
attributedUnitsOrdered30dOtherSKU	NUMERIC
attributedSales1dOtherSKU	NUMERIC
attributedSales7dOtherSKU	NUMERIC
attributedSales14dOtherSKU	NUMERIC
attributedSales30dOtherSKU	NUMERIC
attributedUnitsOrdered7dOtherSKU	INTEGER
attributedSales1d	NUMERIC
attributedSales7d	NUMERIC
attributedSales14d	NUMERIC
attributedSales30d	NUMERIC
attributedConversions1d	INTEGER
attributedConversions7d	INTEGER
attributedConversions14d	INTEGER
attributedConversions30d	INTEGER
targetingType	STRING
attributedConversions1dOtherSKU	INTEGER
attributedConversions7dOtherSKU	INTEGER
attributedConversions14dOtherSKU	INTEGER
attributedConversions30dOtherSKU	INTEGER
attributedKindleEditionNormalizedPagesRead14d	INTEGER
attributedKindleEditionNormalizedPagesRoyalties14d	INTEGER
portfolioId	STRING
targetId	STRING

TargetingReport

Purpose: Retrieves targets performance report

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: Targeting

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
reportDate	DATE
campaignName	STRING
campaignId	STRING
adGroupName	STRING
adGroupId	STRING
keywordId	STRING
keywordText	STRING
matchType	STRING
impressions	INTEGER
clicks	INTEGER
cost	NUMERIC
attributedConversions1d	INTEGER
attributedConversions7d	INTEGER
attributedConversions14d	INTEGER
attributedConversions30d	INTEGER
attributedConversions1dSameSKU	INTEGER
attributedConversions7dSameSKU	INTEGER
attributedConversions14dSameSKU	INTEGER
attributedConversions30dSameSKU	INTEGER
attributedUnitsOrdered1d	INTEGER
attributedUnitsOrdered7d	INTEGER
attributedUnitsOrdered14d	INTEGER
attributedUnitsOrdered30d	INTEGER
attributedSales1d	NUMERIC
attributedSales7d	NUMERIC
attributedSales14d	NUMERIC
attributedSales30d	NUMERIC
attributedSales1dSameSKU	NUMERIC
attributedSales7dSameSKU	NUMERIC
attributedSales14dSameSKU	NUMERIC
attributedSales30dSameSKU	NUMERIC
attributedUnitsOrdered1dSameSKU	INTEGER
attributedUnitsOrdered7dSameSKU	INTEGER
attributedUnitsOrdered14dSameSKU	INTEGER
attributedUnitsOrdered30dSameSKU	INTEGER
campaignBudget	NUMERIC
campaignBudgetType	STRING
campaignStatus	STRING
currency	STRING
keywordStatus	STRING
costPerClick	NUMERIC
clickThroughRate	NUMERIC
acosClicks7d	NUMERIC

SearchTermTargetingReport

Purpose: Retrieves targets performance report with 'query' segmentation

Source API Documentation: Amazon Sponsored Product Ads - Reports

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name	Data Type
RequestTime	TIMESTAMP
profileId	STRING
countryName	STRING
accountName	STRING
accountId	STRING
reportDate	DATE
query	STRING
campaignName	STRING
campaignId	STRING
adGroupName	STRING
adGroupId	STRING
keywordId	STRING
keywordText	STRING
matchType	STRING
targetId	STRING
targetingExpression	STRING
targetingText	STRING
targetingType	STRING
targeting	STRING
impressions	INTEGER
clicks	INTEGER
cost	NUMERIC
attributedConversions1d	INTEGER
attributedConversions7d	INTEGER
attributedConversions14d	INTEGER
attributedConversions30d	INTEGER
attributedConversions1dSameSKU	INTEGER
attributedConversions7dSameSKU	INTEGER
attributedConversions14dSameSKU	INTEGER
attributedConversions30dSameSKU	INTEGER
attributedUnitsOrdered1d	INTEGER
attributedUnitsOrdered7d	INTEGER
attributedUnitsOrdered14d	INTEGER
attributedUnitsOrdered30d	INTEGER
attributedSales1d	NUMERIC
attributedSales7d	NUMERIC
attributedSales14d	NUMERIC
attributedSales30d	NUMERIC
attributedSales1dSameSKU	NUMERIC
attributedSales7dSameSKU	NUMERIC
attributedSales14dSameSKU	NUMERIC
attributedSales30dSameSKU	NUMERIC
attributedUnitsOrdered1dSameSKU	INTEGER
attributedUnitsOrdered7dSameSKU	INTEGER
attributedUnitsOrdered14dSameSKU	INTEGER
attributedUnitsOrdered30dSameSKU	INTEGER
api	STRING
campaignBudget	NUMERIC

Table of Contents

Tables/APIs/Reports APIs Profile Portfolio Store ProductMetadata Campaign CampaignEx AdGroup AdGroupEx BiddableKeyword BiddableKeywordsEx NegativeKeyword NegativeKeywordEx CampaignNegativeKeyword CampaignNegativeKeywordEx ProductAd ProductAdEx TargetingClause TargetingClauseEx KeywordBidRecommendations TargetBidRecommendations SuggestedKeywords ProductTargetingRecommendations NegativeTargetingClause NegativeTargetingClauseEx BudgetRecommendations BudgetUsage ConsolidatedRecommendations Invoices KeywordRecommendations ThemeBasedBidRecommendation Store_AsinEngagement StoresInsights Reports CampaignsReport Reports PlacementCampaignsReport AdGroupReport KeywordReport SearchTermKeywordReport ProductAdsReport ProductTargetingReport SearchTermProductTargetingReport AsinsReportWithTargetId AsinsReportWithKeywordId TargetingReport SearchTermTargetingReport

Schema Information for Amazon Sponsored Products

Contact Us

Saras Daton