ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

AdGroupWebpages

Create, Read, Update or Delete allowed or excluded settings of PageFeedItem setting in 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'.
  • TargetId supports the '=,IN'.
  • CampaignId supports the '=,IN'.

For example:

SELECT * FROM AdGroupWebpages WHERE AccountId = '25687'

SELECT * FROM AdGroupWebpages WHERE AccountId = '25687' AND AdGroupId IN ('89756')	

SELECT * FROM AdGroupWebpages WHERE AccountId = '25687' AND TargetId IN ('89756')

SELECT * FROM AdGroupWebpages WHERE AccountId = '25687' AND CampaignId IN ('78962')

INSERT

Insert can be executed by specifying the AccountId, AdGroupId, TargetId and WebpageParameterConditions 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 AdGroupWebpages(AccountId, AdGroupId, TargetId, WebpageParameterConditions) VALUES ('15625', '12365', '4789', 'test list')

UPDATE

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

UPDATE AdGroupWebpages SET WebpageTargetTrackId = '897466' WHERE AccountId = '525862' AND AdGroupId = '89348'

DELETE

Delete can be executed by specifying the AccountId and AdGroupId in the WHERE Clause. For example:

DELETE FROM AdGroupWebpages WHERE AccountId = '8975' AND AdGroupId = '2369'

Columns

Name Type ReadOnly References Description
TargetId [KEY] Int64 True

Unique ID for each identify webpage.

AccountId Int64 True

SearchAdsAccounts.AccountId

Account ID.

AdGroupId Int64 True

SearchAdsAdGroups.AdGroupId

Ad Group ID.

AdGroupTrackId Int64 False

Ad group tracking ID.

AdGroupCpc Int64 False

Max bid of ad group.

BidSource String False

Describes the level at which bid is set.

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

KeywordCpc Int64 False

Max bid of keyword.

Cpc Int64 False

Max bid.The default value in ADD operation will be 1.

デフォルト値は1です。

CampaignId Int64 False

Campaign ID.

CampaignTrackId Int64 False

Campaign Tracking ID.

ExcludedType String False

Describes the setting type which delivers ads or do not delivers ads.

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

デフォルト値はINCLUDEDです。

UserStatus String False

Displays ad delivery status that can be set by an user.This field can be updated when ExcludedType is 'INCLUDED'.

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

WebpageParameterConditions String False

The rule list of webpage to be allowed or excluded.

WebpageTargetTrackId Int64 False

Tracking ID for each identify webpage.

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