HotelPerformanceView

A hotel performance view.

Table Specific Information

Select

Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the Ads console.

To use the nondefault fields, explicitly select them in your query.

Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the Ads API.

Columns

Name

Type

Behavior

Description

HotelPerformanceViewResourceName

String

Attribute

ResourceName column for table HotelPerformanceView

CustomerId

Long

Attribute

ClientCustomerId column for table HotelPerformanceView

AllConversions

Double

Metric

AllConversions column for table Metrics

AllConversionsFromInteractionsRate

Double

Metric

AllConversionsFromInteractionsRate column for table Metrics

AllConversionsFromInteractionsValuePerInteraction

Double

Metric

AllConversionsFromInteractionsValuePerInteraction column for table Metrics

AllConversionsValue

Double

Metric

AllConversionsValue column for table Metrics

AllConversionsValuePerCost

Double

Metric

AllConversionsValuePerCost column for table Metrics

AverageCpc

Double

Metric

AverageCpc column for table Metrics

AverageCpm

Double

Metric

AverageCpm column for table Metrics

Clicks

Long

Metric

Clicks column for table Metrics

Conversions

Double

Metric

Conversions column for table Metrics

ConversionsFromInteractionsRate

Double

Metric

ConversionsFromInteractionsRate column for table Metrics

ConversionsFromInteractionsValuePerInteraction

Double

Metric

ConversionsFromInteractionsValuePerInteraction column for table Metrics

ConversionsValue

Double

Metric

ConversionsValue column for table Metrics

ConversionsValuePerCost

Double

Metric

ConversionsValuePerCost column for table Metrics

CostMicros

Long

Metric

CostMicros column for table Metrics

CostPerAllConversions

Double

Metric

CostPerAllConversions column for table Metrics

CostPerConversion

Double

Metric

CostPerConversion column for table Metrics

CrossDeviceConversions

Double

Metric

CrossDeviceConversions column for table Metrics

Ctr

Double

Metric

Ctr column for table Metrics

HotelAverageLeadValueMicros

Double

Metric

HotelAverageLeadValueMicros column for table Metrics

HotelEligibleImpressions

Long

Metric

HotelEligibleImpressions column for table Metrics

HotelPriceDifferencePercentage

Double

Metric

HotelPriceDifferencePercentage column for table Metrics

Impressions

Long

Metric

Impressions column for table Metrics

SearchAbsoluteTopImpressionShare

Double

Metric

SearchAbsoluteTopImpressionShare column for table Metrics

SearchBudgetLostAbsoluteTopImpressionShare

Double

Metric

SearchBudgetLostAbsoluteTopImpressionShare column for table Metrics

SearchBudgetLostImpressionShare

Double

Metric

SearchBudgetLostImpressionShare column for table Metrics

SearchBudgetLostTopImpressionShare

Double

Metric

SearchBudgetLostTopImpressionShare column for table Metrics

SearchClickShare

Double

Metric

SearchClickShare column for table Metrics

SearchImpressionShare

Double

Metric

SearchImpressionShare column for table Metrics

SearchRankLostAbsoluteTopImpressionShare

Double

Metric

SearchRankLostAbsoluteTopImpressionShare column for table Metrics

SearchRankLostImpressionShare

Double

Metric

SearchRankLostImpressionShare column for table Metrics

SearchRankLostTopImpressionShare

Double

Metric

SearchRankLostTopImpressionShare column for table Metrics

SearchTopImpressionShare

Double

Metric

SearchTopImpressionShare column for table Metrics

ValuePerAllConversions

Double

Metric

ValuePerAllConversions column for table Metrics

ValuePerConversion

Double

Metric

ValuePerConversion column for table Metrics

AdNetworkType

String

Segment

AdNetworkType column for table Segments

ClickType

String

Segment

ClickType column for table Segments

Date

Date

Segment

Date column for table Segments

DayOfWeek

String

Segment

DayOfWeek column for table Segments

Device

String

Segment

Device column for table Segments

GeoTargetCountry

String

Segment

GeoTargetCountry column for table Segments

HotelBookingWindowDays

Long

Segment

HotelBookingWindowDays column for table Segments

HotelCenterId

Long

Segment

HotelCenterId column for table Segments

HotelCheckInDate

Date

Segment

HotelCheckInDate column for table Segments

HotelCheckInDayOfWeek

String

Segment

HotelCheckInDayOfWeek column for table Segments

HotelCity

String

Segment

HotelCity column for table Segments

HotelClass

Int

Segment

HotelClass column for table Segments

HotelCountry

String

Segment

HotelCountry column for table Segments

HotelDateSelectionType

String

Segment

HotelDateSelectionType column for table Segments

HotelLengthOfStay

Int

Segment

HotelLengthOfStay column for table Segments

HotelPriceBucket

String

Segment

HotelPriceBucket column for table Segments

HotelRateRuleId

String

Segment

HotelRateRuleId column for table Segments

HotelRateType

String

Segment

HotelRateType column for table Segments

HotelState

String

Segment

HotelState column for table Segments

Hour

Int

Segment

Hour column for table Segments

Month

Date

Segment

Month column for table Segments

PartnerHotelId

String

Segment

PartnerHotelId column for table Segments

Quarter

Date

Segment

Quarter column for table Segments

Week

Date

Segment

Week column for table Segments

Year

Int

Segment

Year column for table Segments

Pseudo-Columns

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

Name

Type

Description

ManagerId

Long

Id of the manager account on behalf of which you are requesting customer data.

Last updated