What the Hotel channel-mix and commission-cost scenario analysis prompt does

Act as a hotel distribution-finance analyst who compares channel economics through transparent net-revenue and contribution scenarios rather than gross booking value alone.

The prompt will, at minimum:

  • Reconcile channel, booking date, stay date, currency, room night, gross revenue, tax, fee, commission, cancellation, refund and payment-cost definitions before modelling
  • Calculate comparable net room revenue and contribution by channel with explicit formulas, separating variable acquisition cost, fixed platform cost, direct-media cost and operational servicing cost
  • Do not label direct booking as automatically cheaper or OTA demand as automatically incremental; model attribution uncertainty, brand capture, cancellation mix, market reach and displacement
  • Create base, optimistic and conservative channel-mix scenarios under occupancy, rate-parity, inventory, contract, cash-flow and market constraints
  • Identify break-even points, marginal cost, sensitivity, data gaps and decisions that require revenue-management, finance, tax or contract review

Who it is for

Gökhan Güzel's hospitality prompt for Claude users: marketers, founders, agencies and consultants who need an auditable, evidence-based deliverable instead of generic advice.

What you get

  • Data dictionary and reconciliation report
  • Channel net-revenue and contribution model
  • Scenario and sensitivity tables
  • Recommended channel-mix ranges and guardrails
  • Decision log, risks and data gaps

Variables

PlaceholderPurpose
{{adr_data}}Structured dataset or source file; state fields, data types, period, units, currency, time zone and provenance
{{analysis_period}}Date, time or period value; state ISO format, time zone, start/end boundary and comparison period
{{attribution_rules}}Approved rule, policy or constraint; state owner, version, scope, jurisdiction and effective date
{{cancellation_data}}Structured dataset or source file; state fields, data types, period, units, currency, time zone and provenance
{{channel_revenue}}Numeric value or table; state formula, numerator, denominator, unit, currency, tax treatment, period and source
{{commission_rates}}Numeric value or table; state formula, numerator, denominator, unit, currency, tax treatment, period and source
{{direct_booking_costs}}Numeric value or table; state formula, numerator, denominator, unit, currency, tax treatment, period and source
{{fixed_channel_costs}}Numeric value or table; state formula, numerator, denominator, unit, currency, tax treatment, period and source
{{hotel_name}}Verified identifier or text value; state exact spelling, source, status and validity scope
{{inventory_constraints}}Structured dataset or source file; state fields, data types, period, units, currency, time zone and provenance
{{marketing_spend}}Monetary spend or price input used for pricing, CAC, payback, profitability or scenario calculations
{{rate_parity_data}}Structured dataset or source file; state fields, data types, period, units, currency, time zone and provenance
{{refund_data}}Structured dataset or source file; state fields, data types, period, units, currency, time zone and provenance
{{room_nights}}Required input value; state source, data type, format, unit, period, market and locale where applicable
{{scenario_assumptions}}Required input value; state source, data type, format, unit, period, market and locale where applicable
{{target_channel_mix}}Numeric value or table; state formula, numerator, denominator, unit, currency, tax treatment, period and source
{{tax_and_fee_rules}}Approved rule, policy or constraint; state owner, version, scope, jurisdiction and effective date
{{transaction_fees}}Numeric value or table; state formula, numerator, denominator, unit, currency, tax treatment, period and source

How to use

Copy the prompt with the button above, replace every {{placeholder}} with your verified data, and paste it as the first message in a new Claude conversation. The prompt runs a short question gate first; answer it, then the deliverable is produced.

Run Hotel channel-mix and commission-cost scenario analysis in Claude

Open a new Claude chat, paste the filled-in Hotel channel-mix and commission-cost scenario analysis prompt and answer the short question gate. Claude then returns the executive decision, the evidence ledger and the task-specific tables in one reply.

Source

Original file in the multilingual prompt library on GitHub: