final_url_expansion_asset_view

Help me build a query

FinalUrlExpansionAssetView Resource.

Attributed resources
ad_group
asset
asset_group
campaign

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.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of final_url_expansion_asset_view. However, when you specify final_url_expansion_asset_view in the FROM clause, some metrics and segments cannot be used. Use the following filter to show only the fields that can be used when final_url_expansion_asset_view is specified in the FROM clause.

Is final_url_expansion_asset_view specified in the FROM clause of your query?

No Yes, it is

Resource fields ad_group asset asset_group campaign field_type final_url resource_name status

Segments date day_of_week month quarter week year

Metrics conversions conversions_value impressions

final_url_expansion_asset_view.ad_group Field description Output only. Ad Group in which FinalUrlExpansionAsset served. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

final_url_expansion_asset_view.asset Field description Output only. The ID of the asset. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

final_url_expansion_asset_view.asset_group Field description Output only. Asset Group in which FinalUrlExpansionAsset served. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

final_url_expansion_asset_view.campaign Field description Output only. Campaign in which the asset served. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

final_url_expansion_asset_view.field_type Field description Output only. The field type of the asset. Category ATTRIBUTE Data Type ENUM AD_IMAGE BOOK_ON_GOOGLE BUSINESS_LOGO BUSINESS_MESSAGE BUSINESS_NAME CALL CALLOUT CALL_TO_ACTION_SELECTION DEMAND_GEN_CAROUSEL_CARD DESCRIPTION HEADLINE HOTEL_CALLOUT HOTEL_PROPERTY LANDSCAPE_LOGO LEAD_FORM LOGO LONG_HEADLINE MANDATORY_AD_TEXT MARKETING_IMAGE MEDIA_BUNDLE MOBILE_APP PORTRAIT_MARKETING_IMAGE PRICE PROMOTION RELATED_YOUTUBE_VIDEOS SITELINK SQUARE_MARKETING_IMAGE STRUCTURED_SNIPPET TALL_PORTRAIT_MARKETING_IMAGE UNKNOWN UNSPECIFIED VIDEO YOUTUBE_VIDEO Type URL google.ads.googleads.v21.enums.AssetFieldTypeEnum.AssetFieldType Filterable True Selectable True Sortable True Repeated False

final_url_expansion_asset_view.final_url Field description Output only. Final URL of the FinalUrlExpansionAsset. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

final_url_expansion_asset_view.resource_name Field description Output only. The resource name of the FinalUrlExpansionAsset. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

final_url_expansion_asset_view.status Field description Output only. Status of the FinalUrlExpansionAsset. Category ATTRIBUTE Data Type ENUM ENABLED PAUSED REMOVED UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v21.enums.AssetLinkStatusEnum.AssetLinkStatus Filterable True Selectable True Sortable True Repeated False

segments.date Field description Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.day_of_week Field description Day of the week, for example, MONDAY. Category SEGMENT Data Type ENUM FRIDAY MONDAY SATURDAY SUNDAY THURSDAY TUESDAY UNKNOWN UNSPECIFIED WEDNESDAY Type URL google.ads.googleads.v21.enums.DayOfWeekEnum.DayOfWeek Filterable True Selectable True Sortable True Repeated False

segments.month Field description Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.quarter Field description Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, for example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.week Field description Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.year Field description Year, formatted as yyyy. Category SEGMENT Data Type INT32 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.conversions Field description The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.conversions_value Field description The value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.impressions Field description Count of how often your ad has appeared on a search results page or website on the Google Network. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False