Tmall Monthly Product Sales

Query capabilities

Time grain

month

Entity types

productshop

Filter fields

product_idshop_idbrandcategory_l1category_l2category_l3shopis_livehas_bybtbc_type

Searchable value fields

brandcategory_l1category_l2category_l3shopbc_type

Exact reference formats

tmall_product_idtmall_product_urltmall_shop_idtmall_shop_url

Minimal call

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

{
  "dataset": "tmall",
  "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 Tmall 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 Tmall product-detail URL generated from product_id.
aggregate-select · group-by · detail-return · requires-group-by=product_id

shop_ididentifier

Stable Tmall 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 Tmall shop-page URL generated from shop_id.
aggregate-select · group-by · detail-return · requires-group-by=shop_id

brand_ididentifier

Upstream Tmall 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 Tmall 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 Tmall category hierarchy; it may be missing.
detail-return · detail-filter=eq,in

category_l1dimension

Level-1 category name in the upstream Tmall 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 Tmall category hierarchy; it may be missing.
detail-return · detail-filter=eq,in

category_l2dimension

Level-2 category name in the upstream Tmall 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 Tmall category hierarchy; it may be missing.
detail-return · detail-filter=eq,in

category_l3dimension

Level-3 category name in the upstream Tmall 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 Tmall, 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

is_livedimension

Whether the product has appeared in live commerce during the record month; null or empty means unknown, not no.
aggregate-select · group-by · aggregate-filter=eq,neq,in,not_in,is_unknown,is_known · detail-return · detail-filter=eq,neq,in,not_in,is_unknown,is_known

has_bybtdimension

Whether the product participates in the RMB 10B subsidy program during the record month; null or empty means unknown, not no.
aggregate-select · group-by · aggregate-filter=eq,neq,in,not_in,is_unknown,is_known · detail-return · detail-filter=eq,neq,in,not_in,is_unknown,is_known

bc_typedimension

Tmall B/C shop type after trimming blank values; null means the type is unknown.
aggregate-select · group-by · aggregate-filter=eq,neq,in,not_in,is_unknown,is_known · detail-return · detail-filter=eq,neq,in,not_in,is_unknown,is_known · search

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; 2026-06 is the first published waterline, not a subscription start month.
• Products and shops require exact IDs or confirmed HTTPS Taobao links.
• NULL and empty strings consistently mean unknown, not no.