CampaignTargets

Create, Read, Update or Delete target setting information.

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

For example, the following queries are processed server side:

SELECT * FROM CampaignTargets WHERE AccountId = '25687'

SELECT * FROM CampaignTargets WHERE AccountId = '25687' AND TargetId IN ('456971')

SELECT * FROM CampaignTargets WHERE AccountId = '25687' AND LocationTargetExcludedType = 'INCLUDED'	

SELECT * FROM CampaignTargets WHERE AccountId = '25687' AND CampaignId IN ('0147')

SELECT * FROM CampaignTargets WHERE AccountId = '25687' AND PlatformTargetPlatformType IN ('SMART_PHONE')

SELECT * FROM CampaignTargets WHERE AccountId = '25687' AND TargetType IN (LOCATION')

INSERT

Insert can be executed by specifying the AccountId, CampaignId, TargetId, LocationTargetExcludedType, PlatformTargetPlatformType, ScheduleTargetDayOfWeek, ScheduleTargetStartMinute, ScheduleTargetEndMinute, ScheduleTargetStartHour, ScheduleTargetEndHour 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 CampaignTargets(AccountId, CampaignId, TargetId, LocationTargetExcludedType, PlatformTargetPlatformType, ScheduleTargetDayOfWeek, ScheduleTargetStartMinute, ScheduleTargetEndMinute, ScheduleTargetStartHour, ScheduleTargetEndHour, TargetType) VALUES('4698', '12365', '3543535', 'INCLUDED', 'SMART_PHONE', 'TUESDAY', 'FIFTEEN', 'FORTY_FIVE', 0, 12, 'LOCATION');

UPDATE

Update can be executed by specifying the AccountId, TargetId, CampaignId, PlatformTargetPlatformType and TargetType in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE CampaignTargets SET ScheduleTargetDayOfWeek = 'WEDNESDAY' WHERE AccountId = '78955' AND TargetId = '78945' AND CampaignId = '3245' AND PlatformTargetPlatformType = 'SMART_PHONE' AND TargetType = 'PLATFORM';

DELETE

Delete can be executed by specifying the AccountId, TargetId, CampaignId and TargetType in the WHERE Clause. For example:

DELETE FROM CampaignTargets WHERE AccountId = '78955' AND TargetId = '78945' AND CampaignId = '3245' AND TargetType = 'PLATFORM'

Columns


Name	Type	ReadOnly	References	Description
TargetId	String	True		Target ID.
AccountId	Int64	True	SearchAdsAccounts.AccountId	Account ID.
CampaignId	Int64	True	SearchAdsCampaigns.CampaignId	Campaign ID.
BidMultiplier	String	False		Bid adjustment rate. Can be specified between 0.10 to 10.00. When specified '0', the ad will not be delivered. Bid adjustment rate can be specified up to two decimal places. The default value will be 1.0.
CampaignName	String	False		Campaign Name.
LocationTargetCityNameEN	String	False		City(English). If targetType is LOCATION, this field is required in ADD operation.
LocationTargetCityNameJA	String	False		City(Japanese). If targetType is LOCATION, this field is required in ADD operation.
LocationTargetExcludedType	String	False		The setting type which delivers ads or do not deliver ads. If targetType is LOCATION, this field is required in ADD operation. 使用できる値は次のとおりです。INCLUDED, EXCLUDED, UNKNOWN
LocationTargetProvinceNameEN	String	False		Prefecture(English). If targetType is LOCATION, this field is required in ADD operation.
LocationTargetProvinceNameJA	String	False		Prefecture(Japanese). If targetType is LOCATION, this field is required in ADD operation.
LocationTargetTargetingStatus	String	False		Status of targeting setting. If targetType is LOCATION, this field is required in ADD operation. 使用できる値は次のとおりです。ACTIVE, OBSOLETE, PHASING_OUT, UNKNOWN
NetworkTargetNetworkCoverageType	String	False		Network coverage type. If targetType is NETWORK, this field is required in ADD operation. If you do not set the NetworkTarget, ads are delivered to the advertising system including all (YAHOO_SEARCH).
PlatformTargetPlatformType	String	False		A platform of the selected device. If targetType is PLATFORM, this field is required in ADD operation. 使用できる値は次のとおりです。SMART_PHONE, TABLET, DESKTOP, UNKNOWN
ScheduleTargetDayOfWeek	String	False		A day of the week. If targetType is SCHEDULE, this field is required in ADD operation. 使用できる値は次のとおりです。MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY, UNKNOWN
ScheduleTargetStartMinute	String	False		Minutes of an hour. Only supported for: 0, 15, 30, and 45 minutes past the hour. If targetType is SCHEDULE, this field is required in ADD operation. 使用できる値は次のとおりです。ZERO, FIFTEEN, THIRTY, FORTY_FIVE, UNKNOWN
ScheduleTargetEndMinute	String	False		Minutes of an hour. Only supported for: 0, 15, 30, and 45 minutes past the hour. If targetType is SCHEDULE, this field is required in ADD operation. 使用できる値は次のとおりです。ZERO, FIFTEEN, THIRTY, FORTY_FIVE, UNKNOWN
ScheduleTargetStartHour	Int64	False		Starting hour in 24 hour time. If targetType is SCHEDULE, this field is required in ADD operation.
ScheduleTargetEndHour	Int64	False		Ending hour in 24 hour time. If targetType is SCHEDULE, this field is required in ADD operation.
TargetType	String	False		Type of target setting. 使用できる値は次のとおりです。LOCATION, SCHEDULE, NETWORK, PLATFORM, UNKNOWN

Pseudo-Columns

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


Name	Type	Description
ReferenceNumber	String	This column will be used in Bulk operations to get specific values from the Temp tables.

Tableau Connector for Yahoo! Ads