Practice a five-slide travel booking clickstream analysis case. The solution covers funnel insights, mobile drop-off, price mismatch, choice overload, a Best Confident Match product proposal, business and user metrics, A/B testing, risks, attribution gaps, partner data quality, and an additional price alert idea.
##### Question
Kayak has shared an anonymized dataset of user interactions on its booking website. In 5 presentation slides:
Extract and summarize the key user insights and pain points.
Propose one data-backed product or feature solution that addresses those insights.
List the 3–5 most important metrics you would track to measure success.
Identify major risks or pitfalls in your approach and how you would mitigate them.
Suggest at least one additional enhancement idea that goes beyond the original prompt.
##### Hints
Use a clear analytical framework (e.g., funnel, cohort, A/B results).
Prioritize metrics that reflect business impact as well as user value.
Quick Answer: Practice a five-slide travel booking clickstream analysis case. The solution covers funnel insights, mobile drop-off, price mismatch, choice overload, a Best Confident Match product proposal, business and user metrics, A/B testing, risks, attribution gaps, partner data quality, and an additional price alert idea.
mediumProduct ManagerOnsiteProduct / Decision Making
4
0
Product Case: Booking Website Interaction Analysis in Five Slides
You have access to an anonymized clickstream dataset from a travel booking website covering the funnel from session to search, results, filters and sorts, item detail, partner click-out or checkout, and booking where post-click conversion is available. Data includes device type, traffic source, timestamps, and basic revenue signals such as CPC, CPA, or gross booking value where available.
Deliver a five-slide product analysis:
Extract and summarize key user insights and pain points from the dataset.
Propose one data-backed product or feature that addresses those insights.
List the three to five most important metrics to track success, covering business impact and user value.
Identify major risks or pitfalls and how to mitigate them.
Suggest at least one additional enhancement idea that goes beyond the original prompt.
Constraints & Assumptions
Use a clear analytical framework such as funnel, cohort, segmentation, or A/B results.
Prioritize metrics that reflect both business impact and user value.
If exact data is not provided, use illustrative numbers and label them as examples.
Keep the deliverable slide-oriented and executive-readable.
Clarifying Questions to Ask Guidance
Are we analyzing flights, hotels, rental cars, packages, or all verticals?
Is booking completed on-site or through partner click-out?
Which revenue model matters most: CPC, CPA, commission, or gross booking value?
What time period and geographies are included?
Do we have user identifiers for repeat search behavior?
Part 1 - Insights and Pain Points
Describe the dataset framework and key findings.
What This Part Should Cover Guidance
Funnel analysis from session to booking.
Segment cuts by device, traffic source, route/market, user type, and time.
Pain points such as mobile drop-off, price mismatch, choice overload, repeated searches, slow results, or low trust.
Quantified examples.
Part 2 - Product Proposal and Metrics
Propose one data-backed product or feature and success metrics.
What This Part Should Cover Guidance
User problem and hypothesis.
Feature concept and MVP.
Metrics such as search-to-click-out, click-out-to-booking, conversion, revenue per session, user satisfaction, and repeat search reduction.
Experiment design.
Part 3 - Risks and Additional Ideas
Identify risks and an additional enhancement.
What This Part Should Cover Guidance
Risks such as attribution gaps, partner data quality, selection bias, revenue-user trade-off, mobile performance, and privacy.
Mitigations.
Additional idea beyond the main proposal with rationale.
What a Strong Answer Covers Guidance
A strong answer turns clickstream data into a focused product recommendation. It shows a slide-ready narrative, quantified funnel insight, a product bet, success metrics, risks, and a second idea for future exploration.
Follow-up Questions Guidance
Which funnel step is most important and why?
How would you handle missing booking data after click-out?
What if the proposed feature improves bookings but hurts CPC revenue?