Skip to content

Category product ranking

Rank exact product IDs within a resolved category.

Authenticated runtime tools and each query response are authoritative for tenant scope and current data coverage.

This is an MCP query composition, not a complete business report; see Research Methods in the Agent Docs for complete workflows.

Required inputs

categoryRequired · search_values

Exact category value

category_l3
timeRequired · user_required

Analysis time range

ranking_metricOptional · user_required

Product ranking metric

Default: gmv · Allowed values: gmv, units
top_nOptional · user_required

Number of products

Default: 20

Execution steps

  1. 1
    resolve_category · search_values

    Resolve the category value.

    Request contract
    category_l3 ← $category
  2. 2
    query_products · query_metrics

    Query and order products by the selected metric.

    Request contract
    metrics: gmv, unitsgroup_by: product_id, title, product_urlfilter: category_l3 eq $categorytime: $timeorder_by: $ranking_metric desclimit: $top_n

Call example

Replace example values with exact user inputs or platform values returned by search_values.

search_values
{
  "dataset": "pdd",
  "field": "category_l3",
  "kw": "示例品类",
  "limit": 10,
  "task_query": "使用 pdd 数据执行品类商品排名;category=示例品类,time={\"last_complete_months\":3},ranking_metric=gmv,top_n=10"
}
query_metrics
{
  "dataset": "pdd",
  "filters": [
    {
      "field": "category_l3",
      "op": "eq",
      "value": "示例品类"
    }
  ],
  "group_by": [
    "product_id",
    "title",
    "product_url"
  ],
  "limit": 10,
  "metrics": [
    "gmv",
    "units"
  ],
  "order_by": [
    {
      "dir": "desc",
      "field": "gmv"
    }
  ],
  "task_query": "使用 pdd 数据执行品类商品排名;category=示例品类,time={\"last_complete_months\":3},ranking_metric=gmv,top_n=10",
  "time": {
    "last_complete_months": 3
  }
}

Agent computation

rank_products · rank

Preserve server ordering and the requested limit.

source_steps: query_products

Output policy

  • Return product IDs, titles, URLs, and ranking metrics.

Stop conditions

  • Stop if the category cannot be resolved exactly.

Limitations

  • Product titles are not available for fuzzy resolution.