Syntax
Parameters in [brackets] are optional. Leave an optional parameter blank to include everything.
=DRAGON_PPC_CROSS_ASIN_PURCHASES("help") in any cell to get the same reference without leaving your spreadsheet.Sample output
Illustrative values – your sheet shows your account's live data.
=DRAGON_PPC_CROSS_ASIN_PURCHASES("Myaccount")| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | campaign_name | advertised_asin | purchased_asin | ad_sales | orders | units |
| 2 | – | – | – | – | – | 0 |
| 3 | – | – | – | – | – | 19 |
| 4 | – | – | – | – | – | 12 |
| 5 | – | – | – | – | – | 81 |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname or Amazon account id. |
| ASIN | Optional | Optional advertised ASIN scope filter; comma/space separated list. Also accepts a cell range like A2:A100 or INDIRECT() pointing to a list. |
| marketplace | Optional | Optional marketplace/country code such as US, CA, or MX. |
| ad type | Optional | Optional ad type: SP, SB, SD, or ALL. Default: SP. |
| campaign | Optional | Optional campaign id scope filter; comma/space separated list. |
| period | Optional | Optional period such as last 30 days, 2026-08, or 2026. Default: last 30 days. |
| period view | Optional | Optional period view: TOTAL, DAY, WEEK, or MONTH. Default: TOTAL. |
| basis | Optional | Optional row basis: CROSS_ASIN, PURCHASED, ADVERTISED, or CAMPAIGN. Default: CROSS_ASIN. |
| filter | Optional | Optional metric-range filter: metric:min-max tokens, space-separated, e.g. ad_sales:100-* orders:5-*. Both ends required; * = open. Halo metrics only: ad_sales, orders, units. |
| columns | Optional | Optional comma-separated output columns. |
| header | Optional | Use no, false, or 0 to suppress the output header row. Default: Yes. |
| transpose | Optional | Use 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.
| Column | Default | Description |
|---|---|---|
| campaign_name | Yes | Campaign name. |
| advertised_asin | Yes | Advertised ASIN. |
| purchased_asin | Yes | Purchased (halo) ASIN. |
| campaign_id | No | Campaign id. |
| advertised_asins | No | Distinct advertised ASINs driving the halo. |
| purchased_asins | No | Distinct purchased (halo) ASINs. |
| date | No | Date bucket (period_view other than TOTAL). |
| ad_sales | Yes | Attributed sales from cross-ASIN purchases. |
| orders | Yes | Attributed orders from cross-ASIN purchases. |
| units | Yes | Attributed 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:
| Metric | Description |
|---|---|
| ad_sales | Attributed sales from cross-ASIN purchases. |
| orders | Attributed orders from cross-ASIN purchases. |
| units | Attributed units from cross-ASIN purchases. |
Examples
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.