HotelGroupPerformanceReportColumn Value Set - Reporting
Defines the attributes and performance statistics columns that you can include in the HotelGroupPerformanceReportRequest.
The attribute columns that you include in a report can affect how the statistics are aggregated. In other words the number of rows increase by a factor of the unique attributes. For more information, see Columns that Group the Data.
To see how far back hourly, daily, weekly, monthly, yearly and summary aggregated data can be retrieved for a report, see Report Data Retention Time Periods.
Syntax
<xs:simpleType name="HotelGroupPerformanceReportColumn" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:restriction base="xs:string">
<xs:enumeration value="TimePeriod" />
<xs:enumeration value="CustomerId" />
<xs:enumeration value="CustomerName" />
<xs:enumeration value="AccountName" />
<xs:enumeration value="AccountId" />
<xs:enumeration value="CampaignName" />
<xs:enumeration value="CampaignId" />
<xs:enumeration value="AdGroupId" />
<xs:enumeration value="AdGroupName" />
<xs:enumeration value="AdId" />
<xs:enumeration value="AccountStatus" />
<xs:enumeration value="CampaignStatus" />
<xs:enumeration value="AdGroupStatus" />
<xs:enumeration value="HotelGroup" />
<xs:enumeration value="HotelGroupNodeId" />
<xs:enumeration value="PartitionType" />
<xs:enumeration value="BidStrategyType" />
<xs:enumeration value="DeviceType" />
<xs:enumeration value="CurrencyCode" />
<xs:enumeration value="CustomParameters" />
<xs:enumeration value="FinalUrlSuffix" />
<xs:enumeration value="Impressions" />
<xs:enumeration value="Clicks" />
<xs:enumeration value="Ctr" />
<xs:enumeration value="Spend" />
<xs:enumeration value="AverageCpc" />
<xs:enumeration value="AverageCpm" />
<xs:enumeration value="Conversions" />
<xs:enumeration value="Revenue" />
<xs:enumeration value="NetRevenue" />
<xs:enumeration value="GrossReturnOnAdSpend" />
<xs:enumeration value="NetReturnOnAdSpend" />
<xs:enumeration value="CostPerAssist" />
<xs:enumeration value="BookedLengthOfStay" />
<xs:enumeration value="AvgBookedABW" />
<xs:enumeration value="AvgBookedNights" />
<xs:enumeration value="BookedABW" />
<xs:enumeration value="CheckInDate" />
<xs:enumeration value="DateType" />
<xs:enumeration value="PartnerImpressions" />
<xs:enumeration value="EligibleImpressions" />
<xs:enumeration value="MissedImpressions" />
<xs:enumeration value="ImpressionShare" />
<xs:enumeration value="MissedImpressionsNoBid" />
<xs:enumeration value="MissedImpressionsSpendingCapReached" />
<xs:enumeration value="MissedImpressionsNoTax" />
<xs:enumeration value="MissedImpressionsOther" />
<xs:enumeration value="ClickShare" />
<xs:enumeration value="MissedImpressionsInsufficientBid" />
</xs:restriction>
</xs:simpleType>
Values
The HotelGroupPerformanceReportColumn value set has the following values: AccountId, AccountName, AccountStatus, AdGroupId, AdGroupName, AdGroupStatus, AdId, AverageCpc, AverageCpm, AvgBookedABW, AvgBookedNights, BidStrategyType, BookedABW, BookedLengthOfStay, CampaignId, CampaignName, CampaignStatus, CheckInDate, Clicks, ClickShare, Conversions, CostPerAssist, Ctr, CurrencyCode, CustomerId, CustomerName, CustomParameters, DateType, DeviceType, EligibleImpressions, FinalUrlSuffix, GrossReturnOnAdSpend, HotelGroup, HotelGroupNodeId, Impressions, ImpressionShare, MissedImpressions, MissedImpressionsInsufficientBid, MissedImpressionsNoBid, MissedImpressionsNoTax, MissedImpressionsOther, MissedImpressionsSpendingCapReached, NetReturnOnAdSpend, NetRevenue, PartitionType, PartnerImpressions, Revenue, Spend, TimePeriod.
| Value | Description |
|---|---|
| AccountId | The Microsoft Advertising assigned identifier of an account. |
| AccountName | The account name. |
| AccountStatus | The account status. |
| AdGroupId | The Microsoft Advertising assigned identifier of an ad group. |
| AdGroupName | The ad group name. |
| AdGroupStatus | The ad group status. |
| AdId | The Microsoft Advertising assigned identifier of an ad. Note: AdId is restricted for share of voice metrics. |
| AverageCpc | The average cost per click (CPC). The total cost of all clicks on an ad divided by the number of clicks. This is the average amount you're actually charged each time your ad is clicked. For example, if you paid a total of 48.35 for 300 clicks, your average CPC is 0.16. The formula for calculating the average CPC is (Spend /Clicks). |
| AverageCpm | The total advertising cost divided by the number of impressions (in thousands).<br/ In Latin, mille means a thousand. Also, sometimes called average cost per thousand (CPT). This is a standard advertising industry performance metric that we calculate based on your spend and number of impressions. The goal of CPM-based ad budgeting is to build awareness of your brand to large audiences. CPM tells you how much it costs to get an ad to the type of users you're targeting. |
| AvgBookedABW | The average advanced booking window for the hotel. The average is calculated as (booked ABW/conversions). |
| AvgBookedNights | The average nights booked for the hotel. The average is calculated as (total booked nights/conversions). |
| BidStrategyType | The bid strategy type. Possible values include EnhancedCpc, ManualCpc, MaxClicks, MaxConversions, and TargetCpa. If the InheritFromParent strategy type is used, the report will include the inherited bid strategy type e.g. one of the supported values listed above. |
| BookedABW | The total advanced booking window days for the hotel. |
| BookedLengthOfStay | The booked length of stay in number of nights. |
| CampaignId | The Microsoft Advertising assigned identifier of a campaign. |
| CampaignName | The campaign name. |
| CampaignStatus | The campaign status. |
| CheckInDate | The check-in date. |
| Clicks | Clicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example, spiders, robots, and test servers). For more information, see Microsoft Advertising click measurement: description of methodology. |
| ClickShare | The estimated percentage of clicks, out of the total number of clicks available, in auctions your ad showed in or was competitive in. Example: Out of the estimated 1,000 clicks that occurred on this day in your target auctions, you had about 230, or 23%. |
| Conversions | The number of conversions. A conversion is the completion of an action by a customer after viewing your ad. The action could be purchasing your product, registering for your webinar, joining an organization, or whatever you consider your goal and best measure of the ad's success. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked. Data will be excluded from the Conversions report column for any conversion goal with the ExcludeFromBidding property set to true. Available for accounts that are setup to use analytics with Microsoft Advertising Universal Event Tracking. For more information, see the Track sales and other conversions help topic. |
| CostPerAssist | The cost per assist. The formula for calculating the cost per assist is (Spend / Assists). |
| Ctr | The click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown (impressions). For example, if your ads got 50 clicks given 2,348 impressions, your CTR is 2.13 (%). The formula for calculating CTR is (Clicks / Impressions) x 100. |
| CurrencyCode | The account currency type. For possible values, see Currencies. |
| CustomerId | The Microsoft Advertising assigned identifier of a customer. |
| CustomerName | The name of the customer. |
| CustomParameters | The current custom parameter set of the criterion. Each custom parameter is a key and value pair. The list of custom parameters is semicolon-delimited and each key is enclosed by braces and a leading underscore, for example {_key1}=value1;{_key2}=value2. |
| DateType | Indicates whether the user searched for hotels using specific dates. The following are the possible values.
|
| DeviceType | The device name attribute of a device OS target bid. The type of device which showed ads. The possible values include Computer, Smartphone, Tablet, and Unknown. |
| EligibleImpressions | The total number of realized and unrealized impressions (impressions plus missed impressions). |
| FinalUrlSuffix | The final URL suffix can include tracking parameters that will be appended to the end of your landing page URL. We recommend placing tracking parameters that your landing page requires in a final URL suffix so that your customers are always sent to your landing page. For more details and validation rules see Final URL Suffix in the technical guides. Add: Optional Update: Optional. If no value is set for the update, this setting is not changed. If you set this element to an empty string (""), the previous setting will be deleted. |
| GrossReturnOnAdSpend | The gross return on ad spend. |
| HotelGroup | A group of hotel ads. |
| HotelGroupNodeId | The identifier for a hotel group. |
| Impressions | The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions. |
| ImpressionShare | The percentage of impressions, out of the total available impressions in the market you were targeting. For example, out of an estimated 59,000 impressions that occurred on this day in your targeted market, you received 2,300, or 3%. The value is in the range 0.0 through 1.0. |
| MissedImpressions | The total number of impressions lost. This is the sum of the following columns:
|
| MissedImpressionsInsufficientBid | The number of impressions lost because there were insufficient bids. |
| MissedImpressionsNoBid | The number of impressions lost because there were no bids. |
| MissedImpressionsNoTax | The number of impressions lost because the hotel didn't specify taxes. |
| MissedImpressionsOther | The number of impressions lost for all other reasons. Typically, low ranking or your rate was available in the More rates section, but the user did not expand the section to view your rate. |
| MissedImpressionsSpendingCapReached | The number of impressions lost because you reached your daily spending limit. |
| NetReturnOnAdSpend | The net return on ad spend. |
| NetRevenue | The net revenue. |
| PartitionType | The type of hotel partition, for example Subdivision or Unit. Add: Required Update: Update is not supported for this object |
| PartnerImpressions | The number of times an ad has been displayed on search results pages on our partner networks. Without impressions there are no clicks or conversions. |
| Revenue | The revenue optionally reported by the advertiser as a result of conversions. Data will be excluded from the Revenue report column for any conversion goal with the ExcludeFromBidding property set to true. Available for accounts that are setup to use analytics with Microsoft Advertising Universal Event Tracking. For more information, see the Track sales and other conversions help topic. |
| Spend | The cost per click (CPC) summed for each click. |
| TimePeriod | The time period of each report row. You may not include this column if the Aggregation element of the request object is set to Summary. If you include the TimePeriod column, the column label in the downloaded report depends on the aggregation level that you specify in the report request. For more information, see Time Period Column. This attribute is available in multiple reports, for example see KeywordPerformanceReportColumn Value Set. |
Requirements
Service: ReportingService.svc v13
Namespace: https://bingads.microsoft.com/Reporting/v13