DisplayAdsAuditLogs
Create or Read the download result information of operation history data file.
Table Specific Information
Select
The connector will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. The AccountId is required to make a request and the rest of the filter is executed client-side within the connector.
- AccountId supports the '='.
- JobId supports the '=,IN'.
- JobStatus supports the '=,IN'.
SELECT * FROM DisplayAdsAuditLogs WHERE AccountId = '1002504155' SELECT * FROM DisplayAdsAuditLogs WHERE AccountId = '1002504155' AND JobId = '4508692'
INSERT
Insert can be executed by specifying the AccountId columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO DisplayAdsAuditLogs (AccountId) VALUES ('1002504155')
Columns
| Name | Type | ReadOnly | References | Description |
| JobId [KEY] | Int64 | True |
The operation history job ID. | |
| AccountId | Int64 | True |
DisplayAdsAccounts.AccountId |
Account ID. |
| JobStartDate | Date | False |
The job start date . | |
| JobEndDate | Date | False |
The job end date . | |
| JobName | String | False |
The operation history job name. | |
| JobUserName | String | False |
The user name who executes the operation history job. | |
| CampaignIds | String | False |
Campaign ID of the download object. | |
| DateRangeStartDate | Datetime | False |
Start date. Entry format : Ymd format Default value : Current date Available range : Current date Enter the date after Start date.e.g.: The oldest date selectable as of April 30 is March 1. | |
| DateRangeEndDate | Datetime | False |
End date. Entry format : Ymd format Default value : Current date Available range : Current date Enter the date after Start date.Maximum length of date range between Start and End is 1 month | |
| JobStatus | String | False |
Serves process status of download job. 使用できる値は次のとおりです。IN_PROGRESS, COMPLETED, SYSTEM_ERROR, UNKNOWN | |
| Lang | String | False |
Serves the language of download data. 使用できる値は次のとおりです。JA, EN, UNKNOWN | |
| Progress | Int64 | False |
Displays progress in integers from 1 to 100. | |
| SourceType | String | False |
Serves update tool type of the download data. 使用できる値は次のとおりです。CAMPAIGN_MANAGEMENT_TOOL, API, YAHOO_JAPAN, ALL, UNKNOWN | |
| Encoding | String | False |
It describes the encoding type (character encoding) for Operation History file. The default value will be SJIS. 使用できる値は次のとおりです。SJIS, UTF8, UNKNOWN | |
| Output | String | False |
It specifies the file format of acruiqred operation history data. The default value will be CSV. 使用できる値は次のとおりです。ZIPPED_CSV, ZIPPED_TSV, CSV, TSV, UNKNOWN |