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