CampaignExportJobStatus
Get the status or creates job to register for export.
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 CampaignExportJobStatus WHERE AccountId = '25687'
SELECT * FROM CampaignExportJobStatus WHERE AccountId = '123434' AND JobId IN ('8520')
SELECT * FROM CampaignExportJobStatus WHERE AccountId = '123436' AND JobStatus IN ('TIMEOUT')
INSERT
Insert can be executed by specifying the AccountId, Encoding, Lang and Output 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 CampaignExportJobStatus (AccountId, Encoding, Lang, Output) VALUES (1234339, 'UTF8', 'EN', 'CSV')
Columns
| Name | Type | ReadOnly | References | Description |
| JobId [KEY] | Int64 | True |
Job ID. | |
| AccountId | Int64 | True |
SearchAdsAccounts.AccountId |
Account ID. |
| StartDate | Date | True |
Start date and time of job setting. | |
| EndDate | Date | True |
End date and time of job setting | |
| ExportFields | String | True |
Fields to be exported | |
| JobName | String | True |
Job name. | |
| JobStatus | String | True |
a status of job in export setting. 使用できる値は次のとおりです。IN_PROGRESS, COMPLETED, TIMEOUT, SYSTEM_ERROR, UNKNOWN | |
| Progress | Int64 | True |
Progress of job setting | |
| UserName | String | True |
Name of user who run the job. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AdGroupApprovalStatuses | String |
Displays Editorial Status. The allowed values are APPROVED,APPROVED_WITH_REVIEW,REVIEW,PRE_DISAPPROVED,POST_DISAPPROVED,UNKNOWN |
| AdGroupAdUserStatuses | String |
Displays ad delivery status that can be set by an user. The allowed values are ACTIVE,PAUSED,UNNKOWN |
| AdGroupCriterionApprovalStatuses | String |
Displays Editorial Status. The allowed values are APPROVED,APPROVED_WITH_REVIEW,REVIEW,PRE_DISAPPROVED,POST_DISAPPROVED,UNKNOWN |
| AdGroupCriterionIds | Int64 |
Ad group criteria ID. |
| AdGroupCriterionUserStatuses | String |
Displays ad delivery status that can be set by an user. |
| AdGroupIds | Int64 |
Ad group ID of export objective. |
| AdGroupUserStatuses | String |
Displays ad delivery status that can be set by an user. The allowed values are ACTIVE,PAUSED,UNKNOWN |
| AdIds | Int64 |
Ad ID of export objective. |
| CampaignCriterionIds | Int64 |
Campaign criteria ID. |
| CampaignIds | Int64 |
Campaign ID of export objective. |
| CampaignUserStatuses | String |
Displays ad delivery status that can be set by an user. The allowed values are ACTIVE,PAUSED,UNKNOWN |
| Encoding | String |
An encoding setting for exporting data. 使用できる値は次のとおりです。UTF8, SJIS, UNKNOWN |
| EntityTypes | String |
Describes target entities. The allowed values are CAMPAIGN,NEGATIVE_CAMPAIGN_CRITERION,AD_GROUP,BIDDABLE_AD_GROUP_CRITERION,NEGATIVE_AD_GROUP_CRITERION,AD,ALL,UNKNOWN |
| Lang | String |
A language setting for exporting data. 使用できる値は次のとおりです。JA, EN, UNKNOWN |
| Output | String |
An output format for exporting data. 使用できる値は次のとおりです。CSV, ZIPPED_CSV, UNKNOWN |