Yield management — hospitality
Maximize revenue per available room: RevPAR, ADR, occupancy rate and pickup.
RevPARADROccupancy rate
Open template →
Tourism · SAP Analytics Cloud
SAP Analytics Cloud templates for Tourism
4 ready-to-use SAC and SAC Planning templates for Tourism — each with the KPIs, dimensions and realistic data your function actually tracks. Import in minutes, or generate a tailored one. No sign-up.
KPIs we cover for Tourism
Occupancy rateRevPARADR (average rate)Average length of stayCustomer NPSAcquisition costCancellation rateGOPPAR
Analysis dimensions
HotelRegionBrandCustomer segmentBooking channelSeasonRoom type
4 Tourism templates
Each opens with a live preview and a one-click download (.xlsx, .csv, .package).
Hotel performance — GOPPAR
An operations view: gross operating profit per available room (GOPPAR), total revenue per room and satisfaction.
GOPPARTRevPAROccupancy rate
Open template →
Hotel marketing
Manage customer acquisition: acquisition cost, direct vs OTA share, ROAS and site conversion.
Acquisition costDirect vs OTA shareROAS
Open template →
Occupancy forecast
Forecast your occupancy 90 days out: pickup, pace vs PY and historical forecast accuracy.
Forecast occupancyPickupPace vs PY
Open template →
How to model Tourism in SAP Analytics Cloud
A solid Tourism model starts with the right grain. Build your dimensions first (Hotel, Region, Brand), then add the measures that matter (Occupancy rate, RevPAR, ADR (average rate)). The trap is aggregation: amounts and volumes sum, but rates and percentages must use AVERAGE, and stocks or balances must use a LAST exception on the time dimension — otherwise your yearly totals come out wrong.
Set those aggregations once in the Modeler, import your data, and build a Story from the KPIs above. For the full method, see our guides on importing a CSV into SAC and choosing the right aggregation.