To obtain historical or future data from reservations & guest profiles.
There are 5 categories to choose data from:
Clicking the + will expand the categories to show the areas that can be extracted
Extracting all profiles that have opted in to your mailing list
Exclude from mailings box within a guests' profile MUST be unticked if they have opted in to your mailing list.
Exclude from 3rd mailings would also be unticked at the same time if you interface with a 3rd party such as GuestRevu.
Show One Record per Unique Profile Only is ticked by default - you can opt to tick the Include Profile Reference by ticking the box
Tick the following:
Click Execute - it will show records returned (if the records returned show 100 exactly then up the Max records to return box and Execute again)
There are 2 different View options:
|The results will show on screen|
|Allows for more options - Direct Print, Viewer, PDF, CSV or Email|
New - refreshes the screen to start again
Load - if you have a report saved
Delete - to delete a report saved
Save - to save a report for future use
Can be compared with:
Guest List – For arrivals & departures
Reservations – For arrivals, created on & departures
Cannot be compared with:
House Status – Design Query shows bookings that have arrived/ departed when House Status shows bookings still to arrive/ depart
Actual/Forecast: Total cost on both Actual & Forecast
Tax Calculation: Gross
Export Options: Export to CSV with no additional fields given
IMPORTANT TO NOTE - Only data for profiles that have been 'linked' will show on the Design Query.