AdGroupTargets

Perform targeting settings operations (get, add, set, replace and remove) for ad group.

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

For example:

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.