# Amazon Sponsored Product Ads

### 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                | <p>Full Replication<br>Key Based Incremental</p> |
| 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.

<table><thead><tr><th width="208.5">Report in Ad console</th><th>Report in Daton</th></tr></thead><tbody><tr><td>Search term</td><td><code>SponsoredProducts_SearchTermKeywordReport</code></td></tr><tr><td>Targeting</td><td><code>SponsoredProducts_SearchTermTargetingReport</code></td></tr><tr><td>Advertised product</td><td><code>SponsoredProducts_ProductAdsReport</code></td></tr><tr><td>Campaign</td><td><code>SponsoredProducts_CampaignsReport</code></td></tr><tr><td>Budget</td><td>-</td></tr><tr><td>Placement</td><td><code>SponsoredProducts_PlacementCampaignsReport</code></td></tr><tr><td>Purchased product</td><td><code>SponsoredProducts_AsinsReportWithTargetId</code><br><code>SponsoredProducts_AsinsReportWithKeywordId</code></td></tr><tr><td>Performance Over Time</td><td>-</td></tr><tr><td>Search Term Impression Share</td><td>-</td></tr><tr><td>Gross And Invalid Traffic</td><td>-</td></tr></tbody></table>

### 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
4. Read more on attribution -  \[FAQs] (<https://docs.sarasanalytics.com/faqs/faqs/amazon-advertising-faqs>)

### AmazonAds Data

#### TABLES

**Profile**

Purpose: Retrieve all profiles associated with the Amazon Advertising account

Source API Documentation:  [Amazon Sponsored Product Ads - Profile](https://advertising.amazon.com/API/docs/en-us/reference/2/profiles)

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](https://advertising.amazon.com/API/docs/en-us/reference/2/portfolios)

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](https://advertising.amazon.com/API/docs/en-us/reference/2/stores)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name                  | Data Type |
| --------------------------- | --------- |
| RequestTime                 | TIMESTAMP |
| profileId                   | STRING    |
| countryName                 | STRING    |
| accountName                 | STRING    |
| accountId                   | STRING    |
| fetchDate                   | DATE      |
| code                        | STRING    |
| entityId                    | STRING    |
| storeName                   | STRING    |
| brandEntityId               | STRING    |
| storePageInfo               | RECORD    |
| \_daton\_user\_id           | NUMERIC   |
| \_daton\_batch\_runtime     | NUMERIC   |
| \_daton\_batch\_id          | NUMERIC   |
| storePageInfo.storePageId   | STRING    |
| storePageInfo.storePageUrl  | STRING    |
| storePageInfo.storePageName | STRING    |

**InvoiceDetails**

Purpose: All Invoice details for at a profile level.

Source API Documentation:  [Amazon Ads- Invoice Details](https://advertising.amazon.com/API/docs/en-us/billing#tag/invoice/operation/getInvoice)

Replication Type: Incremental Key

Replication Key: Invoice Date

{% hint style="info" %}
Note: Invoices with the status "Accumulating"  won't show up as the API does not support them.
{% endhint %}

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

**StoresInsights**

Purpose: Provides information about your store's performance.&#x20;

Source API Documentation:   [Amazon Ads Store Insights](https://advertising.amazon.com/API/docs/en-us/stores/open-api#tag/Stores-Analytics/operation/getInsightsForStoreAPI)

Replication Type: Incremental Key

Replication Key: Date

{% hint style="info" %}
Note: 'Sales' insight metric is being used, and the data is aggregated by date.
{% endhint %}

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| brandEntityId           | STRING    |
| dimension               | STRING    |
| date                    | DATE      |
| sales                   | NUMERIC   |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**Store\_AsinEngagement**

Purpose: Provides information about your store asin performance.

Source API Documentation:  [Amazon Ads Store Asin Engagement](https://advertising.amazon.com/API/docs/en-us/stores/open-api#tag/Stores-Analytics/operation/getAsinEngagementForStore)

Replication Type: Incremental Key

Replication Key: Date

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| startDate               | DATE      |
| endDate                 | DATE      |
| brandEntityId           | STRING    |
| dimension               | STRING    |
| asin                    | STRING    |
| averageInStockPrice     | NUMERIC   |
| renders                 | NUMERIC   |
| averageSalePrice        | NUMERIC   |
| inStockRate             | NUMERIC   |
| clickRate               | NUMERIC   |
| clicks                  | NUMERIC   |
| orders                  | NUMERIC   |
| conversionRate          | NUMERIC   |
| units                   | NUMERIC   |
| views                   | NUMERIC   |
| inStockViews            | NUMERIC   |
| addToCarts              | NUMERIC   |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredProducts\_ProductMetadata**

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

Source API Documentation:  [Amazon Sponsored Product Ads - Product Metadata](https://advertising.amazon.com/API/docs/en-us/product-metadata/#/Product%20selector)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| fetchDate               | DATE      |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| adId                    | STRING    |
| campaignId              | STRING    |
| adGroupId               | STRING    |
| state                   | STRING    |
| creationDate            | STRING    |
| lastUpdatedDate         | STRING    |
| servingStatus           | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredProducts\_Campaign**

Purpose: Return a list of Sponsored Products campaigns

Source API Documentation:  [Amazon Sponsored Product Ads - Campaign](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Campaigns/listCampaigns)

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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Campaigns/listCampaignsEx)

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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Ad%20groups/getAdGroups)

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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Ad%20groups/getAdGroupsEx)

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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Keywords/listKeywords)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

<table><thead><tr><th width="251.5">Field Name </th><th>Data Type</th></tr></thead><tbody><tr><td>RequestTime</td><td>TIMESTAMP</td></tr><tr><td>profileId</td><td>STRING</td></tr><tr><td>countryName</td><td>STRING</td></tr><tr><td>accountName</td><td>STRING</td></tr><tr><td>accountId</td><td>STRING</td></tr><tr><td>fetchDate</td><td>DATE</td></tr><tr><td>targetId</td><td>INTEGER</td></tr><tr><td>campaignId</td><td>STRING</td></tr><tr><td>adGroupId</td><td>STRING</td></tr><tr><td>state</td><td>STRING</td></tr><tr><td>keywordText</td><td>STRING</td></tr><tr><td>matchType</td><td>STRING</td></tr><tr><td>bid</td><td>NUMERIC</td></tr><tr><td>nativeLanguageKeyword</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

**SponsoredProducts\_BiddableKeywordsEx**

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

Source API Documentation:  [Amazon Sponsored Product Ads - Keyword Extended](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Keywords/listKeywordsEx)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| keywordId               | INTEGER   |
| campaignId              | STRING    |
| adGroupId               | STRING    |
| state                   | STRING    |
| keywordText             | STRING    |
| matchType               | STRING    |
| creationDate            | STRING    |
| lastUpdatedDate         | STRING    |
| servingStatus           | STRING    |
| bid                     | NUMERIC   |
| nativeLanguageKeyword   | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredProducts\_NegativeKeyword**

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

Source API Documentation:  [Amazon Sponsored Product Ads - Negative Keyword](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Negative%20keywords/listNegativeKeywords)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| keywordId               | INTEGER   |
| campaignId              | STRING    |
| adGroupId               | STRING    |
| state                   | STRING    |
| keywordText             | STRING    |
| matchType               | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredProducts\_NegativeKeywordEx**

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

Source API Documentation:  [Amazon Sponsored Product Ads - Negative Keyword Extended](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Negative%20keywords/listNegativeKeywordsEx)

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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Campaign%20negative%20keywords/listCampaignNegativeKeywords)

Replication: Full Replication

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| profileId               | STRING    |
| keywordId               | INTEGER   |
| campaignId              | STRING    |
| state                   | STRING    |
| keywordText             | STRING    |
| matchType               | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredProducts\_CampaignNegativeKeywordEx**

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

Source API Documentation:  [Amazon Sponsored Product Ads - Campaign Negative Keyword Extended](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Campaign%20negative%20keywords/listCampaignNegativeKeywordsEx)

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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Product%20ads/listProductAds)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| fetchDate               | DATE      |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| adId                    | STRING    |
| campaignId              | STRING    |
| adGroupId               | STRING    |
| state                   | STRING    |
| creationDate            | STRING    |
| lastUpdatedDate         | STRING    |
| servingStatus           | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

&#x20;

**SponsoredProducts\_ProductAdEx**

Purpose: Return a list of product ads with additional properties

Source API Documentation:  [Amazon Sponsored Product Ads - Product Ads Extended](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Product%20ads/listProductAdsEx)

Replication Type: Full Load

Replication Key: N/A

**SponsoredProducts\_TargetingClause**

Purpose: List targeting expressions

Source API Documentation:  [Amazon Sponsored Product Ads - Product Targeting](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Product%20targeting/listTargetingClauses)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| profileId               | STRING    |
| targetId                | INTEGER   |
| campaignId              | STRING    |
| adGroupId               | STRING    |
| state                   | STRING    |
| resolvedExpression      | RECORD    |
| expression              | RECORD    |
| expressionType          | STRING    |
| bid                     | NUMERIC   |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredProducts\_TargetingClauseEx**

Purpose: List targeting expressions with additional properties

Source API Documentation:  [Amazon Sponsored Product Ads - Product Targeting Extended](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Product%20targeting/listTargetingClausesEx)

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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Bid%20recommendations/createKeywordBidRecommendations)

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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Bid%20recommendations/getBidRecommendations)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| adGroupId               | STRING    |
| recommendations         | RECORD    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredProducts\_SuggestedKeywords**

Purpose: Gets suggested keywords for a specified list of ASINs

Source API Documentation:  [Amazon Sponsored Product Ads - Suggested Keywords](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Suggested%20keywords/bulkGetAsinSuggestedKeywords)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| keywordText             | STRING    |
| matchType               | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredProducts\_ProductTargetingRecommendations**

Purpose: Gets a list of recommended products for targeting

Source API Documentation:  [Amazon Sponsored Product Ads - Product Targeting Recommendations](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Product%20targeting/createTargetRecommendations)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| recommendedProducts     | RECORD    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredProducts\_NegativeTargetingClause**

Purpose: Gets a list of negative targeting clauses

Source API Documentation:  [Amazon Sponsored Product Ads - Negative Targeting Clauses](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Negative%20product%20targeting/listNegativeTargetingClauses)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| targetId                | INTEGER   |
| campaignId              | STRING    |
| adGroupId               | STRING    |
| state                   | STRING    |
| expression              | RECORD    |
| expressionType          | STRING    |
| resolvedExpression      | RECORD    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredProducts\_NegativeTargetingClauseEx**

Purpose: Gets a list of negative targeting clauses

Source API Documentation:  [Amazon Sponsored Product Ads - Negative Targeting Clauses Extended](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Negative%20product%20targeting/listNegativeTargetingClausesEx)

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.&#x20;

Source API Documentation: [Amazon Sponsored Product Ads - Budget recommendations and missed opportunities](https://advertising.amazon.com/API/docs/en-us/sponsored-products/3-0/openapi/prod#/Budget%20recommendations%20and%20missed%20opportunities)

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

| Field Name                          | Data Type |
| ----------------------------------- | --------- |
| RequestTime                         | TIMESTAMP |
| profileId                           | STRING    |
| countryName                         | STRING    |
| accountName                         | STRING    |
| accountId                           | STRING    |
| fetchDate                           | DATE      |
| budgetRecommendationsSuccessResults | RECORD    |
| budgetRecommendationsErrorResults   | RECORD    |
| \_daton\_user\_id                   | NUMERIC   |
| \_daton\_batch\_runtime             | NUMERIC   |
| \_daton\_batch\_id                  | NUMERIC   |

**SponsoredProducts\_BudgetUsage**

Purpose: Retrieves the budget usage for an advertised product.

Source API Documentation: [Amazon Sponsored Product Ads - Budget Usage](https://advertising.amazon.com/API/docs/en-us/sponsored-products/3-0/openapi/prod#/Budget%20Usage/spCampaignsBudgetUsage)

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    |
| \_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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/3-0/openapi/prod#/Budget%20Usage/spCampaignsBudgetUsage)

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    |
| \_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](https://advertising.amazon.com/API/docs/en-us/invoices#/invoice/getAdvertiserInvoices)

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    |
| \_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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/3-0/openapi/prod#/Keyword%20Recommendations/getRankedKeywordRecommendation)

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    |
| \_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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/3-0/openapi/prod#/ThemeBasedBidRecommendation/GetThemeBasedBidRecommendationForAdGroup_v1)

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    |
| \_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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

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   |

**SponsoredProducts\_PlacementCampaignsReport**

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

Source API Documentation:  [Amazon Sponsored Product Ads - Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

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   |

**SponsoredProducts\_AdGroupReport**

Purpose: Retrieves ad-group performance report

Source API Documentation:  [Amazon Sponsored Product Ads - Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

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   |
| \_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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

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   |

**SponsoredProducts\_SearchTermKeywordReport**

Purpose: Retrieves keyword performance report with 'query' segmentation

Source API Documentation:  [Amazon Sponsored Product Ads - Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

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   |

**SponsoredProducts\_ProductAdsReport**

Purpose: Retrieves performance reports for advertised products

Source API Documentation:  [Amazon Sponsored Product Ads - Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

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   |

**SponsoredProducts\_ProductTargetingReport**

Purpose: Retrieves targets performance report

Source API Documentation:  [Amazon Sponsored Product Ads - Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

ReportName in Seller Central: Purchased product

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

<table><thead><tr><th width="397.5">Field Name</th><th>Data Type</th></tr></thead><tbody><tr><td>RequestTime</td><td>TIMESTAMP</td></tr><tr><td>profileId</td><td>STRING</td></tr><tr><td>countryName</td><td>STRING</td></tr><tr><td>accountName</td><td>STRING</td></tr><tr><td>accountId</td><td>STRING</td></tr><tr><td>reportDate</td><td>DATE</td></tr><tr><td>campaignName</td><td>STRING</td></tr><tr><td>campaignId</td><td>STRING</td></tr><tr><td>adGroupName</td><td>STRING</td></tr><tr><td>adGroupId</td><td>STRING</td></tr><tr><td>asin</td><td>STRING</td></tr><tr><td>otherAsin</td><td>STRING</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>matchType</td><td>STRING</td></tr><tr><td>attributedUnitsOrdered1d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrdered7d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrdered14d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrdered30d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrdered1dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrdered14dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrdered30dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedSales1dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedSales7dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedSales14dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedSales30dOtherSKU</td><td>NUMERIC</td></tr><tr><td>targetingText</td><td>STRING</td></tr><tr><td>attributedUnitsOrdered7dOtherSKU</td><td>INTEGER</td></tr><tr><td>targetingExpression</td><td>STRING</td></tr><tr><td>attributedSales1d</td><td>NUMERIC</td></tr><tr><td>attributedSales7d</td><td>NUMERIC</td></tr><tr><td>attributedSales14d</td><td>NUMERIC</td></tr><tr><td>attributedSales30d</td><td>NUMERIC</td></tr><tr><td>attributedConversions1d</td><td>INTEGER</td></tr><tr><td>attributedConversions7d</td><td>INTEGER</td></tr><tr><td>attributedConversions14d</td><td>INTEGER</td></tr><tr><td>attributedConversions30d</td><td>INTEGER</td></tr><tr><td>targetingType</td><td>STRING</td></tr><tr><td>attributedConversions1dOtherSKU</td><td>INTEGER</td></tr><tr><td>attributedConversions7dOtherSKU</td><td>INTEGER</td></tr><tr><td>attributedConversions14dOtherSKU</td><td>INTEGER</td></tr><tr><td>attributedConversions30dOtherSKU</td><td>INTEGER</td></tr><tr><td>attributedKindleEditionNormalizedPagesRead14d</td><td>INTEGER</td></tr><tr><td>attributedKindleEditionNormalizedPagesRoyalties14d</td><td>INTEGER</td></tr><tr><td>portfolioId</td><td>STRING</td></tr><tr><td>keywordText</td><td>STRING</td></tr><tr><td>targetId</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

**SponsoredProducts\_AsinsReportWithKeywordId**

Purpose: Retrieves purchased product performance report

ReportName in Seller Central: Purchased product

Source API Documentation:  [Amazon Sponsored Product Ads - Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

<table><thead><tr><th width="388.5">Field Name</th><th>Data Type</th></tr></thead><tbody><tr><td>RequestTime</td><td>TIMESTAMP</td></tr><tr><td>profileId</td><td>STRING</td></tr><tr><td>countryName</td><td>STRING</td></tr><tr><td>accountName</td><td>STRING</td></tr><tr><td>accountId</td><td>STRING</td></tr><tr><td>reportDate</td><td>DATE</td></tr><tr><td>campaignName</td><td>STRING</td></tr><tr><td>campaignId</td><td>STRING</td></tr><tr><td>adGroupName</td><td>STRING</td></tr><tr><td>adGroupId</td><td>STRING</td></tr><tr><td>keywordId</td><td>STRING</td></tr><tr><td>keywordText</td><td>STRING</td></tr><tr><td>asin</td><td>STRING</td></tr><tr><td>otherAsin</td><td>STRING</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>matchType</td><td>STRING</td></tr><tr><td>attributedUnitsOrdered1d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrdered7d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrdered14d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrdered30d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrdered1dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrdered14dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrdered30dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedSales1dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedSales7dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedSales14dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedSales30dOtherSKU</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrdered7dOtherSKU</td><td>INTEGER</td></tr><tr><td>attributedSales1d</td><td>NUMERIC</td></tr><tr><td>attributedSales7d</td><td>NUMERIC</td></tr><tr><td>attributedSales14d</td><td>NUMERIC</td></tr><tr><td>attributedSales30d</td><td>NUMERIC</td></tr><tr><td>attributedConversions1d</td><td>INTEGER</td></tr><tr><td>attributedConversions7d</td><td>INTEGER</td></tr><tr><td>attributedConversions14d</td><td>INTEGER</td></tr><tr><td>attributedConversions30d</td><td>INTEGER</td></tr><tr><td>targetingType</td><td>STRING</td></tr><tr><td>attributedConversions1dOtherSKU</td><td>INTEGER</td></tr><tr><td>attributedConversions7dOtherSKU</td><td>INTEGER</td></tr><tr><td>attributedConversions14dOtherSKU</td><td>INTEGER</td></tr><tr><td>attributedConversions30dOtherSKU</td><td>INTEGER</td></tr><tr><td>attributedKindleEditionNormalizedPagesRead14d</td><td>INTEGER</td></tr><tr><td>attributedKindleEditionNormalizedPagesRoyalties14d</td><td>INTEGER</td></tr><tr><td>portfolioId</td><td>STRING</td></tr><tr><td>targetId</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

**SponsoredProducts\_TargetingReport**

Purpose: Retrieves targets performance report

Source API Documentation:  [Amazon Sponsored Product Ads - Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

ReportName in Seller Central: Targeting

Replication Type: Key Based Replication

Replication Key: Date

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

**SponsoredProducts\_SearchTermTargetingReport**

Purpose: Retrieves targets performance report with 'query' segmentation

Source API Documentation:  [Amazon Sponsored Product Ads - Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports/requestReport)

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

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