Syntax
Parameters in [brackets] are optional. Leave an optional parameter blank to include everything.
=DRAGON_PPC_SEARCH_TERMS("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.
=DRAGON_PPC_SEARCH_TERMS("Nordvik")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | search_term | match_type | spend | ad_sales | orders | clicks | impressions | ctr | … |
| 2 | – | – | – | – | – | – | – | – | … 2 more |
| 3 | – | – | – | – | – | – | – | – | … 2 more |
| 4 | – | – | – | – | – | – | – | – | … 2 more |
| 5 | – | – | – | – | – | – | – | – | … 2 more |
Video walkthrough
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account. |
| search term | Optional | Optional exact customer search term filter (case-insensitive). Separate several with ;. When given, each campaign, ad group and match type the term appeared in gets its own row. |
| 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. |
| ad type | Optional | Optional ad type: SP, SB, or ALL (SD has no search terms). Default: SP. |
| campaign | Optional | Optional campaign id scope filter. Separate several with ;. |
| ad group | Optional | Optional ad group id scope filter. Separate several with ;. |
| target | Optional | Optional matched keyword id scope filter. Separate several with ;. |
| period | Optional | Optional period such as last 30 days, 2026-08, or 2026. Default: last 30 days. |
| period view | Optional | Optional period view: TOTAL, DAY, WEEK, or MONTH. Default: TOTAL. |
| basis | Optional | Optional row basis. SEARCH_TERM (default): one row per search term, or per campaign, ad group and match type when a search term is given. TARGET: one row per search term and matched keyword or target. CAMPAIGN: one row per search term and campaign. Default: SEARCH_TERM. |
| filter | Optional | Optional metric-range filter: metric:min-max tokens separated by ;, e.g. roas:1-3; spend:25-*; impressions:0-10. Both ends required; * = open. Metric names match output columns. |
| 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 |
|---|---|---|
| seller_id | No | Amazon seller id (merchant token) of the store. |
| search_term | Yes | Customer search term. |
| match_type | Yes | Match type(s) the term came in through: BROAD, PHRASE, EXACT, AUTO (auto targeting) or PRODUCT (product/category targeting). |
| campaign_name | No | Campaign name (shown when a search term is given). |
| ad_group_name | No | Ad group name (shown when a search term is given). |
| campaigns | No | Distinct campaigns the term appeared in. |
| keyword_id | No | Matched keyword id (basis=TARGET). |
| campaign_id | No | Campaign id (basis=CAMPAIGN). |
| ad_group_id | No | Ad group id. |
| date | No | Date bucket (period_view other than TOTAL). |
| spend | Yes | Ad spend (SUM of cost). |
| ad_sales | Yes | Attributed sales, 7-day. |
| orders | Yes | Attributed orders, 7-day. |
| clicks | Yes | Clicks. |
| impressions | Yes | Impressions. |
| units | No | Attributed units, 7-day. |
| ctr | Yes | Click-through rate %. |
| cpc | Yes | Cost per click. |
| cvr | No | Conversion rate % (orders / clicks). |
| acos | No | ACOS %. |
| roas | Yes | ROAS. |
Filter metrics
The filter parameter narrows rows by metric range on the server, before the row limit – so a narrow filter returns the narrow set instead of a truncated one. Write metric:min-max tokens separated by spaces; both ends are required and * means an open end (for example roas:1-3 spend:25-*). Only these metrics can be filtered:
| Metric | Description |
|---|---|
| spend | Ad spend (SUM of cost). |
| ad_sales | Attributed sales, 7-day. |
| orders | Attributed orders, 7-day. |
| clicks | Clicks. |
| impressions | Impressions. |
| units | Attributed units, 7-day. |
| ctr | Click-through rate %. |
| cpc | Cost per click. |
| cvr | Conversion rate % (orders / clicks). |
| acos | ACOS %. |
| roas | ROAS. |
Examples
Notes
- A search term is what a customer typed, not a keyword you bid on – different from DRAGON_PPC_TARGETS.
- Without a search term: one row per search term, with every match type it came in through. With a search term: one row per campaign, ad group and match type it appeared in.
- Search terms match exactly but ignore upper/lower case. Separate several with ;.
- Match types: BROAD, PHRASE, EXACT (keywords), AUTO (auto targeting), PRODUCT (product or category targeting).
- ad_type is SP or SB only; Sponsored Display has no search terms. Stats only.
Not running SellerDragon yet? One connected account – your data in Google Sheets™, a dashboard that acts, and your AI on the account. Plans from 99 USD.
See how it works