ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

SearchAdsCampaignServiceLabels

Retrieve the details of Campaign Labels.The columns values set read-only false can be inserted in the parent table using Temp tables

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'.
  • BiddingStrategyConfigurationBiddingStrategyId supports the '=,IN'.
  • StartDate supports the '='.
  • EndDate supports the '='.
  • UserStatus supports the '=,IN'.
  • ContainsLabel supports the '='.
  • LabelId supports the '=,IN'.
  • MinBudgetAmount supports the '='.
  • MaxBudgetAmount supports the '='.

For example:

SELECT * FROM  SearchAdsCampaignServiceLabels WHERE AccountId = '12346'

SELECT * FROM  SearchAdsCampaignServiceLabels WHERE AccountId = '12346' AND CampaignId = '9756'

SELECT * FROM  SearchAdsCampaignServiceLabels WHERE AccountId = '12346' AND StartDate = '2021-01-21' AND EndDate = '2021-02-03'

SELECT * FROM  SearchAdsCampaignServiceLabels WHERE AccountId = '12346' AND UserStatus = 'UNKNOWN'

SELECT * FROM  SearchAdsCampaignServiceLabels WHERE AccountId = '12346' AND ContainsLabel = 'TRUE'

SELECT * FROM  SearchAdsCampaignServiceLabels WHERE AccountId = '12346' AND MinBudgetAmount = '1' AND MaxBudgetAmount = '1000'

Columns

Name Type References Description
LabelId [KEY] Int64 Label ID.
Color String Color.
Description String Description.
LabelName String Label name.
CampaignId Int64 Campaign ID.
AccountId Int64

SearchAdsAccounts.AccountId

Account ID.
BiddingStrategyConfigurationBiddingStrategyId Int64 Auto Bidding ID. This field cannot be specified when Standard bidding is setting, and is required when Portfolio bidding is setting in ADD operation. It cannot be specified at the same times as biddingScheme.
StartDate Date Start date of Campaign. The default value in ADD operation will be Today's date. The default value in ADD operation will be Today's date. Cannot set the past date. Cannot change the date to the campaign that is already active.
EndDate Date End date of Campaign. The default value in ADD operation will be 20371231. Cannot set the past date and date before the start date.
UserStatus String Displays ad delivery status that can be set by an user.

使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN

Pseudo-Columns

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

Name Type Description
ContainsLabel String acquisition flag of label data

使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN

MinBudgetAmount Int64 Minimum value of the search range.
MaxBudgetAmount Int64 Maximum value of the search range.

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