AdGroupFeeds

Read or update FeedItem information of ad groups.

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'.
PlaceholderType supports the '=,IN'.
FeedItemId supports the '=,IN'.

For example:

SELECT * from AdGroupFeeds WHERE AccountId = '1234339'

SELECT * from AdGroupFeeds WHERE AccountId = '1234339' AND AdGroupId = '303282282'

SELECT * FROM AdGroupFeeds WHERE AccountId = '1234339' AND CampaignId = '1767536'

UPDATE

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

INSERT INTO AdGroupFeedServiceAdGroupFeeds#temp (FeedItemId) VALUES ('123456')

UPDATE AdGroupFeeds SET AdGroupFeed = 'AdGroupFeedServiceAdGroupFeeds#temp', CampaignId = '1833923', PlaceholderType = 'QUICKLINK' WHERE AccountId = '1234339' AND AdGroupId = '303133212'

Columns


Name	Type	ReadOnly	References	Description
AdGroupId [KEY]	Int64	True	SearchAdsAdGroups.AdGroupId	AdGroup ID.
AccountId	Int64	True	SearchAdsAccounts.AccountId	Account ID.
AdGroupFeed	String	False		the FeedItem information connected to ad group.
CampaignId	Int64	False	SearchAdsCampaigns.CampaignId	Campaign ID.
PlaceholderType	String	False		The type of FeedItem information. 使用できる値は次のとおりです。QUICKLINK, CALLEXTENSION, CALLOUT, STRUCTURED_SNIPPET, UNKNOWN

Pseudo-Columns

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