100 Best Claude Excel Data Analysis Prompts for Spas

Direct Answer

The best Claude prompts for Excel data analysis for spas are a curated set of practical, ready-to-use prompts that help you extract revenue, utilization, and customer insights from spa data. Each prompt includes a clear role, task, data context, output format, and constraints to ensure actionable results.

Introduction

This page is a practical prompt library for Excel data analysis in the spa industry. It targets spa owners, managers, and analysts seeking data-driven decisions.

Use these prompts to analyze revenue, bookings, service mix, and operations, and to build dashboards and reports that drive performance.

How to Use These Claude Prompts

• Replace placeholders like [industry], [audience], [product], and [constraints] with your actual data and goals.
• Add constraints such as currency, date ranges, or locations to tailor results.
• Request formats such as tables, CSV-ready data, or bullet-point summaries to fit your workflow.
• Verify outputs against known metrics and adjust prompts for accuracy.
• Save prompts as templates to reuse after data refreshes.

100 Best Claude Excel Data Analysis Prompts for Spas

1. Revenue by spa service: You are a data analyst for a spa chain. Given an Excel dataset with columns: Service, Date, Revenue, Duration, Therapist, Location, and CouponFlag, generate a 12 month trend analysis of Revenue by Service. Output: a concise summary of top performing services, a pivot-ready table showing Service vs Month with total Revenue, and a chart-ready data table. Constraints: exclude voids, include only confirmed bookings, and use currency in USD. Provide at most two actionable recommendations.
2. Average booking value by location: Act as a spa analytics consultant. Using columns Location, BookingID, Revenue, Service, TimeSlot, and Date, compute the average revenue per booking by Location for the last 6 months. Output: a ranked list of locations with averages, plus a compact KPI summary and a brief interpretation. Include CSV-friendly data and recommendation bullets.
3. Service mix analysis: You are an analytics lead. With data columns Service, Category, Revenue, Bookings, and Date, determine the share of revenue and bookings by Service Category for the most recent full quarter. Output: a two-column legend with Category and % share for Revenue and for Bookings, plus 1-page executive summary highlighting any shifts and suggested promotions.
4. Cohort retention by service: Position as a spa data scientist. Given a dataset with CustomerID, FirstVisitDate, LastVisitDate, Service, and Revenue, create a 6-month cohort analysis by First Visit Month. Output: cohort retention rates, revenue per cohort, and a simple interpretation. Include a table of CohortMonth x Month since first visit with retention and revenue metrics.
5. Seasonality and trend: You are an Excel analytics assistant. With dataset containing Date, Revenue, Location, and Service, perform a seasonality decomposition by Location. Output: for each Location, a seasonal index and a trend line summary, plus a compact explanation of how seasonality affects promotions.
6. Promo impact analysis: Act as data analyst. Using fields Date, PromoCode, Revenue, Service, and Location, compare weeks with and without promotions in the last 12 weeks. Output: a difference-in-differences style table showing Revenue lift, bookings lift, and confidence cues. Provide guidance for next promotions.
7. Client retention score: As a spa data consultant, compute a customer retention score from dataset containing CustomerID, VisitCount, Revenue, LastVisit, and ChurnRisk. Output: a scorecard per customer segment and a 1-page matrix showing actions to improve retention for high-risk segments.
8. Staff productivity by location: You are an operations analyst. From data columns Therapist, Location, Service, Revenue, and Bookings, calculate revenue per therapist per location for the last quarter. Output: ranked lists of therapists by productivity, with confidence notes and recommended staffing changes.
9. Upsell opportunity map: Act as a revenue strategist. Given data with CustomerID, Service, Revenue, and AddOn (optional), produce an upsell opportunity map identifying services with highest incremental revenue per booking. Output: list of top 5 upsell opportunities and a brief rationale.
10. No-show rate analysis: You are a spa analyst. Using BookingStatus, Date, Service, Therapist, and Location, compute no-show rate by Location and Service for the past 8 weeks. Output: a table and recommended process improvements to reduce no-shows by 15 percent.
11. Average service duration: Act as process optimizer. From Service, Duration, Date, and Location, compute average service duration by Service and Location for the last 90 days. Output: a table with standard deviation and a brief actionable note on capacity planning.
12. Capacity utilization: You are an operations analyst. Given data with Location, Date, Sessions, and AvailableSlots, calculate capacity utilization by location for the current month. Output: a heatmap-ready data table and 2 strategic recommendations to improve utilization.
13. Pricing sensitivity: As a pricing analyst. Using data columns Service, Price, Revenue, and Bookings, compute price elasticity by Service for the last 12 months. Output: a ranking of services by elasticity and recommended price tiers.
14. Customer lifetime value: Act as a financial analyst. With data: CustomerID, Revenue, Visits, AvgTicket, and ChurnFlag, estimate 12-month lifetime value per customer segment. Output: a segment table with LTV and recommended targeting actions.
15. Patient-like follow-ups: You are a CRM analyst. For customers with a recent service, generate a follow-up sequence plan including message timing, channel, and templates, using fields CustomerID, LastVisit, Service, and Location. Output: a 4-step plan and a CSV-ready template.
16. Booking lag analysis: As a data analyst, compute average booking lead time by Location and Service for the last 6 months. Output: a sortable table and a brief interpretation of how lead times affect demand.
17. Cancellation reasons: You are a spa operations analyst. From Dataset including CancelReason, Date, Service, and Location, produce a summary of cancellation reasons by month and a mitigation plan with 3 concrete actions.
18. Repeat visit propensity: Act as a data scientist. Using CustomerID, VisitCount, LastVisit, and Revenue, compute the propensity to repeat visits and suggest targeted retention actions for high-propensity groups.
19. Gift card sales trend: You are a market analyst. With data: Date, GiftCardValue, Location, and Channel, analyze gift card sales trend and provide 2 action-oriented recommendations for driving gift card growth.
20. Cross-sell matrix: As a data strategist, using data fields CustomerID, Service, RelatedService, Revenue, and Date, create a cross-sell matrix showing which services are commonly purchased together. Output: top 5 pairs and a guidance note.
21. Service profitability: You are a financial analyst. With data: Service, Revenue, Cost, and Bookings, compute gross profit per Service and rank services by profitability for the current quarter. Output: a ranked list with profit margins and optimization notes.
22. Loyalty program impact: Act as analytics lead. Compare customers enrolled in a loyalty program versus non-members using fields CustomerID, Revenue, Visits, and LoyaltyStatus. Output: a profitability delta and 2 program-improvement ideas.
23. Peak hour demand: You are a demand planner. Given Date, TimeSlot, Location, and Bookings, identify peak demand hours and days for the current week. Output: 2 recommended staffing scenarios and a simple forecast.
24. Wait time analysis: As a service operations analyst, use Data: Location, Service, WaitTime, Date, and StaffOnDuty to compute average wait times by service and location and propose queue optimization steps.
25. Resource allocation plan: You are a spa operations strategist. For Date, Location, Therapist, and Service, generate a 4-week resource allocation plan to meet projected demand with minimal idle time. Output: a schedule-ready matrix and rationale.
26. Productivity vs. revenue: Act as business analyst. From Therapist, Location, Revenue, Bookings, and Service, compute revenue per hour worked and identify high-value therapists. Output: ranked list and 2 coaching suggestions.
27. Brand sentiment indicators: You are a data analyst. Given customer survey data with Sentiment, Service, Location, and Date, produce a sentiment index by Location and Service, and a plan to improve negative sentiment.
28. Seasonal promotions calendar: As a marketing analyst, create a 12-week promotions calendar by Location and Service using sales history, with recommended promo types and timing. Output: a calendar table and rationale.
29. Churn risk by service: Act as customer analytics lead. Using fields CustomerID, LastVisit, Service, and ChurnFlag, identify services with highest churn risk and suggest retention interventions for those services.
30. Refunds and refunds impact: You are a compliance data analyst. From RefundFlag, Date, Service, and Revenue, analyze refund rate and impact on profitability, with a corrective action plan.
31. Upsell pipeline: As a sales analytics specialist, generate a pipeline of potential upsell opportunities from CustomerID, Service, Revenue, and Date, prioritizing by expected incremental revenue.
32. Operational cost per service: You are a cost analyst. With data: Service, LaborCost, Materials, Overhead, and Revenue, compute operating cost per service and propose cost-saving measures.
33. Client cohort revenue: Act as data analyst. Create 3-month cohorts by FirstVisitMonth using Revenue data, and output a cohort table with monthly revenue per cohort and retention notes.
34. Booking source analysis: You are an attribution analyst. Using BookingSource, Revenue, and Date, determine which sources drive the most revenue for the last quarter and provide source-level recommendations.
35. Service duration vs. satisfaction: As a data scientist, analyze correlation between Service duration and satisfactionScore using fields Duration, Service, Satisfaction, and Date. Output: a correlation summary and 2 practical implications.
36. Inventory readiness: You are an operations planner. Given commonly used products and stock levels by Location, estimate stockouts risk for the next 30 days and suggest replenishment actions.
37. Group booking insights: Act as event analytics lead. For group bookings, analyze size, location, and revenue, and provide 2 optimization ideas to improve group-booking profitability.
38. Online vs in-person revenue: You are a channel analyst. With data: Channel, Revenue, Date, Location, and Service, compare online versus in-person revenue for the last 6 months and provide a 1-page action plan.
39. No show mitigation plan: As a process improvement analyst, design a no-show mitigation plan using BookingDate, LastReminders, and CustomerID. Output: 4 concrete reminders and a monitoring plan.
40. Regional KPI dashboard: You are a BI analyst. Build an Excel-ready KPI dashboard blueprint for Regions, listing metrics like Revenue, Bookings, AverageTicket, and Retention, with a data table and chart suggestions.
41. Client age segmentation: Act as market analyst. Using AgeGroup, Revenue, and VisitFrequency, segment clients by demographics and propose tailored promotions for each segment.
42. Gift card allocation: You are a retail analytics expert. Given GiftCardRedemption, Location, and Revenue, optimize gift card allocation across locations for maximum ROI this quarter.
43. Service waitlist optimization: As a process engineer, create an algorithm to optimize waitlist flow by Service and TimeSlot, given current bookings and constraints. Output: a rule set and example pseudorun.
44. Customer feedback theme: You are a voice of customer analyst. From FeedbackText, Service, and Location, extract top 3 themes by month and propose 2 improvement actions per theme.
45. Cross-location benchmarking: Act as benchmark analyst. Compare key metrics across locations for last quarter: Revenue, Bookings, AvgTicket. Output: a benchmark table and 3 best-practice ideas.
46. Spa menu profitability: You are a product analyst. Given menu items with Price, Cost, and Demand, calculate profit per menu item and rank to inform menu redesign.
47. Seasonal staff scheduling: As a scheduling analyst, produce a 4-week staff schedule by Location and Service, aligned to forecasted demand, with minimal overtime.
48. Referral program impact: Act as marketing data strategist. Using data: ReferralSource, Revenue, and NewCustomerFlag, measure referral program impact and suggest improvements.
49. Ancillary revenue opportunities: You are a business analyst. From data including PrimaryService, AddOn, Revenue, and BookingID, identify top 5 add-ons driving incremental revenue and recommended bundles.
50. Customer segmentation by village: As a data scientist, segment customers by Location and VisitFrequency to tailor promotions. Output: segment profiles and 2 targeted campaigns.
51. Bookings by reminder type: You are an CRM analytics specialist. Analyze effect of reminderType (email/SMS/none) on bookings in the last 90 days. Output: table by reminder type and recommended outreach mix.
52. Refund risk indicators: Act as risk analyst. From RefundFlag, Date, Service, and Customer tenure, identify indicators that predict refunds and propose preventive actions.
53. Promotion decay analysis: You are a marketing analyst. Compare performance of promotions over time to determine decay rate and suggest duration adjustments.
54. Channel mix optimization: As a data strategist, analyze Revenue by Channel and Location, identify underperforming channels, and propose reallocation actions.
55. Digital footprint impact: You are a data analyst. Relate online engagement metrics to in-store bookings using Date, Channel, and Revenue, and provide 2 actionable insights.
56. Client reactivation campaigns: Act as CRM strategist. For dormant clients, design a reactivation plan with sequence and templates using CustomerID, LastVisit, and Preferences.
57. Service-level forecast: You are a demand forecaster. Using historic bookings by Service and Location, produce a near-term forecast for the next 4 weeks with confidence intervals.
58. Upsell-ready templates: As a copywriter for analytics, create 6 ready-to-send upsell email templates tailored to common services with placeholders for personalization.
59. Warranty and service lifecycle: You are a lifecycle analyst. For spa memberships and warranties, analyze renewal rates and propose lifecycle actions to improve retention.
60. No inventory stalls: Act as supply chain analyst. Identify services most impacted by inventory shortages and propose mitigation strategies to keep service levels high.
61. Target market by service: You are a market strategist. From data Service, Revenue, and Customer demographics, profile ideal target market for each service.
62. Loyalty tier economics: As a loyalty economist, analyze the profitability of each loyalty tier using Revenue, Cost, and RedemptionRate, and recommend tier adjustments.
63. Cancellation pattern: You are a data detective. Analyze cancellation patterns by day of week and service type, and propose calendar-level mitigations.
64. Operational risk heatmap: Act as risk manager. Build a risk heatmap for locations based on incidents, downtime, and customer complaints. Output: top risk areas and mitigation steps.
65. Customer satisfaction drivers: You are a research analyst. Use SatisfactionScore, Service, and Location to identify top drivers of satisfaction and suggest 2 concrete improvements.
66. Promotional ROI calculator: As a finance analyst, create a ROI calculator for promotions using CampaignCost, RevenueUplift, and Weather factor, and output a decision-ready result.
67. Booking age analysis: You are a data analyst. Analyze new customer age at time of first booking and compare with returning customers to tailor onboarding messages.
68. Spa trend report: Act as trend analyst. Compile a quarterly spa trend report across Location, Service, and Revenue with key takeaways and 3 recommended actions.
69. Data quality audit: You are a data governance lead. Audit essential fields (Date, Service, Revenue, Location) for completeness and consistency, and provide a remediation plan.
70. Churn driver analysis: As a data scientist, identify top drivers of churn by analyzing LastVisit, Service, and Revenue, and propose 3 retention interventions.
71. Real-time KPI alerts: You are a dashboard engineer. Define 4 real-time KPI alerts (thresholds) for Revenue, Bookings, and Utilization with actionable responses.
72. Seasonal headroom: Act as capacity planner. For peak months, calculate headroom in staff and rooms and propose overtime thresholds and shift changes.
73. A/B test readiness: You are a experiments analyst. Outline an A/B test plan for comparing two service variants using Revenue, Satisfaction, and BookingRate, including sample size and success metrics.
74. Demographics by service: As a market analytics lead, segment customers by age, gender, and location for each service and propose tailored messaging.
75. Data sandbox setup: You are a data engineer. Provide a blueprint for a spa analytics data sandbox with sample schemas, sample records, and data quality checks.
76. Forecast accuracy review: Act as forecasting reviewer. Compare forecast vs actual for last quarter by Location and Service and suggest 2 model improvements.
77. Revenue leakage audit: You are a finance auditor. Audit for revenue leakage by matching bookings to revenue recognition and flag discrepancies with remediation actions.
78. Event-driven promotions: As a marketing strategist, design 2 event-driven promotions aligned to local events, using location, service, and revenue data for targeting.
79. Customer data enrichment: You are a data enrichment specialist. Propose a plan to augment customer records with preferences and lifecycle attributes, while respecting privacy rules.
80. Data storytelling one-pager: Act as analytics storyteller. Create a one-page data story outline for a spa executive, including 3 visuals and executive takeaways.
81. Compliance data checks: You are a compliance analyst. Verify data fields for regulatory compliance, log issues, and propose corrective actions to ensure compliance.
82. Service sunset analysis: As a product analyst, assess which services to sunset based on declining revenue and low adoption, with 2 alternatives.
83. Referral cascade effect: You are a growth analyst. Model how referrals affect new bookings over time and provide 2 amplification strategies.
84. Seasonality guardrails: Act as business planner. Define guardrails for seasonal promotions including budget caps and performance metrics.
85. Customer sentiment by service: You are a sentiment analyst. Map customer sentiment scores by service and propose service-level improvements based on the findings.
86. Data dictionary draft: As a data steward, draft a concise data dictionary for key spa analytics fields with definitions, data types, and permissible values.
87. Pricing banding strategy: You are a pricing strategist. Propose a tiered pricing bands by service with target occupancy and price thresholds.
88. Operational dashboards: Act as BI consultant. Outline an Excel-ready operations dashboard with 6 widgets: revenue, bookings, utilization, satisfaction, churn, and inventory.
89. Booking channel cleanup: You are a data hygiene specialist. Identify duplicate or inconsistent bookings across channels and propose clean-up steps.
90. Service growth plan: As a growth analyst, map a 90-day plan to grow revenue per service using data-driven experiments and milestones.
91. Data-driven onboarding: You are an onboarding analyst. Create an onboarding checklist for new spa data users with data sources, access, and starter prompts.
92. Customer heatmap by zip: Act as geographic analyst. Generate a heatmap of customers by ZIP code for the latest quarter and propose expansion targets.
93. Refund recovery actions: You are a customer recovery specialist. For refunded bookings, outline 3 recovery actions to win back dissatisfied customers.
94. Product bundle profitability: As a product strategist, analyze bundles of services with addons and compute incremental profit margins to guide bundling decisions.
95. Data refresh calendar: You are a data operations manager. Create a refresh calendar for spa analytics datasets with frequency, responsible, and validation checks.
96. Forecast error analysis: Act as forecast accuracy auditor. Break down forecast errors by location and service and propose model improvements.
97. Operational SOP prompts: You are an operations assistant. Generate 6 SOP prompts for common spa tasks with data-driven performance checks.
98. Customer journey map: As a journey analyst, map typical customer paths across touchpoints using booking data and service history, and identify drop-off points.
99. Data privacy checklist: You are a privacy lead. Provide a 10-item data privacy checklist for spa analytics, including minimization, access control, and anonymization steps.
100. Executive summary templates: Act as a communications specialist. Create 5 concise executive-summary templates for spa analytics results with placeholders for metrics and insights.

Best Practices

• Test prompts on a subset of data first to validate results.
• Combine prompts to build end-to-end analyses and dashboards.
• Document assumptions and data definitions alongside each result.
• Keep prompts versioned to track changes in data or goals.
• Use consistent units and date formats to avoid misinterpretation.

Common Mistakes to Avoid

• Asking for outputs without defining date ranges or locations.
• Using vague objectives like optimize revenue without specifying how or what to optimize.
• Ignoring data quality issues that skew results.
• Overloading prompts with too many tasks leading to noisy outputs.
• Not validating outputs with domain knowledge before acting.

FAQ

What is the best way to use these prompts with Excel data for spas?

Run prompts against clean, well-structured spa data in Excel or CSV, verify outputs, and adapt the prompts to your dataset and goals.

Do these prompts require advanced Excel skills?

Most prompts expect basic to intermediate Excel knowledge plus familiarity with pivot tables, filters, and simple formulas.

Can I customize prompts for multiple locations or services?

Yes. Use placeholders like [Location] and [Service] to tailor prompts to your spa network and service mix.

How often should I refresh data for prompts to stay relevant?

Refresh data monthly or after each major promotion cycle to keep insights timely and actionable.

Are these prompts suitable for dashboards and reports?

Yes. Many prompts produce table-ready data and summaries suitable for dashboards and executive reports.

What should I do if results seem incorrect or inconsistent?

Check data quality, verify date formats, ensure currency consistency, and adjust filters to align with your scope.