Stay organized with collections
Save and categorize content based on your preferences.
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.
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?
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.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-08-13 UTC."],[],[]]