Files
Lists all DoubleClick Campaign Manager files for the user.
Columns
Name | Type | Dimension | Description |
Id [KEY] | Long | The unique ID of the file. | |
ReportId | Long | The ID of the report this file was generated from. | |
FileName | String | The name of the report. | |
Format | String | The output format of the report. If not specified, default format is 'CSV'. Note that the actual format in the completed report file might differ if for instance the report's size exceeds the format's capabilities. 'CSV' will then be the fallback format. | |
Status | String | The status of the report file. Values can be CANCELLED, FAILED, PROCESSING, or REPORT_AVAILABLE. | |
DateRange | String | The date range for which the file has report data. The date range will always be the absolute date range for which the report is run. | |
URLs | String | The URLs where the completed report file can be downloaded. | |
LastModifiedTime | Datetime | The timestamp of when this report was last modified. | |
Kind | String | The kind of resource this is, in this case dfareporting#file. | |
eTag | String | The eTag of this response for caching purposes. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Scope | String | The scope that defines which results are returned. Values aer ALL, MINE (default), or SHARED_WITH_ME. |