Feed
A feed.
Table Specific Information
Select
Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the Ads console.
To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the Ads API.
Columns
Name | Type | Behavior | Description |
CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
FeedAffiliateLocationFeedDataChainIds | String | ATTRIBUTE | The list of chains that the affiliate location feed will sync the locations from. |
FeedAffiliateLocationFeedDataRelationshipType | String | ATTRIBUTE | The relationship the chains have with the advertiser.
使用できる値は次のとおりです。GENERAL_RETAILER, UNKNOWN, UNSPECIFIED |
FeedAttributes | String | ATTRIBUTE | The Feed's attributes. Required on CREATE, unless system_feed_generation_data is provided, in which case Google Ads will update the feed with the correct attributes. Disallowed on UPDATE. Use attribute_operations to add new attributes. |
FeedId | Long | ATTRIBUTE | Output only. The ID of the feed. This field is read-only. |
FeedName | String | ATTRIBUTE | Immutable. Name of the feed. Required. |
FeedOrigin | String | ATTRIBUTE | Immutable. Specifies who manages the FeedAttributes for the Feed.
使用できる値は次のとおりです。GOOGLE, UNKNOWN, UNSPECIFIED, USER |
FeedPlacesLocationFeedDataBusinessNameFilter | String | ATTRIBUTE | Used to filter Business Profile listings by business name. If business_name_filter is set, only listings with a matching business name are candidates to be sync'd into FeedItems. |
FeedPlacesLocationFeedDataCategoryFilters | String | ATTRIBUTE | Used to filter Business Profile listings by categories. If entries exist in category_filters, only listings that belong to any of the categories are candidates to be sync'd into FeedItems. If no entries exist in category_filters, then all listings are candidates for syncing. |
FeedPlacesLocationFeedDataEmailAddress | String | ATTRIBUTE | Email address of a Business Profile or email address of a manager of the Business Profile. Required. |
FeedPlacesLocationFeedDataLabelFilters | String | ATTRIBUTE | Used to filter Business Profile listings by labels. If entries exist in label_filters, only listings that has any of the labels set are candidates to be synchronized into FeedItems. If no entries exist in label_filters, then all listings are candidates for syncing. |
FeedResourceName | String | ATTRIBUTE | Immutable. The resource name of the feed. Feed resource names have the form: customers/{customer_id}/feeds/{feed_id} |
FeedStatus | String | ATTRIBUTE | Output only. Status of the feed. This field is read-only.
使用できる値は次のとおりです。ENABLED, REMOVED, UNKNOWN, UNSPECIFIED |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |