AgentSales & profitability

Gross margin opportunity score

Score out of 100 across COGS, returns, fees, discounting, and fulfilment — benchmarked against your industry, with the dollar opportunity in each.

Works with
ClaudeChatGPTAny MCP-compatible AI tool
Requires
StoreHero MCPShopify
Get the prompt
Example chat in Claude. You ask: "Run the Gross margin opportunity score agent for month to date". Claude reads your StoreHero data and answers: Contribution margin is up 8% on last year, month to date. Week 3 dipped when discounting rose. It adds an interactive example chart, Weekly contribution margin vs last year, with example data you can switch below.
Weekly contribution margin vs last yearExample

Example, Contribution margin: $83.5k month to date, +8% vs last year

  • W1: $18.2k (last year $16.9k)
  • W2: $21.4k (last year $19.0k)
  • W3: $19.8k (last year $20.5k)
  • W4: $24.1k (last year $21.2k)

Dashed line: last year

Week 1: $18.2k vs $16.9k last year.

The prompt

How to run it

Paste it into a new chat in Claude or ChatGPT and you get the answer straight away.

Use the StoreHero MCP to do the following analysis. Always anchor the answer in real StoreHero data, not platform-reported metrics.

Give me a gross margin opportunity report. Score the business out of 100 overall, then score each of the following components against the StoreHero benchmark for this industry and revenue band:

1. Product cost (COGS as % of net sales)
2. Returns rate and return cost as % of revenue
3. Transaction fees as % of net sales
4. Discounting level (% of revenue lost to discounts)
5. Shipping and fulfilment cost per order

For each component, give: (1) the score out of 100, (2) the actual % vs the benchmark %, (3) the $ opportunity available if the brand moved to benchmark median over the next 12 months, (4) a specific concrete action to close the gap (e.g. "renegotiate Stripe rate", "move to 3PL with sub-$6/order rate", "tighten discount stacking").

Apply a traffic light per component: green (at or above benchmark), amber (within 20% of benchmark, room to improve), red (significantly below benchmark, priority fix).

End with the single biggest dollar opportunity — the one component where closing the gap to benchmark would unlock the most contribution margin over a year.

At the bottom of your answer, render an inline visual summary: a single overall score card (large number out of 100), plus five component score cards each showing component score, current %, benchmark %, and $ opportunity. Place text commentary alongside the visuals. Use the Spend Advisor tool to suggest what to explore next.

Get the full prompt

Enter your email to see every prompt in full and copy it in one click. It unlocks the whole library.

See our privacy policy.

How to use a skill

New to skills? It takes three steps and a few minutes: connect StoreHero once, copy a skill into Claude or ChatGPT, and ask.

  1. Connect StoreHero to Claude or ChatGPTAdd the StoreHero MCP connector once. It works with Claude, ChatGPT and any other tool that supports MCP. Setup guide
  2. Pick a prompt and copy it into ClaudeOpen one, press Copy prompt (or download the file) and paste it into a new chat.
  3. AskIt pulls your live StoreHero data and gives you the analysis in minutes. Ask follow-up questions in the same chat.

Run every prompt on your own numbers.

Connect your store to StoreHero and the whole library works on your live profit data.