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 consoleReport 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

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

FIELDS

Field NameData 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.

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 NameData 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.

Source API Documentation: Amazon Ads Store Insights

Replication Type: Incremental Key

Replication Key: Date

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

FIELDS

Field NameData 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.

Source API Documentation: Amazon Ads Store Asin Engagement

Replication Type: Incremental Key

Replication Key: Date

FIELDS

Field NameData 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

Source API Documentation: Amazon Sponsored Product Ads - Product Metadata

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field NameData 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

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

_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

Source API Documentation: Amazon Sponsored Product Ads - Campaign Extended

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_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

daton_user_id

NUMERIC

daton_batch_runtime

NUMERIC

daton_batch_id

NUMERIC

SponsoredProducts_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

SponsoredProducts_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

_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

Source API Documentation: Amazon Sponsored Product Ads - Keyword Extended

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field NameData 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

Source API Documentation: Amazon Sponsored Product Ads - Negative Keyword

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field NameData 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

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

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_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 NameData 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

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

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_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 NameData 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

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

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_TargetingClause

Purpose: List targeting expressions

Source API Documentation: Amazon Sponsored Product Ads - Product Targeting

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field NameData 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

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

Replication Type: Full Load

Replication Key: N/A

SponsoredProducts_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

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

Source API Documentation: Amazon Sponsored Product Ads - Bid Recommendations

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field NameData 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

Source API Documentation: Amazon Sponsored Product Ads - Suggested Keywords

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field NameData 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

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

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field NameData 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

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

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field NameData 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

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

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.

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

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field NameData 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.

Source API Documentation: Amazon Sponsored Product Ads - Budget Usage

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field NameData Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

success

RECORD

error

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredProducts_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 NameData Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

recommendations

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredProducts_Invoices

Purpose: Gets invoices for advertisers.

Source API Documentation: Amazon Sponsored Product Ads - Invoices

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field NameData Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

invoiceSummaries

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredProducts_KeywordRecommendations

Purpose: Gets Keyword Recommendationsces for advertisers.

Source API Documentation: Amazon Sponsored Product Ads - Keyword Recommendations

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field NameData Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

adGroupId

STRING

keywordTargetList

RECORD

impactMetrics

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredProducts_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 NameData Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

bidRecommendations

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

REPORTS

SponsoredProducts_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 NameData 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

SponsoredProducts_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 NameData 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

SponsoredProducts_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 NameData 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

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredProducts_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 NameData 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

SponsoredProducts_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 NameData 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

SponsoredProducts_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 NameData 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

SponsoredProducts_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

SponsoredProducts_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

SponsoredProducts_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 NameData 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

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredProducts_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 NameData 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

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredProducts_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

Field NameData 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

SponsoredProducts_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

Field NameData 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

Last updated