Query advertising
query_advertisingReturns store-level advertising performance or paginated advertising performance metrics grouped by SKU, ASIN, or parent ASIN for a single store and business date range. MCP reporting and workflow metric date ranges use yyyy-MM-dd and include both startDate and endDate, with at most 95 calendar days per range. For longer read-only reports, split into non-overlapping windows: endDate = startDate plus 94 days, capped at the requested end date; the next startDate is the previous endDate plus 1 day. Apply the same limit independently to comparison ranges. Do not average ratios such as ACOS or ROAS across windows; recompute them from summed base metrics. Do not automatically split advertising write plans or metric-based selectors; obtain a supported analysis window from the user. Keyword ranking trends have separate limits: DAILY supports up to 90 inclusive days and RAW up to 31 inclusive days. For keyword ranking trends, use these interval-specific limits when splitting read-only reports. This reporting limit does not apply to campaign scheduling dates.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of items to return. Defaults to 100 and cannot exceed 100. | |
| offset | No | Zero-based pagination offset. | |
| sortBy | No | Advertising performance sort field. | |
| values | No | Optional identifiers for the selected dimension. | |
| endDate | Yes | End business date in yyyy-MM-dd format. Date range is inclusive and can contain at most 95 days. For longer read-only reports, use non-overlapping windows of up to 95 days. | |
| storeId | Yes | Store ID from the Stores API, formatted as sellerId:marketplaceId. | |
| dimension | No | Query dimension. | |
| sortOrder | No | Sort order. | |
| startDate | Yes | Start business date in yyyy-MM-dd format. Date range is inclusive and can contain at most 95 days. For longer read-only reports, use non-overlapping windows of up to 95 days. | |
| reportType | No | Report type. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||