DRAGON_PPC_SEARCH_TERMS

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

Customer search-term performance – what shoppers actually typed. Sponsored Products / Brands only.

Syntax

=DRAGON_PPC_SEARCH_TERMS(account, [search term], [marketplace], [ad type], [campaign], [ad group], [target], [period], [period view], [basis], [filter], [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_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.

A1fx=DRAGON_PPC_SEARCH_TERMS("Nordvik")
ABCDEFGHI
1search_termmatch_typespendad_salesordersclicksimpressionsctr…
2––––––––… 2 more
3––––––––… 2 more
4––––––––… 2 more
5––––––––… 2 more

Video walkthrough

Parameters

ParameterRequiredDescription
accountRequiredAccount nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account.
search termOptionalOptional 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.
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, or ALL (SD has no search terms). Default: SP.
campaignOptionalOptional campaign id scope filter. Separate several with ;.
ad groupOptionalOptional ad group id scope filter. Separate several with ;.
targetOptionalOptional matched keyword id scope filter. Separate several with ;.
periodOptionalOptional period such as last 30 days, 2026-08, or 2026. Default: last 30 days.
period viewOptionalOptional period view: TOTAL, DAY, WEEK, or MONTH. Default: TOTAL.
basisOptionalOptional 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.
filterOptionalOptional 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.
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.

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.

ColumnDefaultDescription
seller_idNoAmazon seller id (merchant token) of the store.
search_termYesCustomer search term.
match_typeYesMatch type(s) the term came in through: BROAD, PHRASE, EXACT, AUTO (auto targeting) or PRODUCT (product/category targeting).
campaign_nameNoCampaign name (shown when a search term is given).
ad_group_nameNoAd group name (shown when a search term is given).
campaignsNoDistinct campaigns the term appeared in.
keyword_idNoMatched keyword id (basis=TARGET).
campaign_idNoCampaign id (basis=CAMPAIGN).
ad_group_idNoAd group id.
dateNoDate bucket (period_view other than TOTAL).
spendYesAd spend (SUM of cost).
ad_salesYesAttributed sales, 7-day.
ordersYesAttributed orders, 7-day.
clicksYesClicks.
impressionsYesImpressions.
unitsNoAttributed units, 7-day.
ctrYesClick-through rate %.
cpcYesCost per click.
cvrNoConversion rate % (orders / clicks).
acosNoACOS %.
roasYesROAS.

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:

MetricDescription
spendAd spend (SUM of cost).
ad_salesAttributed sales, 7-day.
ordersAttributed orders, 7-day.
clicksClicks.
impressionsImpressions.
unitsAttributed units, 7-day.
ctrClick-through rate %.
cpcCost per click.
cvrConversion rate % (orders / clicks).
acosACOS %.
roasROAS.

Examples

=DRAGON_PPC_SEARCH_TERMS("Mystore")
=DRAGON_PPC_SEARCH_TERMS("Mystore", "insulated coffee mug", "US", "SP", "", "", "", "last 30 days")
=DRAGON_PPC_SEARCH_TERMS("Mystore", "insulated coffee mug; travel mug", "US", "ALL", "", "", "", "2026-09")

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