DRAGON_PPC_CAMPAIGNS

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

Sponsored Ads campaign performance over a period. Use basis=PLACEMENT to split by placement.

Syntax

=DRAGON_PPC_CAMPAIGNS(account, [campaign], [marketplace], [ad type], [period], [period view], [basis], [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_CAMPAIGNS("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_CAMPAIGNS("Nordvik")
ABCDEFGHI
1campaign_namespendad_salesordersclicksimpressionsctrcpc…
2––––––––… 1 more
3––––––––… 1 more
4––––––––… 1 more
5––––––––… 1 more

Video walkthrough

Parameters

ParameterRequiredDescription
accountRequiredAccount nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account.
campaignOptionalOptional campaign 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.
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: CAMPAIGN or PLACEMENT. Default: CAMPAIGN.
stateOptionalOptional campaign 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_idNoCampaign id.
campaign_nameYesCampaign name.
ad_typeNoAd type (SP, SB, SD).
portfolioNoPortfolio id.
stateNoCampaign state.
delivery_statusNoDelivery status.
budgetNoCampaign budget.
budget_typeNoBudget type.
bid_strategyNoBid strategy.
placementNoPlacement (basis=PLACEMENT).
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_CAMPAIGNS("Mystore")
=DRAGON_PPC_CAMPAIGNS("Mystore", "", "US", "SP", "last 30 days", "week")
=DRAGON_PPC_CAMPAIGNS("Mystore", "", "US", "SP", "last 14 days", "total", "placement")

Notes

  • Stats only – bids and budgets are managed in the dashboard, not the sheet.
  • ad_type defaults to SP. state defaults to ACTIVE (current state); use ALL to include paused/archived.
  • period_view other than TOTAL returns one row per date bucket (long format).

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