TACOS (total ad cost of sales)
get_tacosUse for ASIN-level TACOS/PPC share from Business Reports plus aligned SP/SD product data. Ads stop at the latest Business Report date in the requested window. ad_sales is SP same-SKU 14-day attributed sales plus SD promoted-ASIN sales; total_attributed_ad_sales separately retains SP halo plus SD promoted-ASIN sales for compatibility. organic_sales is approximate Business Report sales less product-attributed ad_sales. TACOS remains SP+SD spend divided by Business Report sales; ASIN-level ACOS uses product-attributed ad_sales. Sponsored Brands and DSP are excluded. Use campaign tools for campaign ACOS.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| asin | No | Filter by child ASIN (exact match) | |
| limit | No | Max rows (1-1000, default 20). | |
| offset | No | Pagination offset (0-100000, default 0). Use the returned pagination.next_offset to continue. | |
| sort_by | No | Column to sort by | total_sales |
| end_date | No | Optional. YYYY-MM-DD. Defaults to today if omitted. | |
| group_by | No | Output grain. asin (default) returns one row per child ASIN; parent_asin rolls sales and SP/SD ad spend up across size/color variations to the parent ASIN. | asin |
| sort_order | No | Sort order | desc |
| start_date | No | Optional. YYYY-MM-DD. Defaults to 30 days ago if omitted. | |
| parent_asin | No | Filter to one variation family (exact match on the Business Report parent ASIN). With group_by=asin returns one row per child in the family; with group_by=parent_asin returns that family's single rollup row. | |
| channel_split | No | Add deterministic per-ASIN spend and product-attributed sales columns. sp_ad_sales uses SP same-SKU sales; sd_ad_sales uses SD promoted-ASIN sales; sp_total_attributed_ad_sales retains SP halo sales. Sponsored Brands and DSP have no per-ASIN spend attribution and are excluded from these and from ad_spend/tacos; use get_sb_campaign_performance for Sponsored Brands. | |
| include_raw_rows | No | False returns compact rows. Default true. | |
| include_zero_sales | No | Include ASINs/parents that have SP/SD ad activity but no Business Report sales row in the window. Default false returns only products with Business Report presence. | |
| include_diagnostics | No | True may add expanded freshness diagnostics. Basic empty-result data-window diagnostics are included by default when available. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| evidence | No |