AdGroupTargets
Perform targeting settings operations (get, add, set, replace and remove) for ad group.
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 '='.
- AdGroupId supports the '=,IN'.
- CampaignId supports the '=,IN'.
- TargetType supports the '=,IN'.
SELECT * FROM AdGroupTargets WHERE AccountId = '1002504155' SELECT * FROM AdGroupTargets WHERE AccountId = '1002504155' AND AdGroupId IN ('437154455', '437154455') SELECT * FROM AdGroupTargets WHERE AccountId = '1002504155' AND CampaignId = '30799754'
INSERT
Insert can be executed by specifying the AccountId, AdGroupId, CampaignId, AdScheduleTargetDayOfWeek, AdScheduleTargetStartHour, AdScheduleTargetEndHour and TargetType 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 AdGroupTargets (AccountId, AdGroupId, CampaignId, TargetType, AdScheduleTargetStartHour, AdScheduleTargetEndHour, AdScheduleTargetDayOfWeek) VALUES ('1002504155', '437154455', '30799754', 'AD_SCHEDULE_TARGET', '10', '12', 'MONDAY')
UPDATE
Update can be executed by specifying the AccountId, AdGroupId, TargetId, CampaignId and TargetType in the WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE AdGroupTargets SET BidMultiplier = '1.0', AgeTargetAge = 'GT_RANGE13_14' WHERE AccountId = '1002504155' AND AdGroupId = '437154455' AND CampaignId = '30799754' AND TargetId = 'as010104' AND TargetType = 'AD_SCHEDULE_TARGET'
DELETE
Delete can be executed by specifying the AccountId, AdGroupId, TargetId, CampaignId and TargetType in the WHERE Clause.
For example:
DELETE FROM AdGroupTargets WHERE AccountId = '1002504155' AND AdGroupId = '437154455' AND CampaignId = '30799754' AND TargetId = 'as011012' AND TargetType = 'AD_SCHEDULE_TARGET'
Columns
Name | Type | ReadOnly | References | Description |
TargetId | String | False |
Target ID.If targetType is any of the following, this field is required in ADD operation.SITE_RETARGETING,PLACEMENT_TARGET,SEARCH_TARGET,GEO_TARGET,INTEREST_CATEGORY,SITE_CATEGORY,PLACEMENT_CATEGORY_TARGET,PLACEMENT_CATEGORY_DETAIL_TARGET,CONTENTS_TARGETIf isRemove is true, this field does not need to be set in REPLACE operation.SITE_RETARGETING: targetListId,PLACEMENT_TARGET: placementUrlListId,,GEO_TARGET: IM area code(geo),SITE_CATEGORY: category code(category),OS_VERSION_TARGET: osVersion,AUDIENCE_CATEGORY_TARGET: audience category code(audience category),POSITION_TARGET: PositionType code.,PLACEMENT_CATEGORY_TARGET: placementCategoryListId,PLACEMENT_CATEGORY_DETAIL_TARGET: placementCategoryId,CONTENTS_TARGET: contentsKeywordListId | |
AccountId | Int64 | True |
DisplayAdsAccounts.AccountId |
Account ID. |
AdGroupId | Int64 | True |
DisplayAdsAdGroups.AdGroupId |
Ad Group ID. |
BidMultiplier | String | False |
Bid adjustment.If bidMultiplier is not specified when SITE_RETARGETING, SEARCH_TARGET, or PLACEMENT_TARGET is specified for the targeting of the ad group and the ad group is linked to the YDN campaign, null will be assigned for this field.If bidMultiplier is not specified in other cases, 1.0 will be assigned for this field. | |
CampaignId | Int64 | False |
DisplayAdsCampaigns.CampaignId |
Campaign ID. |
AdScheduleTargetDayOfWeek | String | False |
Serves the days of the week for delivery.If targetType is AD_SCHEDULE_TARGET, this field is required 使用できる値は次のとおりです。MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY, UNKNOWN | |
AdScheduleTargetStartHour | Int64 | False |
Start time (hour only).If targetType is AD_SCHEDULE_TARGET, this field is required | |
AdScheduleTargetEndHour | Int64 | False |
End time (hour only).If targetType is AD_SCHEDULE_TARGET, this field is required | |
AgeTargetAge | String | False |
Displays ages.If targetType is AGE_TARGET, this field is required. 使用できる値は次のとおりです。GT_RANGE13_14, GT_RANGE15_17, GT_RANGE18_19, GT_RANGE17_21, GT_RANGE22_29, GT_RANGE30_39, GT_RANGE40_49, GT_RANGE50_59, GT_RANGE60_69, GT_RANGE70_UL, GT_UNKNOWN, GT_RANGE15_19, GT_RANGE20_24, GT_RANGE25_29, GT_RANGE35_34, GT_RANGE35_39, GT_RANGE41_44, GT_RANGE45_49, GT_RANGE51_54, GT_RANGE55_59, GT_RANGE61_64, GT_RANGE65_69, GT_RANGE70_UL2, GT_UNKNOWN2, UNKNOWN | |
AgeTargetEstimateFlg | String | False |
Displays the advance delivery setting.If targetType is AGE_TARGET, this field is required. 使用できる値は次のとおりです。PAUSED, ACTIVE, UNKNOWN | |
AppTargetDeviceAppType | String | False |
Serves application types for devices. 使用できる値は次のとおりです。APP, WEB, UNKNOWN | |
AudienceCategoryTargetAudienceCategoryType | String | False |
Category type. | |
AudienceCategoryTargetCategoryNameEn | String | False |
Category name (English).If targetType is AUDIENCE_CATEGORY_TARGET, this field is required. | |
AudienceCategoryTargetCategoryNameJa | String | False |
Category name (Japanese).If targetType is AUDIENCE_CATEGORY_TARGET, this field is required. | |
DeviceTargetDeviceType | String | False |
A container for storing gender targeting settings.Can set only bid adjustment in SET operation | |
GenderTargetGender | String | False |
AdGroupTargetServiceGender serves genders.If targetType is GENDER_TARGET, this field is required. 使用できる値は次のとおりです。ST_MALE, ST_FEMALE, ST_UNKNOWN, UNKNOWN | |
GeoTargetGeoareaSearchType | String | False |
Types of regional search method.The default value in ADD operation will be GEO. | |
GeoTargetLatitudeInMicroDegrees | Int64 | False |
Micro degrees for the latitude. | |
GeoTargetLongitudeInMicroDegrees | Int64 | False |
Micro degrees for the longitude | |
GeoTargetRadius | Int64 | False |
Radius(km). | |
GeoTargetDescription | String | False |
A description of the specified location | |
GeoTargetGeoNameEn | String | False |
Region name (English). | |
GeoTargetGeoNameJa | String | False |
Region name (Japanese).If targetType is GEO_TARGET, this field is required. | |
IsRemove | Boolean | False |
If true, delete all targeting types. | |
OsTargetDeviceOsType | String | False |
Serves OS types for devices to be posted on. 使用できる値は次のとおりです。IOS, ANDROID, UNKNOWN | |
OsVersionTargetOsVersion | String | False |
OS version. | |
PlacementCategoryTargetPlacementCategoryListName | String | False |
Placement category list name. | |
PlacementTargetPlacementUrlListName | String | False |
Placement List Name. | |
PlacementTargetPlacementUrlListType | String | False |
Describes type of Placement URL list. 使用できる値は次のとおりです。WHITE_LIST, BLACKLIST, UNKNOWN | |
PositionTargetPositionType | String | False |
Serves position types of the instream video ads. 使用できる値は次のとおりです。INSTREAM_PREROLL, INSTREAM_MIDROLL, INSTREAM_POSTROLL, UNKNOWN | |
SearchTargetSearchKeywordListName | String | False |
Search Keyword List name. | |
SiteCategoryTargetCategoryFullNameEn | String | False |
Site category name (English). | |
SiteCategoryTargetCategoryFullNameJa | String | False |
Site category name (Japanese). | |
SiteRetargetingTargetTargetListDeliverType | String | False |
Displays the type of target list type. 使用できる値は次のとおりです。INCLUDE, EXCLUDE, UNKNOWN | |
SiteRetargetingTargetTargetListName | String | False |
Target List name. | |
TargetType | String | False |
Types of targets. PLACEMENT_CATEGORY_TARGET are target type exclusive for Guaranteed ads. 使用できる値は次のとおりです。AD_SCHEDULE_TARGET, GEO_TARGET, AGE_TARGET, GENDER_TARGET, INTEREST_CATEGORY, SITE_CATEGORY, SITE_RETARGETING, SEARCH_TARGET, PLACEMENT_TARGET, DEVICE_TARGET, CARRIER_TARGET, APP_TARGET, OS_TARGET, OS_VERSION_TARGET, AUDIENCE_CATEGORY_TARGET, POSITION_TARGET, PLACEMENT_CATEGORY_TARGET, UNKNOWN | |
TargetSetting | String | False |
Displays the setting information of target. 使用できる値は次のとおりです。ACTIVE, PAUSED, NONE, UNKNOWN | |
AudienceListTargetDeliveryType | String | False |
Describes whether the subjected targeting setting is delivery target or excluded from delivery target. 使用できる値は次のとおりです。INCLUDE, EXCLUDE, UNKNOWN | |
AudienceListTargetAudienceListName | String | False |
Audience List name. | |
AudienceListTargetAudienceListNameEn | String | False |
Audience list name (Eng). | |
AudienceListTargetAudienceListType | String | False |
Type of audience list. | |
PlacementCategoryDetailTargetPlacementCategoryNameJa | String | False |
Category name (Japanese). | |
PlacementCategoryDetailTargetPlacementCategoryNameEn | String | False |
Category name (English). | |
PlacementCategoryDetailTargetPlacementCategoryType | String | False |
Describes the type of placement category. | |
ContentsTargetDeliverType | String | False |
Describes whether the subjected targeting setting is delivery target or excluded from delivery target. | |
ContentsTargetContentsKeywordListName | String | False |
Contents Keyword List name. |