CData Python Connector for Yahoo! Ads

Build 22.0.8479

SearchAdsFeeds

Create, Read, Update or Delete the Feed (Data auto insertion) information.

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

For example, the following queries are processed server side:

SELECT * FROM SearchAdsFeeds WHERE AccountId = '1234339' AND FeedId = '174849'

INSERT

Insert can be executed by specifying the AccountName, FeedName and PlaceholderType 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 SearchAdsFeedServiceFeedAttributes#TEMP (FeedAttributeName,PlaceholderField) VALUES ('InsertingFeedAttribute',AD_CUSTOMIZER_INTEGER)
INSERT INTO SearchAdsFeeds (AccountId,FeedName,FeedAttribute,PlaceholderType) values (1234339,'InsertingFeed','SearchAdsFeedServiceFeedAttributes#TEMP','AD_CUSTOMIZER')

UPDATE

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

INSERT INTO SearchAdsFeedServiceFeedAttributes#TEMP (FeedAttributeName,PlaceholderField) VALUES ('UpdateFeedAttribute','AD_CUSTOMIZER_PRICE')
UPDATE SearchAdsFeeds SET FeedName = 'NewFeed', FeedAttribute = 'SearchAdsFeedServiceFeedAttributes#TEMP', PlaceholderType = 'DYNAMIC_AD_FOR_SEARCH_PAGE_FEEDS' WHERE AccountId = '1234339' AND FeedId = '174849'

DELETE

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

DELETE FROM SearchAdsFeeds WHERE AccountId = '1234339' AND FeedId = '174849'

Columns

Name Type ReadOnly References Description
FeedId [KEY] Int64 True

Feed ID.

AccountId Int64 True

SearchAdsAccounts.AccountId

Account ID. Not required by design change on editorials.

Domain String False

Domain.

FeedAttribute String False

FeedServiceAttribute object contains the attribute of auto data insertion list.

FeedName String False

List name of Feed.

FeedTrackId Int64 False

Tracking ID of Feed.

PlaceholderType String False

FeedServicePlaceholderType (enum) object select the type of Feed Item information.

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479