SearchAdsAuditLogEventSelector
Retrieve the details of AuditLog EventSelector.The columns values set read-only false can be inserted in the parent table using Temp tables
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'.
For example:
SELECT * FROM SearchAdsAuditLogEventSelector WHERE AccountId = '25687' SELECT * FROM SearchAdsAuditLogEventSelector WHERE AccountId = '23542' AND JobId = '456971'
Columns
| Name | Type | References | Description |
| JobId | Int64 | Job ID. | |
| AccountId | Int64 |
SearchAdsAccounts.AccountId | Account ID. |
| EntityType | String | Describes the type of entities to be output on the data of operation history.
使用できる値は次のとおりです。CAMPAIGN, NEGATIVE_CAMPAIGN_CRITERION, CAMPAIGN_CRITERION, AD_GROUP, AD_GROUP_BID_MULTIPLIER, BIDDABLE_AD_GROUP_CRITERION, NEGATIVE_AD_GROUP_CRITERION, AD, FEED, FEED_ITEM, CAMPAIGN_FEED, AD_GROUP_FEED, SS_IO, SS_CONVERSION, BIDDING_STRATEGY, NEGATIVE_CAMPAIGN_USER_LIST, NEGATIVE_AD_GROUP_USER_LIST, AD_GROUP_USER_LIST, TARGET_LIST, SHARED_SET, SHARED_CRITERION, CAMPAIGN_SHARED_SET, AD_CUSTOMIZER, EXCLUDE_AD_CUSTOMIZER, ASSET, CAMPAIGN_ASSET, AD_GROUP_ASSET, ACCOUNT_CUSTOMIZER, CAMPAIGN_CUSTOMIZER, AD_GROUP_CUSTOMIZER, AD_GROUP_CRITERION_CUSTOMIZER, CUSTOMIZER_ATTRIBUTE, PAGE_FEED_ASSET_SET, PAGE_FEED_ASSET, BIDDING_SEASONALITY_ADJUSTMENT, CAMPAIGN_BUDGET, ALL, UNKNOWN | |
| EventTypes | String | Describes the operation type to be acquired the operation history data. The allowed values are ADD,SET,REMOVE,ALL,UNKNOWN | |
| JobStatus | String | Describes the job status of acquiring operation history data.
使用できる値は次のとおりです。SYSTEM_ERROR, IN_PROGRESS, COMPLETED, TIMEOUT, UNKNOWN |