Power BI Connector for Google Ads

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062