Syntax
=DRAGON_SALES_TOTALS(account, [ASIN/SKU], [marketplace], [fulfillment], [period], [period view], [basis], [view], [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_SALES_TOTALS("help") in any cell to get the same reference without leaving your spreadsheet.Sample output
Illustrative values – your sheet shows your account's live data.
A1fx
=DRAGON_SALES_TOTALS("Myaccount", "", "US", "FBA", "last_7_days")| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | sku | asin | 2026-07-21 | 2026-07-20 | 2026-07-19 | 2026-07-18 | 2026-07-17 |
| 2 | MB-TEE-BLK-L_FBA | B0EXAMPLE1 | 17.95 | 34.95 | 51.95 | 68.95 | 85.95 |
| 3 | MB-TEE-NVY-M_FBA | B0EXAMPLE2 | 48.95 | 65.95 | 82.95 | 2.95 | 19.95 |
| 4 | MB-HAT-GRY_FBA | B0EXAMPLE3 | 79.95 | 96.95 | 16.95 | 33.95 | 50.95 |
| 5 | MB-MUG-11OZ_FBA | B0EXAMPLE4 | 13.95 | 30.95 | 47.95 | 64.95 | 81.95 |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname or Amazon account id. |
| ASIN/SKU | Optional | Optional ASIN, SKU, or comma/space separated list. 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. |
| fulfillment | Optional | Optional fulfillment filter: FBA or FBM. |
| period | Optional | Optional period such as last 90 days, 2026-04, or 2026. Default: last 90 days. |
| period view | Optional | Optional period view: DAY, WEEK, MONTH, QUARTER, YEAR, or TOTAL. Default: DAY. |
| basis | Optional | Optional row basis: ASIN or SKU. Default: ASIN. |
| view | Optional | Optional output view: DETAILS or SUMMARY. Default: DETAILS. |
| columns | Optional | Optional comma-separated output columns. Leave empty for ASIN/SKU; use none or - to suppress ASIN/SKU. Currently supported: currency. |
| 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. |
| currency | Yes | Currency. |
Examples
=DRAGON_SALES_TOTALS("Myaccount", "", "US", "FBA", "last 12 months", "month", "asin")
=DRAGON_SALES_TOTALS("Myaccount", "", "US", "", "last 12 months", "month", "asin", "summary")
=DRAGON_SALES_TOTALS("Myaccount", "A1:A10", "US", "FBA", "7_days", "total", "asin", "details", "none", "no")
Notes
- view: DETAILS returns ASIN/SKU rows. SUMMARY returns Amazon daily totals with precomputed FBA/FBM splits.
- columns: leave empty for ASIN/SKU; use compact, none, or - to suppress ASIN/SKU. Use currency to show currency instead of ASIN/SKU.