Find top product revenue and margin drivers

Pinpoint which products drive the bulk of sales and actual profit margin. Use this to focus inventory spend and marketing budget on top performers.

You getTop 5 Revenue and Margin Drivers, hidden Opportunities and margin Risks

Prompt

Prompt
Act as an ecommerce merchandise analyst. Analyze the raw sales data provided below to identify the primary revenue and margin drivers.

Rules:
- Rank the top contributing items or categories by total revenue and by estimated gross profit margin.
- Highlight any high-volume products that show dangerously low profit contributions.
- Identify low-volume items with unusually high margins worth promoting.
- Base all findings strictly on the numbers provided; do not invent missing cost figures.

Output format:
1. Top 5 Revenue and Margin Drivers (table: Item/Category, Revenue Share, Margin Share, Takeaway)
2. Hidden Opportunities (bullet points on under-promoted high-margin items)
3. Margin Risks (bullet points on volume drivers with weak profitability)
4. Recommended Next Actions

Sales data is below:

Example output

Example for: Q3 product catalog sales export

1. Top 5 Revenue and Margin Drivers
Item/CategoryRevenue ShareMargin ShareTakeaway
Ergonomic Desk Chair34%41%Core profit engine; protected by high direct margins.
Standing Desk Frame28%19%Strong top-line revenue, but freight costs compress realized margin.
Monitor Arm Mount14%22%High-margin accessory that attaches frequently to chair orders.
Desk Mat Pad9%11%Consistent basket builder with stable profit margins.
Cable Spine Organizer5%7%Small absolute volume, but 65% gross margin.
2. Hidden Opportunities
  • Monitor Arm Mount: Generates 22% of total margin on only 14% of revenue. Bundle this actively on the Standing Desk checkout page.
  • Cable Spine Organizer: Converts well when viewed and carries negligible shipping weight. Feature as a default add-on.
3. Margin Risks
  • Standing Desk Frame: Accounts for nearly a third of revenue but under-indexes heavily on margin due to inbound carrier surcharges. Avoid discounting this SKU during promotional periods.
4. Recommended Next Actions
  • Test an automated bundle discount that combines the Desk Frame with the high-margin Monitor Arm to lift blended cart margins.
  • Review carrier rates for heavy parcel shipments to recover margin on desk frames.
Written by AI from this prompt. Your results will vary.

Paste your sales table or CSV export directly after the prompt in ChatGPT, Claude or Gemini. For a deeper follow-up, ask the model to recommend discount limits for the bottom margin performers.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis