Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

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

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        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:

        • Setup Instructions for Amazon Brand Metric
        • Essential Attributes and Supported Tables

        Tables/APIs

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

        • Profile 
        • Portfolio 
        • Brand Metrics Report 1 week 
        • Brand Metrics Report 1 month 
        • Brand Metrics Report 1 calendar month

        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

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Setup Instructions for Amazon Brand Metrics
        • Essential Attributes and Supported Tables for Amazon Brand Metric

        Table of Contents

        Tables/APIs Profile Portfolio BrandMetricsReport_1week BrandMetricsReport_1month BrandMetricsReport_1calendarmonth

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand