100 Best Claude Excel Data Analysis Prompts for Hair Salons

Direct Answer

The best Claude prompts for Excel data analysis for hair salons are a curated set of practical, copyable tasks that turn raw salon data into actionable insights. These prompts cover revenue, service mix, retention, inventory, marketing impact, and staffing, all tailored to hair salon data in Excel. Use them to drive decisions, track performance, and optimize profitability.

Introduction

This page is a prompt library focused on Excel data analysis for hair salons. It provides 100 Claude prompts you can copy and adapt to your salon data to improve revenue, efficiency, and client experience.

Whether you manage a single salon or a growing chain, these prompts help you turn daily data into clear, actionable plans without writing complex code.

How to Use These Claude Prompts

• Replace placeholders like [industry], [audience], and [format] with your specifics. Add constraints such as time ranges, currency units, or allowed output formats. Request outputs as structured tables, bullet lists, or concise summaries. When in doubt, ask for a brief interpretation first, then a detailed appendix. Always verify outputs against raw data and maintain data hygiene.

100 Best Claude Excel Data Analysis Prompts for Hair Salons

1. Revenue by service type: You are a data analyst for a hair salon. Analyze the Excel dataset with columns: Service, Price, Quantity, Date, Stylist, and Revenue. Task: summarize total revenue by Service and by Month, identify top 3 services by revenue, and provide a 4 line executive summary with trends and recommendations. Output: a short table and a bullet list in plain text.
2. Revenue by stylist: You are a data analyst for a hair salon. Given data columns: Stylist, Service, Revenue, Date, and AppointmentCount, compute total revenue per stylist for the last quarter, rank stylists, and provide a 5 line interpretation including potential capacity constraints and staffing suggestions. Output: ranked list and insights.
3. Average ticket size per visit: In an Excel dataset with columns: VisitID, Date, CustomerID, Service, Price, and Tax, calculate average ticket size per visit for the current month, show variance by weekday, and provide 3 actionable price or bundling ideas to raise average ticket by 8 percent. Output: summary and bullet ideas.
4. Service mix trend: Using columns Service, Date, Revenue, and CustomerID, analyze monthly service mix over the last year, identify the top 5 services by revenue, and suggest 2 promotions to promote underperforming services. Output: trend chart description and recommendations.
5. Promotion impact analysis: For dataset with columns PromotionCode, Service, Revenue, Date, and CustomerID, assess the impact of a given promotion on revenue and new customers over the last 8 weeks; compare with baseline weeks. Output: two comparison tables and a 4 sentence interpretation.
6. Loyalty program effect: Analyze loyalty program data with columns LoyaltyTier, VisitDate, Revenue, and IsNewCustomer. Determine if loyalty tier correlates with higher spend, and propose adjustments to tier thresholds to maximize revenue. Output: correlation result and recommendations.
7. Customer retention window: Given CustomerID with VisitDate, identify the average interarrival time between visits for retained customers in the last 12 months, and suggest interval targets to improve retention by 10 percent. Output: numeric results and 2 tactics.
8. Churn risk indicators: Using dataset columns CustomerID, LastVisitDate, TotalSpend, VisitsLast6Months, and EmailOptIn, classify customers into risk categories for churn and propose targeted re-engagement messages. Output: risk categories and message ideas.
9. Inventory usage forecast: For inventory data with Item, QuantityUsed, DateUsed, and ItemCost, forecast next 6 weeks usage by item using simple moving average, and propose reorder quantities to maintain service availability. Output: forecast table and reorder suggestions.
10. Product contribution margin: Compute contribution margin by product line (items used in services) using dataset with Item, Cost, Price, and Usage. Identify top-margin items and suggest promos to push lower-margin lines to break even. Output: margin table and actions.
11. Seasonality adjustment: Analyze monthly revenue with a seasonality component and provide a 12-month forecast with seasonal multipliers for hair salon services. Include a recommended pricing or packaging adjustment per season. Output: forecast and rationale.
12. Client lifetime value: Model client lifetime value using data fields CustomerID, TotalSpend, VisitCount, AverageTicket, and RetentionYears. Produce 3 life-time value segments and suggest targeted marketing for each segment. Output: segment table and strategies.
13. Discount uplift test: Given data on discounts applied and resulting revenue, perform a simple A/B test to evaluate whether discounts increase average ticket and repeat visits, with clear statistical interpretation and 2 recommended discount rules. Output: results and recommendations.
14. Pricing elasticity: Analyze price changes and quantity sold for a service over the last 12 months to estimate price elasticity of demand. Provide 2 pricing scenarios to optimize revenue and a risk checklist. Output: elasticity estimates and scenarios.
15. Booking lead time: From bookings dataset with BookingDate, VisitDate, Service, and Revenue, compute average lead time and correlate with no-show rate. Propose 2 scheduling policies to reduce no-shows. Output: metrics and policy ideas.
16. No-show analysis: Analyze no-show rate by service, day of week, and stylist. Propose a 3-point plan to reduce no-shows by at least 15 percent, including confirmation reminders and overbooking guardrails. Output: findings and plan.
17. Service profitability map: Create a profitability map by service and stylist, using CostOfService, Price, and Quantity. Visualize hot spots and propose two service-stylist pairings to increase profitability. Output: profitability map description and suggestions.
18. Coupon vs. loyalty: Compare the impact of coupons versus loyalty points on revenue and retention for the last quarter. Provide 2 recommended mixes for each channel to maximize long-term value. Output: comparative findings and actions.
19. Gift card impact: Evaluate gift card sales and redemption rates, correlate with new customer acquisition and revenue. Suggest marketing actions to boost gift card uptake by 20 percent. Output: analysis and actions.
20. Client segmentation: Cluster customers into 4 segments based on recency, frequency, and monetary value from the salon dataset. Describe each segment and tailor 2 outreach ideas per segment. Output: segment descriptions and ideas.
21. Appointment utilization: Compute utilization rate of appointment slots by day and stylist, identify underutilized times, and propose 2 staffing or scheduling changes to improve utilization by ten percent. Output: utilization metrics and changes.
22. Waste and overstock: Identify inventory waste and overstock risks from unused products, calculate wastage rate, and present 3 actions to reduce waste by at least 25 percent. Output: findings and actions.
23. Staff productivity: Measure revenue per hour by stylist, account for downtime, and propose 2 efficiency improvements to raise productivity by 8 percent. Output: metrics and recommendations.
24. Cancellation reasons: Analyze cancellation codes and times to identify root causes for appointment cancellations and propose 3 mitigations, including policy tweaks and reminders. Output: insights and actions.
25. Cross-sell opportunities: Using service and product data, identify cross-sell opportunities that increase average ticket by at least 5 percent. Provide 4 concrete prompts for staff to suggest add-ons. Output: opportunities and prompts.
26. Gross margin by service: Calculate gross margin per service and identify high-margin and low-margin services, with 2 improvement ideas for low-margin services. Output: margin table and actions.
27. Client return intervals: Determine optimal follow-up intervals after a service to maximize rebooking probability; propose a 3-step follow-up schedule and messaging. Output: schedule and messages.
28. Channel attribution: If data includes marketing channel and revenue, attribute revenue by channel for the last quarter and identify the top performing channel, with 2 optimization ideas. Output: attribution table and ideas.
29. Seasonal staffing plan: Create a 6-week staffing plan aligned to seasonal demand, using past revenue by week and appointment counts. Provide 2 contingency scenarios. Output: plan and contingencies.
30. Zero-based budget: Create a 4-week zero-based budget for salon operations based on historical revenue, with line-items for labor, products, and marketing. Include a 10 percent contingency. Output: budget table and notes.
31. Client churn drivers: Identify top drivers of client churn from the dataset (e.g., price, wait time, service quality) and propose 3 retention experiments to run next month. Output: drivers and experiments.
32. Digital booking optimization: Assess online booking data to identify frictions in the booking flow; propose 3 changes to increase online bookings by 12 percent and reduce drop-offs. Output: actionable changes.
33. Service pricing tiers: Create 3 pricing tiers for core services and simulate expected revenue impact based on current demand; provide tier descriptions and eligibility criteria. Output: tiered pricing model and forecast.
34. New customer boost: Analyze first-time customers to determine 2 fastest paths to convert them to repeat clients, with 2 messaging templates each. Output: pathways and templates.
35. Return on marketing: Calculate ROAS for the last two marketing campaigns and propose a budget reallocation strategy to improve overall ROI by 15 percent. Output: ROAS results and recommendations.
36. Aesthetic trends impact: Review service revenue alongside quarterly trend indicators and external aesthetic trends; propose 2 trend-aligned services to pilot. Output: trend alignment and pilot plan.
37. Wait time optimization: Analyze appointment start times and actual wait times; propose 3 scheduling adjustments to reduce average wait by 5 minutes and improve customer satisfaction. Output: adjustments and rationale.
38. Upsell script prompts: Create 4 role-based upsell scripts for front desk staff, tailored to service types and typical client profiles, to increase add-ons by 7 percent. Output: scripts and prompts.
39. Service duration accuracy: Compare scheduled service duration vs actual duration by stylist; identify overruns and propose 2 plan changes to improve scheduling accuracy by 10 percent. Output: variance table and actions.
40. Payment method analysis: Analyze revenue by payment method and identify any biases or fees; propose 2 alternatives to minimize processing costs while maintaining user experience. Output: method analysis and actions.
41. Refund and reversal tracking: Track refunds and reversals by reason; propose 3 controls to reduce refund rate by at least 30 percent. Output: insights and controls.
42. Digital gift upsell: If gift cards are tracked, propose 2 digital gift strategies that increase uptake among new clients and boost revenue by 8 percent. Output: strategies and metrics.
43. Service bundle profitability: Create bundles that combine two or more services; calculate bundle profitability and recommend 2 bundles to test for 6 weeks. Output: bundle proposals and profitability.
44. Client age analysis: Analyze client age distribution and tailor age-targeted promotions; propose 2 offers per age group and the expected impact. Output: age segments and offers.
45. Group booking planning: Plan group bookings (weddings, events) by forecasting demand, pricing and staff allocation; provide a 4-week rollout plan. Output: plan and schedule.
46. Retap pricing prompts: Model retap pricing for popular services based on elasticity estimates and competitor benchmarks; provide 2 price points and expected outcomes. Output: pricing prompts and expectations.
47. Facility utilization: Assess room/tool utilization in the salon; propose 2 changes to improve space efficiency and reduce idle time by 12 percent. Output: utilization suggestions.
48. Client feedback synthesis: Aggregate client feedback by service and stylist; turn insights into 3 actionable service improvements and a 1-page summary. Output: insights and actions.
49. Zero waste goals: Set 3 waste reduction targets for products and implement a tracking prompt to monitor progress monthly. Output: targets and tracking prompts.
50. New service viability: Assess viability of a proposed new service using cost, price sensitivity, and capacity; provide a go/no-go decision with a 2-page brief. Output: viability decision and rationale.
51. Market comparison: Benchmark salon performance against a regional peer group on key metrics; identify 2 competitive advantages and 2 risks. Output: benchmarks and actions.
52. Customer journey map: Create a simple customer journey map from first contact to post-visit; identify 2 friction points and 2 improvements. Output: journey map description and improvements.
53. Lead magnet effectiveness: Evaluate lead magnet campaigns (free consults, samples) by conversion rate and revenue; recommend 2 new magnets. Output: effectiveness and recommendations.
54. Productivity by hour: Breakdown revenue by hour of day and day of week; propose 2 staffing plans to increase peak-hour revenue by 10 percent. Output: hourly revenue and plans.
55. Client waitlist management: Model a waitlist system to fill gaps in real time; propose a 2-step automation to reduce idle time and improve client experience. Output: waitlist model and steps.
56. Recurring revenue plan: Design a 6-month recurring service package with predictable revenue; specify pricing, inclusions, and marketing milestones. Output: package design and milestones.
57. Upsell by service: For each core service, list 2 high-value add-ons and create a one-page staff prompt to present them during checkout. Output: add-ons and prompts.
58. Client acquisition cost: Calculate CAC for new clients over last 6 months and propose 2 lower-cost channels to reduce CAC by 20 percent. Output: CAC and channels.
59. Data hygiene check: Identify common data quality issues in the salon dataset and provide 5 validation prompts to keep data clean going forward. Output: issues and prompts.
60. Seasonal bundles: Create seasonal service bundles with clear pricing and expected demand; simulate revenue impact for the next 4 quarters. Output: bundle designs and forecast.
61. Service duration planning: Forecast required duration per service based on historic averages; adjust staff allocations to meet demand with a 95 percent service-level target. Output: plan and targets.
62. No-show predictive model: Using historical data, build a simple rule-based predictor for no-shows by service and day; suggest proactive reminders for high-risk slots. Output: predictor rules and reminders.
63. Gift card propensity: Identify customers with high likelihood to buy gift cards and craft 2 campaigns to promote gifting during holidays. Output: audience and campaigns.
64. Client satisfaction score: Compute satisfaction proxies from survey or feedback; map to service types and suggest improvements to raise average score by 0.5 points. Output: score map and actions.
65. Referral program plan: Evaluate referral data and design a two-tier referral program to boost new client acquisitions by 15 percent within 3 months. Output: program design and targets.
66. Seasonal price testing: Plan a price test for a service across two price points for 8 weeks; specify test groups, metrics, and stop criteria. Output: test design and decision rules.
67. Stockout risk alerts: Create a threshold-based alert system for stockouts; outline 3 alert levels and the actions to take at each level. Output: alert specs and actions.
68. Rebooking rate booster: Propose a 4-step rebooking workflow to convert post-service touchpoints into booked future visits; include templates. Output: workflow and templates.
69. Marketing campaign forecast: Forecast revenue impact of a proposed marketing campaign using historical CPC/CTR and conversion rates; provide a 1-page forecast and risk notes. Output: forecast and notes.
70. Service introduction rollout: Plan a phased roll-out for a new service across 3 weeks; specify staff training, marketing, and soft launch checks. Output: rollout plan.
71. Client data privacy: Audit data handling for client data; propose 3 privacy controls to ensure compliance and trust. Output: controls and rationale.
72. Season pass model: Design a salon season pass with included services, price, and limits; forecast retention and revenue impact over 6 months. Output: pass design and forecast.
73. Pricing psychology: Apply pricing psychology concepts to core services; propose 2 psychologically informed price points and rationales. Output: price points and reasoning.
74. Client win-back: Create a 6-week win-back campaign for lapsed clients, including messaging and offer structure. Output: campaign plan and copy prompts.
75. Service mix optimization: Analyze service mix to identify underrepresented high-margin services and propose 2 pilot promotions to balance workload. Output: recommendations.
76. Staff skill gaps: Survey or infer skill gaps from service outcomes; propose 2 training programs to raise service quality and efficiency. Output: gaps and programs.
77. Pricing tier testing: Test two pricing tiers for a flagship service across customer segments; provide rollout plan and success metrics. Output: test design and metrics.
78. Promotional calendar: Create a 3-month promotional calendar aligned with revenue targets and events; specify promotions and success metrics. Output: calendar and metrics.
79. Client outreach templates: Provide 4 outreach email/SMS templates tailored by client segment to increase rebooking and referrals. Output: templates.
80. Productivity benchmarks: Set 3 realistic productivity benchmarks by role; compare to current performance and propose 2 improvement actions. Output: benchmarks and actions.
81. Service waitlist prompts: Create prompts for staff to manage waitlists and offer alternatives to customers during peak times. Output: prompts and guidelines.
82. Customer demographics: Profile core customer demographics from the dataset and propose 2 targeted marketing messages for each segment. Output: demographics and messages.
83. Client onboarding flow: Map a streamlined onboarding flow for new clients, including data capture, preferences, and first-visit offerings. Output: flow description.
84. Density forecast: Forecast appointment density per hour by day and corner-case scenarios for holidays; propose adjustments to staffing. Output: density forecast and actions.
85. Promotions profitability: Evaluate profitability of each promotion type by comparing incremental revenue to cost; suggest 2 profitable promo formats. Output: profitability analysis.
86. Inventory replenishment: Create a replenishment rule: reorder items when stock falls below a threshold; include safety stock and lead times. Output: rule and example.
87. Customer feedback loop: Design a closed-loop feedback process from post-visit to QA; outline 4 steps and responsible roles. Output: loop design.
88. Digital channel mix: Analyze digital channels (email, social, ads) by cost and revenue; propose 2 shifts to improve overall profitability. Output: channel mix and actions.
89. Client referral score: Build a simple client referral scoring rubric using past referral data; identify top referrers and reward plans. Output: rubric and plan.
90. Gender and age trends: Examine gender and age distributions in visits; propose inclusive offers across demographics and test 2 messaging variants. Output: trend analysis and offers.
91. Service downtime plan: Outline a 2-week downtime recovery plan if a key service is temporarily unavailable, including customer communication and scheduling adjustments. Output: plan and messages.
92. Gift card redemption timing: Analyze timing of gift card redemptions relative to purchase date; propose 2 timing-based promotions to boost redemption. Output: timing insights and promotions.
93. Cashflow forecast: Create a monthly cashflow forecast for the next 6 months based on revenue, expenses, and seasonality; include a burn rate check. Output: forecast and notes.
94. Audit trail prompts: Design prompts to maintain an audit trail of changes to key metrics and data exports for accountability. Output: prompts and checklist.
95. Forecast accuracy check: Set up a quarterly forecast accuracy check; compare forecast vs actual and propose 2 calibration steps. Output: accuracy report and actions.
96. Client reactivation: Identify lapsed clients and craft 2 reactivation campaigns tailored to service preferences and past visits. Output: campaigns and copy ideas.
97. Loyalty tier optimization: Review current loyalty tiers and propose 2 adjustments to tier benefits to drive long-term value. Output: tier plan and rationale.
98. Data-driven culture: Provide 3 prompts to foster a data-driven culture in the salon, including weekly dashboards and decision prompts for staff. Output: prompts and usage tips.
99. KPI dashboard prompts: Design 4 KPI prompts to populate a weekly executive dashboard: revenue, visits, average ticket, and cleanup metrics. Output: dashboard prompts.
100. Closing the loop prompts: Create 3 prompts to close the data storytelling loop with clients: summarize insights, actions, and owners for weekly meetings. Output: prompts and structure.

Best Practices

• Keep prompts idempotent by avoiding hard-coded values that change over time. Save prompts as templates and reuse them with updated data. Include a short interpretation plus a one-page executive summary for stakeholders. Validate outputs by cross-checking with pivot tables or built charts. Use role prompts to ensure consistent framing across teams.

Common Mistakes to Avoid

• Using vague prompts that lack specific metrics or time ranges. Demanding too many outputs in a single prompt leading to incomplete results. Ignoring data quality issues that skew insights. Not specifying output formats, which makes parsing difficult. Relying on prompts without validating against the underlying Excel data.

FAQ

What makes these Claude prompts good for hair salons?

They are tailored to salon data, cover key metrics like revenue, service mix, retention, and inventory, and provide clear output formats for quick decision making.

Do I need to know Claude to use them?

No. Each prompt is self-contained with explicit instructions and placeholders you can replace.

Can I adapt prompts for multiple locations?

Yes. Use placeholders for location and store-specific ranges, and summarize results by location.

How should I verify results?

Cross-check summaries with pivot tables, charts, and raw data checks to ensure consistency.

Are there prompts for forecasting future performance?

Yes. Several prompts forecast revenue, seasonality, and staffing needs to support planning.

How often should I run these prompts?

Run them weekly for operational metrics or monthly for strategic planning to track trends.