JD Monthly Product Sales

Query capabilities

Time grain

month

Entity types

productshop

Filter fields

product_idshop_idbrandcategory_l1category_l2category_l3shop

Searchable value fields

brandcategory_l1category_l2category_l3shop

Exact reference formats

jd_product_idjd_product_urljd_shop_idjd_shop_url

Minimal call

This is an executable request shape; adjust its scope to the user's question.

{
  "dataset": "jd",
  "group_by": [
    "brand"
  ],
  "limit": 10,
  "metrics": [
    "gmv"
  ],
  "order_by": [
    {
      "dir": "desc",
      "field": "gmv"
    }
  ],
  "task_query": "查看京东最近一个完整月的品牌销售额排名",
  "time": {
    "last_complete_months": 1
  }
}

Fields and capabilities

product_ididentifier

Stable JD product identifier used for exact filtering and paired with product_url.
aggregate-select · group-by · aggregate-filter=eq,in · detail-return · detail-filter=eq,in

titleattribute

Product title recorded for the month; available for output, but not for title search or filtering.
aggregate-select · group-by · detail-return · requires-group-by=product_id

product_urlattribute

Canonical JD product-detail URL generated from product_id.
aggregate-select · group-by · detail-return · requires-group-by=product_id

shop_ididentifier

Stable JD shop identifier used for exact filtering and paired with shop_url.
aggregate-select · group-by · aggregate-filter=eq,in · detail-return · detail-filter=eq,in

shop_urlattribute

Canonical JD shop-page URL supplied by the upstream record and paired with shop_id; it may be empty.
aggregate-select · group-by · detail-return · requires-group-by=shop_id

brand_ididentifier

Upstream JD brand identifier paired with brand; it may be missing when the source does not identify a brand.
detail-return · detail-filter=eq,in

branddimension

Brand name recorded by the upstream JD data, paired with brand_id; it may be missing or vary in spelling.
aggregate-select · group-by · aggregate-filter=eq,neq,in,not_in,contains · detail-return · detail-filter=eq,neq,in,not_in,contains · search

category_l1_ididentifier

Identifier of category_l1 in the upstream JD category hierarchy; it may be missing.
detail-return · detail-filter=eq,in

category_l1dimension

Level-1 category name in the upstream JD hierarchy, paired with category_l1_id.
aggregate-select · group-by · aggregate-filter=eq,neq,in,not_in,contains · detail-return · detail-filter=eq,neq,in,not_in,contains · search

category_l2_ididentifier

Identifier of category_l2 in the upstream JD category hierarchy; it may be missing.
detail-return · detail-filter=eq,in

category_l2dimension

Level-2 category name in the upstream JD hierarchy, paired with category_l2_id.
aggregate-select · group-by · aggregate-filter=eq,neq,in,not_in,contains · detail-return · detail-filter=eq,neq,in,not_in,contains · search

category_l3_ididentifier

Identifier of category_l3 in the upstream JD category hierarchy; it may be missing.
detail-return · detail-filter=eq,in

category_l3dimension

Level-3 category name in the upstream JD hierarchy, paired with category_l3_id.
aggregate-select · group-by · aggregate-filter=eq,neq,in,not_in,contains · detail-return · detail-filter=eq,neq,in,not_in,contains · search

shopdimension

Shop name recorded by JD, paired with shop_id; it may change over time.
aggregate-select · group-by · aggregate-filter=eq,neq,in,not_in,contains · detail-return · detail-filter=eq,neq,in,not_in,contains · search

specificationattribute

Product specification attributes, usually encoded as a JSON object string; keys vary by category, the value may be empty, and it is available only in detail output.
detail-return

monthtime

Calendar month to which the product sales record belongs, formatted as YYYY-MM; the dataset grain is monthly.
aggregate-select · group-by · detail-return

gmvmeasure

Post-coupon sales amount in CNY; aggregate queries sum the selected scope, while detail queries return the value for one product-month record.
aggregate-select · detail-return · certified

unitsmeasure

Units sold; aggregate queries sum the selected scope, while detail queries return the value for one product-month record.
aggregate-select · detail-return

aspmeasure

Weighted average selling price in CNY, calculated as SUM(gmv) / SUM(units); null when total units is zero, and available only in aggregate queries.
aggregate-select

Limitations

• Only monthly-grain data is available.
• Products require an exact product_id or a standard item.jd.com URL; names, aliases, fuzzy search, and short links are unsupported.
• Shops accept an exact shop_id, a standard mall.jd.com URL, or an exact shop name resolved with search_values.
• Reviews, traffic, inventory, causal explanations, and other platforms are not provided.
• YoY, MoM, share, contribution, and cross-period set differences must be computed by the Agent from atomic query results.