Revenue Intelligence
AI-powered revenue analysis · July 2026 · Week 29
AI Revenue Narrative: Today
Your Thu-Sun leisure segment is outperforming: but corporate is quietly bleeding out.
Weekend leisure Function Yield is +22% YoY, driven by improved direct booking conversion (+8.4 pts) and strong summer pre-booking velocity.
However, your Mon-Wed corporate segment dropped −11%: two key accounts (Turquoise Coast Airlines, Vodafone TR) have not renewed Q2 contracts.
third-party channel commission drag is at $18,400 this month: your direct channel carries a 3.1× lifetime guest value advantage but represents only 34% of volume.
Recommended actions: (1) Launch proactive outreach to top 5 lapsed corporate accounts before end of July. (2) Redirect 12% of SevenRooms local search spend to owned-email nurture sequence. (3) Monitor Competitor B: they dropped Cover Value by $14 last week; defend your #2 comp-set position.
Recommended actions: (1) Launch proactive outreach to top 5 lapsed corporate accounts before end of July. (2) Redirect 12% of SevenRooms local search spend to owned-email nurture sequence. (3) Monitor Competitor B: they dropped Cover Value by $14 last week; defend your #2 comp-set position.
AI Channel Insight: Direct bookings cost 3.1× less to acquire and retain guests 68% longer than third-party channel. Yet third-party channel represents 51% of volume and $18.4K in commission drag this month.
Shifting 12% of third-party channel local search budget to email nurture is projected to yield +$6,200 net revenue/month within 60 days.
Direct Bookings
34%
+3.2 pts MoM
LGV: $2,840 avg
third-party channel Volume
51%
−1.8 pts MoM
Commission: $18,400
Corporate / GDS
11%
−2.1 pts MoM
2 accounts lapsed
Venue
4%
+0.7 pts MoM
Cover Value: $380 avg
Commission Drag
$18.4K
+$1,200 MoM
This month
Booking Channel Mix
Volume share by channel: July 2026
Lifetime Guest Value by Channel
Average LGV over 24-month horizon
Channel Performance Breakdown
Revenue, Cover Value, conversion rate, and commission cost by channel
| Channel | Revenue (July) | Cover Value | Bookings | Conversion | Acq. Cost | LGV | Share |
|---|---|---|---|---|---|---|---|
| Direct | $124,800 | $412 | 303 | 4.8% | $28 | $2,840 | |
| third-party channel | $186,300 | $388 | 480 | 2.1% | $86 | $920 | |
| Corporate | $40,200 | $355 | 113 | : | $12 | $1,640 | |
| GDS | : | $370 | : | : | $44 | $1,200 | |
| Venue | $14,600 | $380 | 38 | : | $0 | $480 |
AI Forecast Narrative: Projected Q3 occupancy at 78.4%: up from 71.2% last year. A local music festival (Sep 18-20) adds +320 room-night demand spike. Cover Value forecast holds at $398 avg but a rate parity risk from Competitor B could compress it by $8-12 if unaddressed.
30-Day Occupancy
74.2%
+4.1 pts YoY
Forecast: 76.8%
Cover Value Forecast
$398
+$22 YoY
Aug-Oct 90-day avg
Function Yield Forecast
$295
+$38 vs last yr
Aug-Oct
Risk: Rate Parity
−$12
Cover Value exposure
Competitor B undercutting
Event Demand Spike
+320
room-nights
Sep 18-20 festival
90-Day Occupancy Forecast
Actuals (solid) vs forecast range (band): with event markers
Actual
Forecast (base)
Event spike
Risk scenario
Seasonality Pattern
3-year occupancy by week
Enquiry Window Distribution
Days before arrival at time of booking
AI Cohort Insight: Your Q3 2024 Direct acquisition cohort has the highest 12-month LGV at $2,840 and a 61% return rate. Business guests from the Nov 2024 cohort are churning: only 18% returned in 12 months. Consider a targeted re-engagement offer ($50 F&B credit) for this segment.
Total Unique Guests
4,820
+412 YoY
Avg Guest LGV
$1,640
+$180 YoY
Return Rate
38.4%
+5.1 pts YoY
Churned (12mo)
1,240
High-value segment
Recovery opp: $180K
LGV by Guest Persona
24-month horizon
Cohort Retention Heatmap
% of guests returning by months since first stay
Top Guest Segments
Ranked by lifetime guest value
| Segment | Guests | Avg LGV | Return Rate | Avg Stay | Top Channel | Revenue |
|---|---|---|---|---|---|---|
| Luxury Leisure (couples) | 1,240 | $3,420 | 61% | 4.2 nights | Direct | $4.2M |
| Solo Business Guest | 820 | $1,640 | 28% | 2.1 nights | Corporate | $1.3M |
| Family (2+ children) | 640 | $2,180 | 44% | 5.8 nights | third-party channel | $1.4M |
| Group / Events | 320 | $4,800 | 72% | 3.4 nights | Direct | $1.5M |
| Churned Business (Nov'24) | 480 | $0 (lapsed) | 18% | : | Corporate | $0 |
Active Anomaly Detected: High Priority
Mon-Wed Function Yield dropped −11% WoW. Primary hypothesis: rate parity breach by Competitor B (−$14 Cover Value on SevenRooms vs your $388).
Secondary: cancellation of Vodafone TR Q2 corporate block (−84 room-nights). Tertiary: off-peak-period demand compression vs YoY event calendar.
Secondary Alert: Medium Priority
Weekend F&B revenue flat despite +22% room occupancy. Hypothesis: upsell gap: guests not converting to restaurant or spa packages.
Recommend: in-stay SMS upsell sequence activation (tested Q4 2025, +$42/stay uplift).
Function Yield Impact
−$28
Mon-Wed only
Rate Parity Gap
−$14
vs Competitor B (third-party channel)
Corp Block Lost
−84
room-nights
Recovery Potential
$14.2K
if rate parity fixed
Dimension Drill-Down
Function Yield Decomposition: Waterfall
What drove the change vs prior week
Function Yield by Day-of-Week
This week vs prior week
Cancellation Trend
30-day cancellation rate by channel
AI Competitive Narrative: You rank #2 in your comp set this week by Function Yield. Competitor A (Hillside Rooftop Bar) holds #1 at $348 Function Yield.
Competitor B dropped Cover Value by $14 last Thursday: likely a distressed inventory move for slow midweek. Do not match their rate: their lower review score (8.1 vs your 9.2) means you can sustain the gap.
Your Comp Set Rank
#2
of 6 venues
by Function Yield
Your Cover Value
$388
+$4 vs last week
Review Score
9.2
Comp avg: 8.4
#1 in comp set
Rate Parity Breach
1
Competitor B undercutting
Market OCC
68.4%
You: 74.2%
+5.8 pts ahead
Cover Value Comparison: 30 Days
Your rate vs top 3 competitors
Comp Set Ranking: This Week
Function Yield rank · review score · occupancy
1
$410
Hillside Rooftop Bar
Occupancy: 76% · Reviews: 9.4
⭐⭐⭐⭐⭐
2
$388
◀ The Wharf Hotel (You)
Occupancy: 74.2% · Reviews: 9.2
⭐⭐⭐⭐⭐
3
$374
D-Resort Göcek
Occupancy: 71% · Reviews: 9.0
⭐⭐⭐⭐⭐
4
$342
Yazz Collective
Occupancy: 69% · Reviews: 8.6
⭐⭐⭐⭐☆
5
$310
Competitor B ⚠️
Occupancy: 61% · Reviews: 8.1 · −$14 Cover Value drop
⭐⭐⭐⭐☆
AI Campaign Ranking: Email nurture sequence is your #1 performer at 1,281% ROI with $0.28 cost-per-click.
Meta-search ads deliver 2.3× ROAS but should be restructured: top 3 ad sets driving 91% of conversions.
Your last flash sale (Jun 28) was margin-negative: −$4,200 net after discount + third-party channel fees. Pause flash sales through peak summer.
Best ROI
1,281%
Email Nurture
Total Campaign Spend
$28,400
This month
Total Revenue Attributed
$184K
6.5× blended ROAS
Worst Performer
−$4.2K
Flash Sale Jun 28
Campaign ROI League Table
Ranked by return on investment: July 2026
1
Email Nurture: Summer Warm-Up Sequence
Email
1,281%
2
SEO: Luxury Beach Venue Melbourne
SEO
874%
3
Meta-Search Bid: Direct Booking Push
231%
4
Loyalty Reward: Return Guest Offer
Loyalty
168%
5
Google Display: Brand Awareness
42%
6
Flash Sale: Jun 28 Last-Minute
Flash
−18%
Spend vs Revenue
By campaign type
Data Hub: 3 connectors active · Last sync 07:42 AM today. Mews PMS is syncing in real-time. SiteMinder channel data updates every 4 hours. Google Analytics last updated 1 hour ago. Missing: Tripleseat partner API: connect to unlock third-party channel enquiry window data.
PMS Connectors
Mews PMS
Reservations · F&B · Housekeeping
Live sync
SiteMinder
Channel manager · Rate parity
4hr sync
Opera PMS
Oracle Hospitality
Not connected
Google Analytics 4
Website · Booking funnel
1hr sync
Tripleseat Partner Central
third-party channel enquiry window data
Not connected
Cloudbeds
Alternative PMS
Not connected
Manual Import
Drag & drop your data file here
Supports CSV, XLSX, JSON · Auto-routes to correct module on import · Max 50MB
Reservations
Rates
Guest Profiles
Campaign Data
Competitor Rates
Recent Imports
| File | Type | Records | Routed To | Status | Imported |
|---|---|---|---|---|---|
| mews_export_may_2026.csv | Reservations | 934 | Channel Attribution, Cohort | ✓ Processed | July 29, 07:42 |
| siteminder_rates_may28.xlsx | Rates | 1,248 | Competitive Intel, RCA | ✓ Processed | July 28, 23:15 |
| campaign_report_apr_may.csv | Campaign Data | 42 | Campaign ROI | ✓ Processed | July 28, 14:30 |
| competitor_rates_bodrum.csv | Competitor Rates | 180 | Competitive Intel | ⚠ Partial (12 errors) | July 27, 09:00 |
AI Brand Narrative: Reputation score 9.2/10: #1 in your comp set. interstate market is your fastest-growing source at +41% YoY (interstate, Switzerland, Austria combined). Search visibility improved to avg position #2.2 from #3.1 last month. Guest sentiment is 78% positive: main detractor theme: "arrival wait times" appearing in 34% of negative reviews.
Reputation Score
9.2
#1 in comp set
Across 5 platforms
Positive Sentiment
78%
+4 pts MoM
Avg Search Position
#2.2
from #3.1 last month
Top Source Market
🇩🇪 DE
+41% YoY
34 bookings (14d)
YoY Revenue
+22%
2026 vs 2025
Full year projected
Revenue Trend
Daily revenue: Apr 1 to May 2, 2026
Year-over-Year Revenue
2026 vs 2025: projected from Jun onwards
2026
2025
Guest Source Markets
Bookings by country: 14d
Market Detail
Bookings, Cover Value, party size, YoY growth
| Market | Bookings | Cover Value | LOS | YoY |
|---|---|---|---|---|
| 🇩🇪 interstate | 34 | $295 | 5.2 | +41% |
| 🇬🇧 UK | 28 | $310 | 4.8 | +28% |
| 🇨🇭 Switzerland | 19 | $320 | 6.1 | +35% |
| 🇳🇱 Netherlands | 15 | $275 | 4.2 | +2% |
| 🇸🇪 Sweden | 12 | $288 | 5.7 | +19% |
| 🇦🇹 Austria | 9 | $300 | 5.0 | +4% |
Reputation by Platform
Score out of 10
9.2
★★★★★
TripAdvisor
342 reviews9.4
SevenRooms
518 reviews9.1
Google
294 reviews9.0
Tripleseat
187 reviews8.9
Mr & Mrs Smith
89 reviews9.6
Guest Sentiment
1,430 reviews analysed: last 90 days
78%
Positive
Positive
78%Neutral
15%Negative
7%Top Negative Theme
"Arrival wait times": 34% of negative reviews. Suggest: dedicated fast-track lane for direct bookers.
Search Visibility
Organic keyword rankings
luxury venue bodrum
#2
boutique venue turkey
#4
5 star bodrum beach
#1
The Wharf Hotel
#1
bodrum resort spa
#3
Avg Position
#2.2
Improved from #3.1 last month