Air France Internet Marketing: Optimizing Google, Yahoo!, MSN, and Kayak Sponsored Search Custom Case Solution & Analysis

1. Evidence Brief

Financial Metrics

• Total SEM Spend: 156,733 dollars across all publishers.
• Total Generated Revenue: 1,556,236 dollars.
• Overall Return on Advertising Spend (ROA): 9.93.
• Google Performance: Cost 105,420 dollars; Revenue 1,105,622 dollars; ROA 10.49.
• Yahoo Performance: Cost 36,892 dollars; Revenue 292,841 dollars; ROA 7.94.
• MSN Performance: Cost 9,657 dollars; Revenue 116,339 dollars; ROA 12.05.
• Kayak Performance: Cost 4,764 dollars; Revenue 41,434 dollars; ROA 8.70.
• Average Cost Per Click (CPC): 1.08 dollars.
• Average Probability of Booking: 0.0076 (calculated from 1,186 bookings over 156,384 clicks).

Operational Facts

• Channel Composition: Google accounts for 67 percent of total spend and 71 percent of total revenue.
• Keyword Volume: Analysis covers thousands of keywords categorized by brand, destination, and generic terms.
• Geography: Data focuses on the United States market for Air France international flights.
• Agency Role: Media Contacts manages the bidding process and campaign execution.
• Platform Mechanics: Google, Yahoo, and MSN operate on auction-based CPC models; Kayak operates as a metasearch engine with different user intent patterns.

Stakeholder Positions

• Air France Marketing Team: Focused on maximizing total bookings while maintaining a target ROA.
• Media Contacts (Agency): Responsible for daily bid adjustments and keyword optimization.
• Google/Yahoo/MSN: Service providers seeking to maximize their own revenue through auction dynamics.
• Consumers: Price-sensitive travelers using search engines to compare international flight options.

Information Gaps

• Customer Lifetime Value (CLV): The case lacks data on repeat booking behavior by channel.
• Attribution Model: It is unclear if revenue is tracked on a first-click or last-click basis.
• Competitor Bidding: No specific data on the bidding intensity of competitors like Lufthansa or British Airways.
• Seasonality: The dataset represents a specific snapshot; year-round variance is not provided.

2. Strategic Analysis

Core Strategic Question

• How should Air France reallocate its search marketing budget across publishers and keyword categories to maximize net revenue without diminishing the high-volume lead flow provided by Google?

Structural Analysis

Applying Marginal ROA Analysis:

• MSN shows the highest efficiency (12.05 ROA) but the lowest scale. This indicates underspending on this platform.
• Yahoo is the least efficient major publisher (7.94 ROA). Current spending levels here are likely past the point of diminishing marginal returns.
• Google serves as the primary volume driver. While its ROA is strong (10.49), its high cost-per-click suggests intense competition for top-tier keywords.
• Keyword Segmentation: Brand keywords (Air France) yield significantly higher ROA than generic terms (flights to Paris), yet generic terms are essential for new customer acquisition.

Strategic Options

Option 1: Efficiency Maximization

• Rationale: Shift 20 percent of the Yahoo budget toward MSN and high-performing long-tail keywords on Google.
• Trade-offs: Increases overall ROA but risks losing market share on Yahoo where competitors may capture displaced traffic.
• Resource Requirements: Minimal; requires agency bid adjustments.

Option 2: Volume Expansion via Metasearch

• Rationale: Double the investment in Kayak. Metasearch users are further down the purchase funnel than generic search users.
• Trade-offs: Kayak has lower total volume capacity compared to search engines; saturation may occur quickly.
• Resource Requirements: Requires integration of real-time pricing feeds to remain competitive on metasearch results.

Preliminary Recommendation

Pursue Option 1. The data indicates a clear misallocation of funds. MSN is under-utilized, and Yahoo is under-performing. Rebalancing toward high-ROA platforms and brand-heavy keywords will improve the bottom line immediately. Long-term growth must then be funded by the savings generated from pruning low-performing Yahoo generic terms.

3. Implementation Planning

Critical Path

• Week 1: Audit all keywords with an ROA below 5.0 across all publishers.
• Week 2: Reallocate 10,000 dollars from Yahoo generic campaigns to MSN brand and destination campaigns.
• Week 4: Implement automated bid management rules to cap CPC on Google keywords where the conversion rate is below 0.5 percent.
• Week 6: Launch a pilot for 50 new long-tail destination keywords (e.g., flights from San Francisco to Nice) on Google and MSN.
• Week 12: Review quarterly performance and adjust the total budget based on the new ROA baseline.

Key Constraints

• Inventory Ceiling: MSN has a lower search volume; there is a physical limit to how much budget it can absorb.
• Agency Latency: The speed at which Media Contacts can execute granular bid changes across thousands of keywords.
• Price Parity: SEM success is tied to actual ticket prices; if Air France fares are not competitive, no amount of bid optimization will fix the conversion rate.

Risk-Adjusted Implementation Strategy

The plan assumes a 15 percent variance in CPC due to competitor reaction. To mitigate this, bid increases will be capped at 10 percent per week. If the conversion rate on MSN drops as spend increases, the reallocation will pause to re-evaluate the keyword match types. Contingency funds are reserved to defend brand keywords on Google if competitors attempt to hijack Air France branded traffic.

4. Executive Review and BLUF

BLUF

Air France must rebalance its 156,000 dollar SEM spend to address significant efficiency gaps between publishers. MSN is currently under-funded despite delivering the highest ROA (12.05), while Yahoo is over-funded for its performance (7.94). By reallocating 15 percent of the Yahoo budget to MSN and high-intent Google long-tail keywords, Air France can increase total revenue by an estimated 120,000 dollars without increasing total spend. The priority is to maximize efficiency on secondary engines before chasing expensive volume on Google.

Dangerous Assumption

The analysis assumes that MSN and Yahoo traffic is incremental and non-overlapping. If users search across multiple engines before booking, cutting Yahoo spend might inadvertently reduce the conversion probability of a later Google search, leading to an overestimation of the savings.

Unaddressed Risks

• Competitor Bidding War: If British Airways or Lufthansa increases bids on Air France brand terms, the cost to defend branded traffic will spike, eroding the projected ROA gains. Probability: High. Consequence: Moderate.
• Attribution Accuracy: Current data likely uses last-click attribution. This undervalues generic keywords that introduce users to the brand but do not result in an immediate booking. Probability: High. Consequence: High (could lead to over-pruning of the top-of-funnel).

Unconsidered Alternative

The team has not considered a direct-to-metasearch strategy that bypasses traditional search engines for destination-specific queries. Shifting the focus from Google Search to deep integration with Kayak and other aggregators could capture high-intent users at a lower aggregate cost per acquisition, as these platforms pre-filter for price and schedule intent.

MECE Categorization of Keywords

VERDICT: APPROVED FOR LEADERSHIP REVIEW