# Schema Infomation

## Tables/APIs 

The following is the list of tables or APIs associated with the Amazon Brand Metrics connector:

* [Profile](#profile) 
* [Portfolio](#portfolio) 
* [Brand Metrics Report 1 week](#brandmetricsreport_1week) 
* [Brand Metrics Report 1 month](#brandmetricsreport_1month) 
* [Brand Metrics Report 1 calendar month](#brandmetricsreport_1calendarmonth)

#### Profile

**Fields**

<table><thead><tr><th width="78">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>profileId</td><td>STRING</td></tr><tr><td>fetchDate</td><td>DATE</td></tr><tr><td>countryCode</td><td>STRING</td></tr><tr><td>currencyCode</td><td>STRING</td></tr><tr><td>dailyBudget</td><td>NUMERIC</td></tr><tr><td>timeZone</td><td>STRING</td></tr><tr><td>accountInfo</td><td>RECORD</td></tr><tr><td>RequestTime</td><td>TIMESTAMP</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>

#### Portfolio

**Fields**

<table><thead><tr><th width="78">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>profileId</td><td>STRING</td></tr><tr><td>countryName</td><td>STRING</td></tr><tr><td>accountName</td><td>STRING</td></tr><tr><td>accountId</td><td>STRING</td></tr><tr><td>fetchDate</td><td>DATE</td></tr><tr><td>portfolioId</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>budget</td><td>RECORD</td></tr><tr><td>inBudget</td><td>BOOLEAN</td></tr><tr><td>state</td><td>STRING</td></tr><tr><td>RequestTime</td><td>TIMESTAMP</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>

#### BrandMetricsReport\_1week

**Fields**

<table><thead><tr><th width="295">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>api</td><td>STRING</td></tr><tr><td>countryName</td><td>STRING</td></tr><tr><td>accountId</td><td>STRING</td></tr><tr><td>accountName</td><td>STRING</td></tr><tr><td>profileId</td><td>STRING</td></tr><tr><td>RequestTime</td><td>STRING</td></tr><tr><td>metricsComputationDate</td><td>STRING</td></tr><tr><td>brandName</td><td>STRING</td></tr><tr><td>categoryNodeName</td><td>STRING</td></tr><tr><td>categoryNodeTreeName</td><td>STRING</td></tr><tr><td>lookbackPeriod</td><td>STRING</td></tr><tr><td>engagedShopperRateLowerBound</td><td>STRING</td></tr><tr><td>engagedShopperRateUpperBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryMedianLowerBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryMedianUpperBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryTopPerformersLowerBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryTopPerformersUpperBound</td><td>STRING</td></tr><tr><td>customerConversionRate</td><td>STRING</td></tr><tr><td>customerConversionRateCategoryMedian</td><td>STRING</td></tr><tr><td>customerConversionRateCategoryTopPerformers</td><td>STRING</td></tr><tr><td>newToBrandCustomerRate</td><td>STRING</td></tr><tr><td>newToBrandCustomerRateCategoryMedian</td><td>STRING</td></tr><tr><td>newToBrandCustomerRateCategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandedSearchesOnly</td><td>STRING</td></tr><tr><td>brandedSearchesCategoryMedian</td><td>STRING</td></tr><tr><td>brandedSearchesCategoryTopPerformers</td><td>STRING</td></tr><tr><td>viewedDetailPageOnly</td><td>STRING</td></tr><tr><td>viewedDetailPageCategoryMedian</td><td>STRING</td></tr><tr><td>viewedDetailPageCategoryTopPerformers</td><td>STRING</td></tr><tr><td>viewedDetailPageOnlyReturnOnEngagement</td><td>STRING</td></tr><tr><td>viewedDetailPageROECategoryMedian</td><td>STRING</td></tr><tr><td>viewedDetailPageROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViews</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsCategoryMedian</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsCategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsReturnOnEngagement</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsROECategoryMedian</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>addToCarts</td><td>STRING</td></tr><tr><td>addToCartsCategoryMedian</td><td>STRING</td></tr><tr><td>addToCartsCategoryTopPerformers</td><td>STRING</td></tr><tr><td>addToCartsReturnOnEngagement</td><td>STRING</td></tr><tr><td>addToCartsROECategoryMedian</td><td>STRING</td></tr><tr><td>addToCartsROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandCustomers</td><td>STRING</td></tr><tr><td>brandCustomersCategoryMedian</td><td>STRING</td></tr><tr><td>brandCustomersCategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandCustomersReturnOnEngagement</td><td>STRING</td></tr><tr><td>brandCustomersROECategoryMedian</td><td>STRING</td></tr><tr><td>brandCustomersROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>highValueCustomers</td><td>STRING</td></tr><tr><td>highValueCustomersCategoryMedian</td><td>STRING</td></tr><tr><td>highValueCustomersTopPerformers</td><td>STRING</td></tr><tr><td>highValueCustomersReturnOnEngagement</td><td>STRING</td></tr><tr><td>highValueCustomersROECategoryMedian</td><td>STRING</td></tr><tr><td>highValueCustomersCategoryTopPerformers</td><td>STRING</td></tr><tr><td>awarenessIndex</td><td>STRING</td></tr><tr><td>considerationIndex</td><td>STRING</td></tr><tr><td>salesIndex</td><td>STRING</td></tr><tr><td>totalSnSCustomers</td><td>STRING</td></tr><tr><td>totalSnSCustomersCategoryMedian</td><td>STRING</td></tr><tr><td>totalSnSCustomersCategoryTopPerformers</td><td>STRING</td></tr><tr><td>newToBrandSnSCustomersRate</td><td>STRING</td></tr><tr><td>newToBrandSnSCustomersRateCategoryMedian</td><td>STRING</td></tr><tr><td>newToBrandSnSCustomersRateCategoryTopPerformers</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### BrandMetricsReport\_1month

**Fields**

<table><thead><tr><th width="192">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>api</td><td>STRING</td></tr><tr><td>countryName</td><td>STRING</td></tr><tr><td>accountId</td><td>STRING</td></tr><tr><td>accountName</td><td>STRING</td></tr><tr><td>profileId</td><td>STRING</td></tr><tr><td>RequestTime</td><td>STRING</td></tr><tr><td>metricsComputationDate</td><td>STRING</td></tr><tr><td>brandName</td><td>STRING</td></tr><tr><td>categoryNodeName</td><td>STRING</td></tr><tr><td>categoryNodeTreeName</td><td>STRING</td></tr><tr><td>lookbackPeriod</td><td>STRING</td></tr><tr><td>engagedShopperRateLowerBound</td><td>STRING</td></tr><tr><td>engagedShopperRateUpperBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryMedianLowerBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryMedianUpperBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryTopPerformersLowerBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryTopPerformersUpperBound</td><td>STRING</td></tr><tr><td>customerConversionRate</td><td>STRING</td></tr><tr><td>customerConversionRateCategoryMedian</td><td>STRING</td></tr><tr><td>customerConversionRateCategoryTopPerformers</td><td>STRING</td></tr><tr><td>newToBrandCustomerRate</td><td>STRING</td></tr><tr><td>newToBrandCustomerRateCategoryMedian</td><td>STRING</td></tr><tr><td>newToBrandCustomerRateCategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandedSearchesOnly</td><td>STRING</td></tr><tr><td>brandedSearchesCategoryMedian</td><td>STRING</td></tr><tr><td>brandedSearchesCategoryTopPerformers</td><td>STRING</td></tr><tr><td>viewedDetailPageOnly</td><td>STRING</td></tr><tr><td>viewedDetailPageCategoryMedian</td><td>STRING</td></tr><tr><td>viewedDetailPageCategoryTopPerformers</td><td>STRING</td></tr><tr><td>viewedDetailPageOnlyReturnOnEngagement</td><td>STRING</td></tr><tr><td>viewedDetailPageROECategoryMedian</td><td>STRING</td></tr><tr><td>viewedDetailPageROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViews</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsCategoryMedian</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsCategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsReturnOnEngagement</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsROECategoryMedian</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>addToCarts</td><td>STRING</td></tr><tr><td>addToCartsCategoryMedian</td><td>STRING</td></tr><tr><td>addToCartsCategoryTopPerformers</td><td>STRING</td></tr><tr><td>addToCartsReturnOnEngagement</td><td>STRING</td></tr><tr><td>addToCartsROECategoryMedian</td><td>STRING</td></tr><tr><td>addToCartsROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandCustomers</td><td>STRING</td></tr><tr><td>brandCustomersCategoryMedian</td><td>STRING</td></tr><tr><td>brandCustomersCategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandCustomersReturnOnEngagement</td><td>STRING</td></tr><tr><td>brandCustomersROECategoryMedian</td><td>STRING</td></tr><tr><td>brandCustomersROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>highValueCustomers</td><td>STRING</td></tr><tr><td>highValueCustomersCategoryMedian</td><td>STRING</td></tr><tr><td>highValueCustomersTopPerformers</td><td>STRING</td></tr><tr><td>highValueCustomersReturnOnEngagement</td><td>STRING</td></tr><tr><td>highValueCustomersROECategoryMedian</td><td>STRING</td></tr><tr><td>highValueCustomersCategoryTopPerformers</td><td>STRING</td></tr><tr><td>awarenessIndex</td><td>STRING</td></tr><tr><td>considerationIndex</td><td>STRING</td></tr><tr><td>salesIndex</td><td>STRING</td></tr><tr><td>totalSnSCustomers</td><td>STRING</td></tr><tr><td>totalSnSCustomersCategoryMedian</td><td>STRING</td></tr><tr><td>totalSnSCustomersCategoryTopPerformers</td><td>STRING</td></tr><tr><td>newToBrandSnSCustomersRate</td><td>STRING</td></tr><tr><td>newToBrandSnSCustomersRateCategoryMedian</td><td>STRING</td></tr><tr><td>newToBrandSnSCustomersRateCategoryTopPerformers</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### BrandMetricsReport\_1calendarmonth

**Fields**

<table><thead><tr><th width="247">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>api</td><td>STRING</td></tr><tr><td>countryName</td><td>STRING</td></tr><tr><td>accountId</td><td>STRING</td></tr><tr><td>accountName</td><td>STRING</td></tr><tr><td>profileId</td><td>STRING</td></tr><tr><td>RequestTime</td><td>STRING</td></tr><tr><td>metricsComputationDate</td><td>STRING</td></tr><tr><td>brandName</td><td>STRING</td></tr><tr><td>categoryNodeName</td><td>STRING</td></tr><tr><td>categoryNodeTreeName</td><td>STRING</td></tr><tr><td>lookbackPeriod</td><td>STRING</td></tr><tr><td>engagedShopperRateLowerBound</td><td>STRING</td></tr><tr><td>engagedShopperRateUpperBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryMedianLowerBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryMedianUpperBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryTopPerformersLowerBound</td><td>STRING</td></tr><tr><td>engagedShopperRateCategoryTopPerformersUpperBound</td><td>STRING</td></tr><tr><td>customerConversionRate</td><td>STRING</td></tr><tr><td>customerConversionRateCategoryMedian</td><td>STRING</td></tr><tr><td>customerConversionRateCategoryTopPerformers</td><td>STRING</td></tr><tr><td>newToBrandCustomerRate</td><td>STRING</td></tr><tr><td>newToBrandCustomerRateCategoryMedian</td><td>STRING</td></tr><tr><td>newToBrandCustomerRateCategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandedSearchesOnly</td><td>STRING</td></tr><tr><td>brandedSearchesCategoryMedian</td><td>STRING</td></tr><tr><td>brandedSearchesCategoryTopPerformers</td><td>STRING</td></tr><tr><td>viewedDetailPageOnly</td><td>STRING</td></tr><tr><td>viewedDetailPageCategoryMedian</td><td>STRING</td></tr><tr><td>viewedDetailPageCategoryTopPerformers</td><td>STRING</td></tr><tr><td>viewedDetailPageOnlyReturnOnEngagement</td><td>STRING</td></tr><tr><td>viewedDetailPageROECategoryMedian</td><td>STRING</td></tr><tr><td>viewedDetailPageROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViews</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsCategoryMedian</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsCategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsReturnOnEngagement</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsROECategoryMedian</td><td>STRING</td></tr><tr><td>brandedSearchesAndDetailPageViewsROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>addToCarts</td><td>STRING</td></tr><tr><td>addToCartsCategoryMedian</td><td>STRING</td></tr><tr><td>addToCartsCategoryTopPerformers</td><td>STRING</td></tr><tr><td>addToCartsReturnOnEngagement</td><td>STRING</td></tr><tr><td>addToCartsROECategoryMedian</td><td>STRING</td></tr><tr><td>addToCartsROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandCustomers</td><td>STRING</td></tr><tr><td>brandCustomersCategoryMedian</td><td>STRING</td></tr><tr><td>brandCustomersCategoryTopPerformers</td><td>STRING</td></tr><tr><td>brandCustomersReturnOnEngagement</td><td>STRING</td></tr><tr><td>brandCustomersROECategoryMedian</td><td>STRING</td></tr><tr><td>brandCustomersROECategoryTopPerformers</td><td>STRING</td></tr><tr><td>highValueCustomers</td><td>STRING</td></tr><tr><td>highValueCustomersCategoryMedian</td><td>STRING</td></tr><tr><td>highValueCustomersTopPerformers</td><td>STRING</td></tr><tr><td>highValueCustomersReturnOnEngagement</td><td>STRING</td></tr><tr><td>highValueCustomersROECategoryMedian</td><td>STRING</td></tr><tr><td>highValueCustomersCategoryTopPerformers</td><td>STRING</td></tr><tr><td>awarenessIndex</td><td>STRING</td></tr><tr><td>considerationIndex</td><td>STRING</td></tr><tr><td>salesIndex</td><td>STRING</td></tr><tr><td>totalSnSCustomers</td><td>STRING</td></tr><tr><td>totalSnSCustomersCategoryMedian</td><td>STRING</td></tr><tr><td>totalSnSCustomersCategoryTopPerformers</td><td>STRING</td></tr><tr><td>newToBrandSnSCustomersRate</td><td>STRING</td></tr><tr><td>newToBrandSnSCustomersRateCategoryMedian</td><td>STRING</td></tr><tr><td>newToBrandSnSCustomersRateCategoryTopPerformers</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>