{"skill":{"slug":"linkfox-mpstats-ozon-brand-products","displayName":"Mpstats Ozon Brand Products","summary":"MPSTATS Ozon 俄罗斯站按品牌下钻商品列表。按 Ozon 品牌展示名（俄语/拉丁）返回该品牌下全部商品的销量、销售额、价格、评分、库存、周转、损失销售额等完整指标，支持多维数值筛选、排序、货币换算。用于品牌对标、竞品分析、品牌商品结构研究、ASIN 级（productId 级）爆款拆解。当用户提到 Oz...","description":"---\nname: linkfox-mpstats-ozon-brand-products\nversion: 1.0.0\ncategory: product-sourcing\ndescription: MPSTATS Ozon 俄罗斯站按品牌下钻商品列表。按 Ozon 品牌展示名（俄语/拉丁）返回该品牌下全部商品的销量、销售额、价格、评分、库存、周转、损失销售额等完整指标，支持多维数值筛选、排序、货币换算。用于品牌对标、竞品分析、品牌商品结构研究、ASIN 级（productId 级）爆款拆解。当用户提到 Ozon 品牌下钻、Ozon 品牌商品、Ozon 竞品品牌分析、品牌结构、品牌 SKU、品牌爆款、Ozon 品牌销售、MPSTATS brand, Ozon brand products, brand drill-down, brand competitor analysis, Russian marketplace brand SKUs, brand revenue share 时触发此技能。即使用户未明确说\"MPSTATS\"，只要意图是按 Ozon 品牌看该品牌下所有商品及其销量/价格/评分表现，也应触发此技能。\n---\n\n# MPSTATS Ozon Brand Products\n\nThis skill drills into all Ozon (Russia) products sold under a given brand display name, returning each SKU's sales, revenue, price, rating, stock, turnover, lost profit, and more. Built for brand competitor audits, brand SKU structure analysis, and bestseller dissection.\n\n## Core Concepts\n\n**Brand display name**: `brandName` must match what's shown on the Ozon storefront — typically Russian (Cyrillic) or Latin (`adidas`, `Xiaomi`). Do **not** pass a category path, a seller ID, or an internal brand code here. If unsure of the exact spelling, resolve via `mpstats-ozon-product-search` first.\n\n**Filters are AND-combined**: The `filters` array supports multiple numeric conditions ANDed together. Each filter is `{field, op, value, value2?}`. Common fields and operators are in the Filter Reference below.\n\n**Currency & rate**: Default currency is **RUB**. Set `currency: \"USD\"` (or another code) to have monetary fields converted server-side; `currencyRate` lets you override the default rate if desired.\n\n**FBO / FBS mix**: `includeFbs: true` folds FBS (seller-shipped) stock + sales into the numbers; `false` keeps them FBO-only.\n\n## Parameters\n\n| Parameter | Type | Required | Description |\n|-----------|------|----------|-------------|\n| brandName | string | yes | Ozon brand display name (Russian or Latin) |\n| startDate | string | no | Stats window start, `YYYY-MM-DD`; latest = yesterday |\n| endDate | string | no | Stats window end, `YYYY-MM-DD`; latest = yesterday |\n| page | integer | no | Page number, starts at 1 |\n| pageSize | integer | no | Rows per page, 1-100, default 100 |\n| sortField | string | no | snake_case column: `sales`, `revenue`, `final_price`, `balance`, `rating`, ... |\n| sortDirection | string | no | `asc` or `desc` |\n| currency | string | no | Currency code, default `RUB`; e.g. `USD`, `EUR`, `CNY` |\n| currencyRate | integer | no | Custom rate when non-default currency is used |\n| includeFbs | boolean | no | Include FBS data |\n| filters | array | no | Numeric filter conditions (see below) |\n\n## Filter Reference\n\nEach `filters` entry: `{\"field\": \"<snake_case>\", \"op\": \"<OP>\", \"value\": <num>, \"value2\": <num?>}`.\n\n**Common fields**: `sales` (monthly units), `final_price` (selling price RUB), `rating` (0-5), `comments` (review count), `balance` (stock), `revenue` (sales amount RUB), `days_in_stock`, `turnover_days`, `lost_profit`, `category_position`.\n\n**Operators**: `GTE`, `LTE`, `GT`, `LT`, `EQ`, `NOT_EQ`, `BETWEEN` (requires `value2` as the upper bound).\n\n## API Usage\n\nThis tool calls the LinkFox tool gateway API. See `references/api.md` for calling conventions, request parameters, response structure, and error codes. You can also execute `scripts/mpstats_ozon_brand_products.py` directly for ad-hoc queries.\n\n## Usage Examples\n\n**1. Top-50 by sales for brand `adidas`**\n```json\n{\n  \"brandName\": \"adidas\",\n  \"sortField\": \"sales\",\n  \"sortDirection\": \"desc\",\n  \"pageSize\": 50\n}\n```\n\n**2. High-rating, mid-price filter**\n```json\n{\n  \"brandName\": \"Xiaomi\",\n  \"filters\": [\n    {\"field\": \"rating\", \"op\": \"GTE\", \"value\": 4.5},\n    {\"field\": \"final_price\", \"op\": \"BETWEEN\", \"value\": 1000, \"value2\": 5000}\n  ],\n  \"sortField\": \"revenue\",\n  \"sortDirection\": \"desc\"\n}\n```\n\n**3. USD-converted output**\n```json\n{\n  \"brandName\": \"Nike\",\n  \"currency\": \"USD\",\n  \"sortField\": \"revenue\"\n}\n```\n\n**4. Include FBS + only in-stock items**\n```json\n{\n  \"brandName\": \"adidas\",\n  \"includeFbs\": true,\n  \"filters\": [{\"field\": \"balance\", \"op\": \"GT\", \"value\": 0}]\n}\n```\n\n**5. Lost-profit hunters (out-of-stock pain)**\n```json\n{\n  \"brandName\": \"Nike\",\n  \"filters\": [{\"field\": \"lost_profit\", \"op\": \"GTE\", \"value\": 100000}],\n  \"sortField\": \"lost_profit\",\n  \"sortDirection\": \"desc\"\n}\n```\n\n## Display Rules\n\n1. **Compact brand table** — key columns: `productId`, `title`, `price`, `monthlySalesUnits`, `monthlySalesRevenue`, `rating`, `reviewCount`, `balance`, `turnoverDays`, `lostProfit`.\n2. **Revenue share context** — `revenueSharePercent` is the SKU's share **within this brand result set**, 0-100; clarify the base when presenting.\n3. **Currency labeling** — always state the currency in the table header; if `currency` was overridden, note \"已按 USD 换算\".\n4. **Russian titles** — preserve original; translate on user request.\n5. **Pagination** — report total and guide the user to next page or narrower filters when total exceeds the returned page.\n6. **No business advice** — present the data; don't project future sales from a snapshot.\n\n## Important Limitations\n\n- **Exact brand-name match** — no fuzzy search; typos return empty results. Verify via `mpstats-ozon-product-search` if unsure.\n- **Page cap** — max 100 rows per page; paginate for larger brands.\n- **Date window** — `endDate` cannot be today or a future date (T-1 data).\n- **Currency conversion** — server-side; historical rates may differ slightly from the user's reference rate.\n- **Russian-only titles** — translate only when asked.\n\n## User Expression & Scenario Quick Reference\n\n**Applicable** — Brand-scoped Ozon product metrics:\n\n| User Says | Scenario |\n|-----------|----------|\n| \"Show me adidas's top-selling Ozon SKUs\" | Brand bestseller drill |\n| \"What does Xiaomi sell on Ozon, sorted by revenue\" | Brand revenue structure |\n| \"Which brand-X SKUs have rating ≥4.5 and stock >0\" | Brand quality filter |\n| \"Are brand-X's stockouts causing big lost profit\" | Lost-profit hunter |\n| \"Convert brand-X's Ozon sales to USD\" | Currency-normalized audit |\n\n**Not applicable** — Needs beyond brand drill-down:\n\n- Unknown exact brand name → first use `mpstats-ozon-product-search`\n- Category-level comparison across brands → use `mpstats-ozon-category-products`\n- Seller-scoped analysis → use `mpstats-ozon-seller-products`\n- Single-SKU time-series → use `mpstats-ozon-product-trend`\n- Wildberries / other Russian marketplaces → not covered\n\n**Boundary judgment**: Use this skill when the question centers on **one brand** and you want the per-SKU rollup under it. For \"which brand dominates category X\" use category drill-down and compare brand rows server-side.\n\n**Feedback:**\n\nAuto-detect and report feedback via the Feedback API when any of the following apply:\n1. The functionality or purpose described in this skill does not match actual behavior\n2. The skill's results do not match the user's intent\n3. The user expresses dissatisfaction or praise about this skill\n4. Anything you believe could be improved\n\nCall the feedback API as specified in `references/api.md`. Do not interrupt the user's flow.\n\n---\n*For more high-quality, professional cross-border e-commerce skills, set [LinkFox Skills](https://skill.linkfox.com/).*\n","tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":389,"installsAllTime":0,"installsCurrent":0,"stars":0,"versions":1},"createdAt":1778045996247,"updatedAt":1778492854429},"latestVersion":{"version":"1.0.0","createdAt":1778045996247,"changelog":"Initial release","license":"MIT-0"},"metadata":null,"owner":{"handle":"linkfox-ai","userId":"s171g8b6m2khwdy9ye8bxj0wx183vd4z","displayName":"linkfox-ai","image":"https://avatars.githubusercontent.com/u/267242260?v=4"},"moderation":null}