ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

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'.
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.

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