📁 E-commerce
Ecommerce Business Monthly Review: Store Numbers to Fix List
Paste two months of store numbers, top products, return reasons, and customer messages to get a monthly ecommerce review with the math and a ranked fix list.
0Reviews
Prompt
Act as an ecommerce operations manager who runs the monthly review for a small online store: you rebuild the core numbers from the owner's own exports, compare this month with last month, connect the changes to returns and customer messages, and turn it into a short fix list the owner can finish in the time they have. Inputs: - What the store sells, the platform, how long it has been open, and where it ships from: [StoreBasics] - This month and last month: sessions, orders, revenue, refunded orders and refund dollars, ad spend, and product cost (COGS): [MonthlyNumbers] - Top products this month with units sold and units returned: [TopProducts] - Return reasons and complaints, with counts per product: [ReturnReasons] - A few real customer questions, emails, or reviews, pasted as written: [CustomerMessages] - Hours per week and money available for fixes next month: [Capacity] Generate: 1. Monthly numbers table for both months: conversion rate (orders / sessions), average order value (revenue / orders), refund rate (refunded orders / orders), ad cost per order (ad spend / orders), and contribution after product cost, refunds, and ads (revenue minus refund dollars minus COGS minus ad spend). Show each calculation and the change from last month. 2. What changed: the three biggest moves in the monthly review, each with a possible cause taken from ReturnReasons or CustomerMessages, labeled as a hypothesis to test. 3. Product review: return rate per product in TopProducts against the store-wide return rate, and which products pull the ecommerce business numbers down. 4. Themes: group ReturnReasons and CustomerMessages into themes with counts, and quote one customer line per theme. 5. Fix list ranked by expected impact and effort that fits Capacity: what to change, which store number it should move, and how to check it next month. 6. Page and policy edits: the exact sentence to add or replace on a product page, FAQ, or shipping and returns page. 7. Next month watch list: three numbers to track, with this month's value as the baseline. Rules: - Use only the numbers in the inputs. No industry averages, benchmarks, or invented conversion rates. - Round money to cents and percentages to one decimal place, and recheck every total. - Label every cause as a hypothesis unless the inputs prove it. - If a number needed for a calculation is missing, write MISSING and skip that line instead of guessing.
Instructions
Export last month's and this month's numbers from your store admin (sessions, orders, revenue, refunds, ad spend, product cost), fill in the brackets, and run it in ChatGPT, Claude, or Gemini. It only uses the numbers you paste and does not look up benchmarks. Recheck the math before you change prices or ad budgets. This is a planning aid, not financial or tax advice.
Generated Output
This image was generated using the prompt above.

Examples
Example Input
StoreBasics: Shopify store selling linen kitchen aprons and tea towels, open 14 months, ships from Portland, Oregon. MonthlyNumbers: September: 8,200 sessions, 164 orders, $6,232.00 revenue, 12 refunded orders worth $498.56, $1,148.00 ad spend, $1,968.00 COGS. August: 7,400 sessions, 170 orders, $6,290.00 revenue, 6 refunded orders worth $251.60, $920.00 ad spend, $2,040.00 COGS. TopProducts: Natural linen apron: 70 sold, 7 returned. Charcoal linen apron: 40 sold, 1 returned. Tea towel set of 2: 90 sold, 4 returned. ReturnReasons: Natural apron: "straps shorter than expected" x5, "color more beige than the photos" x2. Charcoal apron: "changed my mind" x1. Tea towels: "loose stitching on arrival" x3, "arrived too late for a gift" x1. CustomerMessages: "Do the neck straps adjust? I'm 6'1"." / "Is the natural color white or oatmeal?" / "Ordered Sept 3, arrived Sept 14, missed the birthday." Capacity: 6 hours a week and $300 next month.
Example Output
1. MONTHLY NUMBERS (September vs August) - Conversion: 164 / 8,200 = 2.0% vs 170 / 7,400 = 2.3%. Down 0.3 points. - Average order value: 6,232.00 / 164 = $38.00 vs 6,290.00 / 170 = $37.00. Up $1.00. - Refund rate: 12 / 164 = 7.3% vs 6 / 170 = 3.5%. More than doubled. - Ad cost per order: 1,148.00 / 164 = $7.00 vs 920.00 / 170 = $5.41. Up $1.59. - Contribution: 6,232.00 - 498.56 - 1,968.00 - 1,148.00 = $2,617.44 vs 6,290.00 - 251.60 - 2,040.00 - 920.00 = $3,078.40. Down $460.96. 2. WHAT CHANGED - Sessions rose by 800 but orders fell by 6. Hypothesis: the extra $228.00 of ad spend brought visitors who were less ready to buy. - Refunded orders went from 6 to 12. Hypothesis: the natural apron's strap length and color are not clear on its page. - Contribution fell $460.96, mostly from refunds (+$246.96) and ad spend (+$228.00). 3. PRODUCT REVIEW (store-wide return rate 12 / 200 units = 6.0%) - Natural linen apron: 7 / 70 = 10.0%. Above store rate. - Tea towel set: 4 / 90 = 4.4%. Below store rate, but 3 of 4 returns are a quality issue. - Charcoal linen apron: 1 / 40 = 2.5%. 4. THEMES - Fit (5 returns, 1 question): "Do the neck straps adjust? I'm 6'1"." - Color (2 returns, 1 question): "Is the natural color white or oatmeal?" - Stitching quality (3 returns): "loose stitching on arrival". - Shipping time (1 return, 1 message): "arrived Sept 14, missed the birthday." 5. FIX LIST 1) Natural apron page: add strap length and whether it adjusts, plus one photo next to the charcoal apron in daylight. Moves: natural apron return rate (10.0%). About 2 hours, $0. 2) Tea towels: check stitching on every set before packing and send the 3 returned sets back to your maker with photos. Moves: tea towel returns (4). About 1 hour a week. 3) Ads: cap September's extra $228.00 and move the rest to the ad that sold the most orders. Moves: ad cost per order ($7.00). About 1 hour, inside the $300. 4) Shipping: state your real delivery window on every product page. Moves: late-gift returns (1). 30 minutes. 6. PAGE AND POLICY EDITS - Natural apron: "Color: natural oatmeal, a warm beige, not white. Neck strap: [length] inches, [adjustable or fixed]." Fill in the brackets with your own measurement. - Shipping line: "Orders ship from Portland, Oregon. Allow [your real window] for delivery; order early for gifts." 7. WATCH NEXT MONTH - Refund rate: baseline 7.3%. - Ad cost per order: baseline $7.00. - Natural apron return rate: baseline 10.0%.