# Amazon Ads

### Snapshot

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

| Tables/APIs Supported                                  |                                               |
| ------------------------------------------------------ | --------------------------------------------- |
| Profile                                                | Portfolio                                     |
| Store                                                  | 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\_CampaignsReports           |
| SponsoredProducts\_CampaignsReports\_Placement         | SponsoredProducts\_AdGroupReports             |
| SponsoredProducts\_KeywordReports                      | SponsoredProducts\_KeywordReports\_SearchTerm |
| SponsoredProducts\_ProductAdsReports                   | SponsoredProducts\_ProductTargetingReports    |
| SponsoredProducts\_ProductTargetingReports\_SearchTerm |                                               |

### Integrate AmazonAds with Daton

1. Signin to Daton.
2. Select AmazonAds from Integrations page
3. Provide Integration Name, Replication Frequency, History and Region/Marketplace associated with your Amazon Advertising account. Integration name would be used in creating tables for the integration and cannot be changed later.
4. You will be redirected to Amazon Advertising login for authorizing Daton to extract data periodically.
5. Post successful 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 which you need daton to pull.
7. Then select required fields for each table.
8. Submit the integration.

### Workflow

1. Integrations could be seen Active tab of Integration List while the job loads data on to the configured 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.

### AmazonAds Data

#### TABLES

**Profile**

Purpose: Retrieve all profiles associated with the Amazon Advertising account.

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

Replication: Full Replication

Replication Key: N/A

**Fields**

|     Name     | Target Datatype |
| :----------: | :-------------: |
|   profileId  |      STRING     |
|  countryCode |      STRING     |
| currencyCode |      STRING     |
|  dailyBudget |     NUMERIC     |
|   timeZone   |      STRING     |
|  accountInfo |      RECORD     |

**Portfolio**

Purpose: Retrieve a list of up to 100 portfolios.

Source API Documentation:  [Amazon Ads Portfolio](https://advertising.amazon.com/API/docs/en-us/reference/2/portfolios)

Replication: Full Replication

Replication Key: N/A

**Fields**

|     Name    | Target Datatype |
| :---------: | :-------------: |
| portfolioId |      STRING     |
|     name    |      STRING     |
|    budget   |      RECORD     |
|   inBudget  |     BOOLEAN     |
|    state    |      STRING     |

**Store**

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

Source API Documentation:  [Amazon Ads Store](https://advertising.amazon.com/API/docs/en-us/reference/2/stores)

Replication: Full Replication

Replication Key: N/A

**Fields**

|      Name     | Target Datatype |
| :-----------: | :-------------: |
|      code     |      STRING     |
|    entityId   |      STRING     |
|   storeName   |      STRING     |
| brandEntityId |      STRING     |
| storePageInfo |      RECORD     |

**SponsoredProducts\_Campaign**

Purpose: Return a list of Sponsored Products campaigns.

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

Replication: Full Replication

Replication Key: N/A

**Fields**

|         Name         | Target Datatype |
| :------------------: | :-------------: |
|       profileId      |      STRING     |
|      campaignId      |      STRING     |
|         name         |      STRING     |
|     campaignType     |      STRING     |
|     targetingType    |      STRING     |
|         state        |      STRING     |
|      dailyBudget     |     NUMERIC     |
|       startDate      |      STRING     |
| premiumBidAdjustment |     BOOLEAN     |
|        bidding       |      RECORD     |

**SponsoredProducts\_CampaignEx**

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

Source API Documentation:  [Amazon Ads Sponsored Product - Campaign Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/campaigns)

Replication: Full Replication

Replication Key: N/A

**Fields**

|         Name         | Target Datatype |
| :------------------: | :-------------: |
|       profileId      |      STRING     |
|      campaignId      |      STRING     |
|         name         |      STRING     |
|     campaignType     |      STRING     |
|     targetingType    |      STRING     |
|         state        |      STRING     |
|      dailyBudget     |     NUMERIC     |
|       startDate      |      STRING     |
| premiumBidAdjustment |     BOOLEAN     |
|     creationDate     |      STRING     |
|    lastUpdatedDate   |      STRING     |
|     servingStatus    |      STRING     |
|        bidding       |      RECORD     |

**SponsoredProducts\_AdGroup**

Purpose: Return a list of ad groups.

Source API Documentation:  [Amazon Ads Sponsored Products - Ad Group](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-groups)

Replication: Full Replication

Replication Key: N/A

**Fields**

|    Name    | Target Datatype |
| :--------: | :-------------: |
|  profileId |      STRING     |
|  adGroupId |      STRING     |
| campaignId |      STRING     |
|    name    |      STRING     |
| defaultBid |     NUMERIC     |
|    state   |      STRING     |

**SponsoredProducts\_AdGroupEx**

Purpose: Return a list of ad groups with additional properties

Source API Documentation:  [Amazon Ads Sponsored Product - Ad Group Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-groups)

Replication: Full Replication

Replication Key: N/A

**Fields**

|       Name      | Target Datatype |
| :-------------: | :-------------: |
|    profileId    |      STRING     |
|    adGroupId    |      STRING     |
|    campaignId   |      STRING     |
|       name      |      STRING     |
|    defaultBid   |     NUMERIC     |
|      state      |      STRING     |
|   creationDate  |      STRING     |
| lastUpdatedDate |      STRING     |
|  servingStatus  |      STRING     |

**SponsoredProducts\_BiddableKeyword**

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

Source API Documentation:  [Amazon Ads Sponsored Product - Keyword](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-keywords)

Replication: Full Replication

Replication Key: N/A

**Fields**

|     Name    | Target Datatype |
| :---------: | :-------------: |
|  profileId  |      STRING     |
|  keywordId  |      STRING     |
|  campaignId |      STRING     |
|  adGroupId  |      STRING     |
|    state    |      STRING     |
| keywordText |      STRING     |
|  matchType  |      STRING     |

**SponsoredProducts\_BiddableKeywordsEx**

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

Source API Documentation:  [Amazon Ads Sponsored Product - Keyword Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-keywords)

Replication: Full Replication

Replication Key: N/A

**Fields**

|       Name      | Target Datatype |
| :-------------: | :-------------: |
|    profileId    |      STRING     |
|    keywordId    |      STRING     |
|    campaignId   |      STRING     |
|    adGroupId    |      STRING     |
|      state      |      STRING     |
|   keywordText   |      STRING     |
|    matchType    |      STRING     |
|   creationDate  |      STRING     |
| lastUpdatedDate |      STRING     |
|  servingStatus  |      STRING     |

**SponsoredProducts\_NegativeKeyword**

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

Source API Documentation:  [Amazon Ads Sponsored Product - Negative Keyword](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-negative-keywords)

Replication: Full Replication

Replication Key: N/A

**Fields**

|     Name    | Target Datatype |
| :---------: | :-------------: |
|  profileId  |      STRING     |
|  keywordId  |      STRING     |
|  campaignId |      STRING     |
|  adGroupId  |      STRING     |
|    state    |      STRING     |
| keywordText |      STRING     |
|  matchType  |      STRING     |

**SponsoredProducts\_NegativeKeywordEx**

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

Source API Documentation:  [Amazon Ads Sponsored Product - Negative Keyword Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-negative-keywords)

Replication: Full Replication

Replication Key: N/A

**Fields**

|       Name      | Target Datatype |
| :-------------: | :-------------: |
|    profileId    |      STRING     |
|    keywordId    |      STRING     |
|    campaignId   |      STRING     |
|    adGroupId    |      STRING     |
|      state      |      STRING     |
|   keywordText   |      STRING     |
|    matchType    |      STRING     |
|   creationDate  |      STRING     |
| lastUpdatedDate |      STRING     |
|  servingStatus  |      STRING     |

**SponsoredProducts\_CampaignNegativeKeyword**

Purpose: Return a list of campaign level negative keywords.

Source API Documentation:  [Amazon Ads Sponsored Product - Campaign Negative Keyword](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/campaign-negative-keywords)

Replication: Full Replication

Replication Key: N/A

**Fields**

|     Name    | Target Datatype |
| :---------: | :-------------: |
|  profileId  |      STRING     |
|  keywordId  |      STRING     |
|  campaignId |      STRING     |
|    state    |      STRING     |
| keywordText |      STRING     |
|  matchType  |      STRING     |

**SponsoredProducts\_CampaignNegativeKeywordEx**

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

Source API Documentation:  [Amazon Ads Sponsored Product - Campaign Negative Keyword Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/campaign-negative-keywords)

Replication: Full Replication

Replication Key: N/A

**Fields**

|       Name      | Target Datatype |
| :-------------: | :-------------: |
|    keywordId    |      STRING     |
|    campaignId   |      STRING     |
|      state      |      STRING     |
|   keywordText   |      STRING     |
|    matchType    |      STRING     |
|   creationDate  |      STRING     |
| lastUpdatedDate |      STRING     |
|  servingStatus  |      STRING     |

**SponsoredProducts\_ProductAd**

Purpose: Return a list of product ads.

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

Replication: Full Replication

Replication Key: N/A

**Fields**

|       Name      | Target Datatype |
| :-------------: | :-------------: |
|    profileId    |      STRING     |
|       adId      |      STRING     |
|    campaignId   |      STRING     |
|    adGroupId    |      STRING     |
|       sku       |      STRING     |
|      state      |      STRING     |
|   creationDate  |      STRING     |
| lastUpdatedDate |      STRING     |
|  servingStatus  |      STRING     |

**SponsoredProducts\_ProductAdEx**

Purpose: Return a list of product ads with additional properties.

Source API Documentation:  [Amazon Ads Sponsored Product - Product Ads Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/product-ads)

Replication: Full Replication

Replication Key: N/A

**Fields**

|       Name      | Target Datatype |
| :-------------: | :-------------: |
|    profileId    |      STRING     |
|       adId      |      STRING     |
|    campaignId   |      STRING     |
|    adGroupId    |      STRING     |
|       sku       |      STRING     |
|       asin      |      STRING     |
|      state      |      STRING     |
|   creationDate  |      STRING     |
| lastUpdatedDate |      STRING     |
|  servingStatus  |      STRING     |

**SponsoredProducts\_TargetingClause**

Purpose: List targeting expressions.

Source API Documentation:  [Amazon Ads Sponsored Product - Product Targeting](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/product-attribute-targeting)

Replication: Full Load

Replication Key: N/A

**Fields**

|        Name        | Target Datatype |
| :----------------: | :-------------: |
|      profileId     |      STRING     |
|      targetId      |      STRING     |
|     campaignId     |      STRING     |
|      adGroupId     |      STRING     |
|        state       |      STRING     |
| resolvedExpression |      RECORD     |
|     expression     |      RECORD     |
|   expressionType   |      STRING     |
|         bid        |     NUMERIC     |

**SponsoredProducts\_TargetingClauseEx**

Purpose: List targeting expressions with additional properties.

Source API Documentation:  [Amazon Ads Sponsored Product - Product Targeting Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/product-attribute-targeting)

Replication: Full Load

Replication Key: N/A

**Fields**

|       Name      | Target Datatype |
| :-------------: | :-------------: |
|    profileId    |      STRING     |
|     targetId    |      STRING     |
|    campaignId   |      STRING     |
|    adGroupId    |      STRING     |
|      state      |      STRING     |
|    expression   |      RECORD     |
|  expressionType |      STRING     |
|       bid       |     NUMERIC     |
|   creationDate  |      STRING     |
| lastUpdatedDate |      STRING     |
|  servingStatus  |      STRING     |

**SponsoredProducts\_CampaignsReports**

Purpose: Retrieves campaigns performance report.

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

Replication: Key Based Replication

Replication Key: Date

**Fields**

|               Name               | Target Datatype |
| :------------------------------: | :-------------: |
|               date               |      STRING     |
|              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        |     INTEGER     |
|         attributedSales7d        |     INTEGER     |
|        attributedSales14d        |     INTEGER     |
|        attributedSales30d        |     INTEGER     |
|     attributedSales1dSameSKU     |     INTEGER     |
|     attributedSales7dSameSKU     |     INTEGER     |
|     attributedSales14dSameSKU    |     INTEGER     |
|     attributedSales30dSameSKU    |     INTEGER     |
|  attributedUnitsOrdered1dSameSKU |     INTEGER     |
|  attributedUnitsOrdered7dSameSKU |     INTEGER     |
| attributedUnitsOrdered14dSameSKU |     INTEGER     |
| attributedUnitsOrdered30dSameSKU |     INTEGER     |

**SponsoredProducts\_CampaignsReports\_Placement**

Purpose: Retrieves campaigns performance report with 'placement' segmentation'.

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

Replication: Key Based Replication

Replication Key: Date

**Fields**

|               Name               | Target Datatype |
| :------------------------------: | :-------------: |
|               date               |      STRING     |
|             placement            |      STRING     |
|              bidPlus             |     NUMERIC     |
|           campaignName           |      STRING     |
|            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        |     INTEGER     |
|         attributedSales7d        |     INTEGER     |
|        attributedSales14d        |     INTEGER     |
|        attributedSales30d        |     INTEGER     |
|     attributedSales1dSameSKU     |     INTEGER     |
|     attributedSales7dSameSKU     |     INTEGER     |
|     attributedSales14dSameSKU    |     INTEGER     |
|     attributedSales30dSameSKU    |     INTEGER     |
|  attributedUnitsOrdered1dSameSKU |     INTEGER     |
|  attributedUnitsOrdered7dSameSKU |     INTEGER     |
| attributedUnitsOrdered14dSameSKU |     INTEGER     |
| attributedUnitsOrdered30dSameSKU |     INTEGER     |

**SponsoredProducts\_AdGroupReports**

Purpose: Retrieves ad-group performance report.

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

Replication: Key Based Replication

Replication Key: Date

**Fields**

|               Name               | Target Datatype |
| :------------------------------: | :-------------: |
|               date               |      STRING     |
|           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        |     INTEGER     |
|         attributedSales7d        |     INTEGER     |
|        attributedSales14d        |     INTEGER     |
|        attributedSales30d        |     INTEGER     |
|     attributedSales1dSameSKU     |     INTEGER     |
|     attributedSales7dSameSKU     |     INTEGER     |
|     attributedSales14dSameSKU    |     INTEGER     |
|     attributedSales30dSameSKU    |     INTEGER     |
|  attributedUnitsOrdered1dSameSKU |     INTEGER     |
|  attributedUnitsOrdered7dSameSKU |     INTEGER     |
| attributedUnitsOrdered14dSameSKU |     INTEGER     |
| attributedUnitsOrdered30dSameSKU |     INTEGER     |

**SponsoredProducts\_KeywordReports**

Purpose: Retrieves keyword performance report.

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

Replication: Key Based Replication

Replication Key: Date

**Fields**

|               Name               | Target Datatype |
| :------------------------------: | :-------------: |
|               date               |      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        |     INTEGER     |
|         attributedSales7d        |     INTEGER     |
|        attributedSales14d        |     INTEGER     |
|        attributedSales30d        |     INTEGER     |
|     attributedSales1dSameSKU     |     INTEGER     |
|     attributedSales7dSameSKU     |     INTEGER     |
|     attributedSales14dSameSKU    |     INTEGER     |
|     attributedSales30dSameSKU    |     INTEGER     |
|  attributedUnitsOrdered1dSameSKU |     INTEGER     |
|  attributedUnitsOrdered7dSameSKU |     INTEGER     |
| attributedUnitsOrdered14dSameSKU |     INTEGER     |
| attributedUnitsOrdered30dSameSKU |     INTEGER     |

**SponsoredProducts\_KeywordReports\_SearchTerm**

Purpose: Retrieves keyword performance report with 'query' segmentation.

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

Replication: Key Based Replication

Replication Key: Date

**Fields**

|               Name               | Target Datatype |
| :------------------------------: | :-------------: |
|               date               |      STRING     |
|               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        |     INTEGER     |
|         attributedSales7d        |     INTEGER     |
|        attributedSales14d        |     INTEGER     |
|        attributedSales30d        |     INTEGER     |
|     attributedSales1dSameSKU     |     INTEGER     |
|     attributedSales7dSameSKU     |     INTEGER     |
|     attributedSales14dSameSKU    |     INTEGER     |
|     attributedSales30dSameSKU    |     INTEGER     |
|  attributedUnitsOrdered1dSameSKU |     INTEGER     |
|  attributedUnitsOrdered7dSameSKU |     INTEGER     |
| attributedUnitsOrdered14dSameSKU |     INTEGER     |
| attributedUnitsOrdered30dSameSKU |     INTEGER     |

**SponsoredProducts\_ProductAdsReports**

Purpose: Retrieves product-ads performance report.

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

Replication: Key Based Replication

Replication Key: Date

**Fields**

|               Name               | Target Datatype |
| :------------------------------: | :-------------: |
|               date               |      STRING     |
|           campaignName           |      STRING     |
|            campaignId            |      STRING     |
|            adGroupName           |      STRING     |
|             adGroupId            |      STRING     |
|            impressions           |     INTEGER     |
|              clicks              |     INTEGER     |
|               cost               |     NUMERIC     |
|             currency             |      STRING     |
|               asin               |      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        |     INTEGER     |
|         attributedSales7d        |     INTEGER     |
|        attributedSales14d        |     INTEGER     |
|        attributedSales30d        |     INTEGER     |
|     attributedSales1dSameSKU     |     INTEGER     |
|     attributedSales7dSameSKU     |     INTEGER     |
|     attributedSales14dSameSKU    |     INTEGER     |
|     attributedSales30dSameSKU    |     INTEGER     |
|  attributedUnitsOrdered1dSameSKU |     INTEGER     |
|  attributedUnitsOrdered7dSameSKU |     INTEGER     |
| attributedUnitsOrdered14dSameSKU |     INTEGER     |
| attributedUnitsOrdered30dSameSKU |     INTEGER     |

**SponsoredProducts\_ProductTargetingReports**

Purpose: Retrieves targets performance report.

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

Replication: Key Based Replication

Replication Key: Date

**Fields**

|               Name               | Target Datatype |
| :------------------------------: | :-------------: |
|               date               |      STRING     |
|           campaignName           |      STRING     |
|            campaignId            |      STRING     |
|            adGroupName           |      STRING     |
|             adGroupId            |      STRING     |
|             targetId             |      STRING     |
|        targetingExpression       |      STRING     |
|           targetingText          |      STRING     |
|           targetingType          |      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        |     INTEGER     |
|         attributedSales7d        |     INTEGER     |
|        attributedSales14d        |     INTEGER     |
|        attributedSales30d        |     INTEGER     |
|     attributedSales1dSameSKU     |     INTEGER     |
|     attributedSales7dSameSKU     |     INTEGER     |
|     attributedSales14dSameSKU    |     INTEGER     |
|     attributedSales30dSameSKU    |     INTEGER     |
|  attributedUnitsOrdered1dSameSKU |     INTEGER     |
|  attributedUnitsOrdered7dSameSKU |     INTEGER     |
| attributedUnitsOrdered14dSameSKU |     INTEGER     |
| attributedUnitsOrdered30dSameSKU |     INTEGER     |

**SponsoredProducts\_ProductTargetingReports\_SearchTerm**

Purpose: Retrieves targets performance report with 'query' segmentation.

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

Replication: Key Based Replication

Replication Key: Date

**Fields**

|               Name               | Target Datatype |
| :------------------------------: | :-------------: |
|               date               |      STRING     |
|               query              |      STRING     |
|           campaignName           |      STRING     |
|            campaignId            |      STRING     |
|            adGroupName           |      STRING     |
|             adGroupId            |      STRING     |
|             targetId             |      STRING     |
|        targetingExpression       |      STRING     |
|           targetingText          |      STRING     |
|           targetingType          |      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        |     INTEGER     |
|         attributedSales7d        |     INTEGER     |
|        attributedSales14d        |     INTEGER     |
|        attributedSales30d        |     INTEGER     |
|     attributedSales1dSameSKU     |     INTEGER     |
|     attributedSales7dSameSKU     |     INTEGER     |
|     attributedSales14dSameSKU    |     INTEGER     |
|     attributedSales30dSameSKU    |     INTEGER     |
|  attributedUnitsOrdered1dSameSKU |     INTEGER     |
|  attributedUnitsOrdered7dSameSKU |     INTEGER     |
| attributedUnitsOrdered14dSameSKU |     INTEGER     |
| attributedUnitsOrdered30dSameSKU |     INTEGER     |