ADO.NET Provider for Google Ads

Build 26.0.9655

HotelReconciliation

A hotel reconciliation. It contains conversion information from Hotel

Columns

Name Type Behavior Description
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
HotelReconciliationBilled Bool ATTRIBUTE Output only. Whether a given booking has been billed. Once billed, a
HotelReconciliationCampaign String ATTRIBUTE Output only. The resource name for the Campaign associated with the
HotelReconciliationCheckInDate Date ATTRIBUTE Output only. Check-in date recorded when the booking is made. If the
HotelReconciliationCheckOutDate Date ATTRIBUTE Output only. Check-out date recorded when the booking is made. If the
HotelReconciliationCommissionId String ATTRIBUTE Required. Output only. The commission ID is Google's ID for this booking.
HotelReconciliationHotelCenterId Long ATTRIBUTE Output only. Identifier for the Hotel Center account which provides the
HotelReconciliationHotelId String ATTRIBUTE Output only. Unique identifier for the booked property, as provided in the
HotelReconciliationOrderId String ATTRIBUTE Output only. The order ID is the identifier for this booking as provided in
HotelReconciliationReconciledValueMicros Long ATTRIBUTE Required. Output only. Reconciled value is the final value of a booking as
HotelReconciliationResourceName String ATTRIBUTE Immutable. The resource name of the hotel reconciliation.
HotelReconciliationStatus String ATTRIBUTE Required. Output only. Current status of a booking with regards to

The allowed values are CANCELED, RECONCILED, RECONCILIATION_NEEDED, RESERVATION_ENABLED, UNKNOWN.

HotelCommissionRateMicros Long METRIC Commission bid rate in micros. A 20% commission is represented as
HotelExpectedCommissionCost Double METRIC Expected commission cost. The result of multiplying the commission value
ValuePerConversionsByConversionDate Double METRIC The value of conversions divided by the number of conversions. This only
Date Date SEGMENT Date to which metrics apply.
Period String SEGMENT Predefined date range.

The allowed values are TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655