SearchAdsAuditLogs

Get procession status about download operation history data or creates job to register for export.

Table Specific Information

Select

The 本製品 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 本製品.

AccountId supports the '='.
JobId supports the '=,IN'.
JobStatus supports the '=,IN'.

For example:

SELECT * FROM SearchAdsAuditLogs WHERE AccountId = '25687';

SELECT * FROM SearchAdsAuditLogs WHERE AccountId = '23542' AND JobId = '456971';

INSERT

Insert can be executed by specifying the AccountId and EventSelector columns. The columns that are not read-only can be inserted optionally. Following is an example of how to inserting into SearchAdsAuditLogs table

INSERT INTO SearchAdsAuditLogEventSelector#TEMP (EntityType) VALUES ('FEED_ITEM')
INSERT INTO SearchAdsAuditLogs (AccountId, StartDate, EndDate, EventSelector) VALUES ('1002504155','2023-04-21','2023-04-25', 'SearchAdsAuditLogEventSelector#TEMP')

Columns


Name	Type	ReadOnly	References	Description
JobId [KEY]	Int64	True		Job ID.
AccountId	Int64	True	SearchAdsAccounts.AccountId	Account ID.
StartDate	Datetime	False		Start date of target date.
EndDate	Datetime	False		End date of target date.
Encoding	String	False		Describes the encoding type (character encoding) for Operation History file. 使用できる値は次のとおりです。SJIS, UTF8, UNKNOWN
EventSelector	String	False		Object enables the target setting of acquiring operation history.
JobName	String	False		Name of job.
JobStatus	String	False		Describes the job status of acquiring operation history data. 使用できる値は次のとおりです。SYSTEM_ERROR, IN_PROGRESS, COMPLETED, TIMEOUT, UNKNOWN
Lang	String	False		Describes the language setting of operation history data file. 使用できる値は次のとおりです。EN, JA, UNKNOWN デフォルト値はJAです。
Output	String	False		Specifies the file format of acruiqred operation history data. 使用できる値は次のとおりです。ZIPPED_CSV, ZIPPED_TSV, CSV, TSV, UNKNOWN デフォルト値はCSVです。
SourceType	String	False		Desribes the operator information of operation history data. 使用できる値は次のとおりです。API, YAHOO_JAPAN, CAMPAIGN_MANAGEMENT_TOOL, ALL, UNKNOWN デフォルト値はAPIです。
OperationSucceeded	String	False		Processing result. If true, the operation was successful. If false, the process has failed

JDBC Driver for Yahoo! Ads

SearchAdsAuditLogs

Table Specific Information

Select

INSERT

Columns