SSIS Components for Google Ads

Build 24.0.9062

AssetGroupListingGroupFilter

AssetGroupListingGroupFilter represents a listing group filter tree node in an asset group.

Columns

Name Type Behavior Description
AssetGroupListingGroupFilterAssetGroup String ATTRIBUTE Immutable. The asset group which this asset group listing group filter is part of.
AssetGroupListingGroupFilterCaseValueProductBrandValue String ATTRIBUTE String value of the product brand.
AssetGroupListingGroupFilterCaseValueProductCategoryCategoryId Long ATTRIBUTE ID of the product category. This ID is equivalent to the google_product_category ID as described in this article: https://support.google.com/merchants/answer/6324436
AssetGroupListingGroupFilterCaseValueProductCategoryLevel String ATTRIBUTE Indicates the level of the category in the taxonomy.

使用できる値は次のとおりです。LEVEL1, LEVEL2, LEVEL3, LEVEL4, LEVEL5, UNKNOWN, UNSPECIFIED

AssetGroupListingGroupFilterCaseValueProductChannelChannel String ATTRIBUTE Value of the locality.

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

AssetGroupListingGroupFilterCaseValueProductConditionCondition String ATTRIBUTE Value of the condition.

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

AssetGroupListingGroupFilterCaseValueProductCustomAttributeIndex String ATTRIBUTE Indicates the index of the custom attribute.

使用できる値は次のとおりです。INDEX0, INDEX1, INDEX2, INDEX3, INDEX4, UNKNOWN, UNSPECIFIED

AssetGroupListingGroupFilterCaseValueProductCustomAttributeValue String ATTRIBUTE String value of the product custom attribute.
AssetGroupListingGroupFilterCaseValueProductItemIdValue String ATTRIBUTE Value of the id.
AssetGroupListingGroupFilterCaseValueProductTypeLevel String ATTRIBUTE Level of the type.

使用できる値は次のとおりです。LEVEL1, LEVEL2, LEVEL3, LEVEL4, LEVEL5, UNKNOWN, UNSPECIFIED

AssetGroupListingGroupFilterCaseValueProductTypeValue String ATTRIBUTE Value of the type.
AssetGroupListingGroupFilterCaseValueWebpageConditions String ATTRIBUTE The webpage conditions are case sensitive and these are and-ed together when evaluated for filtering. All the conditions should be of same type.
AssetGroupListingGroupFilterId Long ATTRIBUTE Output only. The ID of the ListingGroupFilter.
AssetGroupListingGroupFilterListingSource String ATTRIBUTE Immutable. The source of listings filtered by this listing group filter.

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

AssetGroupListingGroupFilterParentListingGroupFilter String ATTRIBUTE Immutable. Resource name of the parent listing group subdivision. Null for the root listing group filter node.
AssetGroupListingGroupFilterPath String ATTRIBUTE Output only. The path of dimensions defining this listing group filter.
AssetGroupListingGroupFilterResourceName String ATTRIBUTE Immutable. The resource name of the asset group listing group filter. Asset group listing group filter resource name have the form: customers/{customer_id}/assetGroupListingGroupFilters/{asset_group_id}~{listing_group_filter_id}
AssetGroupListingGroupFilterType String ATTRIBUTE Immutable. Type of a listing group filter node.

使用できる値は次のとおりです。SUBDIVISION, UNIT_EXCLUDED, UNIT_INCLUDED, 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