Google Ad Manager predefined reports
The Google Ad Manager datasource in Data Integration comes with the predefined reports. Each report includes a short description of the data, a list of customizable fields (if any), and the schema mapping.
Since these reports follow a standardized format, a few fields are locked, and you can only access them through the Custom Reports feature.
Source-Level selections
Google Ad Manager's one source-level selection is a Network filter. Choosing distinct values filters down each report within the river to the selected networks' data only.
Entity
The Entity report pulls Line Item data, an advertiser's commitment to purchase a specific number of ad impressions, clicks, or time. You can only customize the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | Integer | Dimension |
| costtype | String | Dimension |
| deliveryratetype | String | Dimension |
| enddatetime | String | Dimension |
| externalid | String | Dimension |
| creationdatetime | String | Dimension |
| ismissingcreatives | String | Dimension |
| issettopboxenabled | String | Dimension |
| lastmodifieddatetime | String | Dimension |
| lineitemtype | String | Dimension |
| name | String | Dimension |
| orderid | Integer | Dimension |
| startdatetime | String | Dimension |
| status | String | Dimension |
| targeting | String | Dimension |
| unitsbought | Integer | Metric |