HotelReconciliation
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.
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 booking can't be modified. |
| HotelReconciliationCampaign | String | ATTRIBUTE | Output only. The resource name for the Campaign associated with the conversion. |
| HotelReconciliationCheckInDate | Date | ATTRIBUTE | 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. |
| HotelReconciliationCheckOutDate | Date | ATTRIBUTE | 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. |
| HotelReconciliationCommissionId | String | ATTRIBUTE | 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. |
| HotelReconciliationHotelCenterId | Long | ATTRIBUTE | Output only. Identifier for the Hotel Center account which provides the rates for the Hotel campaign. |
| HotelReconciliationHotelId | String | ATTRIBUTE | 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. |
| HotelReconciliationOrderId | String | ATTRIBUTE | Output only. The order ID is the identifier for this booking as provided in the 'transaction_id' parameter of the conversion tracking tag. |
| HotelReconciliationReconciledValueMicros | Long | ATTRIBUTE | 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. |
| HotelReconciliationResourceName | String | ATTRIBUTE | Immutable. The resource name of the hotel reconciliation. Hotel reconciliation resource names have the form: customers/{customer_id}/hotelReconciliations/{commission_id} |
| HotelReconciliationStatus | String | ATTRIBUTE | 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.
使用できる値は次のとおりです。CANCELED, RECONCILED, RECONCILIATION_NEEDED, RESERVATION_ENABLED, UNKNOWN, UNSPECIFIED |
| HotelCommissionRateMicros | Long | METRIC | Commission bid rate in micros. A 20% commission is represented as 200,000. |
| HotelExpectedCommissionCost | Double | METRIC | Expected commission cost. The result of multiplying the commission value times the hotel_commission_rate in advertiser currency. |
| ValuePerConversionsByConversionDate | Double | METRIC | 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. |
| Date | Date | SEGMENT | Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. |
| Period | String | SEGMENT | Predefined date range.
使用できる値は次のとおりです。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
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |