Data Analytics Portfolio Project

Does the Same Strategy Work in Every Market?

Analyzing 229K+ Airbnb listings across 4 major US cities to uncover how minimum-night policies impact revenue—and why location-specific strategies matter.

229K+ Listings Analyzed
4 Cities NYC, SF, Seattle, LA
31% Revenue Difference
1 Major Exception

Presentation

View Presentation
My Role

City-by-City Strategic Analysis

As part of a 4-person analytics team, I led the comparative analysis of minimum-night booking policies across New York, San Francisco, Seattle, and Los Angeles. My focus was understanding whether revenue optimization strategies work universally—or if market-specific factors require localized approaches.

Tools & Methods: Python (Pandas, NumPy), SQL, Matplotlib/Seaborn for visualization, comparative statistical analysis across geographic segments

The Problem

Airbnb Hosts Don't Know Which Policy to Choose

Airbnb hosts face a critical decision: Should they require guests to book for a minimum number of nights? The tradeoff seems clear—more flexibility attracts more bookings, but longer stays reduce turnover costs and effort.

"Should I set a 1-night minimum to maximize bookings, or require 7+ nights to reduce the hassle of constant turnovers?"

Without data, hosts rely on intuition. Some assume flexibility always wins. Others copy what works in their city without understanding why. The result? Suboptimal pricing strategies that leave money on the table.

The Approach

How I Analyzed Four Markets

I designed a framework to compare minimum-night policies across cities, examining how different strategies impact revenue and occupancy rates.

1

Policy Classification

Categorized listings into Flexible (1-2 nights), Moderate (3-7 nights), and Strict (8+ nights) policies

2

Revenue Modeling

Calculated estimated annual revenue using price, availability, and booking frequency data

3

Occupancy Analysis

Segmented properties by occupancy levels to understand booking patterns

4

City Comparison

Used trend line analysis and scatter plots to identify patterns and exceptions across markets

The Findings

Three Cities Follow the Pattern, One Breaks It

My analysis revealed a clear pattern in NYC, San Francisco, and Seattle—but Los Angeles told a completely different story.

New York City
Pattern: Standard
[Trend line chart placeholder:
Moderate outperforms across occupancy levels]

Moderate policies (3-7 nights) consistently deliver 25-31% higher revenue than both flexible and strict approaches.

Key Data Point
Median revenue: Moderate ($54,750) vs Flexible ($41,975) vs Strict ($35,451)
Strategy
Moderate policies optimal. Strict only competitive at 85%+ occupancy for premium properties.
San Francisco
Pattern: Standard
[Trend line chart placeholder:
Moderate leads consistently]

SF shows the strongest preference for moderate policies, with clear separation from other policy types across all occupancy levels.

Key Data Point
Moderate policies achieve highest revenue even at lower occupancy rates
Strategy
Strong moderate policy advantage. Pair with dynamic pricing for premium neighborhoods (Marina, Mission, Noe Valley).
Seattle
Pattern: Standard
[Trend line chart placeholder:
Moderate wins, strict rises at high occupancy]

Moderate policies lead overall. Flexible stays steady. Strict policies show sharper upward trend at higher occupancy rates.

Key Data Point
51% of moderate-policy listings achieve high occupancy vs 47% for flexible
Strategy
Moderate for most hosts. High-occupancy premium properties can consider strict policies.
Exception
Los Angeles
Pattern: Inverse
[Trend line chart placeholder:
Strict stays flat, Flexible/Moderate decline]

LA breaks the pattern entirely. Flexible and moderate policies trend downward as occupancy increases, while strict policies remain competitive.

Why This Matters
LA's crowded market and long-term rental culture reward premium positioning over booking flexibility
Strategy
Strict policies competitive for premium positioning. Flexible/moderate require aggressive dynamic pricing to succeed.
The Playbook

City-Specific Hosting Strategies

Based on this analysis, here are actionable recommendations for hosts in each market.

📍 NYC Hosts
  • Default to 3-7 night minimum policies
  • Use strict (8+ nights) only for premium properties with 85%+ occupancy
  • Pair moderate policies with dynamic pricing
📍 San Francisco Hosts
  • Moderate policies deliver strongest returns
  • Premium neighborhoods (Marina, Mission, Noe Valley) can charge higher rates
  • Avoid strict policies unless targeting corporate/extended stays
📍 Seattle Hosts
  • Moderate policies optimal for most segments
  • High-occupancy properties can test strict policies
  • Flexible policies offer steady but lower revenue
📍 Los Angeles Hosts
  • Consider strict policies for premium market positioning
  • Long-term stays (30+ days) perform better than short stays
  • Flexible/moderate policies need aggressive pricing optimization
🆕 New Hosts (All Cities)
  • Start with moderate (3-7 nights) in NYC/SF/Seattle
  • Test for 3 months and track performance metrics
  • Build reputation before optimizing
⭐ Luxury Properties (All Cities)
  • Moderate policies + premium pricing works in most markets
  • Use dynamic pricing tools to optimize rates
  • Add perks (late checkout, breakfast) to justify higher prices
The Impact

What This Means for Stakeholders

For Airbnb Hosts

Clear, data-backed policy recommendations by market. Switching from strict to moderate policies could increase annual revenue by $10K-$20K per listing in most cities.

For Property Managers

Portfolio-wide optimization strategies. Different cities require different approaches—one-size-fits-all policies leave money on the table.

For the Platform

Framework for automated, location-aware policy recommendations in host dashboards. Improved revenue = higher platform fees.

Key Lesson

Market strategies can't be copy-pasted across geographies. Local context—market saturation, tourist vs. business travel, regulatory environment—drives optimal outcomes.