InventoryReport
A template inventory report.
Select
Represents a report job that will be run to retrieve performance and statistics information about inventories. By default, the report will retrieve data for the last month. Specify StartDate and EndDate to run the report on the desired time period.
For example:
SELECT * FROM [InventoryReport] WHERE StartDate = '01-01-2018' AND EndDate = '01-02-2018'
Columns
| Name | Type | Description |
| AdUnitId | String | This column maps to the field of the same name in the DoubleClick for Publishers API. |
| AdUnitName | String | This column maps to the field of the same name in the DoubleClick for Publishers API. |
| AdServerImpressions | Long | The number of impressions delivered by the ad server. |
| AdServerClicks | Long | The number of clicks delivered by the ad server. |
| AdExchangeLineItemLevelImpressions | Long | The number of impressions an Ad Exchange ad delivered for line item-level dynamic allocation. |
| AdExchangeLineItemLevelClicks | Long | The number of clicks an Ad Exchange ad delivered for line item-level dynamic allocation. |
| TotalLineItemLevelImpressions | Long | The total number of impressions delivered including line item-level dynamic allocation. |
| TotalLineItemLevelCPMAndCPCRevenue | Long | The total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| EndDate | Date | The end date of the custom date range. The end date cannot be later than today's date. |
| StartDate | Date | The start date of the custom date range. The start date must be earlier than or the same as the end date. |
| DateRangeType | String | The period of time for which the reporting data is being generated. Supported values are: TODAY, YESTERDAY, LAST_WEEK, LAST_MONTH, LAST_3_MONTHS, REACH_LIFETIME, CUSTOM_DATE, NEXT_DAY, NEXT_90_DAYS, NEXT_WEEK, NEXT_MONTH, CURRENT_AND_NEXT_MONTH, NEXT_QUARTER, NEXT_3_MONTHS, NEXT_12_MONTHS. In order to define custom time periods, set this to CUSTOM_DATE |