DRAGON_PPC_ADGROUPS

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

Ad group performance, rolled up from target facts by ad group.

Syntax

=DRAGON_PPC_ADGROUPS(account, [ad group], [marketplace], [ad type], [campaign], [period], [period view], [state], [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_ADGROUPS("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_ADGROUPS("Nordvik")
ABCDEFGHI
1campaign_namead_group_namespendad_salesordersclicksimpressionsctr…
2––––––––… 2 more
3––––––––… 2 more
4––––––––… 2 more
5––––––––… 2 more

Parameters

ParameterRequiredDescription
accountRequiredAccount nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account.
ad groupOptionalOptional ad group id or name filter. Separate several with ;.
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.
campaignOptionalOptional campaign 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.
stateOptionalOptional ad group state: ACTIVE, PAUSED, ARCHIVED, or ALL. Default: ACTIVE.
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.
campaign_nameYesCampaign name.
ad_group_idNoAd group id.
ad_group_nameYesAd group name.
campaign_idNoCampaign id.
default_bidNoAd group default bid.
stateNoAd group state.
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.
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.
acosACOS %.
roasROAS.

Examples

=DRAGON_PPC_ADGROUPS("Mystore")
=DRAGON_PPC_ADGROUPS("Mystore", "", "US", "SP", "", "last 30 days", "week")

Notes

  • Metrics roll up from keyword/target facts within each ad group.
  • ad_type defaults to SP; state defaults to ACTIVE. 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