JDBC Driver for Google Ad Manager

Build 22.0.8462

DeliveryReport

Query DoubleClick for Publishers Delivery Reports.

Select

Represents a report job that will be run to retrieve performance and statistics information about deliveries. 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 [DeliveryReport] WHERE StartDate = '01-01-2018' AND EndDate = '01-02-2018'

Columns

Name Type Description
OrderId String This column maps to the field of the same name in the DoubleClick for Publishers API.
OrderName String This column maps to the field of the same name in the DoubleClick for Publishers API.
AdServerImpressions Long This column maps to the field of the same name in the DoubleClick for Publishers API.
AdServerClicks Long This column maps to the field of the same name in the DoubleClick for Publishers API.
AdServerCtr Double This column maps to the field of the same name in the DoubleClick for Publishers API.
AdServerCpmAndCpcRevenue Long This column maps to the field of the same name in the DoubleClick for Publishers API.
AdServerWithoutCpdAverageEcpm Double This column maps to the field of the same name in the DoubleClick for Publishers API.
OrderTrafficker String This column maps to the field of the same name in the DoubleClick for Publishers API.
OrderStartDateTime Datetime This column maps to the field of the same name in the DoubleClick for Publishers API.
OrderEndDateTime Datetime This column maps to the field of the same name in the DoubleClick for Publishers API.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462