DRAGON_PPC_NEGATIVES

Documentation for SellerDragon – Amazon sales, PPC and keyword data in Google Sheets™, a dashboard and your AI.

Negative keywords/targets (structure only – no metrics). level is CAMPAIGN or ADGROUP.

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")
ABCDEF
1target_textmatch_typelevelstatecampaign_idadded_date
2–––––2026-10-12
3–––––2026-10-11
4–––––2026-10-10
5–––––2026-10-09

Video walkthrough

Parameters

ParameterRequiredDescription
accountRequiredAccount nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account.
marketplaceOptionalOne 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 typeOptionalOptional ad type: SP, SB, SD, or ALL. Default: SP.
levelOptionalOptional ownership level: CAMPAIGN, ADGROUP, or ALL. Default: ALL.
campaignOptionalOptional campaign id scope filter. Separate several with ;.
ad groupOptionalOptional ad group id scope filter. Separate several with ;.
targetOptionalOptional exact negative text, target id, or excluded ASIN/brand filter (case-insensitive). Separate several with ;.
match typeOptionalOptional negative match type: EXACT, PHRASE, or ALL. Default: ALL.
stateOptionalOptional state: ACTIVE, PAUSED, ARCHIVED, or ALL. Default: ACTIVE.
columnsOptionalOptional output columns separated by ;.
headerOptionalUse no, false, or 0 to suppress the output header row. Default: Yes.
transposeOptionalUse 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.

ColumnDefaultDescription
seller_idNoAmazon seller id (merchant token) of the store.
target_textYesNegative keyword or target expression.
match_typeYesNegative match type.
levelYesOwnership level (CAMPAIGN or AD_GROUP).
target_typeNoTarget type.
stateYesState.
campaign_idYesCampaign id.
ad_group_idNoAd group id.
target_idNoTarget id.
added_dateYesDate 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