asset_group_listing_group_filter

Help me build a query

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

Attributed resources
asset_group
campaign
customer

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

asset_group_listing_group_filter.asset_group Field description Immutable. The asset group which this asset group listing group filter is part of. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

asset_group_listing_group_filter.case_value.product_brand.value Field description String value of the product brand. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.case_value.product_category.category_id Field description 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 Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.case_value.product_category.level Field description Indicates the level of the category in the taxonomy. Category ATTRIBUTE Data Type ENUM LEVEL1 LEVEL2 LEVEL3 LEVEL4 LEVEL5 UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v16.enums.ListingGroupFilterProductCategoryLevelEnum.ListingGroupFilterProductCategoryLevel Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.case_value.product_channel.channel Field description Value of the locality. Category ATTRIBUTE Data Type ENUM LOCAL ONLINE UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v16.enums.ListingGroupFilterProductChannelEnum.ListingGroupFilterProductChannel Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.case_value.product_condition.condition Field description Value of the condition. Category ATTRIBUTE Data Type ENUM NEW REFURBISHED UNKNOWN UNSPECIFIED USED Type URL google.ads.googleads.v16.enums.ListingGroupFilterProductConditionEnum.ListingGroupFilterProductCondition Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.case_value.product_custom_attribute.index Field description Indicates the index of the custom attribute. Category ATTRIBUTE Data Type ENUM INDEX0 INDEX1 INDEX2 INDEX3 INDEX4 UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v16.enums.ListingGroupFilterCustomAttributeIndexEnum.ListingGroupFilterCustomAttributeIndex Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.case_value.product_custom_attribute.value Field description String value of the product custom attribute. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.case_value.product_item_id.value Field description Value of the id. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.case_value.product_type.level Field description Level of the type. Category ATTRIBUTE Data Type ENUM LEVEL1 LEVEL2 LEVEL3 LEVEL4 LEVEL5 UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v16.enums.ListingGroupFilterProductTypeLevelEnum.ListingGroupFilterProductTypeLevel Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.case_value.product_type.value Field description Value of the type. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.case_value.webpage.conditions Field description The webpage conditions are case sensitive and these are and-ed together when evaluated for filtering. All the conditions should be of same type. Example1: for URL1 = www.ads.google.com?ocid=1&euid=2 and URL2 = www.ads.google.com?ocid=1 and with "ocid" and "euid" as url_contains conditions, URL1 will be matched, but URL2 not. Example2 : If URL1 has Label1, Label2 and URL2 has Label2, Label3, then with Label1 and Label2 as custom_label conditions, URL1 will be matched but not URL2. With Label2 as the only custom_label condition then both URL1 and URL2 will be matched. Category ATTRIBUTE Data Type MESSAGE Type URL google.ads.googleads.v16.resources.ListingGroupFilterDimension.WebpageCondition Filterable False Selectable True Sortable False Repeated True

asset_group_listing_group_filter.id Field description Output only. The ID of the ListingGroupFilter. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.listing_source Field description Immutable. The source of listings filtered by this listing group filter. Category ATTRIBUTE Data Type ENUM SHOPPING UNKNOWN UNSPECIFIED WEBPAGE Type URL google.ads.googleads.v16.enums.ListingGroupFilterListingSourceEnum.ListingGroupFilterListingSource Filterable True Selectable True Sortable True Repeated False

asset_group_listing_group_filter.parent_listing_group_filter Field description Immutable. Resource name of the parent listing group subdivision. Null for the root listing group filter node. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

asset_group_listing_group_filter.path Field description Output only. The path of dimensions defining this listing group filter. Category ATTRIBUTE Data Type MESSAGE Type URL google.ads.googleads.v16.resources.ListingGroupFilterDimensionPath Filterable False Selectable True Sortable False Repeated False

asset_group_listing_group_filter.resource_name Field description 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} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

asset_group_listing_group_filter.type Field description Immutable. Type of a listing group filter node. Category ATTRIBUTE Data Type ENUM SUBDIVISION UNIT_EXCLUDED UNIT_INCLUDED UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v16.enums.ListingGroupFilterTypeEnum.ListingGroupFilterType Filterable True Selectable True Sortable True Repeated False