hotel_performance_view

Help me build a query

A hotel performance view.

Segmenting resources
ad_group
campaign

Fields from the above resources, when selected along with this resource in your SELECT and WHERE clauses, will segment metrics.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of hotel_performance_view. However, when you specify hotel_performance_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 hotel_performance_view is specified in the FROM clause.

Is hotel_performance_view specified in the FROM clause of your query?

No Yes, it is

Resource fields resource_name

Segments ad_network_type click_type date day_of_week device geo_target_country hotel_booking_window_days hotel_center_id hotel_check_in_date hotel_check_in_day_of_week hotel_city hotel_class hotel_country hotel_date_selection_type hotel_length_of_stay hotel_price_bucket hotel_rate_rule_id hotel_rate_type hotel_state hour month partner_hotel_id quarter week year

Metrics all_conversions all_conversions_from_interactions_rate all_conversions_from_interactions_value_per_interaction all_conversions_value all_conversions_value_per_cost average_cpc average_cpm clicks conversions conversions_from_interactions_rate conversions_from_interactions_value_per_interaction conversions_value conversions_value_per_cost cost_micros cost_per_all_conversions cost_per_conversion cross_device_conversions ctr hotel_average_lead_value_micros hotel_eligible_impressions hotel_price_difference_percentage impressions search_absolute_top_impression_share search_budget_lost_absolute_top_impression_share search_budget_lost_impression_share search_budget_lost_top_impression_share search_click_share search_impression_share search_rank_lost_absolute_top_impression_share search_rank_lost_impression_share search_rank_lost_top_impression_share search_top_impression_share value_per_all_conversions value_per_conversion

hotel_performance_view.resource_name Field description Output only. The resource name of the hotel performance view. Hotel performance view resource names have the form: customers/{customer_id}/hotelPerformanceView Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable False Selectable True Sortable False Repeated False

segments.ad_network_type Field description Ad network type. Category SEGMENT Data Type ENUM CONTENT GOOGLE_OWNED_CHANNELS GOOGLE_TV MIXED SEARCH SEARCH_PARTNERS UNKNOWN UNSPECIFIED YOUTUBE Type URL google.ads.googleads.v18.enums.AdNetworkTypeEnum.AdNetworkType Filterable True Selectable True Sortable True Repeated False

segments.click_type Field description Click type. Category SEGMENT Data Type ENUM AD_IMAGE APP_DEEPLINK BREADCRUMBS BROADBAND_PLAN CALLS CALL_TRACKING CLICK_ON_ENGAGEMENT_AD CROSS_NETWORK GET_DIRECTIONS HOTEL_BOOK_ON_GOOGLE_ROOM_SELECTION HOTEL_PRICE LOCATION_EXPANSION LOCATION_FORMAT_CALL LOCATION_FORMAT_DIRECTIONS LOCATION_FORMAT_IMAGE LOCATION_FORMAT_LANDING_PAGE LOCATION_FORMAT_MAP LOCATION_FORMAT_STORE_INFO LOCATION_FORMAT_TEXT MOBILE_CALL_TRACKING OFFER_PRINTS OTHER PRICE_EXTENSION PRODUCT_AD_APP_DEEPLINK PRODUCT_EXTENSION_CLICKS PRODUCT_LISTING_ADS_COUPON PRODUCT_LISTING_AD_CLICKS PRODUCT_LISTING_AD_LOCAL PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE PRODUCT_LISTING_AD_TRANSACTABLE PROMOTION_EXTENSION SHOPPING_COMPARISON_LISTING SHOWCASE_AD_CATEGORY_LINK SHOWCASE_AD_LOCAL_PRODUCT_LINK SHOWCASE_AD_LOCAL_STOREFRONT_LINK SHOWCASE_AD_ONLINE_PRODUCT_LINK SITELINKS STORE_LOCATOR SWIPEABLE_GALLERY_AD_HEADLINE SWIPEABLE_GALLERY_AD_SEE_MORE SWIPEABLE_GALLERY_AD_SITELINK_FIVE SWIPEABLE_GALLERY_AD_SITELINK_FOUR SWIPEABLE_GALLERY_AD_SITELINK_ONE SWIPEABLE_GALLERY_AD_SITELINK_THREE SWIPEABLE_GALLERY_AD_SITELINK_TWO SWIPEABLE_GALLERY_AD_SWIPES TRAVEL_ASSETS UNKNOWN UNSPECIFIED URL_CLICKS VIDEO_APP_STORE_CLICKS VIDEO_CALL_TO_ACTION_CLICKS VIDEO_CARD_ACTION_HEADLINE_CLICKS VIDEO_END_CAP_CLICKS VIDEO_WEBSITE_CLICKS VISUAL_SITELINKS WIRELESS_PLAN Type URL google.ads.googleads.v18.enums.ClickTypeEnum.ClickType 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.v18.enums.DayOfWeekEnum.DayOfWeek Filterable True Selectable True Sortable True Repeated False

segments.device Field description Device to which metrics apply. Category SEGMENT Data Type ENUM CONNECTED_TV DESKTOP MOBILE OTHER TABLET UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.DeviceEnum.Device Filterable True Selectable True Sortable True Repeated False

segments.geo_target_country Field description Resource name of the geo target constant that represents a country. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.hotel_booking_window_days Field description Hotel booking window in days. Category SEGMENT Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.hotel_center_id Field description Hotel center ID. Category SEGMENT Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.hotel_check_in_date Field description Hotel check-in date. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.hotel_check_in_day_of_week Field description Hotel check-in day of week. Category SEGMENT Data Type ENUM FRIDAY MONDAY SATURDAY SUNDAY THURSDAY TUESDAY UNKNOWN UNSPECIFIED WEDNESDAY Type URL google.ads.googleads.v18.enums.DayOfWeekEnum.DayOfWeek Filterable True Selectable True Sortable True Repeated False

segments.hotel_city Field description Hotel city. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.hotel_class Field description Hotel class. Category SEGMENT Data Type INT32 Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.hotel_country Field description Hotel country. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.hotel_date_selection_type Field description Hotel date selection type. Category SEGMENT Data Type ENUM DEFAULT_SELECTION UNKNOWN UNSPECIFIED USER_SELECTED Type URL google.ads.googleads.v18.enums.HotelDateSelectionTypeEnum.HotelDateSelectionType Filterable True Selectable True Sortable True Repeated False

segments.hotel_length_of_stay Field description Hotel length of stay. Category SEGMENT Data Type INT32 Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.hotel_price_bucket Field description Hotel price bucket. Category SEGMENT Data Type ENUM LOWEST_TIED LOWEST_UNIQUE NOT_LOWEST ONLY_PARTNER_SHOWN UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.HotelPriceBucketEnum.HotelPriceBucket Filterable True Selectable True Sortable True Repeated False

segments.hotel_rate_rule_id Field description Hotel rate rule ID. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.hotel_rate_type Field description Hotel rate type. Category SEGMENT Data Type ENUM PRIVATE_RATE PUBLIC_RATE QUALIFIED_RATE UNAVAILABLE UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.HotelRateTypeEnum.HotelRateType Filterable True Selectable True Sortable True Repeated False

segments.hotel_state Field description Hotel state. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.hour Field description Hour of day as a number between 0 and 23, inclusive. Category SEGMENT Data Type INT32 Type URL N/A 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.partner_hotel_id Field description Partner hotel ID. Category SEGMENT Data Type STRING 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.all_conversions Field description The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_from_interactions_rate Field description All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_from_interactions_value_per_interaction Field description The value of all conversions from interactions divided by the total number of interactions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_value Field description The value of all conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_value_per_cost Field description The value of all conversions divided by the total cost of ad interactions (such as clicks for text ads or views for video ads). Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.average_cpc Field description The total cost of all clicks divided by the total number of clicks received. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.average_cpm Field description Average cost-per-thousand impressions (CPM). Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.clicks Field description The number of clicks. Category METRIC Data Type INT64 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_from_interactions_rate Field description Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). 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_from_interactions_value_per_interaction Field description The value of conversions from interactions divided by the number of ad interactions. 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.conversions_value_per_cost Field description The value of conversions divided by the cost of ad interactions. 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.cost_micros Field description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.cost_per_all_conversions Field description The cost of ad interactions divided by all conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.cost_per_conversion Field description The cost of ad interactions divided by 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.cross_device_conversions Field description Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.ctr Field description The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.hotel_average_lead_value_micros Field description Average lead value based on clicks. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.hotel_eligible_impressions Field description The number of impressions that hotel partners could have had given their feed performance. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.hotel_price_difference_percentage Field description The average price difference between the price offered by reporting hotel advertiser and the cheapest price offered by the competing advertiser. 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

metrics.search_absolute_top_impression_share Field description The percentage of the customer's Shopping or Search ad impressions that are shown in the most prominent Shopping position. See https://support.google.com/google-ads/answer/7501826 for details. Any value below 0.1 is reported as 0.0999. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_budget_lost_absolute_top_impression_share Field description The number estimating how often your ad wasn't the very first ad among the top ads in the search results due to a low budget. Note: Search budget lost absolute top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_budget_lost_impression_share Field description The estimated percent of times that your ad was eligible to show on the Search Network but didn't because your budget was too low. Note: Search budget lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_budget_lost_top_impression_share Field description The number estimating how often your ad didn't show adjacent to the top organic search results due to a low budget. Note: Search budget lost top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_click_share Field description The number of clicks you've received on the Search Network divided by the estimated number of clicks you were eligible to receive. Note: Search click share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_impression_share Field description The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive. Note: Search impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_rank_lost_absolute_top_impression_share Field description The number estimating how often your ad wasn't the very first ad among the top ads in the search results due to poor Ad Rank. Note: Search rank lost absolute top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_rank_lost_impression_share Field description The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor Ad Rank. Note: Search rank lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_rank_lost_top_impression_share Field description The number estimating how often your ad didn't show adjacent to the top organic search results due to poor Ad Rank. Note: Search rank lost top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_top_impression_share Field description The impressions you've received among the top ads compared to the estimated number of impressions you were eligible to receive among the top ads. Note: Search top impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999. Top ads are generally above the top organic results, although they may show below the top organic results on certain queries. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.value_per_all_conversions Field description The value of all conversions divided by the number of all conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.value_per_conversion Field description The value of conversions divided by 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