If your Ipiphany account has integrations enabled, the Expedia - Hotel Reviews data source is available when creating or appending data to a Dataset. It is used to download and import Hotel reviews.

Step 1: Give the Connection a memorable name

We suggest the name contains both a reference to Expedia and the name of the Hotel you are sourcing reviews for. e.g. Expedia - Crowne Plaza Hotel Queenstown

Step 2: Add Expedia page URL

The URL is the link to the Expedia page for the hotel. Go to expedia.com and search for the hotel then copy and paste the URL.

The URL will look something like this: https://www.expedia.com/Queenstown-Hotels-Crowne-Plaza-Hotel-Queenstown.h10842.Hotel-Information?chkin=2021-10-15&chkout=2021-10-16&x_pwa=1&rfrr=HSR&pwa_ts=1633035450752&referrerUrl=aHR0cHM6Ly93d3cuZXhwZWRpYS5jb20vSG90ZWwtU2VhcmNo&useRewards=false&rm1=a2&regionId=180018&destination=Queenstown%2C+Otago%2C+New+Zealand&destType=MARKET&neighborhoodId=6216654&hotelName=plaza&sort=RECOMMENDED&top_dp=107&top_cur=USD&semdtl=&userIntent=&selectedRoomType=201421232&selectedRatePlan=380213676

Note, you can remove everything in the URL after and including the '?' as this is not required:

https://www.expedia.com/Queenstown-Hotels-Crowne-Plaza-Hotel-Queenstown.h10842.Hotel-Information

Step 3: Add an Earliest Record Date if required

The earliest record date limits the results to only those after the specified date. Note that the most recent reviews will return first up to your maximum records setting.

Step 4: Set the Maximum Records to Import

This setting limits the number of reviews that are downloaded in one synchronization.

Step 5: Choose if you want to 'Download Only' or not

If you enable 'Download Only' the reviews will be downloaded and appear in Dataset Settings > Data but will not be appended to your Dataset. This is useful when you want to manually add a column, translate, or perform some other manual action to the data prior to it being appended.