hotel_reconciliation

Help me build a query

A hotel reconciliation. It contains conversion information from Hotel bookings to reconcile with advertiser records. These rows may be updated or canceled before billing through Bulk Uploads.

Attributed resources
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.

Fields/Segments/Metrics

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

Is hotel_reconciliation specified in the FROM clause of your query?

No Yes, it is

Resource fields
billed
campaign
check_in_date
check_out_date
commission_id
hotel_center_id
hotel_id
order_id
reconciled_value_micros
resource_name
status

Segments
date

Metrics
hotel_commission_rate_micros
hotel_expected_commission_cost
value_per_conversions_by_conversion_date

hotel_reconciliation.billed Field description Output only. Whether a given booking has been billed. Once billed, a booking can't be modified. Category ATTRIBUTE Data Type BOOLEAN Type URL N/A Filterable True Selectable True Sortable True Repeated False

hotel_reconciliation.campaign Field description Output only. The resource name for the Campaign associated with the conversion. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

hotel_reconciliation.check_in_date Field description Output only. Check-in date recorded when the booking is made. If the check-in date is modified at reconciliation, the revised date will then take the place of the original date in this column. Format is YYYY-MM-DD. Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

hotel_reconciliation.check_out_date Field description Output only. Check-out date recorded when the booking is made. If the check-in date is modified at reconciliation, the revised date will then take the place of the original date in this column. Format is YYYY-MM-DD. Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

hotel_reconciliation.commission_id Field description Required. Output only. The commission ID is Google's ID for this booking. Every booking event is assigned a Commission ID to help you match it to a guest stay. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

hotel_reconciliation.hotel_center_id Field description Output only. Identifier for the Hotel Center account which provides the rates for the Hotel campaign. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

hotel_reconciliation.hotel_id Field description Output only. Unique identifier for the booked property, as provided in the Hotel Center feed. The hotel ID comes from the 'ID' parameter of the conversion tracking tag. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

hotel_reconciliation.order_id Field description Output only. The order ID is the identifier for this booking as provided in the 'transaction_id' parameter of the conversion tracking tag. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

hotel_reconciliation.reconciled_value_micros Field description Required. Output only. Reconciled value is the final value of a booking as paid by the guest. If original booking value changes for any reason, such as itinerary changes or room upsells, the reconciled value should be the full final amount collected. If a booking is canceled, the reconciled value should include the value of any cancellation fees or non-refundable nights charged. Value is in millionths of the base unit currency. For example, $12.35 would be represented as 12350000. Currency unit is in the default customer currency. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

hotel_reconciliation.resource_name Field description Immutable. The resource name of the hotel reconciliation. Hotel reconciliation resource names have the form: customers/{customer_id}/hotelReconciliations/{commission_id} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

hotel_reconciliation.status Field description Required. Output only. Current status of a booking with regards to reconciliation and billing. Bookings should be reconciled within 45 days after the check-out date. Any booking not reconciled within 45 days will be billed at its original value. Category ATTRIBUTE Data Type ENUM CANCELED RECONCILED RECONCILIATION_NEEDED RESERVATION_ENABLED UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v22.enums.HotelReconciliationStatusEnum.HotelReconciliationStatus 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 Selectable with The following fields/resources can be selected with this field: ad_group ad_group_ad ad_group_ad_asset_combination_view ad_group_ad_asset_view ad_group_asset ad_group_audience_view ad_schedule_view age_range_view ai_max_search_term_ad_combination_view android_privacy_shared_key_google_ad_group android_privacy_shared_key_google_campaign android_privacy_shared_key_google_network_type asset_field_type_view asset_group asset_group_asset asset_group_product_group_view asset_group_top_combination_view asset_set_asset asset_set_type_view bidding_strategy campaign campaign_aggregate_asset_view campaign_asset campaign_audience_view campaign_budget campaign_group campaign_search_term_insight campaign_search_term_view channel_aggregate_asset_view click_view content_criterion_view conversion_action customer customer_asset customer_search_term_insight detail_content_suitability_placement_view detail_placement_view display_keyword_view distance_view dynamic_search_ads_search_term_view expanded_landing_page_view final_url_expansion_asset_view gender_view geographic_view group_content_suitability_placement_view group_placement_view hotel_group_view hotel_performance_view hotel_reconciliation income_range_view keyword_view landing_page_view location_interest_view location_view managed_placement_view metrics.absolute_top_impression_percentage metrics.active_view_cpm metrics.active_view_ctr metrics.active_view_impressions metrics.active_view_measurability metrics.active_view_measurable_cost_micros metrics.active_view_measurable_impressions metrics.active_view_viewability metrics.all_conversions metrics.all_conversions_by_conversion_date metrics.all_conversions_from_click_to_call metrics.all_conversions_from_directions metrics.all_conversions_from_interactions_rate metrics.all_conversions_from_interactions_value_per_interaction metrics.all_conversions_from_location_asset_click_to_call metrics.all_conversions_from_location_asset_directions metrics.all_conversions_from_location_asset_menu metrics.all_conversions_from_location_asset_order metrics.all_conversions_from_location_asset_other_engagement metrics.all_conversions_from_location_asset_store_visits metrics.all_conversions_from_location_asset_website metrics.all_conversions_from_menu metrics.all_conversions_from_order metrics.all_conversions_from_other_engagement metrics.all_conversions_from_store_visit metrics.all_conversions_from_store_website metrics.all_conversions_value metrics.all_conversions_value_by_conversion_date metrics.all_conversions_value_per_cost metrics.all_new_customer_lifetime_value metrics.all_value_adjustment metrics.auction_insight_search_absolute_top_impression_percentage metrics.auction_insight_search_impression_share metrics.auction_insight_search_outranking_share metrics.auction_insight_search_overlap_rate metrics.auction_insight_search_position_above_rate metrics.auction_insight_search_top_impression_percentage metrics.average_cart_size metrics.average_cost metrics.average_cpc metrics.average_cpe metrics.average_cpm metrics.average_impression_frequency_per_user metrics.average_order_value_micros metrics.average_page_views metrics.average_target_cpa_micros metrics.average_target_roas metrics.average_time_on_site metrics.average_video_watch_time_duration_millis metrics.benchmark_average_max_cpc metrics.benchmark_ctr metrics.biddable_app_install_conversions metrics.biddable_app_post_install_conversions metrics.biddable_cohort_app_post_install_conversions metrics.bounce_rate metrics.clicks metrics.clicks_unique_query_clusters metrics.combined_clicks metrics.combined_clicks_per_query metrics.combined_queries metrics.content_budget_lost_impression_share metrics.content_impression_share metrics.content_rank_lost_impression_share metrics.conversions metrics.conversions_by_conversion_date metrics.conversions_from_interactions_rate metrics.conversions_from_interactions_value_per_interaction metrics.conversions_unique_query_clusters metrics.conversions_value metrics.conversions_value_by_conversion_date metrics.conversions_value_per_cost metrics.cost_converted_currency_per_platform_comparable_conversion metrics.cost_micros metrics.cost_of_goods_sold_micros metrics.cost_per_all_conversions metrics.cost_per_conversion metrics.cost_per_current_model_attributed_conversion metrics.cost_per_platform_comparable_conversion metrics.coviewed_impressions metrics.cross_device_conversions metrics.cross_device_conversions_value_micros metrics.cross_sell_cost_of_goods_sold_micros metrics.cross_sell_gross_profit_micros metrics.cross_sell_revenue_micros metrics.cross_sell_units_sold metrics.ctr metrics.current_model_attributed_conversions metrics.current_model_attributed_conversions_from_interactions_rate metrics.current_model_attributed_conversions_from_interactions_value_per_interaction metrics.current_model_attributed_conversions_value metrics.current_model_attributed_conversions_value_per_cost metrics.eligible_impressions_from_location_asset_store_reach metrics.engagement_rate metrics.engagements metrics.general_invalid_click_rate metrics.general_invalid_clicks metrics.gmail_forwards metrics.gmail_saves metrics.gmail_secondary_clicks metrics.gross_profit_margin metrics.gross_profit_micros metrics.historical_creative_quality_score metrics.historical_landing_page_quality_score metrics.historical_quality_score metrics.historical_search_predicted_ctr metrics.hotel_average_lead_value_micros metrics.hotel_commission_rate_micros metrics.hotel_eligible_impressions metrics.hotel_expected_commission_cost metrics.hotel_price_difference_percentage metrics.impressions metrics.impressions_unique_query_clusters metrics.interaction_event_types metrics.interaction_rate metrics.interactions metrics.invalid_click_rate metrics.invalid_clicks metrics.lead_cost_of_goods_sold_micros metrics.lead_gross_profit_micros metrics.lead_revenue_micros metrics.lead_units_sold metrics.message_chat_rate metrics.message_chats metrics.message_impressions metrics.mobile_friendly_clicks_percentage metrics.new_customer_lifetime_value metrics.orders metrics.organic_clicks metrics.organic_clicks_per_query metrics.organic_impressions metrics.organic_impressions_per_query metrics.organic_queries metrics.percent_new_visitors metrics.phone_calls metrics.phone_impressions metrics.phone_through_rate metrics.platform_comparable_conversions metrics.platform_comparable_conversions_by_conversion_date metrics.platform_comparable_conversions_from_interactions_rate metrics.platform_comparable_conversions_from_interactions_value_per_interaction metrics.platform_comparable_conversions_value metrics.platform_comparable_conversions_value_by_conversion_date metrics.platform_comparable_conversions_value_per_cost metrics.primary_impressions metrics.publisher_organic_clicks metrics.publisher_purchased_clicks metrics.publisher_unknown_clicks metrics.relative_ctr metrics.revenue_micros metrics.search_absolute_top_impression_share metrics.search_budget_lost_absolute_top_impression_share metrics.search_budget_lost_impression_share metrics.search_budget_lost_top_impression_share metrics.search_click_share metrics.search_exact_match_impression_share metrics.search_impression_share metrics.search_rank_lost_absolute_top_impression_share metrics.search_rank_lost_impression_share metrics.search_rank_lost_top_impression_share metrics.search_top_impression_share metrics.search_volume metrics.sk_ad_network_installs metrics.sk_ad_network_total_conversions metrics.speed_score metrics.top_impression_percentage metrics.trueview_average_cpv metrics.unique_users metrics.units_sold metrics.valid_accelerated_mobile_pages_clicks_percentage metrics.value_adjustment metrics.value_per_all_conversions metrics.value_per_all_conversions_by_conversion_date metrics.value_per_conversion metrics.value_per_conversions_by_conversion_date metrics.value_per_current_model_attributed_conversion metrics.value_per_platform_comparable_conversion metrics.value_per_platform_comparable_conversions_by_conversion_date metrics.video_quartile_p100_rate metrics.video_quartile_p25_rate metrics.video_quartile_p50_rate metrics.video_quartile_p75_rate metrics.video_trueview_view_rate metrics.video_trueview_views metrics.video_watch_time_duration_millis metrics.view_through_conversions metrics.view_through_conversions_from_location_asset_click_to_call metrics.view_through_conversions_from_location_asset_directions metrics.view_through_conversions_from_location_asset_menu metrics.view_through_conversions_from_location_asset_order metrics.view_through_conversions_from_location_asset_other_engagement metrics.view_through_conversions_from_location_asset_store_visits metrics.view_through_conversions_from_location_asset_website paid_organic_search_term_view parental_status_view per_store_view performance_max_placement_view product_group_view search_term_view segments.activity_account_id segments.activity_city segments.activity_country segments.activity_rating segments.activity_state segments.ad_destination_type segments.ad_format_type segments.ad_group segments.ad_network_type segments.ad_using_product_data segments.ad_using_video segments.adjusted_age_range segments.adjusted_gender segments.asset_group segments.asset_interaction_target.asset segments.asset_interaction_target.interaction_on_this_asset segments.auction_insight_domain segments.budget_campaign_association_status.campaign segments.budget_campaign_association_status.status segments.campaign segments.click_type segments.conversion_action segments.conversion_action_category segments.conversion_action_name segments.conversion_adjustment segments.conversion_attribution_event_type segments.conversion_lag_bucket segments.conversion_or_adjustment_lag_bucket segments.conversion_value_rule_primary_dimension segments.day_of_week segments.device segments.external_activity_id segments.external_conversion_source segments.geo_target_airport segments.geo_target_canton segments.geo_target_city segments.geo_target_country segments.geo_target_county segments.geo_target_district segments.geo_target_metro segments.geo_target_most_specific_location segments.geo_target_postal_code segments.geo_target_province segments.geo_target_region segments.geo_target_state segments.hotel_booking_window_days segments.hotel_center_id segments.hotel_check_in_date segments.hotel_check_in_day_of_week segments.hotel_city segments.hotel_class segments.hotel_country segments.hotel_date_selection_type segments.hotel_length_of_stay segments.hotel_price_bucket segments.hotel_rate_rule_id segments.hotel_rate_type segments.hotel_state segments.hour segments.interaction_on_this_extension segments.keyword.ad_group_criterion segments.keyword.info.match_type segments.keyword.info.text segments.landing_page_source segments.match_type segments.month segments.month_of_year segments.new_versus_returning_customers segments.partner_hotel_id segments.product_aggregator_id segments.product_brand segments.product_category_level1 segments.product_category_level2 segments.product_category_level3 segments.product_category_level4 segments.product_category_level5 segments.product_channel segments.product_channel_exclusivity segments.product_condition segments.product_country segments.product_custom_attribute0 segments.product_custom_attribute1 segments.product_custom_attribute2 segments.product_custom_attribute3 segments.product_custom_attribute4 segments.product_feed_label segments.product_item_id segments.product_language segments.product_merchant_id segments.product_store_id segments.product_title segments.product_type_l1 segments.product_type_l2 segments.product_type_l3 segments.product_type_l4 segments.product_type_l5 segments.quarter segments.search_engine_results_page_type segments.search_subcategory segments.search_term segments.search_term_match_source segments.search_term_match_type segments.search_term_targeting_status segments.sk_ad_network_ad_event_type segments.sk_ad_network_attribution_credit segments.sk_ad_network_coarse_conversion_value segments.sk_ad_network_fine_conversion_value segments.sk_ad_network_postback_sequence_index segments.sk_ad_network_redistributed_fine_conversion_value segments.sk_ad_network_source_app.sk_ad_network_source_app_id segments.sk_ad_network_source_domain segments.sk_ad_network_source_type segments.sk_ad_network_user_type segments.sk_ad_network_version segments.slot segments.travel_destination_city segments.travel_destination_country segments.travel_destination_region segments.webpage segments.week segments.year shopping_performance_view shopping_product smart_campaign_search_term_view targeting_expansion_view topic_view travel_activity_group_view travel_activity_performance_view user_location_view video webpage_view

metrics.hotel_commission_rate_micros Field description Commission bid rate in micros. A 20% commission is represented as 200,000. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False Selectable with The following fields/resources can be selected with this field: hotel_reconciliation segments.date

metrics.hotel_expected_commission_cost Field description Expected commission cost. The result of multiplying the commission value times the hotel_commission_rate in advertiser currency. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False Selectable with The following fields/resources can be selected with this field: hotel_reconciliation segments.date

metrics.value_per_conversions_by_conversion_date 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. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/google-ads/answer/9549009. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False Selectable with The following fields/resources can be selected with this field: ad_group ad_group_ad ad_group_audience_view asset_group campaign campaign_audience_view customer hotel_reconciliation keyword_view segments.ad_network_type segments.click_type segments.conversion_action segments.conversion_action_category segments.conversion_action_name segments.conversion_adjustment segments.conversion_attribution_event_type segments.conversion_lag_bucket segments.conversion_or_adjustment_lag_bucket segments.date segments.day_of_week segments.device segments.external_conversion_source segments.hour segments.keyword.ad_group_criterion segments.keyword.info.match_type segments.keyword.info.text segments.match_type segments.month segments.new_versus_returning_customers segments.quarter segments.week segments.year