100 Best Claude KPI and Dashboard Prompts for Travel Agencies
These Claude prompts help with KPI and dashboard for travel agencies using practical instructions, clear constraints, and reusable output formats.
Best For
Travel agency managers, data analysts, and business owners who need actionable KPI dashboards and automated reporting
Prompt Use Cases
- KPI reporting for travel agencies
- Dashboard generation
- Automated analytics briefing
- Performance dashboards for sales and operations
- Channel profitability analysis
- Customer lifetime value and retention tracking
- Pricing and revenue optimization for travel agencies
- Supplier performance dashboards
- Marketing campaign ROI tracking
- Operational dashboards for booking workflows
Direct Answer
The best Claude prompts for KPI and dashboard for travel agencies are designed to deliver precise, actionable analytics and dashboard-ready outputs. They cover channels, occupancy, revenue, attribution, and operational metrics, enabling fast insights and data-driven decisions. Use them as templates to standardize reporting and automate reiterations.
Introduction
This page compiles 100 Claude KPI and dashboard prompts specifically for travel agencies. It is a practical prompt library intended for analysts, managers, and operators who need repeatable, actionable analytics.
Each prompt is crafted to be copyable and immediately usable, with placeholders that you can replace to fit your agency, destinations, and time periods.
How to Use These Claude Prompts
- Replace the placeholders like [timePeriod], [destination], and [timePeriod] with your actual data window before running the prompt.
- Add constraints or formats to suit your reporting cadence, such as monthly, quarterly, or weekly dashboards.
- Request specific formats like tables, JSON, or CSV, and specify whether you want trends, comparisons, or drill-downs.
- Verify outputs by cross-checking with source systems and reconciling any outliers or anomalies.
- Use the prompts as building blocks in a macro that generates a consistent KPI pack for leadership reviews.
100 Best Claude KPI and Dashboard Prompts for Travel Agencies
- Bookings by channel: You are a Travel Analytics Lead. Task: generate a KPI dashboard overview for the selected travel agency. Context: data comes from online bookings, call center, and walk-ins for the period [timePeriod]. Output format: provide a concise table with Channel, Bookings, Conversion Rate, Revenue, and Share of Channel. Constraints: include year-over-year comparison, highlight top channel, ensure numbers are rounded to two decimals.
- Occupancy and nights sold: Act as an airline and travel partner analytics specialist. Task: compute occupancy rate and nights sold by date range for a given destination [destination], using data from the PMS and CRS. Output format: a daily trend chart data ready to plot, with fields: date, occupancyRate, nights Sold. Constraints: normalize for seasonality, flag anomalies.
- Average booking value: You are a KPI analyst for a travel agency. Task: determine average booking value for [timePeriod] across all channels, with segmentation by packaged tours and standalone bookings. Output format: JSON with totalBookings, totalValue, averageValue, bySegment. Constraints: exclude cancellations, show confidence interval if data noisy.
- Cancellation impact: Act as a dashboard designer. Task: quantify the impact of cancellations on monthly revenue for [timePeriod]. Output: a dashboard-ready summary with metrics: cancellations, cancel rate, revenue impact, recovery actions. Constraints: provide a waterfall breakdown and sensitivity range.
- Customer acquisition cost: You are a marketing analytics reviewer. Task: compute CAC for the period [timePeriod] across paid search, social, and affiliates. Output: a stacked bar data structure: channel, spend, newCustomers, CAC. Constraints: normalize for multi-touch attribution using last-click default, show alternative MA attribution in a note.
- Retention rate trends: Act as a retention analytics specialist. Task: compute 12-month rolling retention rate for customers acquired in [month] and cohort analysis by first destination. Output: cohort heatmap data with month, retentionRate. Constraints: include confidence bounds when data sparse.
- Net promoter score: You are a customer experience analyst. Task: calculate NPS for the period [timePeriod] across regions and compare to last period. Output: NPS, promoters, detractors, passives by region. Constraints: annotate drivers from free-text feedback using a simple sentiment map.
- Top products by revenue: Act as a product analytics lead. Task: list top selling products (packages, tours, add-ons) by revenue for [timePeriod]. Output: ranked list with productName, revenue, units, averagePrice. Constraints: filter out canceled bookings, show margin where available.
- Channel profitability: You are a profitability analyst. Task: generate a channel profitability report by partner and OTA for [timePeriod]. Output: table with channel, grossProfit, costs, netProfit, margin%. Constraints: include partner-level notes for optimization.
- Price sensitivity: You are a revenue optimization specialist. Task: compute price elasticity for select tours in [destination] for [timePeriod]. Output: elasticity values, recommended price adjustments, scenario table. Constraints: provide a usage caution note for price changes during holidays.
- Forecast accuracy: Act as a forecasting analyst. Task: compare forecast vs actual bookings for [timePeriod] by destination. Output: table with forecast, actual, bias, MAPE, forecast error range. Constraints: indicate model version and data quality caveats.
- Lead conversion funnel: You are a funnel analytics expert. Task: map from lead to completed booking for [timePeriod], show conversion rates at each stage. Output: funnel steps with counts and conversion rate. Constraints: highlight bottlenecks and recommended optimizations.
- Seasonality impact: You are a seasonal analytics specialist. Task: quantify seasonality effects on bookings for [season] across destinations. Output: seasonality index by month, recommended push periods. Constraints: normalize across year intervals.
- Supplier performance: Act as a supplier analytics lead. Task: assess supplier performance by on-time delivery, price competitiveness, and defect rate for [timePeriod]. Output: ranked supplier list with KPIs. Constraints: flag reliability issues and suggested renegotiation targets.
- Tour package profitability: You are a profitability analyst. Task: compute profitability per tour package for [timePeriod], including fixed and variable costs. Output: per-package P&L with margin and break-even units. Constraints: include sensitivity to occupancy.
- Marketing ROI by channel: You are a marketing analytics analyst. Task: calculate ROI for each marketing channel in [timePeriod] across campaigns for [destination]. Output: table with channel, spend, revenue attributable, ROI, attribution note. Constraints: include view-through attribution if available.
- Revenue per available booking: Act as a revenue management analyst. Task: compute revenue per available booking (RPAB) for [timePeriod] by destination. Output: RPAB by destination with trend and target. Constraints: compare to last period and set target uplift.
- Cross-sell uplift: You are a cross-sell analytics lead. Task: identify most effective add-ons for existing bookings in [timePeriod]. Output: list of add-ons with incremental revenue and lift percentage. Constraints: stratify by customer segment.
- Booking window analysis: You are a demand planning analyst. Task: analyze average booking window for [timePeriod] by destination. Output: averageDaysBetweenBooking, distribution, recommended promotions. Constraints: avoid overfitting promotions.
- Inventory aging: Act as an inventory analytics expert. Task: monitor aging inventory for travel products in [timePeriod]. Output: aging buckets with units, value, and recommended promo actions. Constraints: alert when aging exceeds threshold.
- Cancellation reasons: You are a customer insight analyst. Task: categorize cancellation reasons for [timePeriod] and quantify impact on revenue. Output: reasons with counts and revenue impact. Constraints: propose mitigations.
- Regional performance: You are a regional analytics lead. Task: compare performance across regions in [timePeriod] for bookings, revenue, and satisfaction. Output: region table with KPIs and trend arrows. Constraints: standardize currency.
- Agent performance: Act as an agency performance coach. Task: rank travel agents by conversion rate and revenue per booking for [timePeriod]. Output: leaderboard with agentName, conversions, revenue, averageBooking. Constraints: flag anomalies.
- Seat inventory dashboard: You are a dashboard designer. Task: create a seat inventory dashboard for flights offered via agency partners for [timePeriod]. Output: seatsAvailable, seatsBooked, utilization by flight. Constraints: forecast next week demand.
- Content impact: You are a content analytics specialist. Task: assess impact of content pages on booking funnel for [timePeriod]. Output: contentName, visits, bookings, conversionRate, recommended content actions. Constraints: attribute value to content type.
- Travel advisor coaching: Act as a performance coach for advisors. Task: generate KPI targets for new advisors in [timePeriod], with ramp metrics. Output: target table by advisor tier and cohort. Constraints: include rampTime.
- Loyalty program value: You are a loyalty analytics expert. Task: measure incremental revenue from loyalty program members in [timePeriod]. Output: members, incrementalRevenue, redemptionRate, ROI. Constraints: compare to non-members.
- Group booking trends: You are a group sales analyst. Task: analyze group bookings by groupSize in [timePeriod]. Output: grouped table with count, revenue, averageBooking, cancellationRate. Constraints: identify most profitable group sizes.
- Destination demand heatmap: Act as a demand visualization specialist. Task: generate heatmap-ready data showing demand by destination for [timePeriod]. Output: destination, demandIndex, bookings, revenue. Constraints: normalize by population.
- Operational SLA dashboard: You are an operations KPI analyst. Task: build SLA metrics for travel operations (booking to ticketing) in [timePeriod]. Output: SLA reach, average handling time, backlog, by team. Constraints: flag SLA breaches.
- Fraud risk indicators: You are a risk analytics expert. Task: surface fraud risk indicators in bookings for [timePeriod]. Output: riskScore by booking, top risk patterns, recommended controls. Constraints: anonymize data.
- Refund timing: Act as a refund analyst. Task: track refunds by reason and timing in [timePeriod]. Output: refundsCount, refundsValue, averageRefundDelay. Constraints: identify refund optimization opportunities.
- Channel mix optimization: You are a mix optimization analyst. Task: optimize channel mix to maximize revenue for [timePeriod]. Output: recommended channel allocations with projected revenue. Constraints: include scenario ranges.
- Pricing guardrails: You are a pricing strategist. Task: define guardrails for price changes in [timePeriod] across destinations. Output: rule list with thresholds, approval workflow, and impact notes. Constraints: align with brand policy.
- Supplier margin analysis: Act as a supplier margin analyst. Task: calculate net margin by supplier for [timePeriod]. Output: supplier, revenue, cost, margin%. Constraints: highlight high-cost outliers.
- New vs returning: You are a customer analytics expert. Task: split bookings between new and returning customers for [timePeriod]. Output: newBookings, returningBookings, revenue by group. Constraints: show repeat rate trend.
- Tour operator comparison: You are a competitive analytics lead. Task: compare top tour operators on price, value, and availability for [timePeriod]. Output: operator ranking with KPIs. Constraints: provide edge cases.
- Upsell opportunity map: Act as an upsell strategist. Task: map high-probability upsell opportunities for existing itineraries in [timePeriod]. Output: opportunityName, expectedLift, recommendedTactics. Constraints: tier opportunities by customer value.
- Meal plan revenue: You are a product revenue analyst. Task: track revenue from optional meal plans by destination in [timePeriod]. Output: mealsSold, revenue, averagePrice. Constraints: tie to occupancy.
- Payment method mix: You are a payments analytics lead. Task: analyze payment method mix for bookings in [timePeriod]. Output: method, share, averageOrderValue, failedPayments. Constraints: recommend alternative methods.
- Origin city trends: Act as an origin analytics specialist. Task: analyze origin city trends for bookings in [timePeriod]. Output: originCity, bookings, revenue, forecast.
- Sales funnel drift: You are a funnel integrity analyst. Task: detect drift in booking funnel between [periodA] and [periodB]. Output: drift metrics, riskReasons, remediation steps. Constraints: data alignment notes.
- Travel advisor utilization: You are a workforce analytics lead. Task: measure advisor utilization rate in [timePeriod]. Output: advisor, hoursBooked, capacity, utilization%. Constraints: target utilization range.
- Seasonal promo impact: Act as a promotions analyst. Task: evaluate impact of seasonal promotions in [timePeriod] on bookings and revenue. Output: promoName, uplift%, revenueImpact. Constraints: attribute to seasonality.
- Booking cancellations by reason: You are a cancellations analyst. Task: break down cancellations by reason for [timePeriod] and quantify revenue impact. Output: reason, count, valueImpact. Constraints: correlate with external events.
- Dynamic alert rules: You are a dashboard engineer. Task: create dynamic alert rules for KPIs in [timePeriod] (e.g., bookings, revenue, cancellations). Output: alertName, condition, action, recipients. Constraints: thresholds must be defensible.
- Travel insurance uptake: Act as a product analytics specialist. Task: measure uptake of travel insurance by booking type in [timePeriod]. Output: insuranceSold, revenueFromInsurance, uplift. Constraints: cross-sell correlation.
- Airport transfer utilization: You are a logistic analytics lead. Task: track airport transfer bookings and utilization by destination in [timePeriod]. Output: transfersBooked, utilizationRate, waitTime. Constraints: flag delays.
- Environmental impact metrics: You are a sustainability analytics specialist. Task: quantify environmental impact of bookings in [timePeriod]. Output: carbonTonnes, offsetCost, perBookingImpact. Constraints: show reductions.
- VIP client segment: Act as a VIP analytics consultant. Task: analyze revenue and loyalty metrics for VIP clients in [timePeriod]. Output: VIPCount, revenue, averageBooking, retention. Constraints: compare to general population.
- Weekday vs weekend: You are a demand analyst. Task: compare bookings and revenue for weekdays versus weekends in [timePeriod]. Output: weekdayStats, weekendStats, delta. Constraints: normalize for seasonality.
- Mobile vs desktop: You are a channel analytics expert. Task: split bookings by device type for [timePeriod]. Output: device, bookings, revenue, conversionRate. Constraints: mobile optimization recommendations.
- Review sentiment analysis: Act as a customer insights analyst. Task: summarize sentiment of reviews for [destination] in [timePeriod]. Output: sentimentScore, top keywords, actionItems. Constraints: quantify impact on bookings.
- Refund policy compliance: You are a policy compliance analyst. Task: check refunds against policy in [timePeriod]. Output: compliantRefunds, policyViolations, valueImpact. Constraints: provide remediation plan.
- Booking source quality: You are a source quality analyst. Task: evaluate lead quality by source for [timePeriod]. Output: sourceName, leads, bookings, conversionRate, costPerBooking. Constraints: flag low-quality sources.
- Cross-border taxes: Act as a compliance and pricing analyst. Task: calculate tax impact on bookings for [timePeriod] by destination. Output: taxesCollected, netRevenue, averageTaxRate. Constraints: align with regulations.
- Payment failure reasons: You are a payments engineer. Task: categorize payment failures in [timePeriod] by reason. Output: reason, count, impact, suggested fix. Constraints: minimize customer friction.
- Upsell by destination: You are a destination-focused upsell strategist. Task: propose destination-specific upsell offers for [timePeriod]. Output: offerName, liftEstimate, targetSegment. Constraints: align with inventory.
- Time-to-ticketing: Act as an ops analyst. Task: measure time from booking to ticketing for [timePeriod]. Output: medianDays, percentWithinTarget, outliers. Constraints: automate alerts.
- Group satış overview: You are a group sales analytics expert. Task: summarize group bookings by group type (corporate, leisure) in [timePeriod]. Output: type, bookings, revenue, averageBooking, cancellationRate. Constraints: separate corporate.
- Revenue leakage scan: You are a revenue integrity analyst. Task: identify revenue leakage points in the booking lifecycle for [timePeriod]. Output: leakageStage, amount, recommendedAction. Constraints: prioritize by impact.
- Booking abandon rate: Act as a user journey analyst. Task: compute cart abandonment rate for travel bookings in [timePeriod]. Output: abandonRate, funnelGap, recommendedMitigations. Constraints: test at least two fixes.
- Season pass profitability: You are a pass product analyst. Task: evaluate profitability of seasonal passes for tours in [timePeriod]. Output: passName, revenue, costs, margin. Constraints: compare to full-price bookings.
- Customer lifetime value: You are a CLV analyst. Task: estimate CLV for different customer cohorts in [timePeriod]. Output: cohort, CLV, discountRate, expectedRetention. Constraints: provide confidence intervals.
- Ad hoc analytics request: Act as a data analyst on demand. Task: fulfill an ad hoc KPI request for [timePeriod], destination, and channel. Output: requestedMetrics with definitions and sources. Constraints: document assumptions.
- Lifecycle email impact: You are an email marketing analyst. Task: measure lifecycle email campaign impact on bookings in [timePeriod]. Output: emailName, opens, clicks, bookings, revenue. Constraints: attribute to final action.
- AXR dashboard: You are a traveler experience analyst. Task: develop an AXR (After-Experience Rating) dashboard for [timePeriod]. Output: ratingCounts, averages, trends by destination. Constraints: correlate with bookings.
- Cost per booking: Act as a cost accounting analyst. Task: calculate total cost per booking for [timePeriod] including overhead. Output: costPerBooking, breakdown by category. Constraints: allocate shared costs fairly.
- Conversion by touchpoint: You are a multi-touch attribution analyst. Task: attribute final bookings to first and last touchpoints in [timePeriod]. Output: touchpoint, attributionShare, cumulativeImpact. Constraints: document method.
- Geo segmentation: You are a geographic analyst. Task: segment bookings by country and city in [timePeriod]. Output: region, bookings, revenue, avgBooking. Constraints: show top growth markets.
- Payment modernization plan: Act as a payment strategy advisor. Task: propose a modernization plan for payment flows in [timePeriod]. Output: milestones, cost, expected benefits. Constraints: minimize PCI scope.
- Churn risk indicators: You are a churn analytics expert. Task: identify customers at risk of churn in [timePeriod]. Output: riskScore, drivers, recommended retention actions. Constraints: personalize actions.
- Budget vs actual: You are a financial control analyst. Task: compare marketing and operations budget vs actual for [timePeriod]. Output: varianceTable, explanations, corrective actions. Constraints: highlight overruns.
- Top destinations ranked: Act as a destination analytics lead. Task: rank destinations by revenue and customer satisfaction for [timePeriod]. Output: destination, revenue, satisfaction, rank. Constraints: tie-breakers explained.
- Activity heatmap: You are a dashboard designer. Task: create an activity heatmap for bookings by hour and day in [timePeriod]. Output: heatValue, peakHours, recommended staffing. Constraints: scale for big data.
- Service level metrics: You are a service operations analyst. Task: track SLA metrics for agent response times and call wait times in [timePeriod]. Output: SLA%, medianWait, escalations. Constraints: set targets.
- Inventory parity: Act as an inventory control analyst. Task: assess parity of inventory across channels for [timePeriod]. Output: channelParityScore, outOfParityItems, actions. Constraints: adjust pricing to balance.
- Green KPI suite: You are a sustainability KPI analyst. Task: assemble a green KPI dashboard for travel products in [timePeriod]. Output: carbonPerBooking, offsetCost, sustainableOfferShare. Constraints: compare to baseline.
- Agent coaching metrics: You are a coaching program analyst. Task: define KPIs for coaching new agents in [timePeriod]. Output: KPIName, target, dataSource, reviewFrequency. Constraints: link to outcomes.
- Market demand forecast: Act as a market forecast analyst. Task: forecast demand for [destination] in [timePeriod] using macro indicators. Output: forecastBookings, confidence, riskFactors. Constraints: state model used.
- Pricing experiments: You are a experiments analytics lead. Task: analyze A/B tests for price prompts in [timePeriod]. Output: testName, effectSize, pValue, recommendedAction. Constraints: ensure statistical validity.
- Referral program impact: You are a referral analytics specialist. Task: measure impact of referrals on bookings in [timePeriod]. Output: referrals, conversions, revenue, costPerReferral. Constraints: attribute long-term value.
- New product ideas: Act as a product discovery analyst. Task: generate KPI-backed ideas for new travel products in [timePeriod]. Output: idea, expectedMetricImpact, feasibility. Constraints: prioritize high impact.
- Customer segmentation: You are a segmentation analyst. Task: segment customers by travel style and spend in [timePeriod]. Output: segmentName, size, averageBooking, lifetimeValue. Constraints: actionable segments.
- Flight offer dashboard: You are a flight analytics lead. Task: track flight offer performance by route in [timePeriod]. Output: route, impressions, clicks, bookings, revenue. Constraints: optimize offer mix.
- Cruise product performance: Act as a cruise analytics specialist. Task: compare cruise product performance with land itineraries in [timePeriod]. Output: productType, revenue, bookings, margin. Constraints: normalize for seasonality.
- Hotel partner performance: You are a hotel analytics manager. Task: evaluate partner hotels by occupancy rate and guest satisfaction in [timePeriod]. Output: partnerName, occupancy, satisfaction, revenue. Constraints: suggest renegotiation points.
- Price elasticity map: You are a pricing modeler. Task: build an elasticity map for destinations in [timePeriod]. Output: elasticity by destination, recommended price bands, forecast impact. Constraints: beware overfitting.
- Data quality score: Act as a data quality lead. Task: compute a data quality score for the KPI data in [timePeriod]. Output: score by dimension, data gaps, remediation plan. Constraints: require weekly checks.
- Automation readiness: You are a workflow automation analyst. Task: assess readiness to automate KPI reporting for [timePeriod]. Output: automationScore, required integrations, ROI estimate. Constraints: phased rollout plan.
- Benchmark against peers: Act as an industry benchmarking analyst. Task: compare KPI benchmarks for travel agencies in [region] for [timePeriod]. Output: metricName, agency, value, percentile. Constraints: source credibility notes.
- Forecast variance drilldown: You are a variance analysis expert. Task: explain drivers of forecast errors for [timePeriod] by destination and channel. Output: driver, impact, corrective actions. Constraints: quantify uncertainty.
- SLA breach alerts: You are a dashboard engineer. Task: implement breach alerts for SLA KPIs in [timePeriod]. Output: alertName, threshold, recipients, remediation steps. Constraints: escalation paths.
- Inventory turnover: Act as an inventory analytics lead. Task: calculate turnover rate for inventory items in [timePeriod]. Output: item, turnoverRate, daysToSell, recommended actions. Constraints: tie to revenue impact.
- Cash flow snapshot: You are a financial analytics analyst. Task: generate a cash flow snapshot for travel operations in [timePeriod]. Output: cashIn, cashOut, netFlow, forecast. Constraints: liquidity risk notes.
- Data storytelling pack: You are a data storyteller. Task: craft a concise KPI narrative for KPI and dashboard for travel agencies in [timePeriod]. Output: executiveSummary, keyVisuals, actionItems. Constraints: avoid jargon.
- Touchpoint richness: Act as a journey analytics expert. Task: measure richness of data captured at each customer touchpoint in [timePeriod]. Output: touchpoint, dataCompleteness, confidence. Constraints: propose data collection improvements.
- Weather impact on demand: You are a demand analytics specialist. Task: analyze weather events' impact on bookings for [destination] in [timePeriod]. Output: event, bookingsDelta, revenueDelta, confidence. Constraints: control for holidays.
- Multi-destination profitability: You are a profitability strategist. Task: compare profitability across multiple destinations in [timePeriod]. Output: destination, revenue, costs, margin, rank. Constraints: show cross-dest comparisons.
- Dashboard sanity checks: Act as a dashboard quality engineer. Task: provide a checklist of sanity checks for KPI dashboards in [timePeriod]. Output: checkName, testSteps, expectedResult. Constraints: include data source validation.
Markdown Template
100 Best Claude KPI and Dashboard Prompts for Travel Agencies
# 100 Best Claude KPI and Dashboard Prompts for Travel Agencies
**Bookings by channel**: You are a Travel Analytics Lead. Task: generate a KPI dashboard overview for the selected travel agency. Context: data comes from online bookings, call center, and walk-ins for the period [timePeriod]. Output format: provide a concise table with Channel, Bookings, Conversion Rate, Revenue, and Share of Channel. Constraints: include year-over-year comparison, highlight top channel, ensure numbers are rounded to two decimals.
**Occupancy and nights sold**: Act as an airline and travel partner analytics specialist. Task: compute occupancy rate and nights sold by date range for a given destination [destination], using data from the PMS and CRS. Output format: a daily trend chart data ready to plot, with fields: date, occupancyRate, nights Sold. Constraints: normalize for seasonality, flag anomalies.
**Average booking value**: You are a KPI analyst for a travel agency. Task: determine average booking value for [timePeriod] across all channels, with segmentation by packaged tours and standalone bookings. Output format: JSON with totalBookings, totalValue, averageValue, bySegment. Constraints: exclude cancellations, show confidence interval if data noisy.
**Cancellation impact**: Act as a dashboard designer. Task: quantify the impact of cancellations on monthly revenue for [timePeriod]. Output: a dashboard-ready summary with metrics: cancellations, cancel rate, revenue impact, recovery actions. Constraints: provide a waterfall breakdown and sensitivity range.
**Customer acquisition cost**: You are a marketing analytics reviewer. Task: compute CAC for the period [timePeriod] across paid search, social, and affiliates. Output: a stacked bar data structure: channel, spend, newCustomers, CAC. Constraints: normalize for multi-touch attribution using last-click default, show alternative MA attribution in a note.
**Retention rate trends**: Act as a retention analytics specialist. Task: compute 12-month rolling retention rate for customers acquired in [month] and cohort analysis by first destination. Output: cohort heatmap data with month, retentionRate. Constraints: include confidence bounds when data sparse.
**Net promoter score**: You are a customer experience analyst. Task: calculate NPS for the period [timePeriod] across regions and compare to last period. Output: NPS, promoters, detractors, passives by region. Constraints: annotate drivers from free-text feedback using a simple sentiment map.
**Top products by revenue**: Act as a product analytics lead. Task: list top selling products (packages, tours, add-ons) by revenue for [timePeriod]. Output: ranked list with productName, revenue, units, averagePrice. Constraints: filter out canceled bookings, show margin where available.
**Channel profitability**: You are a profitability analyst. Task: generate a channel profitability report by partner and OTA for [timePeriod]. Output: table with channel, grossProfit, costs, netProfit, margin%. Constraints: include partner-level notes for optimization.
**Price sensitivity**: You are a revenue optimization specialist. Task: compute price elasticity for select tours in [destination] for [timePeriod]. Output: elasticity values, recommended price adjustments, scenario table. Constraints: provide a usage caution note for price changes during holidays.
**Forecast accuracy**: Act as a forecasting analyst. Task: compare forecast vs actual bookings for [timePeriod] by destination. Output: table with forecast, actual, bias, MAPE, forecast error range. Constraints: indicate model version and data quality caveats.
**Lead conversion funnel**: You are a funnel analytics expert. Task: map from lead to completed booking for [timePeriod], show conversion rates at each stage. Output: funnel steps with counts and conversion rate. Constraints: highlight bottlenecks and recommended optimizations.
**Seasonality impact**: You are a seasonal analytics specialist. Task: quantify seasonality effects on bookings for [season] across destinations. Output: seasonality index by month, recommended push periods. Constraints: normalize across year intervals.
**Supplier performance**: Act as a supplier analytics lead. Task: assess supplier performance by on-time delivery, price competitiveness, and defect rate for [timePeriod]. Output: ranked supplier list with KPIs. Constraints: flag reliability issues and suggested renegotiation targets.
**Tour package profitability**: You are a profitability analyst. Task: compute profitability per tour package for [timePeriod], including fixed and variable costs. Output: per-package P&L with margin and break-even units. Constraints: include sensitivity to occupancy.
**Marketing ROI by channel**: You are a marketing analytics analyst. Task: calculate ROI for each marketing channel in [timePeriod] across campaigns for [destination]. Output: table with channel, spend, revenue attributable, ROI, attribution note. Constraints: include view-through attribution if available.
**Revenue per available booking**: Act as a revenue management analyst. Task: compute revenue per available booking (RPAB) for [timePeriod] by destination. Output: RPAB by destination with trend and target. Constraints: compare to last period and set target uplift.
**Cross-sell uplift**: You are a cross-sell analytics lead. Task: identify most effective add-ons for existing bookings in [timePeriod]. Output: list of add-ons with incremental revenue and lift percentage. Constraints: stratify by customer segment.
**Booking window analysis**: You are a demand planning analyst. Task: analyze average booking window for [timePeriod] by destination. Output: averageDaysBetweenBooking, distribution, recommended promotions. Constraints: avoid overfitting promotions.
**Inventory aging**: Act as an inventory analytics expert. Task: monitor aging inventory for travel products in [timePeriod]. Output: aging buckets with units, value, and recommended promo actions. Constraints: alert when aging exceeds threshold.
**Cancellation reasons**: You are a customer insight analyst. Task: categorize cancellation reasons for [timePeriod] and quantify impact on revenue. Output: reasons with counts and revenue impact. Constraints: propose mitigations.
**Regional performance**: You are a regional analytics lead. Task: compare performance across regions in [timePeriod] for bookings, revenue, and satisfaction. Output: region table with KPIs and trend arrows. Constraints: standardize currency.
**Agent performance**: Act as an agency performance coach. Task: rank travel agents by conversion rate and revenue per booking for [timePeriod]. Output: leaderboard with agentName, conversions, revenue, averageBooking. Constraints: flag anomalies.
**Seat inventory dashboard**: You are a dashboard designer. Task: create a seat inventory dashboard for flights offered via agency partners for [timePeriod]. Output: seatsAvailable, seatsBooked, utilization by flight. Constraints: forecast next week demand.
**Content impact**: You are a content analytics specialist. Task: assess impact of content pages on booking funnel for [timePeriod]. Output: contentName, visits, bookings, conversionRate, recommended content actions. Constraints: attribute value to content type.
**Travel advisor coaching**: Act as a performance coach for advisors. Task: generate KPI targets for new advisors in [timePeriod], with ramp metrics. Output: target table by advisor tier and cohort. Constraints: include rampTime.
**Loyalty program value**: You are a loyalty analytics expert. Task: measure incremental revenue from loyalty program members in [timePeriod]. Output: members, incrementalRevenue, redemptionRate, ROI. Constraints: compare to non-members.
**Group booking trends**: You are a group sales analyst. Task: analyze group bookings by groupSize in [timePeriod]. Output: grouped table with count, revenue, averageBooking, cancellationRate. Constraints: identify most profitable group sizes.
**Destination demand heatmap**: Act as a demand visualization specialist. Task: generate heatmap-ready data showing demand by destination for [timePeriod]. Output: destination, demandIndex, bookings, revenue. Constraints: normalize by population.
**Operational SLA dashboard**: You are an operations KPI analyst. Task: build SLA metrics for travel operations (booking to ticketing) in [timePeriod]. Output: SLA reach, average handling time, backlog, by team. Constraints: flag SLA breaches.
**Fraud risk indicators**: You are a risk analytics expert. Task: surface fraud risk indicators in bookings for [timePeriod]. Output: riskScore by booking, top risk patterns, recommended controls. Constraints: anonymize data.
**Refund timing**: Act as a refund analyst. Task: track refunds by reason and timing in [timePeriod]. Output: refundsCount, refundsValue, averageRefundDelay. Constraints: identify refund optimization opportunities.
**Channel mix optimization**: You are a mix optimization analyst. Task: optimize channel mix to maximize revenue for [timePeriod]. Output: recommended channel allocations with projected revenue. Constraints: include scenario ranges.
**Pricing guardrails**: You are a pricing strategist. Task: define guardrails for price changes in [timePeriod] across destinations. Output: rule list with thresholds, approval workflow, and impact notes. Constraints: align with brand policy.
**Supplier margin analysis**: Act as a supplier margin analyst. Task: calculate net margin by supplier for [timePeriod]. Output: supplier, revenue, cost, margin%. Constraints: highlight high-cost outliers.
**New vs returning**: You are a customer analytics expert. Task: split bookings between new and returning customers for [timePeriod]. Output: newBookings, returningBookings, revenue by group. Constraints: show repeat rate trend.
**Tour operator comparison**: You are a competitive analytics lead. Task: compare top tour operators on price, value, and availability for [timePeriod]. Output: operator ranking with KPIs. Constraints: provide edge cases.
**Upsell opportunity map**: Act as an upsell strategist. Task: map high-probability upsell opportunities for existing itineraries in [timePeriod]. Output: opportunityName, expectedLift, recommendedTactics. Constraints: tier opportunities by customer value.
**Meal plan revenue**: You are a product revenue analyst. Task: track revenue from optional meal plans by destination in [timePeriod]. Output: mealsSold, revenue, averagePrice. Constraints: tie to occupancy.
**Payment method mix**: You are a payments analytics lead. Task: analyze payment method mix for bookings in [timePeriod]. Output: method, share, averageOrderValue, failedPayments. Constraints: recommend alternative methods.
**Origin city trends**: Act as an origin analytics specialist. Task: analyze origin city trends for bookings in [timePeriod]. Output: originCity, bookings, revenue, forecast.
**Sales funnel drift**: You are a funnel integrity analyst. Task: detect drift in booking funnel between [periodA] and [periodB]. Output: drift metrics, riskReasons, remediation steps. Constraints: data alignment notes.
**Travel advisor utilization**: You are a workforce analytics lead. Task: measure advisor utilization rate in [timePeriod]. Output: advisor, hoursBooked, capacity, utilization%. Constraints: target utilization range.
**Seasonal promo impact**: Act as a promotions analyst. Task: evaluate impact of seasonal promotions in [timePeriod] on bookings and revenue. Output: promoName, uplift%, revenueImpact. Constraints: attribute to seasonality.
**Booking cancellations by reason**: You are a cancellations analyst. Task: break down cancellations by reason for [timePeriod] and quantify revenue impact. Output: reason, count, valueImpact. Constraints: correlate with external events.
**Dynamic alert rules**: You are a dashboard engineer. Task: create dynamic alert rules for KPIs in [timePeriod] (e.g., bookings, revenue, cancellations). Output: alertName, condition, action, recipients. Constraints: thresholds must be defensible.
**Travel insurance uptake**: Act as a product analytics specialist. Task: measure uptake of travel insurance by booking type in [timePeriod]. Output: insuranceSold, revenueFromInsurance, uplift. Constraints: cross-sell correlation.
**Airport transfer utilization**: You are a logistic analytics lead. Task: track airport transfer bookings and utilization by destination in [timePeriod]. Output: transfersBooked, utilizationRate, waitTime. Constraints: flag delays.
**Environmental impact metrics**: You are a sustainability analytics specialist. Task: quantify environmental impact of bookings in [timePeriod]. Output: carbonTonnes, offsetCost, perBookingImpact. Constraints: show reductions.
**VIP client segment**: Act as a VIP analytics consultant. Task: analyze revenue and loyalty metrics for VIP clients in [timePeriod]. Output: VIPCount, revenue, averageBooking, retention. Constraints: compare to general population.
**Weekday vs weekend**: You are a demand analyst. Task: compare bookings and revenue for weekdays versus weekends in [timePeriod]. Output: weekdayStats, weekendStats, delta. Constraints: normalize for seasonality.
**Mobile vs desktop**: You are a channel analytics expert. Task: split bookings by device type for [timePeriod]. Output: device, bookings, revenue, conversionRate. Constraints: mobile optimization recommendations.
**Review sentiment analysis**: Act as a customer insights analyst. Task: summarize sentiment of reviews for [destination] in [timePeriod]. Output: sentimentScore, top keywords, actionItems. Constraints: quantify impact on bookings.
**Refund policy compliance**: You are a policy compliance analyst. Task: check refunds against policy in [timePeriod]. Output: compliantRefunds, policyViolations, valueImpact. Constraints: provide remediation plan.
**Booking source quality**: You are a source quality analyst. Task: evaluate lead quality by source for [timePeriod]. Output: sourceName, leads, bookings, conversionRate, costPerBooking. Constraints: flag low-quality sources.
**Cross-border taxes**: Act as a compliance and pricing analyst. Task: calculate tax impact on bookings for [timePeriod] by destination. Output: taxesCollected, netRevenue, averageTaxRate. Constraints: align with regulations.
**Payment failure reasons**: You are a payments engineer. Task: categorize payment failures in [timePeriod] by reason. Output: reason, count, impact, suggested fix. Constraints: minimize customer friction.
**Upsell by destination**: You are a destination-focused upsell strategist. Task: propose destination-specific upsell offers for [timePeriod]. Output: offerName, liftEstimate, targetSegment. Constraints: align with inventory.
**Time-to-ticketing**: Act as an ops analyst. Task: measure time from booking to ticketing for [timePeriod]. Output: medianDays, percentWithinTarget, outliers. Constraints: automate alerts.
**Group satış overview**: You are a group sales analytics expert. Task: summarize group bookings by group type (corporate, leisure) in [timePeriod]. Output: type, bookings, revenue, averageBooking, cancellationRate. Constraints: separate corporate.
**Revenue leakage scan**: You are a revenue integrity analyst. Task: identify revenue leakage points in the booking lifecycle for [timePeriod]. Output: leakageStage, amount, recommendedAction. Constraints: prioritize by impact.
**Booking abandon rate**: Act as a user journey analyst. Task: compute cart abandonment rate for travel bookings in [timePeriod]. Output: abandonRate, funnelGap, recommendedMitigations. Constraints: test at least two fixes.
**Season pass profitability**: You are a pass product analyst. Task: evaluate profitability of seasonal passes for tours in [timePeriod]. Output: passName, revenue, costs, margin. Constraints: compare to full-price bookings.
**Customer lifetime value**: You are a CLV analyst. Task: estimate CLV for different customer cohorts in [timePeriod]. Output: cohort, CLV, discountRate, expectedRetention. Constraints: provide confidence intervals.
**Ad hoc analytics request**: Act as a data analyst on demand. Task: fulfill an ad hoc KPI request for [timePeriod], destination, and channel. Output: requestedMetrics with definitions and sources. Constraints: document assumptions.
**Lifecycle email impact**: You are an email marketing analyst. Task: measure lifecycle email campaign impact on bookings in [timePeriod]. Output: emailName, opens, clicks, bookings, revenue. Constraints: attribute to final action.
**AXR dashboard**: You are a traveler experience analyst. Task: develop an AXR (After-Experience Rating) dashboard for [timePeriod]. Output: ratingCounts, averages, trends by destination. Constraints: correlate with bookings.
**Cost per booking**: Act as a cost accounting analyst. Task: calculate total cost per booking for [timePeriod] including overhead. Output: costPerBooking, breakdown by category. Constraints: allocate shared costs fairly.
**Conversion by touchpoint**: You are a multi-touch attribution analyst. Task: attribute final bookings to first and last touchpoints in [timePeriod]. Output: touchpoint, attributionShare, cumulativeImpact. Constraints: document method.
**Geo segmentation**: You are a geographic analyst. Task: segment bookings by country and city in [timePeriod]. Output: region, bookings, revenue, avgBooking. Constraints: show top growth markets.
**Payment modernization plan**: Act as a payment strategy advisor. Task: propose a modernization plan for payment flows in [timePeriod]. Output: milestones, cost, expected benefits. Constraints: minimize PCI scope.
**Churn risk indicators**: You are a churn analytics expert. Task: identify customers at risk of churn in [timePeriod]. Output: riskScore, drivers, recommended retention actions. Constraints: personalize actions.
**Budget vs actual**: You are a financial control analyst. Task: compare marketing and operations budget vs actual for [timePeriod]. Output: varianceTable, explanations, corrective actions. Constraints: highlight overruns.
**Top destinations ranked**: Act as a destination analytics lead. Task: rank destinations by revenue and customer satisfaction for [timePeriod]. Output: destination, revenue, satisfaction, rank. Constraints: tie-breakers explained.
**Activity heatmap**: You are a dashboard designer. Task: create an activity heatmap for bookings by hour and day in [timePeriod]. Output: heatValue, peakHours, recommended staffing. Constraints: scale for big data.
**Service level metrics**: You are a service operations analyst. Task: track SLA metrics for agent response times and call wait times in [timePeriod]. Output: SLA%, medianWait, escalations. Constraints: set targets.
**Inventory parity**: Act as an inventory control analyst. Task: assess parity of inventory across channels for [timePeriod]. Output: channelParityScore, outOfParityItems, actions. Constraints: adjust pricing to balance.
**Green KPI suite**: You are a sustainability KPI analyst. Task: assemble a green KPI dashboard for travel products in [timePeriod]. Output: carbonPerBooking, offsetCost, sustainableOfferShare. Constraints: compare to baseline.
**Agent coaching metrics**: You are a coaching program analyst. Task: define KPIs for coaching new agents in [timePeriod]. Output: KPIName, target, dataSource, reviewFrequency. Constraints: link to outcomes.
**Market demand forecast**: Act as a market forecast analyst. Task: forecast demand for [destination] in [timePeriod] using macro indicators. Output: forecastBookings, confidence, riskFactors. Constraints: state model used.
**Pricing experiments**: You are a experiments analytics lead. Task: analyze A/B tests for price prompts in [timePeriod]. Output: testName, effectSize, pValue, recommendedAction. Constraints: ensure statistical validity.
**Referral program impact**: You are a referral analytics specialist. Task: measure impact of referrals on bookings in [timePeriod]. Output: referrals, conversions, revenue, costPerReferral. Constraints: attribute long-term value.
**New product ideas**: Act as a product discovery analyst. Task: generate KPI-backed ideas for new travel products in [timePeriod]. Output: idea, expectedMetricImpact, feasibility. Constraints: prioritize high impact.
**Customer segmentation**: You are a segmentation analyst. Task: segment customers by travel style and spend in [timePeriod]. Output: segmentName, size, averageBooking, lifetimeValue. Constraints: actionable segments.
**Flight offer dashboard**: You are a flight analytics lead. Task: track flight offer performance by route in [timePeriod]. Output: route, impressions, clicks, bookings, revenue. Constraints: optimize offer mix.
**Cruise product performance**: Act as a cruise analytics specialist. Task: compare cruise product performance with land itineraries in [timePeriod]. Output: productType, revenue, bookings, margin. Constraints: normalize for seasonality.
**Hotel partner performance**: You are a hotel analytics manager. Task: evaluate partner hotels by occupancy rate and guest satisfaction in [timePeriod]. Output: partnerName, occupancy, satisfaction, revenue. Constraints: suggest renegotiation points.
**Price elasticity map**: You are a pricing modeler. Task: build an elasticity map for destinations in [timePeriod]. Output: elasticity by destination, recommended price bands, forecast impact. Constraints: beware overfitting.
**Data quality score**: Act as a data quality lead. Task: compute a data quality score for the KPI data in [timePeriod]. Output: score by dimension, data gaps, remediation plan. Constraints: require weekly checks.
**Automation readiness**: You are a workflow automation analyst. Task: assess readiness to automate KPI reporting for [timePeriod]. Output: automationScore, required integrations, ROI estimate. Constraints: phased rollout plan.
**Benchmark against peers**: Act as an industry benchmarking analyst. Task: compare KPI benchmarks for travel agencies in [region] for [timePeriod]. Output: metricName, agency, value, percentile. Constraints: source credibility notes.
**Forecast variance drilldown**: You are a variance analysis expert. Task: explain drivers of forecast errors for [timePeriod] by destination and channel. Output: driver, impact, corrective actions. Constraints: quantify uncertainty.
**SLA breach alerts**: You are a dashboard engineer. Task: implement breach alerts for SLA KPIs in [timePeriod]. Output: alertName, threshold, recipients, remediation steps. Constraints: escalation paths.
**Inventory turnover**: Act as an inventory analytics lead. Task: calculate turnover rate for inventory items in [timePeriod]. Output: item, turnoverRate, daysToSell, recommended actions. Constraints: tie to revenue impact.
**Cash flow snapshot**: You are a financial analytics analyst. Task: generate a cash flow snapshot for travel operations in [timePeriod]. Output: cashIn, cashOut, netFlow, forecast. Constraints: liquidity risk notes.
**Data storytelling pack**: You are a data storyteller. Task: craft a concise KPI narrative for KPI and dashboard for travel agencies in [timePeriod]. Output: executiveSummary, keyVisuals, actionItems. Constraints: avoid jargon.
**Touchpoint richness**: Act as a journey analytics expert. Task: measure richness of data captured at each customer touchpoint in [timePeriod]. Output: touchpoint, dataCompleteness, confidence. Constraints: propose data collection improvements.
**Weather impact on demand**: You are a demand analytics specialist. Task: analyze weather events' impact on bookings for [destination] in [timePeriod]. Output: event, bookingsDelta, revenueDelta, confidence. Constraints: control for holidays.
**Multi-destination profitability**: You are a profitability strategist. Task: compare profitability across multiple destinations in [timePeriod]. Output: destination, revenue, costs, margin, rank. Constraints: show cross-dest comparisons.
**Dashboard sanity checks**: Act as a dashboard quality engineer. Task: provide a checklist of sanity checks for KPI dashboards in [timePeriod]. Output: checkName, testSteps, expectedResult. Constraints: include data source validation.Best Practices
- Keep prompts specific to your destinations and channels to improve accuracy.
- Reuse prompts by tagging them with your top goals (revenue, retention, efficiency) for quick filtering.
- Limit scope when validating outputs; start with a narrow time period before expanding to full year.
- Always include a note about data quality and attribution assumptions in outputs.
- Sanity-check results with your data team before sharing with executives.
Common Mistakes to Avoid
- Using generic prompts that lack context about travel industry KPIs.
- Omitting time period or destination details, causing meaningless results.
- Ignoring data quality and attribution methods, leading to unreliable outputs.
- Overloading prompts with too many metrics, making outputs hard to act on.
- Not validating results against source systems, increasing risk of decisions based on incorrect data.
FAQ
What is the purpose of KPI dashboards for travel agencies?
KPI dashboards translate complex data into clear performance signals, helping travel agencies optimize bookings, revenue, and customer satisfaction.
How do I tailor prompts to my destinations?
Replace placeholders like [destination], [timePeriod], and [channel] with real values and specify any region-specific rules or currencies.
Can I automate these prompts for daily reporting?
Yes. Create a workflow that runs the prompts, pulls data, and returns dashboards or CSV/JSON files on a daily or weekly schedule.
What should I do if data is incomplete or noisy?
Include data quality notes in outputs, apply simple smoothing or smoothing over cohorts, and flag uncertainties for leadership review.
How can I verify Claude outputs?
Cross-check results with source systems, compare against last period, and validate calculations with a data analyst.
What formats work best for leadership briefings?
Provide a concise executive summary plus a tabular KPI pack and a few visuals or charts suitable for slides.