DRAGON_PPC_CROSS_ASIN_PURCHASES

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

Cross-ASIN purchases attributed to an advertised product.

Syntax

=DRAGON_PPC_CROSS_ASIN_PURCHASES(account, [ASIN], [marketplace], [ad type], [campaign], [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_CROSS_ASIN_PURCHASES("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_CROSS_ASIN_PURCHASES("Nordvik")
ABCDEF
1campaign_nameadvertised_asinpurchased_asinad_salesordersunits
2–––––85
3–––––19
4–––––50
5–––––81

Video walkthrough

Parameters

ParameterRequiredDescription
accountRequiredAccount nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account.
ASINOptionalOptional advertised ASIN scope filter. Separate several with ;. Also accepts a cell range like A2:A100 or INDIRECT() pointing to a list.
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.
basisOptionalOptional row basis: CROSS_ASIN, PURCHASED, ADVERTISED, or CAMPAIGN. Default: CROSS_ASIN.
filterOptionalOptional metric-range filter: metric:min-max tokens separated by ;, e.g. ad_sales:100-*; orders:5-*. Both ends required; * = open. Halo metrics only: ad_sales, orders, units.
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.
advertised_asinYesAdvertised ASIN.
purchased_asinYesPurchased (halo) ASIN.
campaign_idNoCampaign id.
advertised_asinsNoDistinct advertised ASINs driving the halo.
purchased_asinsNoDistinct purchased (halo) ASINs.
dateNoDate bucket (period_view other than TOTAL).
ad_salesYesAttributed sales from cross-ASIN purchases.
ordersYesAttributed orders from cross-ASIN purchases.
unitsYesAttributed units from cross-ASIN purchases.

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
ad_salesAttributed sales from cross-ASIN purchases.
ordersAttributed orders from cross-ASIN purchases.
unitsAttributed units from cross-ASIN purchases.

Examples

=DRAGON_PPC_CROSS_ASIN_PURCHASES("Mystore")
=DRAGON_PPC_CROSS_ASIN_PURCHASES("Mystore", "B0MYASIN02", "US", "SP", "", "last 30 days")

Notes

  • Attribution only: ad_sales, orders, units. No spend, clicks, or ROAS.
  • basis: CROSS_ASIN (default) = campaign x advertised ASIN x purchased ASIN; PURCHASED, ADVERTISED, and CAMPAIGN provide summaries.

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