Create a CSV Hotel Feed file
This beta release of Hotel Price Ads is available to select participants only. For information about participating in the beta release program, please contact your account manager or enroll here.
The Hotel feed and documentation are subject to change.
To provide Microsoft your hotel listings, create a CSV file that contains a listing of each hotel you want to advertise. A listing describes the hotel's name, address, telephone number, and geographical coordinates.
For information about creating a feed file using an XML document, see Creating an XML Hotel Feed file.
The hotel feed supports only the English language.
CSV format doesn't support images. Use XML format instead.
Getting the data right
Because Microsoft attempts to match properties in your hotel feed to businesses in Bing Maps, it is important that the data you provide about the hotel is accurate and complete.
If your hotel has missing or incorrect information, Microsoft may not be able to match it. If Microsoft cannot match the hotel, Microsoft will not advertise it. After your TAM imports your hotel feed file, they'll send you a report that indicates which hotels Microsoft matched or didn't match. If Microsoft didn't match the hotel, the report includes the message, Unable to match this hotel to a property in Bing. For help improving your match rate, work with your TAM.
Defining a hotel listing
The first line of the feed file is the header row, which contains the column names of the hotel data in the feed. The header must include the column names of all required data elements. Only include the names of optional columns if you provide data for them.
The following is the list of columns that you may include in the feed. The feed file may contain the columns in any order and the column names are case insensitive.
|An opaque, user-defined ID that uniquely identifies the hotel within the feed.
When you create your transaction message, use this ID in the
Property element of your transaction message to identify the hotel.
|The hotel's name. The name may contain a maximum of 200 characters.
|The street address of the hotel using free-form text. Separate each component of the address with a comma and enclose the address in quotes. For example, "1234 Billings Way, Redmond, WA, 98030".
Use this column only if you provide the address using free-form text; otherwise, use the address component columns such as addr1, city, and province. It's preferred that you to use the address component columns instead of using free-form text.
|The hotel's street address. For example, 1234 Billings Way. The address must be a physical street address and not a post office box or other mailing-only address.
|Second street address line.
|Third street address line.
|The name of the city where the hotel is located.
|The name of the state, region, or province where the hotel is located.
|The address' postal code.
|The country or region where the hotel is located. Specify the country or region using the two-letter ISO 3116 country code. For example, use US for United States.
|The latitude of the hotel's geographical coordinates.
|The longitude of the hotel's geographical coordinates.
|The main voice telephone number that customers use to contact the hotel. The number should be the front desk's phone number and not a central reservations phone number.
|A category that identifies the type of hotel. The expected format is vacation_rental or hotel followed by the pipe character and a custom value. For example, vacation_rental | 'custom value' or hotel | 'custom value'
For a list of custom values, see Lodging property categories.
|The hotel chain's brand. For example, Fabrikam Residences by Contoso, where Contoso is the brand.
|The hotel's star rating. Possible values are 1 through 5.
address column and the
postal_code columns are mutually exclusive. Specify either the
address column or the address component columns. Specifying the address component columns is preferred.
Although you may specify either geographical coordinates or a telephone number, you should specify both to ensure a better chance of matching properties in Bing Maps.
To include a description, images, and reviews for a listing, use an XML feed file. See Create an XML Hotel Feed file.
The following shows an example header in CSV format. Separate all columns with a comma. Include only columns that contain values for at least one hotel.
After the header row, include a row for each hotel that you advertise. The feed must include listings for all your hotels— the feed process does not support partial updates. Do not include blank rows in your feed.
If a value contains a comma, you must surround the value with quotes. The following shows the contents of an example CSV file.
abc123,Great Ambers Getaway,1234 Porter Rd,Goldendale,WA,98234,US,47.694351,-122.451782,123-456-7890
What happens if the hotel's content changes?
If you change any of the hotel's property values between feed runs (for example, its name, address, phone, etc.), Microsoft Advertising may treat it as a new hotel property and create a new listing for it. If Microsoft creates a new listing, prior performance history for the old hotel remains available for up to 36 months. Note that the old hotel's bids and multipliers will not transfer to the new hotel entity.
If you remove a hotel and add it back in a later feed with the same property values as before, Microsoft treats it as a new listing. Also, the performance report will show it as two separate listings.
Ask your account manager to import the feed file.
Be sure to also import your points of sale data. For information about creating your points of sale feed file, see Points of Sale Feed.
After Microsoft successfully imports your data and is able to match your hotels with properties in Bing Maps, you may begin sending your hotel pricing and availability data. For information, see Transaction Messages.