# Amazon Sponsored Brand 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       | Seller 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

| Profile                                          | Portfolio                                        |
| ------------------------------------------------ | ------------------------------------------------ |
| Store                                            | SponsoredBrands\_ProductMetadata                 |
| SponsoredBrands\_Campaign                        | SponsoredBrands\_AdGroup                         |
| SponsoredBrands\_Keywords                        | SponsoredBrands\_Drafts                          |
| SponsoredBrands\_StoresAssets                    | SponsoredBrands\_NegativeKeywords                |
| SponsoredBrands\_Targets                         | SponsoredBrands\_NegativeTargets                 |
| SponsoredBrands\_TargetingRecommendations        | SponsoredBrands\_BidRecommendations              |
| SponsoredBrands\_CampaignsReports                | SponsoredBrands\_PlacementCampaignsReport        |
| SponsoredBrands\_AdGroupsReport                  | SponsoredBrands\_KeywordsReport                  |
| SponsoredBrands\_PlacementKeywordsReport         | SponsoredBrands\_SearchTermKeywordsReport        |
| SponsoredBrands\_TargetReport                    | SponsoredBrands\_HeadlineSearchReport            |
| SponsoredBrands\_SearchTermHeadlineSearchReport  | SponsoredBrands\_KeywordsVideoReport             |
| SponsoredBrands\_AdGroupsVideoReport             | SponsoredBrands\_CampaignsVideoReport            |
| SponsoredBrands\_PlacementCampaignsVideoReport   | SponsoredBrands\_SearchTermKeywordsVideoReport   |
| SponsoredBrands\_PlacementKeywordsVideoReport    | SponsoredBrands\_TargetVideoReport               |
| SponsoredBrands\_UnifiedAdGroupsReport           | SponsoredBrands\_UnifiedTargetReport             |
| SponsoredBrands\_UnifiedKeywordsReport           | SponsoredBrands\_UnifiedCampaignsReport          |
| SponsoredBrands\_UnifiedPlacementCampaignsReport | SponsoredBrands\_UnifiedSearchTermKeywordsReport |
| SponsoredBrands\_UnifiedPlacementKeywordsReport  |                                                  |

#### 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="241.5">Report in Ad console</th><th>Report in Daton</th></tr></thead><tbody><tr><td>Search term</td><td><code>SponsoredBrands_SearchTermKeywordsReport</code><br><code>SponsoredBrands_SearchTermKeywordsVideoReport</code></td></tr><tr><td>Keyword</td><td><code>SponsoredBrands_KeywordsReport</code><br><code>SponsoredBrands_KeywordsVideoReport</code></td></tr><tr><td>Keyword Placement</td><td><code>SponsoredBrands_PlacementKeywordsReport</code><br><code>SponsoredBrands_PlacementKeywordsVideoReport</code></td></tr><tr><td>Campaign</td><td><code>SponsoredBrands_CampaignsReport</code><br><code>SponsoredBrands_CampaignsVideoReport</code></td></tr><tr><td>Campaign Placement</td><td><code>SponsoredBrands_PlacementCampaignsReport</code><br><code>SponsoredBrands_PlacementCampaignsVideoReport</code></td></tr><tr><td>Search Term Impression Share</td><td>-</td></tr><tr><td>Category Benchmark</td><td>-</td></tr><tr><td>Attributed Purchases</td><td><code>SponsoredBrands_PurchasedProductReport</code></td></tr><tr><td>Gross And Invalid Traffic</td><td>-</td></tr></tbody></table>

### Authentication Credentials

1. Sponsored Brand 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 Brand Ads with Daton

1. Sign in to Daton.
2. Select Amazon Sponsored Brand 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 to authorize Daton to extract data periodically. Log in with your seller account.
5. After authentication, you can choose from the available Amazon Advertising Accounts/ProfileIds list.
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, 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 Brand 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 Brand 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 Brand Ads - Store](https://advertising.amazon.com/API/docs/en-us/reference/2/stores)

Replication Type: Full Load

Replication Key: N/A

#### **SponsoredBrands\_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 Brand, Sponsored Brands or Sponsored Display advertising campaigns. The Product Selector API is available to Sellers, Vendors, and Authors

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

Replication Type: Full Load

Replication Key: N/A

**FIELDS**&#x20;

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| profileId               | STRING    |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| fetchDate               | DATE      |
| eligibilityStatus       | STRING    |
| basisPrice              | RECORD    |
| createdDate             | STRING    |
| imageUrl                | STRING    |
| priceToPay              | RECORD    |
| asin                    | STRING    |
| availability            | STRING    |
| sku                     | STRING    |
| title                   | STRING    |
| brand                   | STRING    |
| variationList           | STRING    |
| ineligibilityReasons    | STRING    |
| ineligibilityCodes      | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

#### **SponsoredBrands\_Campaign**

Purpose: Return a list of Sponsored Brands campaigns

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

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      |
| campaignId              | STRING    |
| name                    | STRING    |
| budget                  | NUMERIC   |
| budgetType              | STRING    |
| startDate               | STRING    |
| endDate                 | STRING    |
| state                   | STRING    |
| servingStatus           | STRING    |
| bidOptimization         | BOOLEAN   |
| bidMultiplier           | NUMERIC   |
| portfolioId             | STRING    |
| creative                | RECORD    |
| landingPage             | RECORD    |
| brandEntityId           | STRING    |
| bidAdjustments          | RECORD    |
| adFormat                | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

#### **SponsoredBrands\_AdGroup**

Purpose: Return a list of ad groups

Source API Documentation:  [Amazon Sponsored Brand Ads - Ad Group](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Ad%20groups/listAdGroups)

Replication Type: Full Load

Replication Key: N/A

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| RequestTime             | TIMESTAMP |
| countryName             | STRING    |
| accountName             | STRING    |
| accountId               | STRING    |
| profileId               | STRING    |
| campaignId              | STRING    |
| adGroupId               | STRING    |
| name                    | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

#### **SponsoredBrands\_Keywords**

Purpose: Gets an array of keywords

Source API Documentation:  [Amazon Sponsored Brand Ads - Keywords](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Keywords/listKeywords)

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               | STRING    |
| adGroupId               | STRING    |
| campaignId              | STRING    |
| keywordText             | STRING    |
| matchType               | STRING    |
| state                   | STRING    |
| bid                     | NUMERIC   |
| nativeLanguageKeyword   | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

#### **SponsoredBrands\_Drafts**

Purpose: Gets an array of all draft campaigns associated with the client identifier passed in the authorization header, filtered by specified criteria. Returns both product collection and video draft campaigns by default

Source API Documentation:  [Amazon Sponsored Brand Ads - Drafts](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Drafts/listDraftCampaigns)

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      |
| draftCampaignId         | STRING    |
| name                    | STRING    |
| budget                  | NUMERIC   |
| budgetType              | STRING    |
| startDate               | STRING    |
| endDate                 | STRING    |
| bidOptimization         | BOOLEAN   |
| bidMultiplier           | NUMERIC   |
| portfolioId             | STRING    |
| creative                | RECORD    |
| landingPage             | RECORD    |
| tags                    | STRING    |
| brandEntityId           | STRING    |
| bidAdjustments          | RECORD    |
| adFormat                | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

#### **SponsoredBrands\_StoresAssets**

Purpose: For sellers or vendors, gets an array of assets associated with the specified brand entity identifier

Source API Documentation:  [Amazon Sponsored Brand Ads - Stores](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Stores/listAssets)

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      |
| assetId                 | STRING    |
| mediaType               | STRING    |
| url                     | STRING    |
| name                    | STRING    |
| brandId                 | STRING    |
| brandEntityId           | STRING    |
| brandRegistryName       | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

#### **SponsoredBrands\_NegativeKeywords**

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

Source API Documentation:  [Amazon Sponsored Brand Ads - Negative Keywords](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-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               | STRING    |
| adGroupId               | STRING    |
| campaignId              | STRING    |
| keywordText             | STRING    |
| matchType               | STRING    |
| state                   | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

#### **SponsoredBrands\_Targets**

Purpose: Gets a list of product targets associated with the client identifier

Source API Documentation:  [Amazon Sponsored Brand Ads - Targets](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Product%20targeting/listTargets)

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                | STRING    |
| adGroupId               | STRING    |
| campaignId              | STRING    |
| state                   | STRING    |
| bid                     | NUMERIC   |
| expressions             | RECORD    |
| resolvedExpressions     | RECORD    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

**SponsoredBrands\_NegativeTargets**

Purpose: Gets a list of product negative targets associated with the client identifier

Source API Documentation:  [Amazon Sponsored Brand Ads - Negative Targets](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Negative%20product%20targeting/listNegativeTargets)

Replication: Full Replication

Replication Key: N/A

**FIELDS**

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

#### **SponsoredBrands\_TargetingRecommendations**

Purpose: Gets a list of recommended products for targeting. Recommendations are based on the ASINs that are passed in the request.

Source API Documentation:  [Amazon Sponsored Brand Ads - Targeting Recommendations](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Targeting%20recommendations/getProductRecommendations)

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      |
| recommendedTargetAsin   | STRING    |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

#### **SponsoredBrands\_BidRecommendations**

Purpose: Get a list of bid recommendation objects for a specified list of keywords or products.

Source API Documentation:  [Amazon Sponsored Brand Ads - Bid Recommendations](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Bid%20recommendations/getBidsRecommendations)

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      |
| keywordsBidsRecommendationSuccessResults | RECORD    |
| keywordsBidsRecommendationErrorResults   | RECORD    |
| targetsBidsRecommendationSuccessResults  | RECORD    |
| targetsBidsRecommendationErrorResults    | RECORD    |
| \_daton\_user\_id                        | NUMERIC   |
| \_daton\_batch\_runtime                  | NUMERIC   |
| \_daton\_batch\_id                       | NUMERIC   |

### REPORTS

#### **SponsoredBrands\_CampaignsReports**

Purpose: Retrieves campaigns performance report

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

ReportName in Seller Central: Campaign

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

<table><thead><tr><th width="401.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>campaignStatus</td><td>STRING</td></tr><tr><td>campaignBudget</td><td>NUMERIC</td></tr><tr><td>campaignBudgetType</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>attributedDetailPageViewsClicks14d</td><td>INTEGER</td></tr><tr><td>attributedSales14d</td><td>NUMERIC</td></tr><tr><td>attributedSales14dSameSKU</td><td>NUMERIC</td></tr><tr><td>attributedConversions14d</td><td>INTEGER</td></tr><tr><td>attributedConversions14dSameSKU</td><td>INTEGER</td></tr><tr><td>attributedOrdersNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedOrdersNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedOrderRateNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrderedNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrderedNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>unitsSold14d</td><td>INTEGER</td></tr><tr><td>dpv14d</td><td>INTEGER</td></tr><tr><td>applicableBudgetRuleId</td><td>STRING</td></tr><tr><td>applicableBudgetRuleName</td><td>STRING</td></tr><tr><td>campaignRuleBasedBudget</td><td>NUMERIC</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>

#### **SponsoredBrands\_PlacementCampaignsReport**

Purpose: Retrieves campaigns performance report with 'placement' segmentation

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

ReportName in Seller Central: Campaign Placement

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

<table><thead><tr><th width="407.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>placement</td><td>STRING</td></tr><tr><td>campaignId</td><td>STRING</td></tr><tr><td>campaignBudgetType</td><td>STRING</td></tr><tr><td>campaignStatus</td><td>STRING</td></tr><tr><td>campaignName</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>attributedDetailPageViewsClicks14d</td><td>INTEGER</td></tr><tr><td>attributedSales14d</td><td>NUMERIC</td></tr><tr><td>attributedSales14dSameSKU</td><td>NUMERIC</td></tr><tr><td>attributedConversions14d</td><td>INTEGER</td></tr><tr><td>attributedConversions14dSameSKU</td><td>INTEGER</td></tr><tr><td>attributedOrdersNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedOrdersNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedOrderRateNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrderedNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrderedNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>unitsSold14d</td><td>INTEGER</td></tr><tr><td>dpv14d</td><td>INTEGER</td></tr><tr><td>applicableBudgetRuleId</td><td>STRING</td></tr><tr><td>applicableBudgetRuleName</td><td>STRING</td></tr><tr><td>campaignRuleBasedBudget</td><td>NUMERIC</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>

#### **SponsoredBrands\_AdGroupsReport**

Purpose: Retrieves ad-group performance report

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

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

| Field Name                                    | Data Type |
| --------------------------------------------- | --------- |
| RequestTime                                   | TIMESTAMP |
| profileId                                     | STRING    |
| countryName                                   | STRING    |
| accountName                                   | STRING    |
| accountId                                     | STRING    |
| reportDate                                    | DATE      |
| campaignId                                    | STRING    |
| campaignName                                  | STRING    |
| campaignBudget                                | NUMERIC   |
| campaignBudgetType                            | STRING    |
| campaignStatus                                | STRING    |
| adGroupId                                     | STRING    |
| adGroupName                                   | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| unitsSold14d                                  | INTEGER   |
| dpv14d                                        | INTEGER   |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_KeywordsReport**

Purpose: Retrieves keyword performance report

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

ReportName in Seller Central: Keyword

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      |
| campaignId                                    | STRING    |
| campaignName                                  | STRING    |
| adGroupId                                     | STRING    |
| adGroupName                                   | STRING    |
| campaignBudgetType                            | STRING    |
| campaignStatus                                | STRING    |
| keywordId                                     | STRING    |
| keywordStatus                                 | STRING    |
| keywordBid                                    | STRING    |
| keywordText                                   | STRING    |
| matchType                                     | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| unitsSold14d                                  | INTEGER   |
| dpv14d                                        | INTEGER   |
| applicableBudgetRuleId                        | STRING    |
| applicableBudgetRuleName                      | STRING    |
| campaignBudget                                | NUMERIC   |
| campaignRuleBasedBudget                       | NUMERIC   |
| searchTermImpressionRank                      | INTEGER   |
| searchTermImpressionShare                     | NUMERIC   |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_PlacementKeywordsReport**

Purpose: Retrieves keyword performance report with 'placement' segmentation

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

ReportName in Seller Central: Keyword 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      |
| placement                                     | STRING    |
| campaignId                                    | STRING    |
| campaignName                                  | STRING    |
| adGroupId                                     | STRING    |
| adGroupName                                   | STRING    |
| campaignBudgetType                            | STRING    |
| campaignStatus                                | STRING    |
| keywordId                                     | STRING    |
| keywordStatus                                 | STRING    |
| keywordBid                                    | STRING    |
| keywordText                                   | STRING    |
| matchType                                     | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| unitsSold14d                                  | INTEGER   |
| dpv14d                                        | INTEGER   |
| applicableBudgetRuleId                        | STRING    |
| applicableBudgetRuleName                      | STRING    |
| campaignBudget                                | NUMERIC   |
| campaignRuleBasedBudget                       | NUMERIC   |
| searchTermImpressionRank                      | INTEGER   |
| searchTermImpressionShare                     | NUMERIC   |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_SearchTermKeywordsReport**

Purpose: Retrieves keyword performance report with 'query' segmentation

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

ReportName in Seller Central: Search term

Replication Type: Key Based Replication

Replication Key: Date

{% hint style="info" %}
**Please note that**, for the "Search Term Keywords Report" table, the data for match type "`-`" corresponds to product-targeted campaigns which **is not supported by Amazon** Ads API and this limitation is not an issue caused by Daton.
{% endhint %}

| Field Name                | Data Type |
| ------------------------- | --------- |
| RequestTime               | TIMESTAMP |
| impressions               | INTEGER   |
| clicks                    | INTEGER   |
| cost                      | NUMERIC   |
| attributedConversions14d  | INTEGER   |
| attributedSales14d        | NUMERIC   |
| profileId                 | STRING    |
| countryName               | STRING    |
| accountName               | STRING    |
| accountId                 | STRING    |
| reportDate                | DATE      |
| query                     | STRING    |
| campaignId                | STRING    |
| campaignName              | STRING    |
| adGroupId                 | STRING    |
| adGroupName               | STRING    |
| campaignBudgetType        | STRING    |
| campaignStatus            | STRING    |
| keywordId                 | STRING    |
| keywordStatus             | STRING    |
| keywordBid                | STRING    |
| keywordText               | STRING    |
| matchType                 | STRING    |
| campaignBudget            | NUMERIC   |
| searchTermImpressionRank  | INTEGER   |
| searchTermImpressionShare | NUMERIC   |
| \_daton\_user\_id         | NUMERIC   |
| \_daton\_batch\_runtime   | NUMERIC   |
| \_daton\_batch\_id        | NUMERIC   |

#### **SponsoredBrands\_TargetReport**

Purpose: Retrieves performance report for targets

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

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

| Field Name                                    | Data Type |
| --------------------------------------------- | --------- |
| RequestTime                                   | TIMESTAMP |
| profileId                                     | STRING    |
| countryName                                   | STRING    |
| accountName                                   | STRING    |
| accountId                                     | STRING    |
| reportDate                                    | DATE      |
| campaignId                                    | STRING    |
| campaignName                                  | STRING    |
| adGroupId                                     | STRING    |
| adGroupName                                   | STRING    |
| campaignBudgetType                            | STRING    |
| campaignStatus                                | STRING    |
| targetId                                      | STRING    |
| targetingExpression                           | STRING    |
| targetingType                                 | STRING    |
| targetingText                                 | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| unitsSold14d                                  | INTEGER   |
| dpv14d                                        | INTEGER   |
| campaignBudget                                | NUMERIC   |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_HeadlineSearchReport**

Purpose:

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

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

| Field Name                                    | Data Type |
| --------------------------------------------- | --------- |
| RequestTime                                   | TIMESTAMP |
| profileId                                     | STRING    |
| countryName                                   | STRING    |
| accountName                                   | STRING    |
| accountId                                     | STRING    |
| reportDate                                    | DATE      |
| campaignName                                  | STRING    |
| campaignId                                    | STRING    |
| campaignStatus                                | STRING    |
| campaignBudget                                | NUMERIC   |
| campaignBudgetType                            | STRING    |
| adGroupName                                   | STRING    |
| adGroupId                                     | STRING    |
| keywordText                                   | STRING    |
| keywordBid                                    | NUMERIC   |
| keywordStatus                                 | STRING    |
| targetId                                      | STRING    |
| targetingExpression                           | STRING    |
| targetingText                                 | STRING    |
| targetingType                                 | STRING    |
| matchType                                     | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| unitsSold14d                                  | INTEGER   |
| dpv14d                                        | INTEGER   |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_SearchTermHeadlineSearchReport**

Purpose:

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

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

| Field Name                                    | Data Type |
| --------------------------------------------- | --------- |
| RequestTime                                   | TIMESTAMP |
| profileId                                     | STRING    |
| countryName                                   | STRING    |
| accountName                                   | STRING    |
| accountId                                     | STRING    |
| reportDate                                    | DATE      |
| campaignName                                  | STRING    |
| campaignId                                    | STRING    |
| campaignStatus                                | STRING    |
| campaignBudget                                | NUMERIC   |
| campaignBudgetType                            | STRING    |
| adGroupName                                   | STRING    |
| adGroupId                                     | STRING    |
| keywordText                                   | STRING    |
| keywordBid                                    | NUMERIC   |
| keywordStatus                                 | STRING    |
| targetId                                      | STRING    |
| targetingExpression                           | STRING    |
| targetingText                                 | STRING    |
| targetingType                                 | STRING    |
| matchType                                     | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| unitsSold14d                                  | INTEGER   |
| dpv14d                                        | INTEGER   |
| query                                         | STRING    |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_KeywordsVideoReport**

Purpose: Retrieves video performance report for Keywords

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

ReportName in Seller Central: Keywords Video

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      |
| campaignId                         | STRING    |
| campaignStatus                     | STRING    |
| campaignBudget                     | NUMERIC   |
| campaignBudgetType                 | STRING    |
| campaignName                       | STRING    |
| impressions                        | INTEGER   |
| clicks                             | INTEGER   |
| cost                               | NUMERIC   |
| attributedSales14d                 | NUMERIC   |
| attributedSales14dSameSKU          | NUMERIC   |
| attributedConversions14d           | INTEGER   |
| attributedConversions14dSameSKU    | INTEGER   |
| keywordText                        | STRING    |
| keywordBid                         | STRING    |
| adGroupName                        | STRING    |
| adGroupId                          | STRING    |
| keywordStatus                      | STRING    |
| query                              | STRING    |
| keywordId                          | STRING    |
| matchType                          | STRING    |
| attributedDetailPageViewsClicks14d | INTEGER   |
| attributedOrderRateNewToBrand14d   | NUMERIC   |

#### **SponsoredBrands\_AdGroupsVideoReport**

Purpose: Retrieves video performance report for AdGroups

ReportName in Seller Central: None

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

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

| Field Name                                    | Data Type |
| --------------------------------------------- | --------- |
| RequestTime                                   | TIMESTAMP |
| profileId                                     | STRING    |
| countryName                                   | STRING    |
| accountName                                   | STRING    |
| accountId                                     | STRING    |
| reportDate                                    | DATE      |
| campaignId                                    | STRING    |
| campaignStatus                                | STRING    |
| campaignBudget                                | NUMERIC   |
| campaignBudgetType                            | STRING    |
| campaignName                                  | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| adGroupId                                     | STRING    |
| adGroupName                                   | STRING    |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| dpv14d                                        | INTEGER   |
| vctr                                          | NUMERIC   |
| video5SecondViewRate                          | NUMERIC   |
| video5SecondViews                             | INTEGER   |
| videoCompleteViews                            | INTEGER   |
| videoFirstQuartileViews                       | INTEGER   |
| videoMidpointViews                            | INTEGER   |
| videoThirdQuartileViews                       | INTEGER   |
| videoUnmutes                                  | INTEGER   |
| viewableImpressions                           | INTEGER   |
| vtr                                           | NUMERIC   |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_CampaignsVideoReport**

Purpose: Retrieves video performance report for Campaigns

ReportName in Seller Central: Campaigns Video

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

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

| Field Name                                    | Data Type |
| --------------------------------------------- | --------- |
| RequestTime                                   | TIMESTAMP |
| profileId                                     | STRING    |
| countryName                                   | STRING    |
| accountName                                   | STRING    |
| accountId                                     | STRING    |
| reportDate                                    | DATE      |
| campaignId                                    | STRING    |
| campaignStatus                                | STRING    |
| campaignBudget                                | NUMERIC   |
| campaignBudgetType                            | STRING    |
| campaignName                                  | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| dpv14d                                        | INTEGER   |
| vctr                                          | NUMERIC   |
| video5SecondViewRate                          | NUMERIC   |
| video5SecondViews                             | INTEGER   |
| videoCompleteViews                            | INTEGER   |
| videoFirstQuartileViews                       | INTEGER   |
| videoMidpointViews                            | INTEGER   |
| videoThirdQuartileViews                       | INTEGER   |
| videoUnmutes                                  | INTEGER   |
| viewableImpressions                           | INTEGER   |
| vtr                                           | NUMERIC   |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_PlacementCampaignsVideoReport**

Purpose: Retrieves video performance report for Campaigns with 'placement' segmentation

ReportName in Seller Central: Campaigns placement video

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

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

| Field Name                                    | Data Type |
| --------------------------------------------- | --------- |
| RequestTime                                   | TIMESTAMP |
| profileId                                     | STRING    |
| countryName                                   | STRING    |
| accountName                                   | STRING    |
| accountId                                     | STRING    |
| reportDate                                    | DATE      |
| campaignName                                  | STRING    |
| campaignId                                    | STRING    |
| campaignStatus                                | STRING    |
| campaignBudget                                | NUMERIC   |
| campaignBudgetType                            | STRING    |
| placement                                     | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| dpv14d                                        | INTEGER   |
| vctr                                          | NUMERIC   |
| video5SecondViewRate                          | NUMERIC   |
| video5SecondViews                             | INTEGER   |
| videoCompleteViews                            | INTEGER   |
| videoFirstQuartileViews                       | INTEGER   |
| videoMidpointViews                            | INTEGER   |
| videoThirdQuartileViews                       | INTEGER   |
| videoUnmutes                                  | INTEGER   |
| viewableImpressions                           | INTEGER   |
| vtr                                           | NUMERIC   |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_SearchTermKeywordsVideoReport**

Purpose: Retrieves video performance report for Keywords with 'query' segmentation

ReportName in Seller Central: Search term video

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

Replication Type: Key Based Replication

Replication Key: Date

{% hint style="info" %}
**Please note that**, for the "Search Term Keywords Video Report" table, the data for match type "`-`" corresponds to product-targeted campaigns which **is not supported by Amazon** Ads API and this limitation is not an issue caused by Daton.
{% endhint %}

**FIELDS**

| Field Name                | Data Type |
| ------------------------- | --------- |
| searchTermImpressionShare | INTEGER   |
| searchTermImpressionRank  | INTEGER   |
| RequestTime               | TIMESTAMP |
| profileId                 | STRING    |
| countryName               | STRING    |
| accountName               | STRING    |
| accountId                 | STRING    |
| reportDate                | DATE      |
| campaignId                | STRING    |
| campaignStatus            | STRING    |
| campaignBudget            | NUMERIC   |
| campaignBudgetType        | STRING    |
| campaignName              | STRING    |
| impressions               | INTEGER   |
| clicks                    | INTEGER   |
| cost                      | NUMERIC   |
| attributedSales14d        | NUMERIC   |
| attributedConversions14d  | INTEGER   |
| keywordText               | STRING    |
| keywordBid                | STRING    |
| adGroupName               | STRING    |
| adGroupId                 | STRING    |
| keywordStatus             | STRING    |
| query                     | STRING    |
| keywordId                 | STRING    |
| matchType                 | STRING    |
| vctr                      | NUMERIC   |
| video5SecondViewRate      | NUMERIC   |
| video5SecondViews         | INTEGER   |
| videoFirstQuartileViews   | INTEGER   |
| videoMidpointViews        | INTEGER   |
| videoThirdQuartileViews   | INTEGER   |
| videoUnmutes              | INTEGER   |
| viewableImpressions       | INTEGER   |
| vtr                       | NUMERIC   |
| videoCompleteViews        | INTEGER   |
| \_daton\_user\_id         | NUMERIC   |
| \_daton\_batch\_runtime   | NUMERIC   |
| \_daton\_batch\_id        | NUMERIC   |

#### **SponsoredBrands\_PlacementKeywordsVideoReport**

Purpose: Retrieves video performance report for Keywords with 'placement' segmentation

ReportName in Seller Central: None

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

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

| Field Name                                    | Data Type |
| --------------------------------------------- | --------- |
| RequestTime                                   | TIMESTAMP |
| profileId                                     | STRING    |
| countryName                                   | STRING    |
| accountName                                   | STRING    |
| accountId                                     | STRING    |
| reportDate                                    | DATE      |
| placement                                     | STRING    |
| campaignId                                    | STRING    |
| campaignName                                  | STRING    |
| adGroupId                                     | STRING    |
| adGroupName                                   | STRING    |
| campaignBudgetType                            | STRING    |
| campaignStatus                                | STRING    |
| keywordId                                     | STRING    |
| keywordStatus                                 | STRING    |
| keywordBid                                    | STRING    |
| keywordText                                   | STRING    |
| matchType                                     | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| dpv14d                                        | INTEGER   |
| vctr                                          | NUMERIC   |
| video5SecondViewRate                          | NUMERIC   |
| video5SecondViews                             | INTEGER   |
| videoCompleteViews                            | INTEGER   |
| videoFirstQuartileViews                       | INTEGER   |
| videoMidpointViews                            | INTEGER   |
| videoThirdQuartileViews                       | INTEGER   |
| videoUnmutes                                  | INTEGER   |
| viewableImpressions                           | INTEGER   |
| vtr                                           | NUMERIC   |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_TargetVideoReport**

Purpose: Retrieves video performance report for Targets

ReportName in Seller Central: None

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

Replication Type: Key Based Replication

Replication Key: Date

**FIELDS**

<table><thead><tr><th width="374.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>campaignId</td><td>STRING</td></tr><tr><td>campaignName</td><td>STRING</td></tr><tr><td>adGroupId</td><td>STRING</td></tr><tr><td>adGroupName</td><td>STRING</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>targetId</td><td>STRING</td></tr><tr><td>targetingExpression</td><td>STRING</td></tr><tr><td>targetingType</td><td>STRING</td></tr><tr><td>targetingText</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>attributedDetailPageViewsClicks14d</td><td>INTEGER</td></tr><tr><td>attributedSales14d</td><td>NUMERIC</td></tr><tr><td>attributedSales14dSameSKU</td><td>NUMERIC</td></tr><tr><td>attributedConversions14d</td><td>INTEGER</td></tr><tr><td>attributedConversions14dSameSKU</td><td>INTEGER</td></tr><tr><td>attributedOrderRateNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedOrdersNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedOrdersNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrderedNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrderedNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>dpv14d</td><td>INTEGER</td></tr><tr><td>vctr</td><td>NUMERIC</td></tr><tr><td>video5SecondViewRate</td><td>NUMERIC</td></tr><tr><td>video5SecondViews</td><td>INTEGER</td></tr><tr><td>videoCompleteViews</td><td>INTEGER</td></tr><tr><td>videoFirstQuartileViews</td><td>INTEGER</td></tr><tr><td>videoMidpointViews</td><td>INTEGER</td></tr><tr><td>videoThirdQuartileViews</td><td>INTEGER</td></tr><tr><td>videoUnmutes</td><td>INTEGER</td></tr><tr><td>viewableImpressions</td><td>INTEGER</td></tr><tr><td>vtr</td><td>NUMERIC</td></tr><tr><td>attributedBrandedSearches14d</td><td>INTEGER</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>

#### **SponsoredBrands\_UnifiedAdGroupsReport**&#x20;

Purpose: Retrieves ad-group performance report

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

**FIELDS**

| Field Name                                    | Data Type |
| --------------------------------------------- | --------- |
| RequestTime                                   | TIMESTAMP |
| profileId                                     | STRING    |
| countryName                                   | STRING    |
| accountName                                   | STRING    |
| accountId                                     | STRING    |
| reportDate                                    | DATE      |
| campaignId                                    | INTEGER   |
| campaignStatus                                | STRING    |
| campaignBudget                                | NUMERIC   |
| campaignBudgetType                            | STRING    |
| campaignName                                  | STRING    |
| impressions                                   | INTEGER   |
| clicks                                        | INTEGER   |
| cost                                          | NUMERIC   |
| attributedSales14d                            | NUMERIC   |
| attributedSales14dSameSKU                     | NUMERIC   |
| attributedConversions14d                      | INTEGER   |
| attributedConversions14dSameSKU               | INTEGER   |
| adGroupName                                   | STRING    |
| adGroupId                                     | STRING    |
| vctr                                          | NUMERIC   |
| video5SecondViewRate                          | NUMERIC   |
| video5SecondViews                             | INTEGER   |
| videoFirstQuartileViews                       | INTEGER   |
| videoMidpointViews                            | INTEGER   |
| videoThirdQuartileViews                       | INTEGER   |
| videoUnmutes                                  | INTEGER   |
| viewableImpressions                           | INTEGER   |
| vtr                                           | NUMERIC   |
| dpv14d                                        | INTEGER   |
| attributedDetailPageViewsClicks14d            | INTEGER   |
| attributedOrderRateNewToBrand14d              | NUMERIC   |
| attributedOrdersNewToBrand14d                 | INTEGER   |
| attributedOrdersNewToBrandPercentage14d       | NUMERIC   |
| attributedSalesNewToBrand14d                  | NUMERIC   |
| attributedSalesNewToBrandPercentage14d        | NUMERIC   |
| attributedUnitsOrderedNewToBrand14d           | INTEGER   |
| attributedUnitsOrderedNewToBrandPercentage14d | NUMERIC   |
| attributedBrandedSearches14d                  | INTEGER   |
| currency                                      | STRING    |
| videoCompleteViews                            | INTEGER   |
| \_daton\_user\_id                             | NUMERIC   |
| \_daton\_batch\_runtime                       | NUMERIC   |
| \_daton\_batch\_id                            | NUMERIC   |

#### **SponsoredBrands\_UnifiedKeywordsReport**&#x20;

Purpose: Retrieves performance report for Keywords&#x20;

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

**FIELDS**

<table><thead><tr><th width="530">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>campaignId</td><td>INTEGER</td></tr><tr><td>campaignStatus</td><td>STRING</td></tr><tr><td>campaignBudget</td><td>NUMERIC</td></tr><tr><td>campaignBudgetType</td><td>STRING</td></tr><tr><td>campaignName</td><td>STRING</td></tr><tr><td>impressions</td><td>INTEGER</td></tr><tr><td>keywordBid</td><td>STRING</td></tr><tr><td>keywordId</td><td>STRING</td></tr><tr><td>keywordStatus</td><td>STRING</td></tr><tr><td>keywordText</td><td>STRING</td></tr><tr><td>matchType</td><td>STRING</td></tr><tr><td>clicks</td><td>INTEGER</td></tr><tr><td>cost</td><td>NUMERIC</td></tr><tr><td>attributedSales14d</td><td>NUMERIC</td></tr><tr><td>attributedSales14dSameSKU</td><td>NUMERIC</td></tr><tr><td>attributedConversions14d</td><td>INTEGER</td></tr><tr><td>attributedConversions14dSameSKU</td><td>INTEGER</td></tr><tr><td>adGroupName</td><td>STRING</td></tr><tr><td>adGroupId</td><td>STRING</td></tr><tr><td>vctr</td><td>NUMERIC</td></tr><tr><td>video5SecondViewRate</td><td>NUMERIC</td></tr><tr><td>video5SecondViews</td><td>INTEGER</td></tr><tr><td>videoFirstQuartileViews</td><td>INTEGER</td></tr><tr><td>videoMidpointViews</td><td>INTEGER</td></tr><tr><td>videoThirdQuartileViews</td><td>INTEGER</td></tr><tr><td>videoUnmutes</td><td>INTEGER</td></tr><tr><td>viewableImpressions</td><td>INTEGER</td></tr><tr><td>vtr</td><td>NUMERIC</td></tr><tr><td>dpv14d</td><td>INTEGER</td></tr><tr><td>attributedDetailPageViewsClicks14d</td><td>INTEGER</td></tr><tr><td>attributedOrderRateNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedOrdersNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedOrdersNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrderedNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrderedNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedBrandedSearches14d</td><td>INTEGER</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>videoCompleteViews</td><td>INTEGER</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>

#### **SponsoredBrands\_UnifiedTargetReport**&#x20;

Purpose: Retrieves performance report for targets

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

**FIELDS**

<table><thead><tr><th width="485">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>campaignId</td><td>STRING</td></tr><tr><td>campaignStatus</td><td>STRING</td></tr><tr><td>campaignBudget</td><td>NUMERIC</td></tr><tr><td>campaignBudgetType</td><td>STRING</td></tr><tr><td>campaignName</td><td>STRING</td></tr><tr><td>impressions</td><td>INTEGER</td></tr><tr><td>targetId</td><td>INTEGER</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>clicks</td><td>INTEGER</td></tr><tr><td>cost</td><td>NUMERIC</td></tr><tr><td>attributedSales14d</td><td>NUMERIC</td></tr><tr><td>attributedSales14dSameSKU</td><td>NUMERIC</td></tr><tr><td>attributedConversions14d</td><td>INTEGER</td></tr><tr><td>attributedConversions14dSameSKU</td><td>INTEGER</td></tr><tr><td>adGroupName</td><td>STRING</td></tr><tr><td>adGroupId</td><td>STRING</td></tr><tr><td>vctr</td><td>NUMERIC</td></tr><tr><td>video5SecondViewRate</td><td>NUMERIC</td></tr><tr><td>video5SecondViews</td><td>INTEGER</td></tr><tr><td>videoFirstQuartileViews</td><td>INTEGER</td></tr><tr><td>videoMidpointViews</td><td>INTEGER</td></tr><tr><td>videoThirdQuartileViews</td><td>INTEGER</td></tr><tr><td>videoUnmutes</td><td>INTEGER</td></tr><tr><td>viewableImpressions</td><td>INTEGER</td></tr><tr><td>vtr</td><td>NUMERIC</td></tr><tr><td>dpv14d</td><td>INTEGER</td></tr><tr><td>attributedDetailPageViewsClicks14d</td><td>INTEGER</td></tr><tr><td>attributedOrderRateNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedOrdersNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedOrdersNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrderedNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrderedNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedBrandedSearches14d</td><td>INTEGER</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>videoCompleteViews</td><td>INTEGER</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>

#### **SponsoredBrands\_UnifiedPlacementCampaignsReport**

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

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

**FIELDS**

<table><thead><tr><th width="480">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>campaignId</td><td>STRING</td></tr><tr><td>campaignStatus</td><td>STRING</td></tr><tr><td>campaignBudget</td><td>NUMERIC</td></tr><tr><td>campaignBudgetType</td><td>STRING</td></tr><tr><td>campaignName</td><td>STRING</td></tr><tr><td>impressions</td><td>INTEGER</td></tr><tr><td>placement</td><td>STRING</td></tr><tr><td>clicks</td><td>INTEGER</td></tr><tr><td>cost</td><td>NUMERIC</td></tr><tr><td>attributedSales14d</td><td>NUMERIC</td></tr><tr><td>attributedSales14dSameSKU</td><td>NUMERIC</td></tr><tr><td>attributedConversions14d</td><td>INTEGER</td></tr><tr><td>attributedConversions14dSameSKU</td><td>INTEGER</td></tr><tr><td>vctr</td><td>NUMERIC</td></tr><tr><td>video5SecondViewRate</td><td>NUMERIC</td></tr><tr><td>video5SecondViews</td><td>INTEGER</td></tr><tr><td>videoFirstQuartileViews</td><td>INTEGER</td></tr><tr><td>videoMidpointViews</td><td>INTEGER</td></tr><tr><td>videoThirdQuartileViews</td><td>INTEGER</td></tr><tr><td>videoUnmutes</td><td>INTEGER</td></tr><tr><td>viewableImpressions</td><td>INTEGER</td></tr><tr><td>vtr</td><td>NUMERIC</td></tr><tr><td>dpv14d</td><td>INTEGER</td></tr><tr><td>attributedDetailPageViewsClicks14d</td><td>INTEGER</td></tr><tr><td>attributedOrderRateNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedOrdersNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedOrdersNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrderedNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrderedNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedBrandedSearches14d</td><td>INTEGER</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>videoCompleteViews</td><td>INTEGER</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></td></tr></tbody></table>

#### **SponsoredBrands\_UnifiedPlacementKeywordsReport**&#x20;

Purpose: Retrieves keyword performance report with 'placement' segmentation

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

**Note**: The API reports don't return the data for match type "-" i.e. auto-targeting data

**FIELDS**

<table><thead><tr><th width="499">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>adGroupId</td><td>STRING</td></tr><tr><td>adGroupName</td><td>STRING</td></tr><tr><td>campaignId</td><td>INTEGER</td></tr><tr><td>campaignStatus</td><td>STRING</td></tr><tr><td>campaignBudget</td><td>NUMERIC</td></tr><tr><td>campaignBudgetType</td><td>STRING</td></tr><tr><td>campaignName</td><td>STRING</td></tr><tr><td>keywordBid</td><td>STRING</td></tr><tr><td>keywordId</td><td>STRING</td></tr><tr><td>keywordStatus</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>placement</td><td>STRING</td></tr><tr><td>clicks</td><td>INTEGER</td></tr><tr><td>cost</td><td>NUMERIC</td></tr><tr><td>attributedSales14d</td><td>NUMERIC</td></tr><tr><td>attributedSales14dSameSKU</td><td>NUMERIC</td></tr><tr><td>attributedConversions14d</td><td>INTEGER</td></tr><tr><td>attributedConversions14dSameSKU</td><td>INTEGER</td></tr><tr><td>vctr</td><td>NUMERIC</td></tr><tr><td>video5SecondViewRate</td><td>NUMERIC</td></tr><tr><td>video5SecondViews</td><td>INTEGER</td></tr><tr><td>videoFirstQuartileViews</td><td>INTEGER</td></tr><tr><td>videoMidpointViews</td><td>INTEGER</td></tr><tr><td>videoThirdQuartileViews</td><td>INTEGER</td></tr><tr><td>videoUnmutes</td><td>INTEGER</td></tr><tr><td>viewableImpressions</td><td>INTEGER</td></tr><tr><td>vtr</td><td>NUMERIC</td></tr><tr><td>dpv14d</td><td>INTEGER</td></tr><tr><td>attributedDetailPageViewsClicks14d</td><td>INTEGER</td></tr><tr><td>attributedOrderRateNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedOrdersNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedOrdersNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrderedNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrderedNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedBrandedSearches14d</td><td>INTEGER</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>videoCompleteViews</td><td>INTEGER</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>

#### **SponsoredBrands\_UnifiedCampaignsReport**&#x20;

Purpose: Retrieves campaigns performance report

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

**FIELDS**

<table><thead><tr><th width="467">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>campaignId</td><td>STRING</td></tr><tr><td>campaignStatus</td><td>STRING</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>campaignBudget</td><td>NUMERIC</td></tr><tr><td>campaignBudgetType</td><td>STRING</td></tr><tr><td>campaignName</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>attributedSales14d</td><td>NUMERIC</td></tr><tr><td>attributedSales14dSameSKU</td><td>NUMERIC</td></tr><tr><td>attributedConversions14d</td><td>INTEGER</td></tr><tr><td>attributedConversions14dSameSKU</td><td>INTEGER</td></tr><tr><td>attributedDetailPageViewsClicks14d</td><td>INTEGER</td></tr><tr><td>attributedOrderRateNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedOrdersNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedOrdersNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrand14d</td><td>NUMERIC</td></tr><tr><td>attributedSalesNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>attributedUnitsOrderedNewToBrand14d</td><td>INTEGER</td></tr><tr><td>attributedUnitsOrderedNewToBrandPercentage14d</td><td>NUMERIC</td></tr><tr><td>dpv14d</td><td>INTEGER</td></tr><tr><td>vctr</td><td>NUMERIC</td></tr><tr><td>video5SecondViewRate</td><td>NUMERIC</td></tr><tr><td>video5SecondViews</td><td>INTEGER</td></tr><tr><td>videoCompleteViews</td><td>INTEGER</td></tr><tr><td>videoFirstQuartileViews</td><td>INTEGER</td></tr><tr><td>videoMidpointViews</td><td>INTEGER</td></tr><tr><td>videoThirdQuartileViews</td><td>INTEGER</td></tr><tr><td>videoUnmutes</td><td>INTEGER</td></tr><tr><td>viewableImpressions</td><td>INTEGER</td></tr><tr><td>vtr</td><td>NUMERIC</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>

#### **SponsoredBrands\_UnifiedSearchTermKeywordsReport**&#x20;

Purpose: Retrieves keyword performance report with 'query' segmentation

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

{% hint style="info" %}
**Please note that**, for the "Unified Search Term Keywords Report" table, the data for match type "`-`" corresponds to product-targeted campaigns which **is not supported by Amazon** Ads API and this limitation is not an issue caused by Daton.
{% endhint %}

**FIELDS**

| Field Name               | Data Type |
| ------------------------ | --------- |
| RequestTime              | TIMESTAMP |
| profileId                | STRING    |
| countryName              | STRING    |
| accountName              | STRING    |
| accountId                | STRING    |
| reportDate               | DATE      |
| campaignId               | STRING    |
| campaignStatus           | STRING    |
| campaignBudget           | NUMERIC   |
| campaignBudgetType       | STRING    |
| campaignName             | STRING    |
| impressions              | INTEGER   |
| clicks                   | INTEGER   |
| cost                     | NUMERIC   |
| attributedSales14d       | NUMERIC   |
| attributedConversions14d | INTEGER   |
| keywordText              | STRING    |
| keywordBid               | STRING    |
| adGroupName              | STRING    |
| adGroupId                | STRING    |
| keywordStatus            | STRING    |
| query                    | STRING    |
| keywordId                | STRING    |
| matchType                | STRING    |
| vctr                     | NUMERIC   |
| video5SecondViewRate     | NUMERIC   |
| video5SecondViews        | INTEGER   |
| videoFirstQuartileViews  | INTEGER   |
| videoMidpointViews       | INTEGER   |
| videoThirdQuartileViews  | INTEGER   |
| videoUnmutes             | INTEGER   |
| viewableImpressions      | INTEGER   |
| vtr                      | NUMERIC   |
| videoCompleteViews       | INTEGER   |
| \_daton\_user\_id        | NUMERIC   |
| \_daton\_batch\_runtime  | NUMERIC   |
| \_daton\_batch\_id       | NUMERIC   |