Schema Information for Amazon Brand Metrics

In this article, we will look at the schema information of the supported APIs and tables for Amazon Brand Metrics

Need help with something?

Talk to data expert

Schema Information for Amazon Brand Metrics

In this article, we will look at the schema information of the supported APIs and tables for Amazon Brand Metrics

Find the links to other articles related to Amazon Brand Metric below:

Tables/APIs

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

Profile

Field Name
Data Type
profileId
STRING
fetchDate
DATE
countryCode
STRING
currencyCode
STRING
dailyBudget
NUMERIC
timeZone
STRING
accountInfo
RECORD
RequestTime
TIMESTAMP
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC

Portfolio

Field Name
Data Type
profileId
STRING
countryName
STRING
accountName
STRING
accountId
STRING
fetchDate
DATE
portfolioId
STRING
name
STRING
budget
RECORD
inBudget
BOOLEAN
state
STRING
RequestTime
TIMESTAMP
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC

BrandMetricsReport_1week

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

BrandMetricsReport_1month

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

BrandMetricsReport_1calendarmonth

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

 

schema details schema data

Related Articles

Table of Contents

Tables/APIs Profile Portfolio BrandMetricsReport_1week BrandMetricsReport_1month BrandMetricsReport_1calendarmonth