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
Illustrative values – your sheet shows your account's live data.
A1fx
=DRAGON_PPC_NEGATIVES("Myaccount")| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | target_text | match_type | level | state | campaign_id | added_date |
| 2 | – | – | – | – | – | 2026-07-21 |
| 3 | – | – | – | – | – | 2026-07-20 |
| 4 | – | – | – | – | – | 2026-07-19 |
| 5 | – | – | – | – | – | 2026-07-18 |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname or Amazon account id. |
| marketplace | Optional | Optional marketplace/country code such as US, CA, or MX. |
| 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; comma/space separated list. |
| ad group | Optional | Optional ad group id scope filter; comma/space separated list. |
| target | Optional | Optional exact negative text or target id filter; comma/space separated list. |
| 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 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. |
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 |
|---|---|---|
| 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("Myaccount")
=DRAGON_PPC_NEGATIVES("Myaccount", "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.