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:
A currency flag. All results will be converted into the specified currency. For example:
A dates object that specifies the date range for which you would like to query data. All requests should be made using eventDateStart and eventDateEnd. Querying based on modified times is not supported in the Report endpoint. Note that these dates are requested in UTC time.
A categories array. 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:
We recommend that you do not combine sku categories & 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.
Click Try It! to start a request and see the response here!