hotel_reconciliation

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?

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.v17.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

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

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

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

hotel_reconciliation

Fields/Segments/Metrics

hotel_reconciliation.billed

hotel_reconciliation.campaign

hotel_reconciliation.check_in_date

hotel_reconciliation.check_out_date

hotel_reconciliation.commission_id

hotel_reconciliation.hotel_center_id

hotel_reconciliation.hotel_id

hotel_reconciliation.order_id

hotel_reconciliation.reconciled_value_micros

hotel_reconciliation.resource_name

hotel_reconciliation.status

segments.date

metrics.hotel_commission_rate_micros

metrics.hotel_expected_commission_cost

metrics.value_per_conversions_by_conversion_date