affiliate_query_brand_data
Run read-only analytical queries on 30-day brand data to compute commissions, pending splits, and top programmes, with results grouped by currency.
Instructions
Run a read-only analytical query (filters, group-bys, sums, top-N) over the persisted 30-day brand dataset and return a small, exact result. Use this to answer questions over a large account's full data — commission by programme and month, the pending split by network, top programmes by commission — without pulling every row through a tool result; build a snapshot first with affiliate_build_brand_snapshot, and note aggregate results always group by currency because sums never cross currencies. Returns grouped metrics (or matching rows with mode "rows") plus the persisted coverage window, an explicit coverageMismatch when the requested range extends beyond it, and an explicit unsupported result when the store fell back to aggregated mode; this is a paid brand-data tool gated by the local entitlement check.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | ||
| brand | Yes | ||
| limit | No | ||
| offset | No | ||
| filters | No | ||
| groupBy | No | ||
| metrics | No | ||
| orderBy | No |