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 descriptionOutput only. Whether a given booking has been billed. Once billed, a booking can't be modified.
CategoryATTRIBUTE
Data TypeBOOLEAN
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

hotel_reconciliation.campaign

Field descriptionOutput only. The resource name for the Campaign associated with the conversion.
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

hotel_reconciliation.check_in_date

Field descriptionOutput 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.
CategoryATTRIBUTE
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

hotel_reconciliation.check_out_date

Field descriptionOutput 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.
CategoryATTRIBUTE
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

hotel_reconciliation.commission_id

Field descriptionRequired. 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.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

hotel_reconciliation.hotel_center_id

Field descriptionOutput only. Identifier for the Hotel Center account which provides the rates for the Hotel campaign.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

hotel_reconciliation.hotel_id

Field descriptionOutput 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.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

hotel_reconciliation.order_id

Field descriptionOutput only. The order ID is the identifier for this booking as provided in the 'transaction_id' parameter of the conversion tracking tag.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

hotel_reconciliation.reconciled_value_micros

Field descriptionRequired. 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.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

hotel_reconciliation.resource_name

Field descriptionImmutable. The resource name of the hotel reconciliation. Hotel reconciliation resource names have the form: customers/{customer_id}/hotelReconciliations/{commission_id}
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

hotel_reconciliation.status

Field descriptionRequired. 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.
CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.googleads.v17.enums.HotelReconciliationStatusEnum.HotelReconciliationStatus
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.date

Field descriptionDate to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.hotel_commission_rate_micros

Field descriptionCommission bid rate in micros. A 20% commission is represented as 200,000.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.hotel_expected_commission_cost

Field descriptionExpected commission cost. The result of multiplying the commission value times the hotel_commission_rate in advertiser currency.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.value_per_conversions_by_conversion_date

Field descriptionThe 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.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse