Missed Opportunity Report

This endpoint enables Retail Media DSP partners to diagnose budget cap-out and estimate missed delivery for their campaigns and line items. Cap-out occurs when a line item exhausts its daily budget before the day ends, causing it to stop participating in eligible auctions. Missed traffic is reported for any line item that did not participate in all eligible auctions during the day. The response is aggregated — one row per day per line item (or per combination of dimensions you specify). All metrics relate to delivery shortfalls; no performance metrics (impressions served, clicks, revenue) are included. For performance metrics, use POST /reports/performance. Primary audience: Engineers and ops teams diagnosing delivery shortfalls. Not a campaign performance reporting surface. The endpoint supports asynchronous report generation. Submit a request, poll for status, and download the output when ready.

Request

POST /2026-07/retail-media/reports/missed-opportunities

Required fields

startDate, endDate, filters, dimensions, and metrics are all required. filters must contain exactly one scope filter (filters.accountIds[], filters.campaignIds[], or filters.lineItemIds[]).

Field	Type	Description
`startDate`	string	Inclusive report start date. ISO 8601 date (`YYYY-MM-DD`).
`endDate`	string	Inclusive report end date. ISO 8601 date (`YYYY-MM-DD`). Must be ≥ `startDate`. Dates are interpreted in UTC.
`filters`	object	Required. Must contain exactly one of the scope filters below.
`filters.accountIds[]`	array of strings	Scope to all line items under this account. Mutually exclusive with `campaignIds` and `lineItemIds`.
`filters.campaignIds[]`	array of strings	Scope to all line items under this campaign. Mutually exclusive with `accountIds` and `lineItemIds`.
`filters.lineItemIds[]`	array of strings	Scope to this line item. Mutually exclusive with `accountIds` and `campaignIds`.
`dimensions`	array of strings	Required. Output grouping fields. See Dimensions below.
`metrics`	array of strings	Required. Output measure fields. See Metrics below.

Optional fields

Field	Type	Default	Description
`format`	string	`json-compact`	Output format: `json`, `json-compact`, `json-newline`, or `csv`.
`filters.salesChannels[]`	array of strings	—	Filter by sales channel.
`filters.mediaTypes[]`	array of strings	—	Filter by media type.

Example request

POST /2026-07/retail-media/reports/missed-opportunities
Authorization: Bearer {token}
Content-Type: application/json

{
  "data": {
    "type": "AsyncMissedOpportunitiesReport",
    "attributes": {
      "startDate": "2026-05-01",
      "endDate": "2026-05-07",
      "filters": {
        "lineItemIds": ["987654"]
      },
      "dimensions": ["date", "lineItemId", "lineItemName"],
      "metrics": ["missedTraffic", "missedSpend", "capoutHour"]
    }
  }
}

Response

A successful request returns 200 OK with a reportId. Poll for status until status is success or failure:

GET /2026-07/retail-media/reports/{reportId}/status
Authorization: Bearer {token}

Download the output when status is success:

GET /2026-07/retail-media/reports/{reportId}/output
Authorization: Bearer {token}

Each row in the report output represents one day (or one combination of dimensions, if dimensions were specified).

Metrics

Select metrics using the metrics[] array in your request. metrics is required.

Metric	Description
`capoutHour`	Hour of the day when the line item exhausted its daily budget, on average. A value of `14` means budget was exhausted around 2pm on average.
`missedClicks`	Estimated clicks lost due to reduced auction participation.
`missedImpressions`	Estimated impressions lost due to reduced auction participation.
`missedSales`	Estimated revenue lost due to reduced auction participation, in the account’s reporting currency.
`missedSpend`	Estimated spend that would have occurred had the line item participated in all eligible auctions.
`missedTraffic`	Percentage of the day’s total eligible traffic the line item did not participate in.
`daypartingScheduled`	Binary: whether dayparting was active at the time of the cap-out event.
`totalSpend`	Total media spend for the line item.
`roas`	Return on ad spend — revenue per unit of currency spent.
`attributedSales`	Sales revenue attributed to the campaign per attribution settings.
`impressions`	Impressions served.
`clicks`	Clicks counted.
`cpc`	Average cost per click.
`cpm`	Average cost per 1,000 impressions.
`ctr`	Click-through rate: clicks / impressions.

All “missed” estimates are modeled — they represent what the line item would have delivered had it participated in all eligible auctions.

Dimensions

Select grouping dimensions using the dimensions[] array in your request. dimensions is required.

Dimension	Description
`date`	Date events occurred.
`campaignId`	Campaign ID.
`campaignName`	Campaign name.
`lineItemId`	Line item ID.
`lineItemName`	Line item name.
`retailerId`	Retailer ID where the line item served.
`retailerName`	Retailer name where the line item served.
`buyType`	Buy type of the line item.
`bidStrategy`	Bid strategy of the line item.

Migrating from `reportType: capout`

Replace your existing call on /reports/campaigns or /reports/line-items with a call to this endpoint. The underlying data is unchanged. Endpoint change:

POST /reports/campaigns   →   POST /reports/missed-opportunities
POST /reports/line-items  →   POST /reports/missed-opportunities

Request shape changes:

Replace the top-level accountId / campaignId / lineItemId fields with a filters object containing accountIds[], campaignIds[], or lineItemIds[] arrays.
Add required dimensions[] and metrics[] arrays to select output columns.
startDate and endDate are now required (date-only YYYY-MM-DD; timestamps are rejected).
Remove reportType: capout — it is not accepted on this endpoint.

Metric renames:

Old name	New name
`capoutMissedClicks`	`missedClicks`
`capoutMissedImpressions`	`missedImpressions`
`capoutMissedSales`	`missedSales`
`capoutMissedSpend`	`missedSpend`
`capoutMissedTraffic`	`missedTraffic`
`capoutHour`	`capoutHour` (unchanged)

Dimension changes: daypartingScheduled has moved from a dimension to a metric in this endpoint. Add it to your metrics[] array instead of dimensions[].

Introduction

Getting Started

API Troubleshooting

Concepts

Resources

Guides for Retail Media API

Missed Opportunity Report

Request

Required fields

Optional fields

Example request

Response

Metrics

Dimensions

Migrating from `reportType: capout`

​Request

​Required fields

​Optional fields

​Example request

​Response

​Metrics

​Dimensions

​Migrating from reportType: capout

Request

Required fields

Optional fields

Example request

Response

Metrics

Dimensions

Migrating from `reportType: capout`