Revenue Analytics & OTA Fee Tracking

Tier: Business 💼
Time: 10 minutes to understand
Prerequisites: Business plan, booking data imported

Overview

Revenue Analytics is your financial command center for understanding the true profitability of your vacation rental business. Track total booking value, calculate OTA fees saved through direct bookings, measure guest lifetime value, and attribute revenue to specific marketing campaigns.

Key Benefits:

💰 Real-Time Revenue Tracking - See booking value as it comes in
💸 OTA Fee Savings Calculator - Quantify what you save on direct bookings
📊 Guest Lifetime Value - Identify your most valuable repeat guests
📈 Campaign ROI - Know which marketing efforts drive bookings
🏆 Property Performance - Compare revenue across your portfolio
💡 Revenue Opportunities - AI-identified upsell and cross-sell chances

Accessing Revenue Analytics

From Dashboard

Navigate to Analytics in sidebar
Click "Real-Time Revenue" card in Advanced Analytics section
Revenue dashboard loads

From Properties

Go to Properties → Select property
View revenue widget on property page
Click "View Details" for full revenue dashboard

Direct Navigation

Visit: /dashboard/analytics/revenue

Understanding Revenue Metrics

Total Booking Value

What It Measures: The total value of all bookings (past, current, and future)

Breakdown:

Past - Completed stays
Current - Guests currently in your property
Future - Upcoming reservations

Example:

Total Booking Value: $127,450

Past (Jan-Oct): $89,200
Current (Nov stays): $12,500
Future (Dec-Feb): $25,750

Average Booking Value: $850
Total Bookings: 150

OTA Fees Saved

How It's Calculated:

For Direct Bookings:
Fee Saved = Booking Value × Platform Commission Rate

Platform Rates:
- Airbnb: 15%
- Booking.com: 15%
- VRBO: 10%
- Direct: 0%

Example:
$5,000 direct booking vs Airbnb:
Saved: $5,000 × 15% = $750

Your Total Savings:

Direct Bookings: 45 ($38,250 value)
OTA Fees Avoided: $5,737

Breakdown:
- If booked via Airbnb: $5,737 in fees
- If booked via Booking.com: $5,737 in fees  
- If booked via VRBO: $3,825 in fees
- Booked Direct: $0 in fees

Net Savings: $5,737 💰

ROI on GuestLoop:

Annual GuestLoop Cost: $948 ($79/mo × 12)
OTA Fees Saved: $5,737
Net Savings: $4,789

ROI: 505% ✅
Payback Period: 2 months

Revenue Per Available Night (RevPAN)

What It Measures: Average revenue per night (regardless of occupancy)

Formula:

RevPAN = Total Revenue ÷ Total Available Nights

Example:
Total Revenue: $45,000
Available Nights: 365
RevPAN: $123/night

Occupancy: 75%
Actual Nightly Rate: $164
RevPAN: $123 (includes empty nights)

Why It Matters:

More accurate than average nightly rate
Accounts for vacancy
Better for comparing properties

Guest Lifetime Value (LTV)

What It Measures: Total revenue generated by each guest across all bookings

Calculation:

Guest LTV = Sum of all booking values from guest

Example Guest:
1st Stay (June 2024): $1,200
2nd Stay (Dec 2024): $1,400
3rd Stay (Feb 2025): $1,100

LTV: $3,700
Average per stay: $1,233
Rebooking rate: Guest returned 2x

Top Guests by LTV:

1. Sarah M. - $8,500 (5 stays)
2. John K. - $6,200 (3 stays)
3. Lisa P. - $5,800 (4 stays)
4. Mike T. - $4,900 (2 stays)
5. Emma R. - $4,500 (3 stays)

💡 These 5 guests = $29,900 (23% of revenue)
Insight: VIP program for repeat bookers 
could increase retention

Revenue Dashboard Widgets

Live Revenue Widget

Real-Time Metrics:

Today's bookings: Value of bookings made today
This week: Rolling 7-day booking value
This month: Month-to-date revenue
This year: Year-to-date revenue

Comparisons:

vs Last Period (week/month/year)
vs Same Period Last Year
Trend arrows (up/down)

Example:

This Month: $12,450
Last Month: $10,200
Change: +22% ↑

Same Month Last Year: $9,800
YoY Growth: +27% ↑

Property Performance Leaderboard

Rankings:

Property name
Total revenue (selected period)
Number of bookings
Average booking value
Revenue change vs last period

Example:

Top 3 Properties (Last 30 Days):

1. 🥇 Beachfront Villa
   Revenue: $15,450
   Bookings: 12
   Avg: $1,287
   Change: +18% ↑

2. 🥈 Mountain Cabin
   Revenue: $12,800
   Bookings: 16
   Avg: $800
   Change: +5% ↑

3. 🥉 Downtown Loft
   Revenue: $11,200
   Bookings: 22
   Avg: $509
   Change: -3% ↓

Direct vs OTA Revenue

Pie Chart Breakdown:

Direct Bookings: 45% ($38,250)
Airbnb: 30% ($25,500)
Booking.com: 15% ($12,750)
VRBO: 10% ($8,500)

Direct Booking Rate: 45%
Industry Average: 25-30%
Status: Above Average ✅

Goal: Increase direct to 55%
Action: Run email campaign to past OTA guests

Campaign Attribution

Which campaigns drive bookings?

Email Campaigns:
"Summer 2025 Early Bird" → $18,500 (12 bookings)
"Return Guest Discount" → $12,400 (8 bookings)
"Last-Minute Fall Deal" → $6,700 (5 bookings)

Social Media:
Instagram posts → $4,200 (3 bookings)
Facebook ads → $2,800 (2 bookings)

Referrals:
Guest referrals → $9,100 (6 bookings)

Total Attributed: $53,700 (36 bookings)
Unattributed: $73,750 (114 bookings)

💡 Improve tracking with UTM parameters

Revenue Forecast

AI-Powered Predictions:

Next 30 Days Forecast:
Expected Bookings: 18-22
Expected Revenue: $15,200 - $18,900
Confidence: 78%

Factors:
- Historical booking pace
- Seasonal patterns
- Current pipeline
- Local events
- Market trends

Action Items:
⚠️ June 15-20: Only 40% booked (below pace)
✅ July 4th weekend: 100% booked
💡 Aug 10-15: High demand period, consider price increase

Revenue Opportunities Dashboard

High-Value Guest Identification

Who to target for rebooking:

Guests Likely to Rebook (90+ Days Since Stay):

1. Mike & Sarah T.
   Last Stay: 120 days ago
   LTV: $4,900 (2 stays)
   Rebooking Probability: 78%
   Action: Send personalized email with 15% off

2. The Johnson Family
   Last Stay: 150 days ago
   LTV: $6,200 (3 stays)
   Rebooking Probability: 85%
   Action: VIP offer + early check-in

3. Emma Rodriguez
   Last Stay: 95 days ago
   LTV: $3,700 (2 stays)
   Rebooking Probability: 65%
   Action: Share new amenities + 10% off

Upsell Opportunities

Revenue left on the table:

Potential Upsell Revenue: $12,400/year

Opportunities:
1. Early Check-In ($50/booking)
   - 45% of guests request early check-in
   - Currently free
   - Potential: +$6,750/year

2. Late Checkout ($40/booking)
   - 38% of guests request late checkout
   - Currently free
   - Potential: +$4,560/year

3. Pet Fee ($75/booking)
   - 5% of guests bring pets
   - Currently free
   - Potential: +$1,125/year

💡 Implement gradual ly to avoid guest friction

Gap Analysis

Vacancy periods to fill:

High-Opportunity Gaps:

March 15-20 (5 nights):
- Historical occupancy: 65%
- Currently: 0% booked
- Days out: 45
- Action: Flash sale, 20% off, minimum 3 nights

May 5-10 (5 nights):
- Historical occupancy: 80%
- Currently: 40% booked
- Days out: 120
- Action: Email campaign to past May guests

October 10-15 (5 nights):
- Historical occupancy: 55%
- Currently: 0% booked
- Days out: 240
- Action: Target fall foliage travelers

Exporting Revenue Data

Export Options

CSV Export:

Click "Export Revenue Data" button
Select date range
Choose data to include:
- ☑ Bookings with values
- ☑ Guest information
- ☑ Property breakdown
- ☑ Campaign attribution
- ☑ OTA fee calculations
Download CSV file

PDF Report:

Click "Generate PDF Report"
Select date range and properties
Choose report sections:
- Executive summary
- Revenue charts
- Property performance
- Guest LTV analysis
- Campaign ROI
Download professional PDF report
Share with accountant, investors, or partners

Accounting Integration:

QuickBooks export format
Xero export format
FreshBooks export format

Revenue Alerts

Set Up Notifications

Alert Types:

1. Revenue Milestones:

✅ $10,000 monthly revenue reached
✅ $100,000 annual revenue reached
✅ Record-breaking month

2. Booking Pace Alerts:

⚠️ Booking pace 20% below last year
⚠️ No bookings in 7 days
✅ Booking surge detected

3. Direct Booking Wins:

🎉 Direct booking saved $150 in OTA fees
🎉 50% direct booking rate achieved this month

4. Guest Value Alerts:

🌟 Guest reached $5,000+ LTV
🌟 New repeat guest (3+ stays)

Notification Methods:

Email digest (daily/weekly)
Push notifications (immediate)
SMS alerts (high priority only)
Slack notifications (team channel)

Measuring Success

Key Performance Indicators (KPIs)

Revenue KPIs:

Total Booking Value - Target: YoY growth of 15-25%
RevPAN - Target: Increase 10% year over year
Average Booking Value - Target: $800-1,200+ depending on market

Efficiency KPIs:

Direct Booking Rate - Target: 40-60%
OTA Fees Saved - Target: 3-5x GuestLoop subscription cost
Campaign ROI - Target: 5:1 or better (spend $1, earn $5)

Guest KPIs:

Guest LTV - Target: $2,000+ per guest
Rebooking Rate - Target: 15-25%
Average Stays Per Guest - Target: 1.5-2+

Benchmarks

Industry Averages:

Your Property vs Industry:

Revenue Per Available Night:
You: $145
Industry: $118
Status: Above Average (+23%) ✅

Direct Booking Rate:
You: 45%
Industry: 28%
Status: Excellent (+17 pts) ✅

Guest Rebooking Rate:
You: 18%
Industry: 12%
Status: Above Average (+6 pts) ✅

OTA Commission Paid:
You: 8.5% of total revenue
Industry: 15.2% of total revenue
Status: Saving 6.7 pts ✅

Tips for Maximizing Revenue

Do's ✅

Track every booking source - Use unique links/codes for attribution
Focus on direct bookings - 3-5x ROI vs OTA bookings
Nurture repeat guests - LTV is 3-4x higher than one-time guests
Use data to make decisions - Don't guess at pricing or marketing
Set up revenue alerts - Catch issues early
Export data monthly - Share with accountant, track trends
Test price changes - Small increases can significantly impact revenue

Don'ts ❌

Don't ignore OTA fees - They add up to thousands per year
Don't treat all guests the same - VIPs deserve special treatment
Don't skip attribution tracking - You need to know what works
Don't forget about upsells - Early check-in, late checkout add up
Don't rely on vanity metrics - Occupancy doesn't equal profit
Don't ignore seasonality - Plan for high/low demand periods

Troubleshooting & FAQs

"My revenue numbers seem wrong"

Common Issues:

Missing bookings:
- Solution: Import all bookings via CSV or integrations
Wrong booking values:
- Solution: Edit bookings to include correct total value
OTA fees not calculating:
- Solution: Ensure "Booking Source" is set correctly (Airbnb, Booking.com, etc.)
Future bookings not counting:
- Solution: Check date filter - ensure "Future" bookings are included

"Campaign attribution not working"

Requirements for Attribution:

Campaign must be sent via GuestLoop - External campaigns can't be tracked
Guest must click link in campaign - Direct bookings without click aren't attributed
Booking must happen within 90 days - Attribution window

Improve Attribution:

Use unique booking links per campaign
Add UTM parameters to all links
Track manually for phone/offline bookings

"Export missing data"

Solutions:

Check date range (may be too narrow)
Ensure all properties selected
Verify booking data is complete
Try CSV format if PDF fails

What's Next?

Now that you understand your revenue:

✅ Use Market Intelligence - Optimize pricing based on market data
✅ Create Targeted Campaigns - Drive more direct bookings
✅ View Advanced Analytics - Deep dive into guest behavior

Need Help?

Business Plan Support: support@guestloop.com (Priority response within 4 hours)
Revenue Strategy Consultation: Available for Business plan users
Video Tutorial: Watch: Understanding Revenue Analytics
Accounting Integration Help: Export Guide

Track every dollar | Calculate true ROI | Maximize profitability | Business plan exclusive

Revenue Analytics & OTA Fee Tracking

Revenue Analytics & OTA Fee Tracking

Overview

Accessing Revenue Analytics

From Dashboard

From Properties

Direct Navigation

Understanding Revenue Metrics

Total Booking Value

OTA Fees Saved

Revenue Per Available Night (RevPAN)

Guest Lifetime Value (LTV)

Revenue Dashboard Widgets

Live Revenue Widget

Property Performance Leaderboard

Direct vs OTA Revenue

Campaign Attribution

Revenue Forecast

Revenue Opportunities Dashboard

High-Value Guest Identification

Upsell Opportunities

Gap Analysis

Exporting Revenue Data

Export Options

Revenue Alerts

Set Up Notifications

Measuring Success

Key Performance Indicators (KPIs)

Benchmarks

Tips for Maximizing Revenue

Do's ✅

Don'ts ❌

Troubleshooting & FAQs

"My revenue numbers seem wrong"

"Campaign attribution not working"

"Export missing data"

What's Next?

Need Help?

Need More Help?

More Guides