ODBC Driver for Yahoo! Ads

Build 24.0.9062

CampaignExportJobStatus

Get the status 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 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062