Syntax
=DRAGON_SQP(account, [ASIN/SKU], [marketplace], [report ID], [period], [search query], [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("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_SQP("Nordvik", "", "US", "", "last 30 days", "", "Nordvik")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | marketplace | date_from | date_to | brand | search_query | best_score | volume | total_impressions | … |
| 2 | US | 2026-10-12 | 2026-10-12 | Nordvik | – | – | – | 28.95 | … 11 more |
| 3 | US | 2026-10-11 | 2026-10-11 | Nordvik | – | – | – | 29.95 | … 11 more |
| 4 | US | 2026-10-10 | 2026-10-10 | Nordvik | – | – | – | 30.95 | … 11 more |
| 5 | US | 2026-10-09 | 2026-10-09 | Nordvik | – | – | – | 56.95 | … 11 more |
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 or an ASIN 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. |
| report ID | Optional | Optional report ID from DRAGON_SQP_LIST. |
| period | Optional | Optional period such as last 90 days, 2026-04, or 2026. Default: last 90 days. |
| search query | Optional | Optional search query text filter. |
| brand | Optional | Optional brand filter. Separate several brands with ;. |
| columns | Optional | Optional output columns separated by ;. |
| 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 | No | Report ID. |
| marketplace | Yes | Marketplace. |
| date_from | Yes | First report week start. |
| date_to | Yes | Last report week end. |
| brand | Yes | Brand. |
| search_query | Yes | Search query. |
| best_score | Yes | Best selected search query score. |
| volume | Yes | Search query volume. |
| total_impressions | Yes | Total query impressions. |
| selected_impressions | Yes | Selected ASIN impressions. |
| impression_share | Yes | Selected impression share. |
| total_clicks | Yes | Total clicks. |
| selected_clicks | Yes | Selected ASIN clicks. |
| click_share | Yes | Selected click share. |
| total_cart_adds | Yes | Total cart adds. |
| selected_cart_adds | Yes | Selected ASIN cart adds. |
| cart_add_share | Yes | Selected cart add share. |
| total_purchases | Yes | Total purchases. |
| selected_purchases | Yes | Selected ASIN purchases. |
| purchase_share | Yes | Selected purchase share. |
| selected_asin_count | No | Selected ASIN count. |
| marketplace_id | No | Marketplace id. |
| seller_id | No | Seller id. |
| total_click_rate | No | Total click rate. |
| total_cart_add_rate | No | Total cart add rate. |
| total_purchase_rate | No | Total purchase rate. |
| total_same_day_shipping_click_count | No | Total same day shipping click count. |
| total_one_day_shipping_click_count | No | Total one day shipping click count. |
| total_two_day_shipping_click_count | No | Total two day shipping click count. |
| total_same_day_shipping_cart_add_count | No | Total same day shipping cart add count. |
| total_one_day_shipping_cart_add_count | No | Total one day shipping cart add count. |
| total_two_day_shipping_cart_add_count | No | Total two day shipping cart add count. |
| total_same_day_shipping_purchase_count | No | Total same day shipping purchase count. |
| total_one_day_shipping_purchase_count | No | Total one day shipping purchase count. |
| total_two_day_shipping_purchase_count | No | Total two day shipping purchase count. |
Examples
=DRAGON_SQP("Mystore", "", "US", "", "last 30 days", "", "Mybrand")