Schema Information for Amazon Sponsored Products
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:
- Essential Attributes and Supported Tables for Amazon Sponsored Products
- Setup Instructions for Amazon Sponsored Products
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 |
