Ask or search…
K
Links

Schema Infomation

This topic provides a structured reference to assist you in working with Daton's Amazon Brand Metrics connector and the associated fields and tables.

Tables/APIs

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

Profile

Fields
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

Fields
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

Fields
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
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC

BrandMetricsReport_1month

Fields
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
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC

BrandMetricsReport_1calendarmonth

Fields
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
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC