Prompt Details
Model
(claude-4-6-sonnet)
Token size
1,103
Example input
[DATASET]: Month,Category,Units Sold,Revenue ($),Returns,Region Jan 2023,Electronics,1200,84000,45,US Jan 2023,Clothing,980,29400,120,EU Jan 2023,Home & Garden,540,21600,18,APAC Feb 2023,Electronics,1350,94500,52,US Feb 2023,Clothing,870,26100,98,EU Feb 2023,Home & Garden,610,24400,22,APAC Mar 2023,Electronics,1100,77000,61,US Mar 2023,Clothing,1040,31200,134,EU Mar 2023,Home & Garden,480,19200,15,APAC
[GOAL]: Identify which product categories and regions are driving revenue growth and which are declining
[FORMAT]: Executive report with tables and bullet points
[AUDIENCE]: E-commerce business owner with no technical background
Example output
E-commerce performance report
Electronics Β· Clothing Β· Home & Garden | Jan β Mar 2023
Key metrics at a glance
Total revenue
$407,400
across Q1 2023
Total units sold
8,170
3 categories Β· 3 regions
Total returns
565
6.9% return rate
Best category
Electronics
64% of all revenue
Monthly revenue by category ($)
Electronics
Clothing
Home & Garden
Units sold & return rate by category
Revenue share by region (all months combined)
US β Electronics
EU β Clothing
APAC β Home & Garden
Top 5 actionable insights
1
Electronics drives nearly two-thirds of all revenue
Electronics generated $255,500 over Q1 β 64% of total revenue β with a low 4.4% return rate. However, revenue dipped 18% in March ($94.5K β $77K), a red flag worth investigating.
Action: Investigate the March Electronics dip β was it a stock-out, a competitor promotion, or seasonal softening? Protect this category first.
2
Clothing has a dangerously high return rate β 12.4%
Clothing returns average 117 items per month versus only 52 for Electronics. This erodes margins and signals sizing, quality, or expectation issues in the EU market.
Action: Audit EU Clothing returns for root cause (sizing charts, product photos, fabric quality). A 50% reduction in returns could recover ~$8,700/month in lost inventory costs.
3
Home & Garden is shrinking β two months of decline
Units sold peaked in February (610) then fell to 480 in March, the lowest of Q1. Revenue also fell back to January levels. This is the smallest category but shows a consistent downward trend.
Action: Evaluate whether APAC Home & Garden needs a targeted promotion or a product refresh heading into Q2 β or consider redistributing budget to Electronics.
4
Clothing revenue shows a recovery signal in March
After dropping to $26,100 in February, Clothing revenue bounced back to $31,200 in March β the highest of the quarter. This is encouraging but return rates also spiked to 134 in the same month.
Action: Ride the revenue rebound but pair it with stricter QA or clearer sizing guidance to prevent the return rate from cancelling out the gain.
5
US is your most valuable region by a wide margin
The US (Electronics) contributes $255,500 β more than EU and APAC combined. Yet it's also the most volatile, with a $17,500 swing between best and worst months.
Action: Diversify revenue by growing EU Clothing and APAC Home & Garden, so that a single bad Electronics month has less impact on overall performance.
Risks & limitations
Only 9 data rows covering 3 months β trends may not be statistically meaningful. Broader conclusions require at least 6β12 months of data.
Return dollar values are not provided; return rate is calculated on unit count only and may understate true financial impact if returned items differ in value.
Each region sells only one category (US = Electronics, EU = Clothing, APAC = Home & Garden). It's impossible to separate regional effects from category effects with this data.
No cost or margin data is included. A high-revenue category may still be low-profit if costs are high.
No year-over-year comparison. Q1 2023 performance cannot be assessed as strong or weak without a prior benchmark.
Executive summary
Your business generated $407,400 in Q1 2023 across three categories and three regions. Electronics (US) is your star performer, contributing 64% of all revenue with the lowest return rate β but it showed a concerning 18% revenue drop in March that needs immediate investigation. Clothing (EU) is recovering in revenue but carries a 12.4% return rate that is quietly eating into your margins; fixing returns here is your fastest lever for improving profitability. Home & Garden (APAC) is the smallest and most stagnant segment β it needs either a strategic push or a reallocation of resources. Your biggest business risk right now is over-reliance on a single category and region: if Electronics stumbles, there is no strong backup. Diversifying category performance across regions should be your medium-term strategic priority.
Here's your complete analytical report. Let me walk you through what matters most.
Data overview β The dataset covers 9 records across JanuaryβMarch 2023, with three product categories (Electronics, Clothing, Home & Garden) each tied to one region (US, EU, APAC respectively). Data quality is clean with no missing values, though the one-category-per-region design limits how much we can separate "regional" from "category" performance.
Key statistics summary
CategoryTotal RevenueTotal UnitsAvg Return RateTrendElectronics (US)$255,5003,6504.4%β Feb peak, β Mar dropClothing (EU)$86,7002,89012.4%β Feb dip, β Mar recoveryHome & Garden (APAC)$65,2001,6303.2%β Feb bump, β Mar declineTotal$407,4008,1706.9%
Trend highlights
Electronics peaked in February (+12.5% vs Jan) then fell sharply in March (β18.5%) β the single most important anomaly in the data.
Clothing had the most volatile pattern: revenue fell in February then rebounded strongly in March, but returns climbed to their highest point (134) in that same month.
Home & Garden showed a brief mid-quarter surge then retreated below January levels β a soft declining arc.
The five insights, risk flags, and executive summary are all built into the interactive report above. If you'd like to drill into any specific segment, explore margin implications, or model what a return-rate reduction would mean in dollar terms, just ask.
By purchasing this prompt, you agree to our terms of service
CLAUDE-4-6-SONNET
Raw data sitting in spreadsheets β no insights, no decisions. This prompt turns any CSV, Excel table, survey or financial export into a full analyst report: trends, segments, top 5 insights, risk flags & executive summary.
What You'll Get:
πΉ Data overview & quality check
πΉ Key metrics & trend analysis
β
Top 5 actionable insights
β
Segment breakdown
β
Executive summary tailored to your audience
...more
Added over 1 month ago
- Reviews for this prompt (1)
