SSIS Components for Google Ads

Build 24.0.9062

CampaignFeed

A campaign feed.

Columns

Name Type Behavior Description
CampaignFeedCampaign String ATTRIBUTE Immutable. The campaign to which the CampaignFeed belongs.
CampaignFeedFeed String ATTRIBUTE Immutable. The feed to which the CampaignFeed belongs.
CampaignFeedMatchingFunctionFunctionString 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.
CampaignFeedMatchingFunctionLeftOperands 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.
CampaignFeedMatchingFunctionOperator String ATTRIBUTE Operator for a function.

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

CampaignFeedMatchingFunctionRightOperands String ATTRIBUTE The operands on the right hand side of the equation.
CampaignFeedPlaceholderTypes String ATTRIBUTE Indicates which placeholder types the feed may populate under the connected campaign. 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

CampaignFeedResourceName String ATTRIBUTE Immutable. The resource name of the campaign feed. Campaign feed resource names have the form: `customers/{customer_id}/campaignFeeds/{campaign_id}~{feed_id}
CampaignFeedStatus String ATTRIBUTE Output only. Status of the campaign 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