GuaranteedCampaigns

Read or Update guaranteed campaign.

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 '='.
CampaignId supports the '=,IN'.
ContainsLabelIdFlg supports the '='.
LabelId supports the '=,IN'.

For example:

SELECT * FROM GuaranteedCampaigns WHERE AccountId = '1002504155'

SELECT * FROM GuaranteedCampaigns WHERE AccountId = '1002504155' AND CampaignId = '1833923'

SELECT * FROM GuaranteedCampaigns WHERE AccountId = '1002504155' AND LabelId = '97108'

UPDATE

Update can be executed by specifying the AccountId,CampaignId in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE GuaranteedCampaigns SET CampaignName = 'Test' WHERE AccountId = '1002504155' AND CampaignId = '1833923'

Columns


Name	Type	ReadOnly	References	Description
CampaignId [KEY]	Int64	True		Campaign ID.
AccountId	Int64	True	DisplayAdsAccounts.AccountId	Account ID.
AdCategoryStatus	String	False		Describes the ad category status of a guaranteed campaign. 使用できる値は次のとおりです。ADDED, NONE, UNKNOWN
BrandTrackingAudienceCategoryIds1	String	False		Audience Category ID group 1.
BrandTrackingAudienceCategoryIds2	String	False		Audience Category ID group 2.
BrandTrackingBusinessCategoryIds	String	False		Business Category ID group.
CampaignBiddingStrategyCampaignBiddingStrategyType	String	False		Describes setting of campaign bid strategy type. 使用できる値は次のとおりです。MAX_VCPM, SOV, UNKNOWN
CampaignBiddingStrategyVcpmBidValue	Int64	False		Max bid of campaign (vCPM).
CampaignBiddingStrategySovRate	Int64	False		SOV rate.
CampaignCanceledDate	Datetime	False		A date and time which the guaranteed campaign is cancelled.
ConversionGroupId	String	False		GuaranteedCampaignServiceConversionGroupID.conversionGroupId and conversionTrackerIds cannot be set at the same time
ConversionTrackerId	Int64	False		GuaranteedCampaignServiceConversionTrackerID.conversionGroupId and conversionTrackerIds cannot be set at the same time
IsRemoveConversionGroupId	Int64	False		GuaranteedCampaignServiceIsRemoveFlg is a flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
IsRemoveConversionTrackerId	Datetime	False		GuaranteedCampaignServiceIsRemoveFlg is a flag for removing an information item 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
CampaignGoal	String	False		Campaign goal.
CampaignName	String	False		Campaign Name.
StartDate	Date	False		Start date.
EndDate	Date	False		End date.
GuaranteedSimulationId	Int64	False		Maximum number of ad viewable impressions to same user.
Labels	String	False		Describes label information to be associated.
LifetimeBudgetAmount	Int64	False		Describes the information of campaign's lifetime budget.
NotificationEmailAddress	String	False		Email address to send notifications.
PackagePackageHistoryId	Int64	False		Package ID.
PackagePackageId	Int64	False		Package history ID.
PackagePackageName	String	False		Package Name.
ServingStatus	String	False		Display the campaign status, regardless of userStatus setting. 使用できる値は次のとおりです。SERVING, ENDED, PENDING, UNKNOWN
UserStatus	String	False		Serves ad delivery status that can be set by an user. 使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN
ViewableFrequencyCapFrequencyLevel	String	False		Frequency setting level. 使用できる値は次のとおりです。CAMPAIGN, UNKNOWN
ViewableFrequencyCapFrequencyTimeUnit	String	False		Frequency setting period. 使用できる値は次のとおりです。DAY, WEEK, MONTH, LIFETIME, UNKNOWN
ViewableFrequencyCapVImps	Int64	False		Maximum number of ad viewable impressions to same user.
ContainsLabelIdFlg	Boolean	False		Flag of contains label ID.
LabelId	Int64	False		Label ID.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。