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.

  • Pulse

    • Daton

      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