Syntax
=DRAGON_SQP_LIST(account, [ASIN/SKU], [marketplace], [period], [brand], [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_SQP_LIST("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_SQP_LIST("Myaccount", "", "US", "last 90 days", "Mybrand")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | report_id | marketplace | week_start | week_end | brand | asin | search_query_count | best_score | … |
| 2 | – | US | – | – | Mybrand | B0EXAMPLE1 | 0 | – | … 6 more |
| 3 | – | US | – | – | Mybrand | B0EXAMPLE2 | 19 | – | … 6 more |
| 4 | – | US | – | – | Mybrand | B0EXAMPLE3 | 12 | – | … 6 more |
| 5 | – | US | – | – | Mybrand | B0EXAMPLE4 | 81 | – | … 6 more |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname or Amazon account id. |
| ASIN/SKU | Optional | Optional ASIN or comma/space separated ASIN 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. |
| period | Optional | Optional period such as last 90 days, 2026-04, or 2026. Default: last 90 days. |
| brand | Optional | Optional brand filter. |
| columns | Optional | Optional comma-separated output columns. |
| 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 |
|---|---|---|
| report_id | Yes | Report ID. |
| marketplace | Yes | Marketplace. |
| week_start | Yes | Report week start. |
| week_end | Yes | Report week end. |
| brand | Yes | Brand. |
| asin | Yes | ASIN. |
| search_query_count | Yes | Distinct search query count. |
| best_score | Yes | Best search query score. |
| worst_score | Yes | Worst search query score. |
| total_volume | Yes | Sum of search query volume. |
| selected_impressions | Yes | Selected ASIN impressions. |
| selected_clicks | Yes | Selected ASIN clicks. |
| selected_cart_adds | Yes | Selected ASIN cart adds. |
| selected_purchases | Yes | Selected ASIN purchases. |
| row_count | No | Source row count. |
| marketplace_id | No | Marketplace id. |
| seller_id | No | Seller id. |
Examples
=DRAGON_SQP_LIST("Myaccount", "", "US", "last 90 days", "Mybrand")