बाज़ार के बारे में समझें

SELECT
  report_date,
  report_granularity,
  report_country_code,
  report_category_id,
  rank,
  previous_rank,
  relative_demand,
  previous_relative_demand,
  relative_demand_change,
  title,
  brand,
  category_l1,
  category_l2,
  category_l3,
  variant_gtins,
  inventory_status,
  brand_inventory_status
FROM best_sellers_product_cluster_view
WHERE report_date = '2022-10-10'
  AND report_granularity = 'WEEKLY'
  AND report_country_code = 'US'
  AND report_category_id = 166
ORDER BY rank

{
  "results": [
    {
      "bestSellersProductClusterView": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "reportCountryCode": "US",
        "reportCategoryId": "166",
        "rank": "1",
        "previousRank": "1",
        "relativeDemand": "VERY_HIGH",
        "previousRelativeDemand": "VERY_HIGH",
        "relativeDemandChange": "FLAT",
        "title": "Ugg Shoes Ugg Tasman",
        "brand": "UGG",
        "categoryL1": "Apparel & Accessories",
        "categoryL2": "Shoes",
        "categoryL3": "",
        "variantGtins":
            ["00737872992873", "00737872992880", "00737872992866"],
        "inventoryStatus": "NOT_IN_INVENTORY",
        "brandInventoryStatus": "NOT_IN_INVENTORY"
      }
    },
    {
      "bestSellersProductClusterView": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "reportCountryCode": "US",
        "reportCategoryId": "166",
        "rank": "2",
        "previousRank": "8",
        "relativeDemand": "VERY_HIGH",
        "previousRelativeDemand": "HIGH",
        "relativeDemandChange": "RISER",
        "title": "UGG Women's s Classic Mini",
        "brand": "UGG",
        "categoryL1": "Apparel & Accessories",
        "categoryL2": "Shoes",
        "categoryL3": "",
        "variantGtins":
            ["00194715081314", "00194715081246", "00194715081321"],
        "inventoryStatus": "NOT_IN_INVENTORY",
        "brandInventoryStatus": "NOT_IN_INVENTORY"
      }
    },
    {
      "bestSellersProductClusterView": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "reportCountryCode": "US",
        "reportCategoryId": "166",
        "rank": "3",
        "previousRank": "2",
        "relativeDemand": "VERY_HIGH",
        "previousRelativeDemand": "VERY_HIGH",
        "relativeDemandChange": "FLAT",
        "title": "Crocs Classic",
        "brand": "Crocs",
        "categoryL1": "Apparel & Accessories",
        "categoryL2": "Shoes",
        "categoryL3": "",
        "variantGtins":
            ["00887350811209", "00191448903852", "00191448769090"],
        "inventoryStatus": "NOT_IN_INVENTORY",
        "brandInventoryStatus": "OUT_OF_STOCK"
      }
    }
  ]
}

SELECT
  report_date,
  report_granularity,
  report_country_code,
  report_category_id,
  rank,
  previous_rank,
  relative_demand,
  previous_relative_demand,
  relative_demand_change,
  brand
FROM best_sellers_brand_view
WHERE report_date = '2022-10-10'
  AND report_granularity = 'WEEKLY'
  AND report_country_code = 'US'
  AND report_category_id = 166
ORDER BY rank

{
  "results": [
    {
      "bestSellersBrandView": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "reportCountryCode": "US",
        "reportCategoryId": "166",
        "rank": "1",
        "previousRank": "1",
        "relativeDemand": "VERY_HIGH",
        "previousRelativeDemand": "VERY_HIGH",
        "relativeDemandChange": "FLAT",
        "brand": "Nike"
      }
    },
    {
      "bestSellersBrandView": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "reportCountryCode": "US",
        "reportCategoryId": "166",
        "rank": "2",
        "previousRank": "2",
        "relativeDemand": "HIGH",
        "previousRelativeDemand": "HIGH",
        "relativeDemandChange": "FLAT",
        "brand": "SHEIN"
      }
    },
    {
      "bestSellersBrandView": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "reportCountryCode": "US",
        "reportCategoryId": "166",
        "rank": "3",
        "previousRank": "4",
        "relativeDemand": "HIGH",
        "previousRelativeDemand": "HIGH",
        "relativeDemandChange": "FLAT",
        "brand": "adidas"
      }
    }
  ]
}

SELECT
  id,
  title,
  brand,
  price,
  report_country_code,
  benchmark_price
FROM price_competitiveness_product_view

{
  "results": [
    {
      "priceCompetitivenessProductView": {
        "id": "en~US~12345",
        "title": "UGG Women's s Classic Mini",
        "brand": "UGG",
        "price" {
          "amountMicros": "124990000",
          "currencyCode": "USD"
        },
        "reportCountryCode": "US",
        "benchmarkPrice" {
          "amountMicros": "119922291",
          "currencyCode": "USD"
        }
      }
    },
    {
      "priceCompetitivenessProductView": {
        "id": "en~US~12346",
        "title": "Nike React Infinity Run Flyknit 2",
        "brand": "Nike",
        "price" {
          "amountMicros": "119990000",
          "currencyCode": "USD"
        },
        "reportCountryCode": "US",
        "benchmarkPrice" {
          "amountMicros": "173436840",
          "currencyCode": "USD"
        }
      }
    },
    {
      "priceCompetitivenessProductView": {
        "id": "en~US~12347",
        "title": "New Balance 327 White Trainers",
        "brand": "New Balance",
        "price" {
          "amountMicros": "84990000",
          "currencyCode": "USD"
        },
        "reportCountryCode": "US",
        "benchmarkPrice" {
          "amountMicros": "85459050",
          "currencyCode": "USD"
        }
      }
    }
  ]
}