SSIS Components for Google Ads

Build 24.0.9062

AdGroupFeed

An ad group feed.

Columns

Name Type Behavior Description
AdGroupFeedAdGroup String ATTRIBUTE Immutable. The ad group being linked to the feed.
AdGroupFeedFeed String ATTRIBUTE Immutable. The feed being linked to the ad group.
AdGroupFeedMatchingFunctionFunctionString String ATTRIBUTE String representation of the Function. Examples: 1. IDENTITY(true) or IDENTITY(false). All or no feed items served. 2. EQUALS(CONTEXT.DEVICE,'Mobile') 3. IN(FEED_ITEM_ID,{1000001,1000002,1000003}) 4. CONTAINS_ANY(FeedAttribute[12345678,0],{'Mars cruise','Venus cruise'}) 5. AND(IN(FEED_ITEM_ID,{10001,10002}),EQUALS(CONTEXT.DEVICE,'Mobile')) For more details, visit https://developers.google.com/google-ads/api/docs/extensions/feeds/matching-functions Note that because multiple strings may represent the same underlying function (whitespace and single versus double quotation marks, for example), the value returned may not be identical to the string sent in a mutate request.
AdGroupFeedMatchingFunctionLeftOperands String ATTRIBUTE The operands on the left hand side of the equation. This is also the operand to be used for single operand expressions such as NOT.
AdGroupFeedMatchingFunctionOperator String ATTRIBUTE Operator for a function.

使用できる値は次のとおりです。AND, CONTAINS_ANY, EQUALS, IDENTITY, IN, UNKNOWN, UNSPECIFIED

AdGroupFeedMatchingFunctionRightOperands String ATTRIBUTE The operands on the right hand side of the equation.
AdGroupFeedPlaceholderTypes String ATTRIBUTE Indicates which placeholder types the feed may populate under the connected ad group. Required.

使用できる値は次のとおりです。AD_CUSTOMIZER, AFFILIATE_LOCATION, APP, CALL, CALLOUT, DYNAMIC_CUSTOM, DYNAMIC_EDUCATION, DYNAMIC_FLIGHT, DYNAMIC_HOTEL, DYNAMIC_JOB, DYNAMIC_LOCAL, DYNAMIC_REAL_ESTATE, DYNAMIC_TRAVEL, IMAGE, LOCATION, MESSAGE, PRICE, PROMOTION, SITELINK, STRUCTURED_SNIPPET, UNKNOWN, UNSPECIFIED

AdGroupFeedResourceName String ATTRIBUTE Immutable. The resource name of the ad group feed. Ad group feed resource names have the form: `customers/{customer_id}/adGroupFeeds/{ad_group_id}~{feed_id}
AdGroupFeedStatus String ATTRIBUTE Output only. Status of the ad group feed. This field is read-only.

使用できる値は次のとおりです。ENABLED, REMOVED, UNKNOWN, UNSPECIFIED

CustomerId Long ATTRIBUTE Output only. The ID of the customer.

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