Hotel Ads is currently under beta testing and available to select advertisers only. Please contact your account manager for details on how you may be able to join.
You can update your bids, bid multipliers, and hotel group associations in bulk via the Microsoft Hotel Center UI, CSV upload, as well as Hotels API.
When preparing your spreadsheet, the FormatVersion row and Name column should not be altered.
|I want to bulk edit...||Columns required|
|Hotel bids||Type, Account Id, Id, Bid, Bid type|
|Hotel bid multipliers||
Type, Account Id, Id, Parent Id
Also required are one or more bid multiplier columns which are documented below.
|Hotel group associations||Type, Account Id, Id, Parent Id|
|Type||Defines the type of update being made. Possible values include: Hotel, Hotel Group, Hotel Association.|
|Name||Used by the FormatVersion row only, do not edit.|
|Account Id||Your Microsoft Advertising account ID.|
|Id||The ID of the entity being updated. For hotel group associations, this is the ID of the hotel to be grouped or ungrouped.|
|Parent Id||The ID of the direct parent entity. For hotel group updates, this is the subaccount ID. For hotel group association updates, this is the ID of the group to move the hotel into.|
|Bid type||Possible values: Percentage, Fixed.|
|Bid||The corresponding bid value. For both percentage and fixed bids, up to two decimal points of precision are supported. For example, 8.25 represents 8.25% if your bid type is percentage, or $8.25 if your bid type is fixed. Set to delete_value if you want the hotel or hotel group to inherit its bid from its parent.|
Adjust your bids based on the device the searcher is using.
Adjust your bids based on the day of check in at the hotel.
|Length of stay 1
Length of stay 2
Length of stay 14
Adjust your bids based on how many nights are included in the reservation. This multiplier applies to all lengths of stay greater than or equal to the one currently being specified (up to a maximum of 14).
For example, to increase bids by 10% for lengths of stay between 1 and 6 nights, and decrease bids by 20% for lengths of stay between 7 and 14 nights, you would set Length of stay 1 equal to 1.1 and Length of stay 7 equal to .8.
|Adjust your bids based on the country of the user.|
|Advance booking window min days 1
Advance booking window multiplier 1
Advance booking window min days 10
Advanced booking window multiplier 10
Adjust your bids based on how many days in advance the reservation is being made, also known as advanced booking window (ABW). The min days column specifies the minimum number of days in the ABW range to apply the multiplier to. The corresponding multiplier column defines the multiplier factor.
The maximum advanced booking window allowed is 90 days.
To delete a bid multiplier, use "delete_value" where you normally specify the multiplier's value. In the case of deleting an advanced booking window multiplier, "delete_value" does not also need to be specified in the ...min days column.