100 Best Claude KPI and Dashboard Prompts for Fashion Boutiques
These Claude prompts help with KPI and dashboard for fashion boutiques using practical instructions, clear constraints, and reusable output formats.
Best For
Retail analysts, boutique owners, and data teams for fashion retail
Prompt Use Cases
- KPI design and tracking
- dashboard automation
- sales and inventory analytics
- customer behavior analysis
- weekly/ monthly performance reporting
Direct Answer
The best Claude prompts for KPI and dashboard for fashion boutiques are designed to drive measurable clarity across sales, inventory, and customer behavior. Use these prompts to build dashboards, forecast demand, analyze promotions, and optimize store performance with clear metrics and action-oriented outputs.
Introduction
This page is a practical KPI and dashboard prompt library for fashion boutiques. It helps boutique owners, managers, and analysts rapidly generate actionable analytics.
The prompts are crafted to be copyable and ready-to-use, minimizing guesswork and ensuring outputs are suitable for dashboards and reporting.
How to Use These Claude Prompts
- Replace placeholders with your data and time ranges.
- Add constraints to fit your reporting cadence and data governance.
- Request outputs in a dashboard-ready format or as structured data for BI tools.
- Verify outputs by cross-checking against source data and recent results.
- Adapt prompts to reflect seasonality and regional differences.
100 Best Claude KPI and Dashboard Prompts for Fashion Boutiques
- Monthly sales KPI dashboard: You are a data analyst for a fashion boutique. Task: design a concise monthly KPI dashboard frame. Context: focus on fashion retail metrics like revenue, units sold, average order value, gross margin, sell-through rate, and inventory turnover for the current month. Output: a structured dashboard outline with section headers, metric definitions, data sources, and quick interpretation notes. Constraints: provide color-coded sections and machine-readable data fields.
- Top products by revenue: You are a fashion retail data consultant. Task: generate a list of top five products by revenue for the last completed month. Context: include product name, category, price, units sold, revenue, gross margin, and stock status. Output: a tabular summary plus one-sentence insights per product. Constraints: rank strictly by revenue, exclude discontinued items.
- Sell-through analysis by category: Act as a KPI analyst for a boutique. Task: produce a sell-through analysis by product category for the current season. Context: calculate sell-through as units sold divided by units received, show trends, flag underperforming categories. Output: bullet list with category, sell-through %, trend arrow, and recommended actions. Constraints: compare to last season.
- Inventory turnover insights: Role: inventory analytics lead. Task: compute inventory turnover for the last 12 weeks by category and by supplier. Context: include turnover rate, days on hand, and reorder recommendations. Output: a dashboard-ready table plus 3 risk flags. Constraints: normalize by seasonality.
- Gross margin by channel: You are a retail finance analyst. Task: analyze gross margin by sales channel (in-store, online, pop-up) for the latest quarter. Context: show margin percentage, contribution to profit, and trend vs prior quarter. Output: dashboard-ready charts descriptions and a summary paragraph. Constraints: exclude non-operating items.
- AOV trend visualization: Role: merchant analyst. Task: create an AMA-style summary of Average Order Value trends for the last six months. Context: break down by day of week and hour of day, flag peak times. Output: concise narrative plus a small set of visual prompts for charts. Constraints: avoid overfitting to short-term noise.
- Customer lifetime value snapshot: You are a boutique data strategist. Task: generate a CLV snapshot for the active customer base. Context: include segments by recency, frequency, and monetary value; show projected 12-month CLV. Output: a dashboard-ready summary with 4 segments and action recommendations. Constraints: use a 12-month horizon.
- Promotion ROI calculator: Role: promotions analyst. Task: calculate ROI for the last promotional event. Context: include incremental revenue, discount depth, margin impact, and payback period. Output: KPI table and one-sentence decision note. Constraints: compare to a baseline non-promo period.
- Market basket analysis: You are a retail data scientist. Task: perform market basket analysis on transactions from the last 60 days. Context: identify common item pairings and cross-sell opportunities. Output: list of top 5 pairs with lift scores and recommended bundle ideas. Constraints: avoid recommending too many similar pairs.
- Customer churn signals: Role: customer insights analyst. Task: identify signals of potential churn within the boutique’s customer base. Context: analyze purchase frequency, recency, and engagement channels. Output: a prioritized list of 6 risk segments with suggested retention actions. Constraints: provide concrete, deployable tactics.
- Seasonal stock plan: You are a merchandising planner. Task: create a seasonal stock plan aligned to forecasted demand. Context: include target stock levels by SKU, safety stock, and replenishment lead times. Output: a supply plan grid and 2 corresponding KPI targets. Constraints: factor lead times and promotions.
- Pricing elasticity notes: Role: pricing analyst. Task: assess pricing elasticity for top 20 SKUs. Context: include demand sensitivity, price bands, and suggested price changes. Output: a compact elasticity report with recommended price adjustments. Constraints: avoid price wars.
- Staff scheduling impact: You are an ops analyst. Task: evaluate how staff scheduling affects sales and service metrics for peak weekends. Context: correlate labor hours with wait times, conversion rate, and average basket size. Output: 2 scenario-based recommendations and a dashboard snippet. Constraints: ensure compliance with labor laws.
- Footfall to conversion: Role: store performance analyst. Task: measure footfall to conversion rate correlation over the last 8 weeks. Context: include weather or event spikes if relevant. Output: a dashboard section with cause-and-effect notes and action steps. Constraints: normalize for promotions.
- Regional performance heatmap: You are a regional analytics lead. Task: create a heatmap of performance by store region. Context: include revenue, revenue per square foot, and stock turnover. Output: heatmap description and recommended regional actions. Constraints: compare regions to baseline.
- New vs returning buyers: Role: customer analytics specialist. Task: compare new and returning buyer performance for the last quarter. Context: show acquisition cost, repeat rate, and average order value by group. Output: executive-friendly KPI summary and 2 optimization ideas. Constraints: ensure privacy compliance.
- Online to offline funnel: You are a digital analytics lead. Task: map the online-to-offline funnel for fashion boutique shoppers. Context: track touchpoints from website visit to in-store purchase; highlight drop-off points. Output: funnel stages with conversion rates and tactical next steps. Constraints: anonymize user data.
- Cart abandonment insights: Role: e-commerce analyst. Task: analyze cart abandonment for the last 60 days. Context: identify common abandonment reasons, device patterns, and potential improvements. Output: recommended on-site and checkout optimizations with expected lift estimates. Constraints: separate promo vs non-promo carts.
- SKU-level profitability: You are a product profitability analyst. Task: compute profitability by SKU for the last quarter. Context: include cost of goods, discounts, and gross profit. Output: sortable table with recommended SKU-level actions. Constraints: exclude discontinued SKUs.
- Supplier performance score: Role: procurement analyst. Task: score suppliers by delivery reliability, quality, and lead time. Context: include top 5 suppliers with weighted scores and action items. Output: supplier scorecard and risk flags. Constraints: periodic updates.
- Channel mix optimization: You are a retail strategist. Task: evaluate channel mix against profitability targets for the current quarter. Context: include in-store, online, mobile app, and marketplaces. Output: recommended channel weightings and 3 actions. Constraints: consider seasonality.
- Return rate analysis: Role: loss prevention analyst. Task: analyze return rates by product category for the last 3 months. Context: identify high-return categories and causes. Output: action plan with 4 mitigations and a dashboard note. Constraints: separate exchanges from refunds.
- Checkout optimization prompts: You are a UX analyst. Task: generate prompts for optimizing the checkout flow for faster conversions. Context: include form field reductions, progress indicators, and payment options. Output: list of 6 micro-optimizations with expected impact estimates. Constraints: validate with A/B testing plan.
- Loyalty program impact: Role: program manager. Task: assess loyalty program impact on repeat purchases. Context: include tier performance, redemption rates, and incremental revenue. Output: KPI dashboard description with 3 optimization ideas. Constraints: isolate loyalty effects from promotions.
- Seasonal demand forecast: You are a forecasting analyst. Task: produce a 12-week demand forecast by category for a fashion boutique. Context: include confidence levels, seasonality adjustments, and promo impact. Output: forecast table and 2 scenario plans. Constraints: incorporate last year's data as baseline.
- Competitor price watch: Role: competitive intelligence analyst. Task: monitor competitor pricing for top 10 SKUs weekly. Context: track price changes, promotions, and stock status. Output: alert summary and 2 pricing recommendations. Constraints: respect fair play policies.
- Cost of goods insight: You are a financial analyst. Task: analyze COGS changes over the last 6 quarters for top categories. Context: explain drivers and margin impact. Output: narrative plus table of 6 quarters. Constraints: exclude one-offs.
- Promo calendar alignment: Role: merchandising planner. Task: align promo calendar with stock plan and forecast. Context: map promotions to inventory and expected lift. Output: calendar with 4 major promos and KPI targets. Constraints: avoid overlap.
- Retail media ROI: You are a marketing analyst. Task: estimate ROI of retail media placements across channels. Context: include media spend, incremental revenue, and attribution. Output: ROI summary and 2 optimization ideas. Constraints: use last 90 days as window.
- COS efficiency checklist: Role: finance analyst. Task: develop a COS (cost of sales) efficiency checklist for boutique operations. Context: identify 6 cost drivers and 3 improvement actions. Output: actionable checklist and dashboard hint. Constraints: keep under 8 items.
- New store launch metrics: You are a retail project analyst. Task: define KPI dashboard for new store openings. Context: include ramp-up period, break-even sales, and early profitability. Output: launch KPI sheet and interpretation notes. Constraints: compare against target store archetype.
- SKU assortment optimization: Role: merchandising data scientist. Task: optimize SKU assortment for a given boutique. Context: measure fit score, sales lift potential, and cannibalization risk. Output: ranked SKU list with actions and expected lift. Constraints: limit new SKUs per quarter.
- Promo performance heatmap: You are a dashboard designer. Task: build a heatmap of promo performance by day and category. Context: include uplift, margin impact, and redemption rate. Output: heatmap description plus interpretation notes. Constraints: label axes clearly.
- Stockout risk forecast: Role: inventory planner. Task: forecast stockout risk for top 20 SKUs next 8 weeks. Context: include lead times, current stock, and demand forecasts. Output: risk dashboard with mitigation actions. Constraints: provide early warning signals.
- Return to purchase cycle: You are a customer lifecycle analyst. Task: analyze the time between returns and subsequent purchases. Context: measure after-return purchase rate and average time to repurchase. Output: lifecycle insights and action plan. Constraints: segment by product category.
- Cash flow snapshot: Role: finance manager. Task: create a cash flow snapshot tied to monthly sales and inventory. Context: show operating cash, receivables, and payables. Output: dashboard summary with top 3 cash levers. Constraints: avoid forecast bias.
- Store-level profit ladder: You are a store ops analyst. Task: compute store-level profit by revenue and cost drivers. Context: include rent, labor, and shrinkage. Output: ranked store profit ladder with 3 improvement ideas per store. Constraints: normalize for store size.
- Shrinkage drivers: Role: loss prevention analyst. Task: identify primary drivers of shrinkage in the boutique. Context: include pilferage, admin errors, and supplier issues. Output: prevention plan with 5 actions and success metrics. Constraints: track across stores.
- Weather-adjusted demand: You are a forecasting specialist. Task: adjust demand forecast for anticipated weather impacts. Context: include temperature ranges and event effects. Output: weather-adjusted forecast with confidence bands. Constraints: document assumptions.
- Productivity by hour: Role: operations analyst. Task: measure staff productivity by hour shift. Context: metrics include sales per labor hour and transactions per hour. Output: shift-level dashboard snippets and improvement tips. Constraints: anonymize staff data.
- Gift guide performance: You are a marketing analyst. Task: evaluate performance of a holiday gift guide campaign. Context: include clicks, add-to-cart, conversions, and average order value. Output: KPI summary and optimization ideas. Constraints: link to product pages.
- Seasonal markdown impact: Role: pricing and merchandising specialist. Task: analyze markdowns' impact on revenue and margin. Context: show uplift versus clearance risk, and time-on-shelf. Output: markdown impact report with 4 takeaways. Constraints: avoid over-discounting.
- Omnichannel inventory view: You are an inventory analytics lead. Task: create an omnichannel view of stock across stores and fulfillment centers. Context: include in-store pickup and curbside data. Output: unified dashboard snippet and 2 actions. Constraints: ensure data timeliness.
- Cost-to-serve by channel: Role: finance analyst. Task: calculate cost-to-serve by channel for the latest quarter. Context: include fulfillment, returns, and handling. Output: channel-level profitability view and 2 optimization tips. Constraints: include fixed and variable costs.
- Deal cadence optimization: You are a promotions planner. Task: optimize deal cadence to maximize profitability. Context: include take rate, incremental sales, and cannibalization risk. Output: recommended cadence and 3 guardrails. Constraints: avoid promo fatigue.
- SKU performance map: Role: product analyst. Task: map SKU performance on a 2D grid by margin and velocity. Context: identify stars, dogs, puzzles, and cows. Output: map with 4 quadrants and recommended actions. Constraints: label quadrants clearly.
- Event-driven forecast: You are a forecasting analyst. Task: adjust forecast for a major fashion event. Context: include expected footfall, promotions, and capacity constraints. Output: event-adjusted forecast table and notes. Constraints: provide confidence intervals.
- Waste and returns audit: Role: operations auditor. Task: audit waste and returns rates for the quarter. Context: identify process gaps and impact on margin. Output: audit findings with 5 recommendations. Constraints: quantify impact.
- Customer segment heatmap: You are a customer insights analyst. Task: build a segment heatmap by recency, frequency, and monetary value. Context: include target action per segment. Output: heatmap description and 4 segment actions. Constraints: keep data anonymized.
- Discount leakage detector: Role: compliance and pricing analyst. Task: detect discount leakage across channels. Context: compare list price, sale price, and discount depth. Output: leakage alerts and 2 corrective actions. Constraints: flag high-risk SKUs.
- Product lifecycle dashboard: You are a product lifecycle manager. Task: track products through launch, growth, maturity, and decline stages. Context: show health indicators and transition actions. Output: lifecycle table with 4 stages and recommended actions. Constraints: align with assortment strategy.
- Returns by reason: Role: returns analyst. Task: categorize returns by reason and product. Context: compute rate and cost by reason. Output: dashboard-ready report and 3 mitigations. Constraints: ensure reason codes are standardized.
- Store-by-store KPI pack: You are a regional ops analyst. Task: assemble a KPI pack for each store. Context: include revenue, conversion, AOV, inventory turnover, and shrink. Output: 5-store sample pack and drill-down prompts. Constraints: ensure consistency.
- Wear and tear insights: Role: product analytics lead. Task: analyze wear-and-tear indicators for footwear. Context: track returns, replacements, and lifecycle. Output: health score per style and 2 improvement ideas. Constraints: base on durable goods standards.
- Acquisition channel plan: You are a marketing strategist. Task: craft an acquisition channel plan tied to budget. Context: show expected CAC, LTV, and payback period. Output: channel plan with 4 initiatives and success metrics. Constraints: keep CAC within target range.
- Luggage and accessories mix: Role: merchandiser. Task: optimize mix of bags and accessories for current season. Context: measure cross-sell, margin, and replenishment risk. Output: ranked mix plan and 2 prompts for replenishment.
- Boutique financial health: You are a boutique CFO assistant. Task: provide a compact financial health snapshot. Context: include liquidity, profitability, and cash runway. Output: dashboard card style with 3 alerts. Constraints: compare to budget.
- Gift card impact: Role: finance analyst. Task: assess gift card redemptions impact on cash and revenue. Context: include breakage estimates and redemption timing. Output: impact report and action notes. Constraints: consider seasonality.
- SKU rationalization plan: You are a merchandising strategist. Task: produce SKU rationalization plan by performance tier. Context: include approvals, cannibalization risk, and sunset dates. Output: actionable plan with 6 SKUs to prune and 6 to promote. Constraints: preserve core assortment.
- Store-opening ROI: Role: expansion analyst. Task: forecast ROI for a proposed new store. Context: include capex, operating costs, and projected revenue. Output: ROI model with sensitivity analysis. Constraints: use conservative assumptions.
- Refund trend watch: You are a risk analyst. Task: monitor refund trends and flags for unusual activity. Context: include time-to-refund and average refund value. Output: alerts and recommended checks. Constraints: avoid false positives.
- Product bundling prompts: Role: merchandising specialist. Task: design effective product bundles for cross-sells. Context: include price points, margin impact, and compatibility. Output: 4 bundle concepts with expected lift. Constraints: test plural combos.
- POS performance by terminal: You are a store operations analyst. Task: evaluate POS performance by terminal. Context: identify idle times, errors, and transaction speed. Output: terminal performance report and 2 optimization actions. Constraints: protect payment data.
- Salon and pop-up metrics: Role: event analytics lead. Task: track KPI for a fashion pop-up event. Context: include footfall, sales, and lead capture. Output: event KPI sheet and post-event learnings. Constraints: integrate with main store data.
- Sustainability KPIs: You are a sustainability analytics lead. Task: define fashion boutique sustainability KPIs. Context: include waste, packaging, and ethical sourcing metrics. Output: dashboard with 4 sustainability KPIs and targets. Constraints: align with reporting standards.
- Seasonal markdown timing: Role: pricing strategist. Task: optimize markdown timing to maximize profit. Context: include inventory levels and seasonality. Output: timing plan with 3 checkpoints and expected lift. Constraints: avoid early clears.
- Customer feedback analytics: You are a consumer insights analyst. Task: analyze customer feedback for top 5 products. Context: categorize sentiment and identify improvement ideas. Output: insight brief with 4 actions. Constraints: anonymize responses.
- SKU risk indicators: Role: inventory risk manager. Task: identify SKU risk indicators (slow movers, obsolete, seasonality mismatch). Context: provide 6 indicators and recommended actions. Output: risk dashboard and 2 triggers for intervention. Constraints: monitor weekly.
- Checkout performance notes: You are a checkout optimization specialist. Task: compile notes on checkout performance by device. Context: include mobile vs desktop, load times, and conversion. Output: optimization brief with 5 actions. Constraints: align with accessibility standards.
- Giftable inventory score: Role: merchandising analyst. Task: score inventory for giftability during holidays. Context: measure packaging, display, and desirability. Output: scorecard and 2 stocking recommendations. Constraints: avoid bias.
- Loyalty redemptions map: You are a loyalty program analyst. Task: map redemptions by tier and region. Context: include incremental revenue and redemption rate. Output: tier-region heatmap and 3 actions. Constraints: protect member data.
- Product downgrade alerts: Role: product manager. Task: alert when a product SKU shows declining sales and price resistance. Context: include margin impact and replenishment risk. Output: alert rules and mitigation plan. Constraints: alert thresholds clearly defined.
- Store conversion drivers: You are a store performance analyst. Task: identify top drivers of store conversion for the current quarter. Context: include product placement, associate engagement, and queue times. Output: ranked drivers with improvement suggestions. Constraints: isolate external factors.
- Digital funnel health: Role: digital analytics lead. Task: assess the health of the online funnel. Context: measure visits, add-to-cart, checkout, and purchase. Output: funnel health score and improvement plan. Constraints: attribute credit correctly.
- Pricing tier recommendations: You are a pricing strategist. Task: propose pricing tiers for best-selling categories. Context: include tier benefits, target margins, and cannibalization risk. Output: tier blueprint with 4 levels and KPI targets. Constraints: stay aligned with brand.
- Inventory aging report: Role: inventory analyst. Task: generate aging stock report by SKU. Context: show days on hand, age bucket, and turnover risk. Output: aging dashboard with 3 actions per age group. Constraints: flag slow sellers.
- Vendor scorecards: You are a vendor management analyst. Task: compile scorecards for top vendors on delivery, quality, and cost. Context: provide 5 vendors and improvement plans. Output: vendor scorecards with risk flags. Constraints: quarterly updates.
- Event-time revenue forecast: Role: events analytics lead. Task: forecast revenue for a fashion event tied to a date. Context: include ticket sales, onsite purchases, and merchandise. Output: event revenue forecast with confidence levels. Constraints: align with marketing plan.
- Brand sentiment scan: You are a brand analytics specialist. Task: run a sentiment scan on social mentions of the boutique. Context: summarize themes and momentum. Output: sentiment dashboard notes and 3 brand actions. Constraints: respect privacy policies.
- Product lifecycle alerts: Role: product operations analyst. Task: set alerts when a product moves into decline phase. Context: include sales velocity and margin. Output: alert rules and recommended action. Constraints: automate where possible.
- Gift guide conversion: You are a marketing analyst. Task: analyze gift guide page conversions. Context: include page views, add-to-cart, and purchases. Output: KPI summary and 2 optimization ideas. Constraints: test different placements.
- Returns by channel: Role: returns analyst. Task: break down returns by channel (online vs in-store). Context: calculate return rate by channel and item. Output: channel report and mitigation plan. Constraints: separate exchanges from refunds.
- Fleet store forecasting: You are a regional forecasting lead. Task: forecast performance across a small network of stores. Context: include synergy effects and shared promotions. Output: network forecast with regional priors and 2 actions. Constraints: ensure consistency.
- Checkout funnel prompts: Role: UX writer. Task: craft prompts to guide users through checkout funnels. Context: specify required fields and friction points. Output: 6 prompts with actionable improvements. Constraints: avoid jargon.
- Store sequence optimization: You are an store operations planner. Task: sequence promotions across stores to maximize regional impact. Context: align with inventory and events. Output: sequence plan and 3 metrics to track. Constraints: ensure non-conflicting promos.
- Product return prevention: Role: risk and quality manager. Task: propose 5 product-level return prevention tactics. Context: tie to design improvements and packaging. Output: actionable tactics with success metrics. Constraints: prioritize high-return items.
- Trend alignment report: You are a trend analyst. Task: align boutique performance with current fashion trends. Context: map trend signals to product mix and promotions. Output: alignment report with 3 recommended shifts. Constraints: avoid overfitting to trends.
- Forecast accuracy check: Role: data quality lead. Task: assess the accuracy of forecast models over the last four quarters. Context: compute error metrics and calibration. Output: accuracy dashboard and 2 improvement steps. Constraints: document data gaps.
- A/B test prompts: You are a experimentation lead. Task: design A/B test prompts for merchandising changes. Context: include sample size, KPI, and decision rule. Output: 4 ready-to-run prompts. Constraints: ensure tests are independent.
- Productivity heatmap: Role: operations data analyst. Task: create a productivity heatmap for store teams. Context: combine sales with labor and shrink. Output: heatmap with 4 actions per quadrant. Constraints: preserve privacy.
- Delivery SLA dashboard: You are a logistics analyst. Task: monitor delivery SLAs by carrier. Context: include on-time delivery rate and delay reasons. Output: SLA dashboard and 2 corrective actions. Constraints: anonymize carrier data.
- Regional promo impact: Role: regional marketing analyst. Task: compare promo impact across regions. Context: include uplift, margin, and traffic. Output: regional impact report and 2 scaling ideas. Constraints: normalize by population.
- New product signal: You are a product launch analyst. Task: identify signals that a new product will succeed. Context: include early sales, saves, and repeat purchases. Output: go/no-go criteria and top risks. Constraints: require threshold clarity.
- LTV by cohort: Role: customer analytics lead. Task: calculate 12-month LTV by customer cohort. Context: include cohort size, average revenue, and retention. Output: cohort dashboard with 4 groups. Constraints: ensure privacy.
- Inventory risk watchlist: You are an inventory risk officer. Task: build a watchlist of high-risk SKUs. Context: include aging, turnover, and margin. Output: watchlist with 6 items and triggers. Constraints: review weekly.
- Promotional calendar health: Role: merchandising planner. Task: assess health of the promo calendar. Context: include conflicts, cannibalization, and stock coverage. Output: health score and 3 fixes. Constraints: keep balanced.
- Customer journey map: You are a customer experience designer. Task: map the journey from first touch to purchase for fashion shoppers. Context: identify pain points and moments of delight. Output: journey map and 4 improvement ideas. Constraints: align with data privacy.
- Returns cost breakdown: Role: finance analyst. Task: break down costs of handling returns by category. Context: include restocking, disposal, and processing fees. Output: cost breakdown and 2 cost-saving ideas. Constraints: separate refunds from exchanges.
- Capex vs opex view: You are a finance planner. Task: compare capital and operational expenditures for store improvements. Context: include payback periods and ROI. Output: decision-ready summary with 3 scenarios. Constraints: align with budget.
- Executive KPI briefing: Role: executive analyst. Task: prepare a KPI briefing tailored to fashion boutique leadership. Context: include top metrics, risks, and 2 recommended strategic moves. Output: briefing notes and a one-page dashboard outline. Constraints: concise and executive-ready.
Markdown Template
100 Best Claude KPI and Dashboard Prompts for Fashion Boutiques
# 100 Best Claude KPI and Dashboard Prompts for Fashion Boutiques
**Monthly sales KPI dashboard**: You are a data analyst for a fashion boutique. Task: design a concise monthly KPI dashboard frame. Context: focus on fashion retail metrics like revenue, units sold, average order value, gross margin, sell-through rate, and inventory turnover for the current month. Output: a structured dashboard outline with section headers, metric definitions, data sources, and quick interpretation notes. Constraints: provide color-coded sections and machine-readable data fields.
**Top products by revenue**: You are a fashion retail data consultant. Task: generate a list of top five products by revenue for the last completed month. Context: include product name, category, price, units sold, revenue, gross margin, and stock status. Output: a tabular summary plus one-sentence insights per product. Constraints: rank strictly by revenue, exclude discontinued items.
**Sell-through analysis by category**: Act as a KPI analyst for a boutique. Task: produce a sell-through analysis by product category for the current season. Context: calculate sell-through as units sold divided by units received, show trends, flag underperforming categories. Output: bullet list with category, sell-through %, trend arrow, and recommended actions. Constraints: compare to last season.
**Inventory turnover insights**: Role: inventory analytics lead. Task: compute inventory turnover for the last 12 weeks by category and by supplier. Context: include turnover rate, days on hand, and reorder recommendations. Output: a dashboard-ready table plus 3 risk flags. Constraints: normalize by seasonality.
**Gross margin by channel**: You are a retail finance analyst. Task: analyze gross margin by sales channel (in-store, online, pop-up) for the latest quarter. Context: show margin percentage, contribution to profit, and trend vs prior quarter. Output: dashboard-ready charts descriptions and a summary paragraph. Constraints: exclude non-operating items.
**AOV trend visualization**: Role: merchant analyst. Task: create an AMA-style summary of Average Order Value trends for the last six months. Context: break down by day of week and hour of day, flag peak times. Output: concise narrative plus a small set of visual prompts for charts. Constraints: avoid overfitting to short-term noise.
**Customer lifetime value snapshot**: You are a boutique data strategist. Task: generate a CLV snapshot for the active customer base. Context: include segments by recency, frequency, and monetary value; show projected 12-month CLV. Output: a dashboard-ready summary with 4 segments and action recommendations. Constraints: use a 12-month horizon.
**Promotion ROI calculator**: Role: promotions analyst. Task: calculate ROI for the last promotional event. Context: include incremental revenue, discount depth, margin impact, and payback period. Output: KPI table and one-sentence decision note. Constraints: compare to a baseline non-promo period.
**Market basket analysis**: You are a retail data scientist. Task: perform market basket analysis on transactions from the last 60 days. Context: identify common item pairings and cross-sell opportunities. Output: list of top 5 pairs with lift scores and recommended bundle ideas. Constraints: avoid recommending too many similar pairs.
**Customer churn signals**: Role: customer insights analyst. Task: identify signals of potential churn within the boutique’s customer base. Context: analyze purchase frequency, recency, and engagement channels. Output: a prioritized list of 6 risk segments with suggested retention actions. Constraints: provide concrete, deployable tactics.
**Seasonal stock plan**: You are a merchandising planner. Task: create a seasonal stock plan aligned to forecasted demand. Context: include target stock levels by SKU, safety stock, and replenishment lead times. Output: a supply plan grid and 2 corresponding KPI targets. Constraints: factor lead times and promotions.
**Pricing elasticity notes**: Role: pricing analyst. Task: assess pricing elasticity for top 20 SKUs. Context: include demand sensitivity, price bands, and suggested price changes. Output: a compact elasticity report with recommended price adjustments. Constraints: avoid price wars.
**Staff scheduling impact**: You are an ops analyst. Task: evaluate how staff scheduling affects sales and service metrics for peak weekends. Context: correlate labor hours with wait times, conversion rate, and average basket size. Output: 2 scenario-based recommendations and a dashboard snippet. Constraints: ensure compliance with labor laws.
**Footfall to conversion**: Role: store performance analyst. Task: measure footfall to conversion rate correlation over the last 8 weeks. Context: include weather or event spikes if relevant. Output: a dashboard section with cause-and-effect notes and action steps. Constraints: normalize for promotions.
**Regional performance heatmap**: You are a regional analytics lead. Task: create a heatmap of performance by store region. Context: include revenue, revenue per square foot, and stock turnover. Output: heatmap description and recommended regional actions. Constraints: compare regions to baseline.
**New vs returning buyers**: Role: customer analytics specialist. Task: compare new and returning buyer performance for the last quarter. Context: show acquisition cost, repeat rate, and average order value by group. Output: executive-friendly KPI summary and 2 optimization ideas. Constraints: ensure privacy compliance.
**Online to offline funnel**: You are a digital analytics lead. Task: map the online-to-offline funnel for fashion boutique shoppers. Context: track touchpoints from website visit to in-store purchase; highlight drop-off points. Output: funnel stages with conversion rates and tactical next steps. Constraints: anonymize user data.
**Cart abandonment insights**: Role: e-commerce analyst. Task: analyze cart abandonment for the last 60 days. Context: identify common abandonment reasons, device patterns, and potential improvements. Output: recommended on-site and checkout optimizations with expected lift estimates. Constraints: separate promo vs non-promo carts.
**SKU-level profitability**: You are a product profitability analyst. Task: compute profitability by SKU for the last quarter. Context: include cost of goods, discounts, and gross profit. Output: sortable table with recommended SKU-level actions. Constraints: exclude discontinued SKUs.
**Supplier performance score**: Role: procurement analyst. Task: score suppliers by delivery reliability, quality, and lead time. Context: include top 5 suppliers with weighted scores and action items. Output: supplier scorecard and risk flags. Constraints: periodic updates.
**Channel mix optimization**: You are a retail strategist. Task: evaluate channel mix against profitability targets for the current quarter. Context: include in-store, online, mobile app, and marketplaces. Output: recommended channel weightings and 3 actions. Constraints: consider seasonality.
**Return rate analysis**: Role: loss prevention analyst. Task: analyze return rates by product category for the last 3 months. Context: identify high-return categories and causes. Output: action plan with 4 mitigations and a dashboard note. Constraints: separate exchanges from refunds.
**Checkout optimization prompts**: You are a UX analyst. Task: generate prompts for optimizing the checkout flow for faster conversions. Context: include form field reductions, progress indicators, and payment options. Output: list of 6 micro-optimizations with expected impact estimates. Constraints: validate with A/B testing plan.
**Loyalty program impact**: Role: program manager. Task: assess loyalty program impact on repeat purchases. Context: include tier performance, redemption rates, and incremental revenue. Output: KPI dashboard description with 3 optimization ideas. Constraints: isolate loyalty effects from promotions.
**Seasonal demand forecast**: You are a forecasting analyst. Task: produce a 12-week demand forecast by category for a fashion boutique. Context: include confidence levels, seasonality adjustments, and promo impact. Output: forecast table and 2 scenario plans. Constraints: incorporate last year's data as baseline.
**Competitor price watch**: Role: competitive intelligence analyst. Task: monitor competitor pricing for top 10 SKUs weekly. Context: track price changes, promotions, and stock status. Output: alert summary and 2 pricing recommendations. Constraints: respect fair play policies.
**Cost of goods insight**: You are a financial analyst. Task: analyze COGS changes over the last 6 quarters for top categories. Context: explain drivers and margin impact. Output: narrative plus table of 6 quarters. Constraints: exclude one-offs.
**Promo calendar alignment**: Role: merchandising planner. Task: align promo calendar with stock plan and forecast. Context: map promotions to inventory and expected lift. Output: calendar with 4 major promos and KPI targets. Constraints: avoid overlap.
**Retail media ROI**: You are a marketing analyst. Task: estimate ROI of retail media placements across channels. Context: include media spend, incremental revenue, and attribution. Output: ROI summary and 2 optimization ideas. Constraints: use last 90 days as window.
**COS efficiency checklist**: Role: finance analyst. Task: develop a COS (cost of sales) efficiency checklist for boutique operations. Context: identify 6 cost drivers and 3 improvement actions. Output: actionable checklist and dashboard hint. Constraints: keep under 8 items.
**New store launch metrics**: You are a retail project analyst. Task: define KPI dashboard for new store openings. Context: include ramp-up period, break-even sales, and early profitability. Output: launch KPI sheet and interpretation notes. Constraints: compare against target store archetype.
**SKU assortment optimization**: Role: merchandising data scientist. Task: optimize SKU assortment for a given boutique. Context: measure fit score, sales lift potential, and cannibalization risk. Output: ranked SKU list with actions and expected lift. Constraints: limit new SKUs per quarter.
**Promo performance heatmap**: You are a dashboard designer. Task: build a heatmap of promo performance by day and category. Context: include uplift, margin impact, and redemption rate. Output: heatmap description plus interpretation notes. Constraints: label axes clearly.
**Stockout risk forecast**: Role: inventory planner. Task: forecast stockout risk for top 20 SKUs next 8 weeks. Context: include lead times, current stock, and demand forecasts. Output: risk dashboard with mitigation actions. Constraints: provide early warning signals.
**Return to purchase cycle**: You are a customer lifecycle analyst. Task: analyze the time between returns and subsequent purchases. Context: measure after-return purchase rate and average time to repurchase. Output: lifecycle insights and action plan. Constraints: segment by product category.
**Cash flow snapshot**: Role: finance manager. Task: create a cash flow snapshot tied to monthly sales and inventory. Context: show operating cash, receivables, and payables. Output: dashboard summary with top 3 cash levers. Constraints: avoid forecast bias.
**Store-level profit ladder**: You are a store ops analyst. Task: compute store-level profit by revenue and cost drivers. Context: include rent, labor, and shrinkage. Output: ranked store profit ladder with 3 improvement ideas per store. Constraints: normalize for store size.
**Shrinkage drivers**: Role: loss prevention analyst. Task: identify primary drivers of shrinkage in the boutique. Context: include pilferage, admin errors, and supplier issues. Output: prevention plan with 5 actions and success metrics. Constraints: track across stores.
**Weather-adjusted demand**: You are a forecasting specialist. Task: adjust demand forecast for anticipated weather impacts. Context: include temperature ranges and event effects. Output: weather-adjusted forecast with confidence bands. Constraints: document assumptions.
**Productivity by hour**: Role: operations analyst. Task: measure staff productivity by hour shift. Context: metrics include sales per labor hour and transactions per hour. Output: shift-level dashboard snippets and improvement tips. Constraints: anonymize staff data.
**Gift guide performance**: You are a marketing analyst. Task: evaluate performance of a holiday gift guide campaign. Context: include clicks, add-to-cart, conversions, and average order value. Output: KPI summary and optimization ideas. Constraints: link to product pages.
**Seasonal markdown impact**: Role: pricing and merchandising specialist. Task: analyze markdowns' impact on revenue and margin. Context: show uplift versus clearance risk, and time-on-shelf. Output: markdown impact report with 4 takeaways. Constraints: avoid over-discounting.
**Omnichannel inventory view**: You are an inventory analytics lead. Task: create an omnichannel view of stock across stores and fulfillment centers. Context: include in-store pickup and curbside data. Output: unified dashboard snippet and 2 actions. Constraints: ensure data timeliness.
**Cost-to-serve by channel**: Role: finance analyst. Task: calculate cost-to-serve by channel for the latest quarter. Context: include fulfillment, returns, and handling. Output: channel-level profitability view and 2 optimization tips. Constraints: include fixed and variable costs.
**Deal cadence optimization**: You are a promotions planner. Task: optimize deal cadence to maximize profitability. Context: include take rate, incremental sales, and cannibalization risk. Output: recommended cadence and 3 guardrails. Constraints: avoid promo fatigue.
**SKU performance map**: Role: product analyst. Task: map SKU performance on a 2D grid by margin and velocity. Context: identify stars, dogs, puzzles, and cows. Output: map with 4 quadrants and recommended actions. Constraints: label quadrants clearly.
**Event-driven forecast**: You are a forecasting analyst. Task: adjust forecast for a major fashion event. Context: include expected footfall, promotions, and capacity constraints. Output: event-adjusted forecast table and notes. Constraints: provide confidence intervals.
**Waste and returns audit**: Role: operations auditor. Task: audit waste and returns rates for the quarter. Context: identify process gaps and impact on margin. Output: audit findings with 5 recommendations. Constraints: quantify impact.
**Customer segment heatmap**: You are a customer insights analyst. Task: build a segment heatmap by recency, frequency, and monetary value. Context: include target action per segment. Output: heatmap description and 4 segment actions. Constraints: keep data anonymized.
**Discount leakage detector**: Role: compliance and pricing analyst. Task: detect discount leakage across channels. Context: compare list price, sale price, and discount depth. Output: leakage alerts and 2 corrective actions. Constraints: flag high-risk SKUs.
**Product lifecycle dashboard**: You are a product lifecycle manager. Task: track products through launch, growth, maturity, and decline stages. Context: show health indicators and transition actions. Output: lifecycle table with 4 stages and recommended actions. Constraints: align with assortment strategy.
**Returns by reason**: Role: returns analyst. Task: categorize returns by reason and product. Context: compute rate and cost by reason. Output: dashboard-ready report and 3 mitigations. Constraints: ensure reason codes are standardized.
**Store-by-store KPI pack**: You are a regional ops analyst. Task: assemble a KPI pack for each store. Context: include revenue, conversion, AOV, inventory turnover, and shrink. Output: 5-store sample pack and drill-down prompts. Constraints: ensure consistency.
**Wear and tear insights**: Role: product analytics lead. Task: analyze wear-and-tear indicators for footwear. Context: track returns, replacements, and lifecycle. Output: health score per style and 2 improvement ideas. Constraints: base on durable goods standards.
**Acquisition channel plan**: You are a marketing strategist. Task: craft an acquisition channel plan tied to budget. Context: show expected CAC, LTV, and payback period. Output: channel plan with 4 initiatives and success metrics. Constraints: keep CAC within target range.
**Luggage and accessories mix**: Role: merchandiser. Task: optimize mix of bags and accessories for current season. Context: measure cross-sell, margin, and replenishment risk. Output: ranked mix plan and 2 prompts for replenishment.
**Boutique financial health**: You are a boutique CFO assistant. Task: provide a compact financial health snapshot. Context: include liquidity, profitability, and cash runway. Output: dashboard card style with 3 alerts. Constraints: compare to budget.
**Gift card impact**: Role: finance analyst. Task: assess gift card redemptions impact on cash and revenue. Context: include breakage estimates and redemption timing. Output: impact report and action notes. Constraints: consider seasonality.
**SKU rationalization plan**: You are a merchandising strategist. Task: produce SKU rationalization plan by performance tier. Context: include approvals, cannibalization risk, and sunset dates. Output: actionable plan with 6 SKUs to prune and 6 to promote. Constraints: preserve core assortment.
**Store-opening ROI**: Role: expansion analyst. Task: forecast ROI for a proposed new store. Context: include capex, operating costs, and projected revenue. Output: ROI model with sensitivity analysis. Constraints: use conservative assumptions.
**Refund trend watch**: You are a risk analyst. Task: monitor refund trends and flags for unusual activity. Context: include time-to-refund and average refund value. Output: alerts and recommended checks. Constraints: avoid false positives.
**Product bundling prompts**: Role: merchandising specialist. Task: design effective product bundles for cross-sells. Context: include price points, margin impact, and compatibility. Output: 4 bundle concepts with expected lift. Constraints: test plural combos.
**POS performance by terminal**: You are a store operations analyst. Task: evaluate POS performance by terminal. Context: identify idle times, errors, and transaction speed. Output: terminal performance report and 2 optimization actions. Constraints: protect payment data.
**Salon and pop-up metrics**: Role: event analytics lead. Task: track KPI for a fashion pop-up event. Context: include footfall, sales, and lead capture. Output: event KPI sheet and post-event learnings. Constraints: integrate with main store data.
**Sustainability KPIs**: You are a sustainability analytics lead. Task: define fashion boutique sustainability KPIs. Context: include waste, packaging, and ethical sourcing metrics. Output: dashboard with 4 sustainability KPIs and targets. Constraints: align with reporting standards.
**Seasonal markdown timing**: Role: pricing strategist. Task: optimize markdown timing to maximize profit. Context: include inventory levels and seasonality. Output: timing plan with 3 checkpoints and expected lift. Constraints: avoid early clears.
**Customer feedback analytics**: You are a consumer insights analyst. Task: analyze customer feedback for top 5 products. Context: categorize sentiment and identify improvement ideas. Output: insight brief with 4 actions. Constraints: anonymize responses.
**SKU risk indicators**: Role: inventory risk manager. Task: identify SKU risk indicators (slow movers, obsolete, seasonality mismatch). Context: provide 6 indicators and recommended actions. Output: risk dashboard and 2 triggers for intervention. Constraints: monitor weekly.
**Checkout performance notes**: You are a checkout optimization specialist. Task: compile notes on checkout performance by device. Context: include mobile vs desktop, load times, and conversion. Output: optimization brief with 5 actions. Constraints: align with accessibility standards.
**Giftable inventory score**: Role: merchandising analyst. Task: score inventory for giftability during holidays. Context: measure packaging, display, and desirability. Output: scorecard and 2 stocking recommendations. Constraints: avoid bias.
**Loyalty redemptions map**: You are a loyalty program analyst. Task: map redemptions by tier and region. Context: include incremental revenue and redemption rate. Output: tier-region heatmap and 3 actions. Constraints: protect member data.
**Product downgrade alerts**: Role: product manager. Task: alert when a product SKU shows declining sales and price resistance. Context: include margin impact and replenishment risk. Output: alert rules and mitigation plan. Constraints: alert thresholds clearly defined.
**Store conversion drivers**: You are a store performance analyst. Task: identify top drivers of store conversion for the current quarter. Context: include product placement, associate engagement, and queue times. Output: ranked drivers with improvement suggestions. Constraints: isolate external factors.
**Digital funnel health**: Role: digital analytics lead. Task: assess the health of the online funnel. Context: measure visits, add-to-cart, checkout, and purchase. Output: funnel health score and improvement plan. Constraints: attribute credit correctly.
**Pricing tier recommendations**: You are a pricing strategist. Task: propose pricing tiers for best-selling categories. Context: include tier benefits, target margins, and cannibalization risk. Output: tier blueprint with 4 levels and KPI targets. Constraints: stay aligned with brand.
**Inventory aging report**: Role: inventory analyst. Task: generate aging stock report by SKU. Context: show days on hand, age bucket, and turnover risk. Output: aging dashboard with 3 actions per age group. Constraints: flag slow sellers.
**Vendor scorecards**: You are a vendor management analyst. Task: compile scorecards for top vendors on delivery, quality, and cost. Context: provide 5 vendors and improvement plans. Output: vendor scorecards with risk flags. Constraints: quarterly updates.
**Event-time revenue forecast**: Role: events analytics lead. Task: forecast revenue for a fashion event tied to a date. Context: include ticket sales, onsite purchases, and merchandise. Output: event revenue forecast with confidence levels. Constraints: align with marketing plan.
**Brand sentiment scan**: You are a brand analytics specialist. Task: run a sentiment scan on social mentions of the boutique. Context: summarize themes and momentum. Output: sentiment dashboard notes and 3 brand actions. Constraints: respect privacy policies.
**Product lifecycle alerts**: Role: product operations analyst. Task: set alerts when a product moves into decline phase. Context: include sales velocity and margin. Output: alert rules and recommended action. Constraints: automate where possible.
**Gift guide conversion**: You are a marketing analyst. Task: analyze gift guide page conversions. Context: include page views, add-to-cart, and purchases. Output: KPI summary and 2 optimization ideas. Constraints: test different placements.
**Returns by channel**: Role: returns analyst. Task: break down returns by channel (online vs in-store). Context: calculate return rate by channel and item. Output: channel report and mitigation plan. Constraints: separate exchanges from refunds.
**Fleet store forecasting**: You are a regional forecasting lead. Task: forecast performance across a small network of stores. Context: include synergy effects and shared promotions. Output: network forecast with regional priors and 2 actions. Constraints: ensure consistency.
**Checkout funnel prompts**: Role: UX writer. Task: craft prompts to guide users through checkout funnels. Context: specify required fields and friction points. Output: 6 prompts with actionable improvements. Constraints: avoid jargon.
**Store sequence optimization**: You are an store operations planner. Task: sequence promotions across stores to maximize regional impact. Context: align with inventory and events. Output: sequence plan and 3 metrics to track. Constraints: ensure non-conflicting promos.
**Product return prevention**: Role: risk and quality manager. Task: propose 5 product-level return prevention tactics. Context: tie to design improvements and packaging. Output: actionable tactics with success metrics. Constraints: prioritize high-return items.
**Trend alignment report**: You are a trend analyst. Task: align boutique performance with current fashion trends. Context: map trend signals to product mix and promotions. Output: alignment report with 3 recommended shifts. Constraints: avoid overfitting to trends.
**Forecast accuracy check**: Role: data quality lead. Task: assess the accuracy of forecast models over the last four quarters. Context: compute error metrics and calibration. Output: accuracy dashboard and 2 improvement steps. Constraints: document data gaps.
**A/B test prompts**: You are a experimentation lead. Task: design A/B test prompts for merchandising changes. Context: include sample size, KPI, and decision rule. Output: 4 ready-to-run prompts. Constraints: ensure tests are independent.
**Productivity heatmap**: Role: operations data analyst. Task: create a productivity heatmap for store teams. Context: combine sales with labor and shrink. Output: heatmap with 4 actions per quadrant. Constraints: preserve privacy.
**Delivery SLA dashboard**: You are a logistics analyst. Task: monitor delivery SLAs by carrier. Context: include on-time delivery rate and delay reasons. Output: SLA dashboard and 2 corrective actions. Constraints: anonymize carrier data.
**Regional promo impact**: Role: regional marketing analyst. Task: compare promo impact across regions. Context: include uplift, margin, and traffic. Output: regional impact report and 2 scaling ideas. Constraints: normalize by population.
**New product signal**: You are a product launch analyst. Task: identify signals that a new product will succeed. Context: include early sales, saves, and repeat purchases. Output: go/no-go criteria and top risks. Constraints: require threshold clarity.
**LTV by cohort**: Role: customer analytics lead. Task: calculate 12-month LTV by customer cohort. Context: include cohort size, average revenue, and retention. Output: cohort dashboard with 4 groups. Constraints: ensure privacy.
**Inventory risk watchlist**: You are an inventory risk officer. Task: build a watchlist of high-risk SKUs. Context: include aging, turnover, and margin. Output: watchlist with 6 items and triggers. Constraints: review weekly.
**Promotional calendar health**: Role: merchandising planner. Task: assess health of the promo calendar. Context: include conflicts, cannibalization, and stock coverage. Output: health score and 3 fixes. Constraints: keep balanced.
**Customer journey map**: You are a customer experience designer. Task: map the journey from first touch to purchase for fashion shoppers. Context: identify pain points and moments of delight. Output: journey map and 4 improvement ideas. Constraints: align with data privacy.
**Returns cost breakdown**: Role: finance analyst. Task: break down costs of handling returns by category. Context: include restocking, disposal, and processing fees. Output: cost breakdown and 2 cost-saving ideas. Constraints: separate refunds from exchanges.
**Capex vs opex view**: You are a finance planner. Task: compare capital and operational expenditures for store improvements. Context: include payback periods and ROI. Output: decision-ready summary with 3 scenarios. Constraints: align with budget.
**Executive KPI briefing**: Role: executive analyst. Task: prepare a KPI briefing tailored to fashion boutique leadership. Context: include top metrics, risks, and 2 recommended strategic moves. Output: briefing notes and a one-page dashboard outline. Constraints: concise and executive-ready.Best Practices
- Start with a core KPI set and layer in drill-down prompts for details.
- Keep prompts modular so you can reuse components across dashboards.
- Validate outputs with historical baselines before acting on insights.
- Annotate prompts with business rules to ensure consistent interpretation.
- Safeguard sensitive customer data through appropriate placeholders and anonymization.
Common Mistakes to Avoid
- Asking for vague insights like Make it better without defining metrics.
- Ignoring seasonality or regional differences in forecasts.
- Overloading prompts with too many variables, causing cluttered outputs.
- Not validating outputs against actual data before decisions.
- Using promotional claims without separating incremental impact from baseline.
FAQ
What makes KPI prompts effective for fashion boutiques?
Effective prompts define scope, data sources, and timeframes, returning dashboard-ready outputs and clear actions.
How should I customize prompts for my boutique?
Replace placeholders with your data ranges, channels, and seasons, and add constraints to fit your reporting cadence.
Can these prompts handle multi-store networks?
Yes, prompts can be adapted to multi-store networks by anchoring metrics to store, region, and network levels.
How do I verify prompt outputs for accuracy?
Cross-check outputs with source systems and recent results, and validate anomalies with a quick data audit.
What if I use a new season or event?
Update seasonality adjustments and event factors in the prompts to reflect the new context.
Are there internal links to related tools?
Yes, see related pages on the site for broader AI-powered retail analytics.