The Report endpoint allows you to query aggregated data in a completely customizable format. While common use cases might include pulling revenue, commission, and clicks by date, publisher, or brand, you can create literally any report using this endpoint.
The JSON body requires:
currencyflag. All results will be converted into the specified currency. For example:
datesobject that specifies the date range for which you would like to query data. All requests should be made using
eventDateEnd. Querying based on modified times is not supported in the Report endpoint. Note that these dates are requested in UTC time.
categoriesarray. This should contain all the fields you would like to group by. For example the following array will return data grouped by date, publisher ID, and publisher name:
"categories": [ "date", "platformName", "publisherName", "publisherId" ]
metricsarray. This should contain all the metrics you would like. For example, the following array will return net revenue, net commissions, and clicks:
"metrics": [ "advertiserRevenueNet", "publisherCommissionNet", "clickCount" ]
offset(see Limit and Offset)
The JSON body can additionally accept:
- We recommend that you do not combine
skucategories & metrics with non-sku categories and metrics, they are not compatible with a large majority of non-sku categories and metrics, so it's likely that the response will be unpredictable.
- For requests that are likely to result in a multi-paged response, we recommend including a sort pattern in the json body, which either uses a unique ID from your list of categories (such as
actionId), or (if there are no unique IDs you can use) a combination of all of the categories you have requested. This is to prevent the response on each page from being unpredictable when changing the offset.
- Use a limit of 100,000.