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

totalSnSCustomers

STRING

totalSnSCustomersCategoryMedian

STRING

totalSnSCustomersCategoryTopPerformers

STRING

newToBrandSnSCustomersRate

STRING

newToBrandSnSCustomersRateCategoryMedian

STRING

newToBrandSnSCustomersRateCategoryTopPerformers

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

totalSnSCustomers

STRING

totalSnSCustomersCategoryMedian

STRING

totalSnSCustomersCategoryTopPerformers

STRING

newToBrandSnSCustomersRate

STRING

newToBrandSnSCustomersRateCategoryMedian

STRING

newToBrandSnSCustomersRateCategoryTopPerformers

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

totalSnSCustomers

STRING

totalSnSCustomersCategoryMedian

STRING

totalSnSCustomersCategoryTopPerformers

STRING

newToBrandSnSCustomersRate

STRING

newToBrandSnSCustomersRateCategoryMedian

STRING

newToBrandSnSCustomersRateCategoryTopPerformers

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

PreviousHow to Integrate Amazon Brand Metrics with Daton NextAmazon DSP V1

Last updated 2 months ago