Syntax
=DRAGON_PPC_NEGATIVES(account, [marketplace], [ad type], [level], [campaign], [ad group], [target], [match type], [state], [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_PPC_NEGATIVES("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_PPC_NEGATIVES("Nordvik")| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | target_text | match_type | level | state | campaign_id | added_date |
| 2 | – | – | – | – | – | 2026-10-12 |
| 3 | – | – | – | – | – | 2026-10-11 |
| 4 | – | – | – | – | – | 2026-10-10 |
| 5 | – | – | – | – | – | 2026-10-09 |
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. |
| 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, SD, or ALL. Default: SP. |
| level | Optional | Optional ownership level: CAMPAIGN, ADGROUP, or ALL. Default: ALL. |
| 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 exact negative text, target id, or excluded ASIN/brand filter (case-insensitive). Separate several with ;. |
| match type | Optional | Optional negative match type: EXACT, PHRASE, or ALL. Default: ALL. |
| state | Optional | Optional state: ACTIVE, PAUSED, ARCHIVED, or ALL. Default: ACTIVE. |
| 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. |
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. |
| target_text | Yes | Negative keyword or target expression. |
| match_type | Yes | Negative match type. |
| level | Yes | Ownership level (CAMPAIGN or AD_GROUP). |
| target_type | No | Target type. |
| state | Yes | State. |
| campaign_id | Yes | Campaign id. |
| ad_group_id | No | Ad group id. |
| target_id | No | Target id. |
| added_date | Yes | Date the negative was created. |
Examples
=DRAGON_PPC_NEGATIVES("Mystore")
=DRAGON_PPC_NEGATIVES("Mystore", "US", "SP", "adgroup")
Notes
- Negatives carry no performance metrics; this lists what is negated and where.
- No period – it is a current-state list. Stats live in the other PPC functions.
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