100 Best Claude KPI and Dashboard Prompts for Etsy Sellers

Direct Answer

The best Claude prompts for KPI and dashboard for Etsy sellers are optimized prompts that drive precise metrics, actionable insights, and clear dashboards for Etsy performance. They focus on sales trends, listing health, customer behavior, and optimization actions, delivering outputs that are ready to paste into reports. Use them to build repeatable analyses and guardrails for decision making.

Introduction

This page is a practical KPI and dashboard prompt library for Etsy sellers. It helps you generate Claude prompts that produce concrete KPI dashboards and insights tailored to Etsy performance.

Whether you are optimizing listings, pricing, traffic, or customer experience, this collection provides ready-to-use prompts you can run to drive measurable improvements.

How to Use These Claude Prompts

• Replace placeholders like [date range], [listing], [channel], and [metric] to fit your shop data.
• Add constraints such as date ranges, sample sizes, and output formats to ensure consistent results.
• Request outputs in a compact, copy-paste-friendly format suitable for dashboards and reports.
• Verify outputs by comparing them against your shop data and recalibrating prompts if needed.
• If results seem unstable, run the same prompt with a larger data window to confirm trends.

100 Best Claude KPI and Dashboard Prompts for Etsy Sellers

1. Sales trend by day: You are an ecommerce analytics consultant. Task: generate a KPI dashboard summary for Etsy shop sales. Context: the shop sells handmade home decor with daily sales data last 180 days and category tags. Output format: provide a concise daily sales trend chart description, key peaks, and a recommendation slate. Constraints: include at most 6 bullet insights, and phrase numbers in words where possible.
2. Top performing listings: Act as an Etsy performance analyst. Task: identify top performing listings by revenue and orders over the last 90 days. Context: include listing titles, price, revenue, orders, and conversion rate. Output format: a compact table-like text block with per-listing metrics and a short optimization tip. Constraints: exclude sponsored listings, include only active listings, and annotate ties.
3. Revenue by channel: Role: data analyst for an Etsy store. Task: break down revenue by channel (organic search, paid ads, external traffic) for the last 60 days. Context: provide percentages, dollar amounts, and trend arrows. Output format: bullet list with a one-sentence takeaway for each channel. Constraints: include a 2 sentence overall conclusion.
4. Traffic sources dive: You are an analytics strategist. Task: map traffic sources to conversion rate for Etsy shop pages. Context: sources include Etsy search, external search, social, email, referrals. Output: concise metrics table and a 3-point optimization plan. Constraints: compare at least three sources and provide causation-friendly explanations.
5. Listing health score: Act as a listing optimization coach. Task: compute a listing health score for each active listing based on title relevance, photo quality, description completeness, and tags. Context: score 0-100, with threshold 70+. Output: a compact health summary per listing and one improvement action.
6. Conversion rate by listing: Role: conversion analyst. Task: compute per-listing conversion rate over the last 45 days and annotate confidence due to sample size. Context: include views, clicks, orders. Output: ranked list with conversion rate, sample size, and two optimization ideas per listing. Constraints: avoid overfit conclusions.
7. Pricing optimization snapshot: You are a pricing strategist. Task: suggest pricing adjustments for 5 listings with elastic demand. Context: use demand elasticity assumptions, seasonality, and competitor price hints. Output: per-listing suggested price, expected revenue delta, and risk notes. Constraints: present as a brief table and a one-sentence caution.
8. Cohort analysis view: Role: business intelligence lead. Task: perform a cohort analysis on first-time buyers vs repeat buyers over 6 months. Context: show retention, average order value, and repeat rate. Output: narrative summary plus a small cohort heatmap description. Constraints: avoid subjective judgments.
9. Inventory turnover pace: Act as operations analyst. Task: calculate inventory turnover pace for best-selling items over 3 months. Context: define turnover as cost of goods sold divided by average inventory. Output: simple KPI table and a one-line supply action.
10. Refunds vs returns: You are a customer behavior analyst. Task: compare refunds to returns by reason codes over 90 days. Context: provide refund rate and return rate and notable patterns. Output: concise chart-ready data plus two policy improvement ideas. Constraints: avoid vendor-specific jargon.
11. Seasonality impact: Role: seasonal analytics expert. Task: isolate seasonality effects on Etsy sales across last four seasons. Context: include baseline trend, seasonal index, and forecast for next quarter. Output: a short narrative with bullets and a one-line forecast.
12. Cost of goods impact: You are a financial analyst. Task: quantify how COGS fluctuations affect gross profit for the most profitable category. Context: provide percentage impact and recommended hedges. Output: 4 bullet points plus a one-paragraph takeaway.
13. Customer lifetime value: Role: LTV specialist. Task: calculate 12-month LTV for each customer segment using recent purchase data. Context: show LTV, margin, and retention. Output: segment table and two optimization experiments.
14. Cart abandonment insights: Act as funnel optimizer. Task: analyze cart abandonment rate by device and traffic source last 60 days. Context: provide funnel stages, drop-off points, and two recovery strategies. Output: summary plus one experiment plan.
15. Marketing ROI snapshot: You are a marketing analyst. Task: compute ROI for Etsy-focused campaigns, including ad spend, revenue, and CPA. Context: provide last 90 days data, and two optimization suggestions. Output: compact metrics block with interpretation.
16. Seasonal promo impact: Role: promotions strategist. Task: evaluate the effect of a 20 percent seasonal promo on sales, margin, and unit economics. Context: compare promo vs non-promo periods. Output: brief report with two recommendations.
17. Email campaign lift: Analyst role. Task: measure lift from last email campaign on orders and repeat purchases. Context: include open rate, click-through, and conversion. Output: concise trend and a two-step follow-up plan.
18. Search term performance: You are an SEO/data analyst. Task: identify top-performing search terms on Etsy within the shop and their conversion impact. Context: map terms to impressions and orders. Output: ranked term list with optimization notes.
19. Listing backlog KPI: Role: operations manager. Task: track backlog to ship rate for 7 days to identify fulfillment bottlenecks. Context: provide days-to-ship and percentage on-time. Output: brief dashboard snippet and two mitigations.
20. Reviews sentiment: You are a customer insights analyst. Task: analyze review sentiment and rating distribution over the last 120 days. Context: categorize by product, issue type, and sentiment score. Output: summary with three action items.
21. Revenue by category: Role: category analyst. Task: compare revenue by product category for the last quarter. Context: include share, growth, and largest gaps. Output: table plus two strategic moves.
22. Stockout risk: Analytics advisor. Task: identify stockout risk indicators from sales velocity and lead time for top items. Context: provide risk score and mitigation plan. Output: alert-ready summary.
23. Checkout flow bottlenecks: You are a UX analytics consultant. Task: evaluate the checkout flow for friction points using last 2 weeks of data. Context: list bottlenecks and measurement plan. Output: prioritized action list.
24. Customer demographics: Role: market insights analyst. Task: profile customers by age, location, and device. Context: provide top segments and growth trends. Output: concise demographic snapshot with two implications.
25. Repeat purchase timing: Analyst role. Task: measure time between first and second purchase for returning customers. Context: show distribution and feature correlations. Output: interpretation and two retention ideas.
26. Platform integration impact: You are a data strategist. Task: assess how integration with a social platform affects orders. Context: show lift by channel, attribution windows, and control comparison. Output: dashboard-ready summary.
27. Product margin map: Role: finance analyst. Task: map gross margin by listing across last 6 months. Context: highlight high-margin items, risky low-margin items. Output: simple map plus two recommendations.
28. Campaign pacing: You are a campaign planner. Task: assess pacing of promotions across the quarter. Context: show cadence, spend, and forecast accuracy. Output: one-page pacing report.
29. A/B testing plan: Analyst role. Task: design an A/B test for listing image order and description length. Context: specify sample size, duration, success criteria. Output: plan with variable, control, and metrics.
30. Churn risk signals: Role: risk analyst. Task: identify signals predicting churn among buyers. Context: use engagement metrics and purchase history. Output: risk score per customer and recommended retention actions.
31. Seasonal demand forecast: You are a forecasting specialist. Task: produce a 3-month demand forecast by listing. Context: incorporate seasonality and promo effects. Output: concise forecast with confidence intervals.
32. Lead time optimization: Analytics lead. Task: reduce supplier lead time impact on top 10 listings. Context: compute impact of 1- to 2-week lead time changes. Output: action plan and metrics.
33. Channel attribution: Role: attribution analyst. Task: assign last-click vs multi-touch attribution weights for Etsy marketing. Context: provide a recommended model and rationale. Output: short description and table of weights.
34. Inventory valuation: You are an operations accountant. Task: value current inventory for financial reporting. Context: use FIFO or weighted average. Output: summary with potential write-down risk.
35. Refund reason trends: Customer service analyst. Task: identify top refund reasons and potential fixes. Context: group by product and reason. Output: prioritized action list.
36. Listing title optimization: Role: SEO content strategist. Task: audit titles for relevance and keyword coverage. Context: score titles 0-100 and propose rewrites. Output: scoring table and rewritten title options.
37. Photo quality score: Photography analyst. Task: rate listing images on clarity, lighting, consistency. Context: provide scoring rubric and improvement tips. Output: per-listing photo score and actionable edits.
38. Description completeness: Content auditor. Task: evaluate listing descriptions for completeness and clarity. Context: check sections, measurements, materials. Output: yes/no checklist and improvement plan.
39. Tag optimization: Tag strategy analyst. Task: assess tag relevance and diversity for top listings. Context: provide tag set with coverage suggestions and performance note. Output: per-listing tag recommendations.
40. Customer questions: Support insights analyst. Task: summarize common customer questions about top listings. Context: extract questions and provide canned answers. Output: FAQ-ready Q&A set.
41. Sales funnel health: Funnel analyst. Task: measure funnel health from impression to purchase for last 60 days. Context: provide drop-off points and mitigation ideas. Output: concise funnel snapshot.
42. Promo sensitivity: Promotions strategist. Task: analyze sensitivity to discount depth for 5 items. Context: compare 10%, 20%, and 30% promos. Output: table of uplift and margin impact.
43. Ad copy effectiveness: Copywriter analytics role. Task: evaluate Etsy ad copy variants for click-through and conversions. Context: provide top-performing phrasing and a plan for iteration. Output: findings and next steps.
44. Checkout abandonment by device: UX analyst. Task: break down checkout abandonment by device last 30 days. Context: desktop vs mobile vs tablet. Output: device-specific action list.
45. Return rate drivers: Operations researcher. Task: identify drivers of product returns and propose countermeasures. Context: segment by product and reason. Output: root-cause brief and actions.
46. Best sellers map: Merchandising analyst. Task: map top 20 listings by revenue and margin. Context: include seasonality note. Output: compact map plus two merchandising ideas.
47. Pricing elasticity test: Price strategy analyst. Task: design a test to measure elasticity for a bundle listing. Context: controls, samples, metrics. Output: test plan and decision rule.
48. Listing stability score: Quality assurance analyst. Task: compute stability score across listings based on update frequency and data freshness. Context: thresholds and remediation plan. Output: stability report.
49. Cohort retention detail: BI lead. Task: provide 3-month retention by cohort with revenue per cohort. Context: show trend and actionable note. Output: chart-ready text description.
50. Delivery performance: Logistics analyst. Task: evaluate delivery times to customers and impact on satisfaction. Context: provide median, percentile, and improvement plan. Output: brief operational insight.
51. Gift card impact: Finance analyst. Task: assess impact of gift card sales on revenue stability. Context: include fee impact and redemption rate. Output: concise financial note.
52. Bundle performance: Merchandising strategist. Task: analyze bundle listings for uplift versus individual items. Context: provide add-on recommendations and price points. Output: brief verdict and plan.
53. Product lifecycle stage: Product manager role. Task: assign lifecycle stages to top listings and suggest actions per stage. Context: collect signals and next steps. Output: lifecycle matrix.
54. Negative feedback patterns: CX analyst. Task: categorize negative feedback by issue type and listing. Context: highlight recurring problems and fixes. Output: actionable insights.
55. Seasonal inventory plan: Operations planner. Task: draft a seasonal inventory plan for upcoming holiday season. Context: target stock levels and reorder points. Output: concise plan with risk notes.
56. Revenue per visit: Analytics role. Task: compute revenue per visit by channel last 90 days. Context: compare channels and provide optimization cues. Output: quick-hit insights.
57. AOV optimization: Pricing strategist. Task: propose tactics to raise average order value without alienating customers. Context: bundles, freebies, tiered shipping. Output: list of 3 concrete tactics.
58. Churn reduction plan: Retention specialist. Task: craft a 90-day plan to reduce buyer churn. Context: include triggers, messages, and success metrics. Output: plan outline.
59. Top keyword gaps: SEO analyst. Task: identify keyword gaps between listing content and top search terms. Context: propose two optimization paths per gap. Output: prioritized list.
60. Shipping option impact: Logistics analyst. Task: evaluate impact of shipping speed options on conversion. Context: include cost and perceived value. Output: recommendation brief.
61. Listing diversity score: Content strategist. Task: measure diversity of listing assets (photos, videos, variants). Context: provide score and two enhancement ideas. Output: asset diversity report.
62. Promotions calendar: Campaign planner. Task: build 3-month promotions calendar aligned to sales goals. Context: include timing, discount levels, and expected lift. Output: calendar outline.
63. Customer satisfaction trend: CX analyst. Task: track customer satisfaction metrics over 6 months. Context: NPS, CSAT, sentiment. Output: trend summary and 2 improvement actions.
64. Listing profitability drilldown: Finance analyst. Task: drill down profitability by listing category and supplier. Context: show margins and recommended cuts. Output: concise drilldown report.
65. Traffic-to-order path: Funnel analyst. Task: map user journey from first visit to order including drop-offs. Context: identify biggest friction points. Output: narrative path with 2 fixes.
66. Customer segment actions: Market insights analyst. Task: propose actions for top 3 customer segments to increase loyalty. Context: include offers and messaging. Output: brief action plan.
67. Listing image A/B plan: UX researcher. Task: design an A/B plan for listing images to maximize CTR. Context: specify variants, sample sizes, and success criteria. Output: test outline.
68. Cross-sell opportunities: Merchandising strategist. Task: identify cross-sell opportunities across top listings. Context: provide pairings and rationale. Output: recommended bundles.
69. Marketplace trend alignment: Strategist. Task: align Etsy shop strategy with overall marketplace trends. Context: map trends to listings and campaigns. Output: strategic notes.
70. Product launch plan: Product manager. Task: plan a new listing launch with pre-launch, launch, and post-launch activities. Context: milestones and metrics. Output: launch playbook.
71. Shipping cost exposure: Finance analyst. Task: quantify impact of shipping costs on conversion for top listings. Context: scenarios for free shipping thresholds. Output: concise insights.
72. Inventory aging report: Operations analyst. Task: highlight aged inventory risk and write-down likelihood. Context: ages by listing and value. Output: brief aging snapshot.
73. Competitor price mapping: Competitive intelligence analyst. Task: map competitor prices for top 5 similar items and suggest price positioning. Output: summary with two moves.
74. Order value distribution: Analytics lead. Task: describe distribution of order values last quarter. Context: outliers, median, and range. Output: compact distribution story.
75. Refund risk scoring: Customer service analyst. Task: score each listing by likelihood of refunds and suggest preventive actions. Output: risk matrix and mitigations.
76. Coupon vs loyalty impact: Promotions analyst. Task: compare short-term coupon effects against loyalty program impact on repeat purchases. Output: side-by-side summary.
77. Social proof impact: Brand analyst. Task: quantify impact of social proof (reviews, testimonials) on conversion for top listings. Output: attribution sketch and optimization idea.
78. Product variant performance: Variant analytics lead. Task: evaluate performance of different color/size variants. Context: include revenue per variant and stock levels. Output: ranking and next-step actions.
79. Shipping carrier performance: Logistics manager. Task: compare carrier performance by on-time rate and damage rate. Context: top items only. Output: carrier scorecard.
80. Tax and pricing compliance: Compliance analyst. Task: ensure pricing complies with tax rules in key regions. Context: flag potential issues. Output: quick compliance note and fixes.
81. Listing quality checklist: QA auditor. Task: provide a standard quality checklist for new listings. Context: include all essential sections and sample data. Output: checklist with scoring.
82. Seasonal risk flags: Risk manager. Task: identify seasonal risks to sales and supply. Context: provide mitigation steps. Output: risk brief and contingency plan.
83. SKU-level forecasting: Forecasting analyst. Task: create SKU-level demand forecast with confidence intervals. Context: top SKUs only. Output: forecast table.
84. Cart value boosters: Growth strategist. Task: propose 3 tactics to increase cart value without deterring buyers. Output: list of tactics with expected lift.
85. Product image metadata: SEO data specialist. Task: audit image alt text and metadata for accessibility and SEO. Output: improvement plan for top listings.
86. Return prevention actions: Operations manager. Task: implement actions to reduce returns by top reasons. Output: actions and expected outcomes.
87. Shipping speed messaging: Copywriter. Task: craft messaging that sets expectations for shipping times. Output: 3 variants for product pages.
88. Green packaging impact: Sustainability analyst. Task: quantify impact of eco-friendly packaging on conversions. Output: brief impact statement and suggested actions.
89. Wholesale channel readiness: Sales enablement analyst. Task: assess readiness of listing for wholesale inquiries. Output: checklist and starter pricing notes.
90. Giftable packaging appeal: Brand strategist. Task: test impact of gift-ready packaging on gift purchase rate. Output: experiment plan and expected uplift.
91. Localization impact: Localization analyst. Task: evaluate performance differences by language region. Output: regional ranking and localization tips.
92. Abandoned checkout reengagement: Lifecycle marketer. Task: craft reengagement sequence for cart abandoners. Output: message cadence and offer plan.
93. Product tag taxonomy: Data architect. Task: create a scalable tag taxonomy for listing categories. Output: taxonomy with examples.
94. Shop-wide goal tracking: Performance manager. Task: define 3 quarterly KPI goals and how to track them. Output: goal sheet and update procedures.
95. Customer feedback loop: Voice of customer lead. Task: design a closed-loop process to act on feedback. Output: process diagram and responsibilities.
96. Automation opportunities: Operational efficiency analyst. Task: identify 3 automation ideas for reporting. Output: automation plan with required data feeds.
97. Model risk management: Risk analytics role. Task: document data quality checks and model validation steps for KPIs. Output: validation plan.
98. Data freshness policy: Data governance lead. Task: set data refresh cadence for KPI dashboards. Output: policy brief and monitoring plan.
99. Executive dashboard summary: BI director. Task: craft a 1-page executive dashboard view for Etsy KPI shop performance. Context: include revenue, profit, traffic, and orders. Output: summary text with bullets.
100. Future-ready KPI set: Analytics strategist. Task: propose a forward-looking KPI set for Etsy shop scaling over the next year. Context: align with growth goals and risks. Output: KPI list and rationale.

Best Practices

• Reuse prompts with the same data structure across different shops to standardize reporting.
• Annotate outputs with business context, thresholds, and action items for clarity.
• Keep prompts focused on specific KPIs to avoid overwhelming dashboards with noise.
• Validate Claude outputs against your source data routinely to ensure accuracy.
• Apply safety checks to prevent misleading conclusions from small sample sizes.

Common Mistakes to Avoid

• Using too many metrics at once, which overwhelms dashboards and reduces actionability.
• Ignoring data quality issues in source data, leading to unreliable prompts.
• Forgetting to define exact date ranges or sample sizes, causing inconsistent results.
• Relying on outputs without cross-checking with your shop analytics and experiments.
• Neglecting to specify output format, which makes results harder to paste into dashboards.

FAQ

What is KPI and dashboard optimization for Etsy sellers?

KPI and dashboard optimization helps Etsy sellers track performance, identify bottlenecks, and make data-driven decisions to improve sales, traffic, and profitability.

How should I begin using these Claude prompts?

Start with a few prompts focused on core metrics like sales, traffic, and conversion, then expand to more advanced prompts as your data collection matures.

Can I customize prompts to my shop niche?

Yes. Replace placeholders with your niche, products, and channels, and add constraints that reflect your data realities.

How often should I refresh dashboard data?

Aim for at least daily updates for dynamic metrics like sales and traffic, with full KPI audits monthly.

What outputs should I expect from these prompts?

Clear KPI summaries, trend insights, actionable recommendations, and compact tables or bullet-point lists ready for dashboards.

Are these prompts safe for sensitive data?

Yes. They are designed to summarize data without exposing PII and can be run on aggregated metrics.