Power BI Connector for Google Ads

Build 24.0.9062

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.

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