Syntax
=DRAGON_KEYWORD_DETAILS(account, [asin], [marketplace], [keyword], [period], [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_KEYWORD_DETAILS("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_KEYWORD_DETAILS("Nordvik", "", "US", "yoga mat", "last 30 days", "marketplace; last_seen")| A | B | |
|---|---|---|
| 1 | keyword | asin |
| 2 | – | B0KNIT0101 |
| 3 | – | B0KNIT0104 |
| 4 | – | B0KNIT0109 |
| 5 | – | B0KNIT0121 |
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 | 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 | One marketplace/country code such as US, CA, or MX. Blank = this sheet's default marketplace (Extensions > SellerDragon > Default Marketplace); without a default, enter one. |
| keyword | Optional | Optional tracked keyword. With a keyword, rows are ASINs; with only an ASIN, rows are that ASIN's tracked keywords. Enter at least one of asin or keyword. |
| period | Optional | Optional period such as last 90 days, 2026-04, or 2026. Default: last 90 days. |
| columns | Optional | Optional output columns. Use marketplace or last_seen to include them. |
| 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 |
|---|---|---|
| keyword | Yes | Tracked keyword. |
| marketplace | No | Marketplace. |
| asin | Yes | ASIN. |
| last_seen | No | Latest SERP date in the selected period. |
Examples
=DRAGON_KEYWORD_DETAILS("Mystore", "", "US", "yoga mat", "last 30 days", "marketplace; last_seen")
=DRAGON_KEYWORD_DETAILS("Mystore", "B0MYASIN01", "US", "", "last 30 days")
Notes
- With a keyword, rows are the ASINs ranking for it; with only an ASIN, rows are its tracked keywords. Dates are columns either way.
- Date columns are the search dates with a rank in the selected period. A rank is stored only when the ASIN is in the top 500 for the keyword: a blank cell means not in the top 500 on that date, or not searched that day.