SSIS Components for Google Ads

Build 24.0.9062

AssetSet

An asset set representing a collection of assets. Use AssetSetAsset to link an asset to the asset set.

Columns

Name Type Behavior Description
AssetSetBusinessProfileLocationGroupDynamicBusinessProfileLocationGroupFilterBusinessNameFilterBusinessName String ATTRIBUTE Business name string to use for filtering.
AssetSetBusinessProfileLocationGroupDynamicBusinessProfileLocationGroupFilterBusinessNameFilterFilterType String ATTRIBUTE The type of string matching to use when filtering with business_name.

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

AssetSetBusinessProfileLocationGroupDynamicBusinessProfileLocationGroupFilterLabelFilters String ATTRIBUTE Used to filter Business Profile locations by label. Only locations that have any of the listed labels will be in the asset set. Label filters are OR'ed together.
AssetSetBusinessProfileLocationGroupDynamicBusinessProfileLocationGroupFilterListingIdFilters String ATTRIBUTE Used to filter Business Profile locations by listing ids.
AssetSetHotelPropertyDataHotelCenterId Long ATTRIBUTE Output only. The hotel center ID of the partner.
AssetSetHotelPropertyDataPartnerName String ATTRIBUTE Output only. Name of the hotel partner.
AssetSetId Long ATTRIBUTE Output only. The ID of the asset set.
AssetSetLocationGroupParentAssetSetId Long ATTRIBUTE Immutable. Parent asset set id for the asset set where the elements of this asset set come from. For example: the sync level location AssetSet id where the the elements in LocationGroup AssetSet come from. This field is required and only applicable for Location Group typed AssetSet.
AssetSetLocationSetBusinessProfileLocationSetBusinessNameFilter String ATTRIBUTE Used to filter Google Business Profile listings by business name. If businessNameFilter is set, only listings with a matching business name are candidates to be sync'd into Assets.
AssetSetLocationSetBusinessProfileLocationSetLabelFilters String ATTRIBUTE Used to filter Google Business Profile listings by labels. If entries exist in labelFilters, only listings that have any of the labels set are candidates to be synchronized into Assets. If no entries exist in labelFilters, then all listings are candidates for syncing. Label filters are OR'ed together.
AssetSetLocationSetBusinessProfileLocationSetListingIdFilters String ATTRIBUTE Used to filter Google Business Profile listings by listing id. If entries exist in listingIdFilters, only listings specified by the filters are candidates to be synchronized into Assets. If no entries exist in listingIdFilters, then all listings are candidates for syncing. Listing ID filters are OR'ed together.
AssetSetLocationSetChainLocationSetRelationshipType String ATTRIBUTE Required. Immutable. Relationship type the specified chains have with this advertiser.

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

AssetSetLocationSetLocationOwnershipType String ATTRIBUTE Required. Immutable. Location Ownership Type (owned location or affiliate location).

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

AssetSetMerchantCenterFeedFeedLabel String ATTRIBUTE Optional. Feed Label from Google Merchant Center.
AssetSetMerchantCenterFeedMerchantId Long ATTRIBUTE Required. Merchant ID from Google Merchant Center
AssetSetName String ATTRIBUTE Required. Name of the asset set. Required. It must have a minimum length of 1 and maximum length of 128.
AssetSetResourceName String ATTRIBUTE Immutable. The resource name of the asset set. Asset set resource names have the form: customers/{customer_id}/assetSets/{asset_set_id}
AssetSetStatus String ATTRIBUTE Output only. The status of the asset set. Read-only.

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

AssetSetType String ATTRIBUTE Required. Immutable. The type of the asset set. Required.

使用できる値は次のとおりです。BUSINESS_PROFILE_DYNAMIC_LOCATION_GROUP, CHAIN_DYNAMIC_LOCATION_GROUP, DYNAMIC_CUSTOM, DYNAMIC_EDUCATION, DYNAMIC_FLIGHTS, DYNAMIC_HOTELS_AND_RENTALS, DYNAMIC_JOBS, DYNAMIC_LOCAL, DYNAMIC_REAL_ESTATE, DYNAMIC_TRAVEL, HOTEL_PROPERTY, LOCATION_SYNC, MERCHANT_CENTER_FEED, PAGE_FEED, STATIC_LOCATION_GROUP, 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