SearchAdsCampaignSettings
Retrive the details of campaign settings.The columns values set read-only false can be inserted in the parent table using Temp tables
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'.
- 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 SearchAdsCampaignSettings WHERE AccountId = '12346' SELECT * FROM SearchAdsCampaignSettings WHERE AccountId = '12346' AND CampaignId = '9756' SELECT * FROM SearchAdsCampaignSettings WHERE AccountId = '12346' AND StartDate = '2021-01-21' AND EndDate = '2021-02-03' SELECT * FROM SearchAdsCampaignSettings WHERE AccountId = '12346' AND UserStatus = 'UNKNOWN' SELECT * FROM SearchAdsCampaignSettings WHERE AccountId = '12346' AND ContainsLabel = 'TRUE'
Columns
| Name | Type | References | Description |
| AccountId | Int64 |
SearchAdsAccounts.AccountId | Account ID. |
| CampaignId | Int64 | Campaign 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 | |
| DynamicAdsForSearchSettingDasUseUrlsType | String | DSA URL usage type.
使用できる値は次のとおりです。USE_SUPPLIED_URLS_ONLY, TOP_DOMAIN_ONLY, DOMAIN_AND_SUPPLIED_URLS, UNKNOWN | |
| DynamicAdsForSearchSettingDomain | String | Domain. If DasUseUrlsType is TOP_DOMAIN_ONLY or DOMAIN_AND_SUPPLIED_URLS, this field is required in ADD and SET operation. | |
| DynamicAdsForSearchSettingFeedIds | String | Page Feed ID for campaign. If DasUseUrlsType is USE_SUPPLIED_URLS_ONLY or DOMAIN_AND_SUPPLIED_URLS, this field is required in ADD and SET operation. | |
| GeoTargetTypeSettingNegativeGeoTargetType | String | Specifies Advanced Location options of Geo Targeting.
使用できる値は次のとおりです。DONT_CARE, AREA_OF_INTENT, LOCATION_OF_PRESENCE, UNKNOWN デフォルト値はDONT_CAREです。 | |
| GeoTargetTypeSettingPositiveGeoTargetType | String | Specifies Advanced Location options of Geo Targeting.
使用できる値は次のとおりです。DONT_CARE, AREA_OF_INTENT, LOCATION_OF_PRESENCE, UNKNOWN デフォルト値はDONT_CAREです。 | |
| SettingType | String | Describes the setting information of Target on the campaign.
使用できる値は次のとおりです。GEO_TARGET_TYPE_SETTING, TARGET_LIST_SETTING, DYNAMIC_ADS_FOR_SEARCH_SETTING, UNKNOWN デフォルト値はGEO_TARGET_TYPE_SETTINGです。 | |
| TargetingSettingTargetAll | String | Describes the setting of target(include) users on Site Retargeting.
使用できる値は次のとおりです。ACTIVE, DEACTIVE, UNKNOWN |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ContainsLabel | String | acquisition flag of label data
使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
| LabelId | Int64 | Label ID. | |
| MinBudgetAmount | Int64 | Minimum value of the search range. | |
| MaxBudgetAmount | Int64 | Maximum value of the search range. |