Ecommerce Metrics Interpreter: Turn Your Dashboard Into a Priority List
Your dashboard has dozens of numbers, and most sellers cannot tell which ones actually matter. Traffic goes up and you celebrate, then miss that conversion just dropped. That is the classic trap. The surface question is what do these numbers say. The real question is which of these numbers is warning you about a fire, and what should you check first tomorrow morning. This prompt takes your sales, traffic, and conversion data, reads the trend, flags the anomalies, and hands you a priority list. It turns a wall of numbers into a single next-action list.
You are an ecommerce analyst and growth advisor. Your expertise: reading raw sales and traffic data to see which metric is signaling a real problem. Your job is not to summarize the numbers nicely. It is to read the trend, flag the anomaly, and hand the seller a priority list that says check this first tomorrow. I will give you: - [PERIOD AND NUMBERS: visits, orders, conversion rate, average order value, returns, ad spend, whatever you have] - [COMPARISON PERIOD IF AVAILABLE: same numbers from last month or last week] - [CONTEXT IF AVAILABLE: new campaign, price change, new product, ad changes] GIVE THE OUTPUT IN THIS ORDER, WITH THESE EXACT HEADINGS: ═══ TREND READING ═══ What the numbers say together, not one by one but as a relationship (example: traffic up plus conversion down means what). ═══ ANOMALIES ═══ Out of the ordinary signals that need attention. For each one, the likely mechanism (why it may have happened). ═══ PRIORITY LIST: CHECK THIS FIRST ═══ A ranked list of 3 to 5 items. The highest impact or most urgent one goes on top. Each item is a concrete action. ═══ MISSING DATA WARNING ═══ Say which numbers or details you would need for a clearer diagnosis. RULES: - Base everything only on the numbers I give you. Do not invent an industry benchmark you do not have. - Explain the mechanism before slapping a good or bad label on a number. - Do not suggest changing many variables at once, remind me of single-variable test discipline. - If the numbers are contradictory or incomplete, say so honestly, do not present a guess as a certainty. - Write in English, plain and action focused.
How to use it
- Step 1: Paste your raw numbers, the more complete the better. Period, visits, orders, conversion rate, average order value, returns, ad spend. If you have a comparison period (last month, last week), always include it.
- Step 2: Focus on the anomalies and priority list sections in the output. What matters is not whether a number is good or bad, it is which one needs urgent attention.
- Step 3: Start with the first item on the priority list, change one variable, then measure again. Change five things at once and you will never know what actually worked.
Example / tip
Input: This month 8,000 visits, 160 orders, conversion 2%, average order value $420, returns 9%; last month 6,500 visits, 170 orders, conversion 2.6%, returns 4%. AI output (shortened): Anomaly, traffic went up but conversion and orders went down, and returns doubled. That combination signals a wrong-audience or expectation-mismatch problem. Check this first, read the return reasons (size, quality, or misleading images), then check what changed in last month's traffic source, then review the product page images last.
Usage example
Copy the prompt as is, fill in the bracketed fields for your own business, and paste it into ChatGPT or Claude. The more concrete your input, the more useful the output. Take the first draft, ask for a one-sentence fix on whatever you don't like, then give it a final pass in your own voice.
When not to use it
Don't force it if you have no real input to work with. A prompt doesn't fill an empty field with data, it organizes and speeds up what you already know. Never publish the output unchecked; AI sometimes produces a claim that sounds right but is wrong or made up. Always verify anything that needs proof yourself: numbers, prices, guarantees.
Output quality checklist
- Is the output specific to your input, or generic filler that fits any business? If it's generic, run it again with more concrete input.
- Does every number, ratio, or claim have something backing it? Delete the unbacked ones or soften them honestly.
- Does it sound like you? Simplify the cliches and inflated lines in your own voice.
- Does it give one clear next step? If the reader knows what to do, the output did its job.
