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 |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
hotel_reconciliation.campaign |
| Field description | Output only. The resource name for the Campaign associated with the
conversion. |
| Category | ATTRIBUTE |
| Data Type | RESOURCE_NAME |
| Capabilities | Selectable: True Filterable: True Sortable: False Repeated: False |
| Selectable with | |
|
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 |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
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 |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
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 |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
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 |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
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 |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
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 |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
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 |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
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 |
| Capabilities | Selectable: True Filterable: True Sortable: False Repeated: False |
| Selectable with | |
|
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.v26.enums.HotelReconciliationStatusEnum.HotelReconciliationStatus |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
segments.date |
| Field description | Date to which metrics apply.
yyyy-MM-dd format, for example, 2018-04-17. |
| Category | SEGMENT |
| Data Type | DATE |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | The following fields and resources can be selected with this field: Resources: 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, app_top_combination_view, 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, cart_data_sales_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, experiment, 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, lift_measurement_age_range, lift_measurement_campaign, lift_measurement_config, lift_measurement_device, lift_measurement_gender, lift_measurement_video, location_interest_view, location_view, managed_placement_view, matched_location_interest_view, paid_organic_search_term_view, parental_status_view, per_store_view, performance_max_placement_view, product_group_view, search_term_view, 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, video_enhancement, webpage_view Segments: activity_account_id, activity_city, activity_country, activity_rating, activity_state, ad_destination_type, ad_format_type, ad_group, ad_network_type, ad_sub_format_type, ad_sub_network_type, ad_using_product_data, ad_using_video, adjusted_age_range, adjusted_gender, advance_booking_window, asset_group, asset_interaction_target.asset, asset_interaction_target.interaction_on_this_asset, auction_insight_domain, brand_lift_measurement_type, budget_campaign_association_status.campaign, budget_campaign_association_status.status, campaign, click_type, conversion_action, conversion_action_category, conversion_action_name, conversion_adjustment, conversion_attribution_event_type, conversion_lag_bucket, conversion_or_adjustment_lag_bucket, conversion_value_rule_primary_dimension, day_of_week, device, external_activity_id, external_conversion_source, geo_target_airport, geo_target_canton, geo_target_city, geo_target_country, geo_target_county, geo_target_district, geo_target_metro, geo_target_most_specific_location, geo_target_postal_code, geo_target_province, geo_target_region, geo_target_state, 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, interaction_on_this_extension, keyword.ad_group_criterion, keyword.info.match_type, keyword.info.text, landing_page_source, length_of_booking, loyalty_membership, match_type, mobile_device_platform, month, month_of_year, new_versus_returning_customers, partner_hotel_id, product_aggregator_id, product_brand, product_category_level1, product_category_level2, product_category_level3, product_category_level4, product_category_level5, product_channel, product_channel_exclusivity, product_condition, product_country, product_custom_attribute0, product_custom_attribute1, product_custom_attribute2, product_custom_attribute3, product_custom_attribute4, product_feed_label, product_item_id, product_language, product_merchant_id, product_sold_brand, product_sold_category_level1, product_sold_category_level2, product_sold_category_level3, product_sold_category_level4, product_sold_category_level5, product_sold_condition, product_sold_custom_attribute0, product_sold_custom_attribute1, product_sold_custom_attribute2, product_sold_custom_attribute3, product_sold_custom_attribute4, product_sold_item_id, product_sold_title, product_sold_type_l1, product_sold_type_l2, product_sold_type_l3, product_sold_type_l4, product_sold_type_l5, product_store_id, product_title, product_type_l1, product_type_l2, product_type_l3, product_type_l4, product_type_l5, quarter, search_engine_results_page_type, search_lift_keyword_bundle, search_property, search_subcategory, search_term, search_term_match_source, search_term_match_type, search_term_targeting_status, sk_ad_network_ad_event_type, sk_ad_network_attribution_credit, sk_ad_network_coarse_conversion_value, sk_ad_network_fine_conversion_value, sk_ad_network_postback_sequence_index, sk_ad_network_redistributed_fine_conversion_value, sk_ad_network_source_app.sk_ad_network_source_app_id, sk_ad_network_source_domain, sk_ad_network_source_type, sk_ad_network_user_type, sk_ad_network_version, slot, start_date, start_day_of_week, travel_destination_city, travel_destination_country, travel_destination_region, user_set_dates, vertical_ads_event_participant_display_names, vertical_ads_hotel_class, vertical_ads_listing, vertical_ads_listing_brand, vertical_ads_listing_city, vertical_ads_listing_country, vertical_ads_listing_region, vertical_ads_listing_user_rating, vertical_ads_listing_venue, vertical_ads_partner_account, vertical_ads_price_tier, vertical_ads_rate_rule_id, vertical_ads_rate_type, vertical_ads_vertical, webpage, week, year Metrics: absolute_brand_lift, absolute_brand_lift_p90_lower_bound, absolute_brand_lift_p90_upper_bound, absolute_brand_lift_p_value, absolute_top_impression_percentage, active_view_audibility_invalid_givt_measurable_impressions_rate, active_view_audibility_invalid_measurable_impressions_rate, active_view_audibility_measurable_impressions, active_view_audibility_measurable_impressions_rate, active_view_audible_impressions, active_view_audible_impressions_rate, active_view_audible_quartile_p100_rate, active_view_audible_quartile_p25_rate, active_view_audible_quartile_p50_rate, active_view_audible_quartile_p75_rate, active_view_audible_thirty_seconds_impressions, active_view_audible_thirty_seconds_impressions_rate, active_view_audible_two_seconds_impressions, active_view_audible_two_seconds_impressions_rate, active_view_cpm, active_view_ctr, active_view_impressions, active_view_measurability, active_view_measurable_cost_micros, active_view_measurable_impressions, active_view_viewability, all_average_cart_size, all_average_order_value_micros, all_conversions, all_conversions_by_conversion_date, all_conversions_from_click_to_call, all_conversions_from_directions, all_conversions_from_interactions_rate, all_conversions_from_interactions_value_per_interaction, all_conversions_from_location_asset_click_to_call, all_conversions_from_location_asset_directions, all_conversions_from_location_asset_menu, all_conversions_from_location_asset_order, all_conversions_from_location_asset_other_engagement, all_conversions_from_location_asset_store_visits, all_conversions_from_location_asset_website, all_conversions_from_menu, all_conversions_from_order, all_conversions_from_other_engagement, all_conversions_from_store_visit, all_conversions_from_store_website, all_conversions_value, all_conversions_value_by_conversion_date, all_conversions_value_per_cost, all_cost_of_goods_sold_micros, all_cross_sell_cost_of_goods_sold_micros, all_cross_sell_gross_profit_micros, all_cross_sell_revenue_micros, all_cross_sell_units_sold, all_gross_profit_margin, all_gross_profit_micros, all_lead_cost_of_goods_sold_micros, all_lead_gross_profit_micros, all_lead_revenue_micros, all_lead_units_sold, all_new_customer_lifetime_value, all_orders, all_revenue_micros, all_units_sold, all_value_adjustment, auction_insight_search_absolute_top_impression_percentage, auction_insight_search_impression_share, auction_insight_search_outranking_share, auction_insight_search_overlap_rate, auction_insight_search_position_above_rate, auction_insight_search_top_impression_percentage, average_cart_size, average_cost, average_cpc, average_cpe, average_cpm, average_impression_frequency_per_user, average_order_value_micros, average_page_views, average_target_cpa_micros, average_target_roas, average_time_on_site, average_video_watch_time_duration_millis, benchmark_average_max_cpc, benchmark_ctr, biddable_app_install_conversions, biddable_app_post_install_conversions, biddable_cohort_app_post_install_conversions, bounce_rate, brand_lift_baseline_positive_response_rate, brand_lift_baseline_positive_response_rate_p90_lower_bound, brand_lift_baseline_positive_response_rate_p90_upper_bound, brand_lift_exposed_positive_responder_fractional_cookies, brand_lift_exposed_positive_responder_fractional_cookies_p90_lower_bound, brand_lift_exposed_positive_responder_fractional_cookies_p90_upper_bound, brand_lift_exposed_positive_response_rate, brand_lift_exposed_positive_response_rate_p90_lower_bound, brand_lift_exposed_positive_response_rate_p90_upper_bound, brand_lift_responses_exposed, brand_lift_responses_suppressed, brand_lift_suppressed_positive_responder_fractional_cookies, brand_lift_suppressed_positive_responder_fractional_cookies_p90_lower_bound, brand_lift_suppressed_positive_responder_fractional_cookies_p90_upper_bound, brand_lift_total_responses, clicks, clicks_margin_of_error, clicks_p_value, clicks_point_estimate, clicks_unique_query_clusters, combined_clicks, combined_clicks_per_query, combined_queries, content_budget_lost_impression_share, content_impression_share, content_rank_lost_impression_share, control_clicks, control_conversion_value, control_conversion_value_per_cost, control_conversions, control_cost_micros, control_cost_per_conversion, control_impressions, conversion_value_change_point_estimate, conversion_value_margin_of_error, conversion_value_p_value, conversion_value_per_cost_change_point_estimate, conversion_value_per_cost_margin_of_error, conversion_value_per_cost_p_value, conversions, conversions_absolute_change_margin_of_error, conversions_absolute_change_p_value, conversions_absolute_change_point_estimate, conversions_by_conversion_date, conversions_from_interactions_rate, conversions_from_interactions_value_per_interaction, conversions_unique_query_clusters, conversions_value, conversions_value_by_conversion_date, conversions_value_per_cost, cost_converted_currency_per_platform_comparable_conversion, cost_micros, cost_micros_change_point_estimate, cost_micros_margin_of_error, cost_micros_p_value, cost_of_goods_sold_micros, cost_per_all_conversions, cost_per_conversion, cost_per_conversion_change_point_estimate, cost_per_conversion_margin_of_error, cost_per_conversion_p_value, cost_per_current_model_attributed_conversion, cost_per_lifted_cookie, cost_per_lifted_cookie_p90_lower_bound, cost_per_lifted_cookie_p90_upper_bound, cost_per_platform_comparable_conversion, coviewed_impressions, cross_device_conversions, cross_device_conversions_by_conversion_date, cross_device_conversions_value_by_conversion_date, cross_device_conversions_value_micros, cross_sell_cost_of_goods_sold_micros, cross_sell_gross_profit_micros, cross_sell_revenue_micros, cross_sell_units_sold, ctr, current_model_attributed_conversions, current_model_attributed_conversions_from_interactions_rate, current_model_attributed_conversions_from_interactions_value_per_interaction, current_model_attributed_conversions_value, current_model_attributed_conversions_value_per_cost, eligible_impressions_from_location_asset_store_reach, engagement_rate, engagements, fractional_lifted_cookies, fractional_lifted_cookies_p90_lower_bound, fractional_lifted_cookies_p90_upper_bound, general_invalid_click_rate, general_invalid_clicks, gmail_forwards, gmail_saves, gmail_secondary_clicks, gross_profit_margin, gross_profit_micros, headroom_brand_lift, headroom_brand_lift_p90_lower_bound, headroom_brand_lift_p90_upper_bound, historical_creative_quality_score, historical_landing_page_quality_score, historical_quality_score, historical_search_predicted_ctr, hotel_average_lead_value_micros, hotel_commission_rate_micros, hotel_eligible_impressions, hotel_expected_commission_cost, hotel_price_difference_percentage, impressions, impressions_margin_of_error, impressions_p_value, impressions_point_estimate, impressions_unique_query_clusters, incremental_searches_p_value, interaction_event_types, interaction_rate, interactions, invalid_click_rate, invalid_clicks, lead_cost_of_goods_sold_micros, lead_gross_profit_micros, lead_revenue_micros, lead_units_sold, message_chat_rate, message_chats, message_impressions, mobile_friendly_clicks_percentage, new_customer_lifetime_value, normalized_incremental_searches, normalized_incremental_searches_p90_lower_bound, normalized_incremental_searches_p90_upper_bound, normalized_incremental_searches_per_cost, normalized_incremental_searches_per_cost_p90_lower_bound, normalized_incremental_searches_per_cost_p90_upper_bound, normalized_incremental_searches_per_impression, normalized_incremental_searches_per_impression_p90_lower_bound, normalized_incremental_searches_per_impression_p90_upper_bound, orders, organic_clicks, organic_clicks_per_query, organic_impressions, organic_impressions_per_query, organic_queries, original_conversion_value, percent_new_visitors, phone_calls, phone_impressions, phone_through_rate, platform_comparable_conversions, platform_comparable_conversions_by_conversion_date, platform_comparable_conversions_from_interactions_rate, platform_comparable_conversions_from_interactions_value_per_interaction, platform_comparable_conversions_value, platform_comparable_conversions_value_by_conversion_date, platform_comparable_conversions_value_per_cost, primary_impressions, publisher_organic_clicks, publisher_purchased_clicks, publisher_unknown_clicks, relative_brand_lift, relative_brand_lift_p90_lower_bound, relative_brand_lift_p90_upper_bound, relative_ctr, relative_search_lift, relative_search_lift_p90_lower_bound, relative_search_lift_p90_upper_bound, revenue_micros, 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_exact_match_impression_share, search_impression_share, search_lift_cost_micros, search_lift_impressions, search_rank_lost_absolute_top_impression_share, search_rank_lost_impression_share, search_rank_lost_top_impression_share, search_top_impression_share, search_volume, sk_ad_network_installs, sk_ad_network_total_conversions, speed_score, svr, top_impression_percentage, trueview_average_cpv, unique_users, unique_users_eight_plus, unique_users_eight_plus_info, unique_users_five_plus, unique_users_five_plus_info, unique_users_four_plus, unique_users_four_plus_info, unique_users_info, unique_users_nine_plus, unique_users_nine_plus_info, unique_users_seven_plus, unique_users_seven_plus_info, unique_users_six_plus, unique_users_six_plus_info, unique_users_ten_plus, unique_users_ten_plus_info, unique_users_three_plus, unique_users_three_plus_info, unique_users_two_plus, unique_users_two_plus_info, units_sold, valid_accelerated_mobile_pages_clicks_percentage, value_adjustment, value_per_all_conversions, value_per_all_conversions_by_conversion_date, value_per_conversion, value_per_conversions_by_conversion_date, value_per_current_model_attributed_conversion, value_per_platform_comparable_conversion, value_per_platform_comparable_conversions_by_conversion_date, vertical_ads_average_booking_value_micros, vertical_ads_potential_impressions, vertical_ads_price_difference_percentage, video_quartile_p100_rate, video_quartile_p25_rate, video_quartile_p50_rate, video_quartile_p75_rate, video_trueview_view_rate, video_trueview_view_rate_in_feed, video_trueview_view_rate_in_stream, video_trueview_view_rate_shorts, video_trueview_views, video_watch_time_duration_millis, view_through_conversions, view_through_conversions_from_location_asset_click_to_call, view_through_conversions_from_location_asset_directions, view_through_conversions_from_location_asset_menu, view_through_conversions_from_location_asset_order, view_through_conversions_from_location_asset_other_engagement, view_through_conversions_from_location_asset_store_visits, view_through_conversions_from_location_asset_website, youtube_comments, youtube_likes, youtube_shares |
|
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 |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
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 |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | |
|
metrics.value_per_conversions_by_conversion_date |
| Field description | The value of conversions divided by the number of conversions. This only
includes conversion actions for which the 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 Understand
conversions by time with new
columns. |
| Category | METRIC |
| Data Type | DOUBLE |
| Capabilities | Selectable: True Filterable: True Sortable: True Repeated: False |
| Selectable with | The following fields and resources can be selected with this field: Resources: ad_group, ad_group_ad, ad_group_audience_view, asset_group, campaign, campaign_audience_view, customer, geographic_view, hotel_reconciliation, keyword_view, shopping_performance_view, user_location_view Segments: ad_network_type, ad_sub_network_type, click_type, conversion_action, conversion_action_category, conversion_action_name, conversion_adjustment, conversion_attribution_event_type, conversion_lag_bucket, conversion_or_adjustment_lag_bucket, date, day_of_week, device, external_conversion_source, geo_target_airport, geo_target_canton, geo_target_city, geo_target_country, geo_target_county, geo_target_district, geo_target_metro, geo_target_most_specific_location, geo_target_postal_code, geo_target_province, geo_target_region, geo_target_state, hour, keyword.ad_group_criterion, keyword.info.match_type, keyword.info.text, match_type, month, new_versus_returning_customers, product_aggregator_id, product_brand, product_category_level1, product_category_level2, product_category_level3, product_category_level4, product_category_level5, product_channel, product_channel_exclusivity, product_condition, product_country, product_custom_attribute0, product_custom_attribute1, product_custom_attribute2, product_custom_attribute3, product_custom_attribute4, product_feed_label, product_item_id, product_language, product_merchant_id, product_store_id, product_title, product_type_l1, product_type_l2, product_type_l3, product_type_l4, product_type_l5, quarter, week, year |
|