SSIS Components for Yahoo! Ads

Build 24.0.9062

GuaranteedAdGroupAdGroupTargets

Retrieve the targeting information specified in ad group.This object is required if you are adding ad group via GuaranteedAdGroupService. 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 '='.
  • AdGroupId supports the '=,IN'.
  • CampaignId supports the '=,IN'.
  • ContainsLabelIdFlg supports the '='.
  • LabelId supports the '=,IN'.

For example, the following queries are processed server side:

SELECT * FROM GuaranteedAdGroupAdGroupTargets WHERE AccountId = '123436'

Columns

Name Type References Description
AccountId Int64

DisplayAdsAccounts.AccountId

Account ID.
AdGroupId Int64

GuaranteedAdGroups.AdGroupId

Ad group ID
BidMultiplier String Bid adjustment
CampaignId Int64

DisplayAdsCampaigns.CampaignId

Campaign ID.
AdScheduleTargetDayOfWeek String days of the week for delivery.

使用できる値は次のとおりです。MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY, UNKNOWN

AdScheduleTargetEndHour Int64 End time (hour only).
AdScheduleTargetStartHour Int64 Start time (hour only).
AgeTargetAge String Ages

使用できる値は次のとおりです。GT_RANGE13_14, GT_RANGE15_17, GT_RANGE20_21, GT_RANGE30_39, GT_RANGE50_59, GT_RANGE70_UL, GT_RANGE15_19, GT_RANGE20_24, GT_RANGE25_29, GT_RANGE30_34, GT_RANGE40_44, GT_RANGE50_54, GT_RANGE60_64, GT_RANGE65_69, GT_RANGE70_UL2, GT_UNKNOWN2, UNKNOWN

AgeTargetEstimateFlg String Advance delivery setting.

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

AppTargetDeviceAppType String Application types for devices.

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

AudienceCategoryTargetAudienceCategoryType String Category type
AudienceCategoryTargetCategoryNameEn String Category name (English).
AudienceCategoryTargetCategoryNameJa String Category name (Japanese).
DeviceTargetDeviceType String Types of devices to be posted on.

使用できる値は次のとおりです。DESKTOP, WAP_MOBILE, SMARTPHONE, TABLET, UNKNOWN

GenderTargetEstimateFlg String Advance delivery setting

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

GenderTargetGender String Types of Genders

使用できる値は次のとおりです。ST_MALE, ST_FEMALE, ST_UNKNOWN, UNKNOWN

GeoTargetGeoNameEn String Region name (English).
GeoTargetGeoNameJa String Region name (Japanese).
GeoTargetGeoAreaSearchType String Displays types of regional search
GeoTargetGeoLatitudeInMicroDegrees String Micro degrees for the latitude
GeoTargetGeoLongitudeInMicroDegrees String Micro degrees for the longitude
GeoTargetGeoRadius String Radius(km)
InterestCategoryTargetCategoryFullNameEn String Interest category name (English).
InterestCategoryTargetCategoryFullNameJa String Interest category name (Japanese).
IsRemove Boolean If true, delete all targeting types.
OsTargetDeviceOsType String OS types for devices to be posted on.

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

OsVersionTargetOsVersion String OS version.
PlacementCategoryTargetPlacementCategoryListName String Placement category list name.
PlacementTargetPlacementUrlListName String Placement List Name.
PlacementTargetPlacementUrlListType String Type of Placement URL list.

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

PositionTargetPositionType String Types of the instream video ads.

使用できる値は次のとおりです。INSTREAM_PREROLL, INSTREAM_MIDROLL, INSTREAM_POSTROLL

SearchTargetSearchKeywordListName String Search Keyword List name.
SiteCategoryTargetCategoryFullNameEn String Site category name (English).
SiteCategoryTargetCategoryFullNameJa String Site category name (Japanese).
AudienceListTargetDeliverType String AdGroupTargetServiceDeliverType describes whether the subjected targeting setting is delivery target or excluded from delivery target.

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

AudienceListTargetAudienceListName String Audience List name.
AudienceListTargetAudienceListType String Type of audience list.

使用できる値は次のとおりです。DEFAULT_LIST, RULE, COMBINATION, SIMILARITY, CUSTOM_AUDIENCE, WEBSITE_VISITORS, CUSTOMER_DATA, OFFERED_BY_YAHOO_JAPAN, UNKNOWN

SiteRetargetingTargetTargetListDeliverType String Type of target list type.

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

SiteRetargetingTargetTargetListName String Target List name.
PlacementCategoryType String Region name (English).
PlacementCategoryNameEn String Region name (Japanese).
PlacementCategoryNameJa String Displays types of regional search
ContentsTargetDeliverType String Region name (Japanese).
ContentsTargetContentsKeywordListName String Displays types of regional search
TargetSetting String AdGroupTargetServiceTargetSetting displays the setting information of target.

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

TargetId String Target ID.
TargetType String Types of targets.

使用できる値は次のとおりです。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, PLACEMENT_CATEGORY_DETAIL_TARGET, CONTENTS_TARGET, UNKNOWN

AudienceListTargetAudienceListNameEn String Audience list name (Eng).

Pseudo-Columns

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

Name Type Description
ContainsLabelIdFlg Boolean Flag of contains label ID.
LabelId String Label ID.

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