Syntax
=DRAGON_OOS_RATE(account, [ASIN/SKU], [marketplace], [period], [view], [basis], [columns], [header], [transpose])
Parameters in [brackets] are optional. Leave an optional parameter blank to include everything.
This page is also available inside Sheets – type
=DRAGON_OOS_RATE("help") in any cell to get the same reference without leaving your spreadsheet.Sample output
Example output from the Nordvik demo store – your sheet shows your own store's data.
A1fx
=DRAGON_OOS_RATE("Nordvik", "", "US", "last 90 days", "total", "asin", "none", "no")| A | B | C | |
|---|---|---|---|
| 1 | asin | sku | marketplace |
| 2 | B0KNIT0101 | NV-HAT-CHARCOAL | US |
| 3 | B0KNIT0104 | NV-HAT-NAVY | US |
| 4 | B0KNIT0109 | NV-TEE-BLACK-L | US |
| 5 | B0KNIT0121 | NV-SWT-CHARCOAL-L | US |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account. |
| ASIN/SKU | Optional | Optional ASIN, SKU, or a list separated by ;. Also accepts a cell range like A2:A100 or INDIRECT() pointing to a list. |
| marketplace | Optional | Optional marketplace/country code such as US, CA, or MX. |
| period | Optional | Optional period such as last 30 days, 2026-04, or 2026. Default: last 30 days. |
| view | Optional | Optional output view: TOTAL, ASIN, or SKU. Default: ASIN. |
| basis | Optional | Optional row basis: ASIN or SKU. Default: ASIN. |
| columns | Optional | Optional output columns: asin or sku, marketplace. Leave empty for all; -marketplace hides marketplace; none or - shows only the rate. |
| header | Optional | Use no, false, or 0 to suppress the output header row. Default: Yes. |
| transpose | Optional | Use yes, true, or 1 to transpose the output. |
The period accepts values like last_30_days, this_month, 2026Q1, or ranges like 2026-01-01..today – see the full period reference.
Columns
Columns are evaluated left to right: a field or group name adds columns, a leading - removes them. default and all select the default or full column set.
| Column | Default | Description |
|---|---|---|
| asin | Yes | Asin. |
| sku | Yes | Seller sku. |
| marketplace | Yes | Marketplace. |
Examples
=DRAGON_OOS_RATE("Mystore", "", "US", "last 90 days", "total", "asin", "none", "no")
=DRAGON_OOS_RATE("Mystore", "A1:A10", "US", "last 30 days", "asin")
Notes
- OOS rate = days with nothing sellable at FBA divided by FBA inventory days. Inbound, reserved, researching and unsellable units do not count as sellable.
- A listed ASIN/SKU with no FBA inventory days in the period (FBM-only, unknown or mistyped) shows "–".
- Every rate covers one marketplace: a product sold in US and CA gets one row per marketplace.
- view: total returns one rate per marketplace; asin or sku returns one rate per product and marketplace.
- columns: leave empty for ASIN/SKU and marketplace; name asin, sku or marketplace to pick, or -marketplace to hide it; use none or - to show only the rate.