DisplayAdsCampaigns

Create, Read, Update or Delete information related campaigns.

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 '='.
CampaignId supports the '=,IN'.
EndDate supports the '='.
FeedId supports the '=,IN'.
StartDate supports the '='.
UserStatus supports the '=,IN'.
CampaignGoalFilterType supports the '='.
CampaignType supports the '='.
ContainsLabel supports the '='.
LabelId supports the '=,IN'.

For example:

SELECT * FROM DisplayAdsCampaigns WHERE AccountId = '1002504155'

SELECT * FROM DisplayAdsCampaigns WHERE AccountId = '1002504155' AND CampaignId = '30799754'

SELECT * FROM DisplayAdsCampaigns WHERE AccountId = '1002504155' AND LabelId = '1000158197'

INSERT

Insert can be executed by specifying the AccountId, BudgetAmount, BiddingStrategyType, CampaignGoal, CampaignName, UserStatus, CpcBiddingSchemeCpc and CpcBiddingSchemeEnhancedCpcEnabled 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 DisplayAdsCampaigns (AccountId, AppId, AppName, AppOsType, BudgetAmount, BiddingStrategyType, CampaignGoal, CampaignName, UserStatus, CpcBiddingSchemeCpc, CpcBiddingSchemeEnhancedCpcEnabled) VALUES ('1002504155', 'Test_214', 'TestApp', 'ANDROID', 1500000, 'CPC', 'APP_PROMOTION', 'TestCampaign2', 'ACTIVE', 800, 'TRUE')

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 DisplayAdsCampaigns SET CampaignName = 'Test', BiddingStrategyType = 'MANUAL_CPC', BudgetAmount = '100' WHERE AccountId = '1002504155'AND CampaignId = '30799754'

DELETE

Delete can be executed by specifying the AccountId and CampaignId in the WHERE Clause. For example:

DELETE FROM DisplayAdsCampaigns WHERE AccountId = '1002504155' AND CampaignId = '30799754'

Columns


Name	Type	ReadOnly	References	Description
CampaignId [KEY]	Int64	True		Campaign ID.
AccountId	Int64	True	DisplayAdsAccounts.AccountId	Account ID
AppId	String	False		APP ID.If campaignGoal is APP_PROMOTION, this field is required in ADD operation.
AppName	String	False		App Name.If campaignGoal is APP_PROMOTION, this field is required in ADD operation.
BudgetAmount	Int64	False		The daily bu.For campaigns with campaign goal, this field is required in ADD operation.
BiddingStrategyType	String	False		Setting of campaign bid strategy type 使用できる値は次のとおりです。MAXIMIZE_CONVERSIONS, MAXIMIZE_CLICKS, MAXIMIZE_VIDEO_VIEWS, MAXIMIZE_VIEWABLE_IMPRESSIONS, VCPM, CPC, CPV, UNKNOWN
CpcBiddingSchemeCpc	Int64	False		Max bid of campaign (CPC).
CpcBiddingSchemeEnhancedCpcEnabled	String	False		It specifies flag of Maximize Conversions. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
CpvBiddingSchemeCpv	Int64	False		Max bid of campaign (CPV).
VcpmBiddingSchemeVcpm	Int64	False		Max bid of campaign (vCPM).
MaximizeConversionsBiddingSchemeTargetCpa	Int64	False		Target bid of campaign (tCPA).
CampaignDeliveryType	String	False		Campaign delivery type.
CampaignGoal	String	False		Campaign goal.Available values can be referred to authorities field of AccountAuthority object obtained by GET operation of AccountAuthorityService.
CampaignName	String	False		Campaign Name.
ConversionGroupId	Int64	False		CampaignServiceConversionGroup ID.
ConversionTrackerId	Int64	False		CampaignServiceConversionTracker ID.
IsRemoveConversionGroupId	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
IsRemoveConversionTrackerId	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
OptimizerTrainingStatus	String	False		Conversion optimizer training status. 使用できる値は次のとおりです。PROCESSING, COMPLETED, PAUSED, UNKNOWN
CreatedDate	Date	True		Date of Campaign made.
AppOsType	String	False		OS types for devices to be posted on.If campaignGoal is APP_PROMOTION, this field is required in ADD operation. 使用できる値は次のとおりです。ANDROID, IOS, UNKNOWN
StartDate	Date	False		Start date.
EndDate	Date	False		End date.
FeedId	Int64	False		Feed ID.If adType is Dynamic Ads for Display, this field is required in ADD operation
Labels	String	False		Label information to be associated.
ServingStatus	String	False		Delivery status in campaign level. 使用できる値は次のとおりです。SERVING, ENDED, PENDING, UNKNOWN
Type	String	False		Type of campaign 使用できる値は次のとおりです。STANDARD, APP, UNKNOWN
CustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
CustomParameters	String	False		Displays the element of custom parameters.
UserStatus	String	False		ad delivery status that can be set by an user 使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN
ViewableFrequencyCapFrequencyLevel	String	False		Frequency setting level 使用できる値は次のとおりです。CAMPAIGN, AD_GROUP, AD, UNKNOWN
ViewableFrequencyCapFrequencyTimeUnit	String	False		Frequency setting period. 使用できる値は次のとおりです。DAY, WEEK, MONTH, UNKNOWN
ViewableFrequencyCapVImps	Int64	False		Maximum number of ad viewable impressions to same user.
OptimizationScore	Double	False		Optimization score.

Pseudo-Columns

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


Name	Type	Description
CampaignGoalFilterType	String	Campaigns with campaignGoal or with no campaignGoal 使用できる値は次のとおりです。ALL, NON_GOAL, GOAL, UNKNOWN デフォルト値はALLです。
CampaignType	String	Type of campaign 使用できる値は次のとおりです。STANDARD, APP, UNKNOWN
ContainsLabel	Boolean	Flag of contains label ID
LabelId	Int64	Label ID
ReferenceNumber	String	This column will be used in Bulk operations to get specific values from the Temp tables.

Power BI Connector for Yahoo! Ads