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
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
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.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Audit driver-based models for compounding optimism bias
Expose subtle, compounding growth assumptions across pipeline stages and conversion metrics. Use this during quarterly budget reviews and board deck prep.
Build three scenarios for revenue and demand forecasts
Generate structured best, base, and worst-case forecast models to prepare for demand swings. Use this during annual planning or runway updates.
Compare cumulative customer lifetime value across monthly cohorts
Spot whether newer customer groups spend faster or retain better than older cohorts. Use this to audit acquisition quality over time.
Diagnose circular loops and friction steps in signup funnels
Map repetitive back-and-forth navigation and error loops within onboarding flows. Use this to pinpoint confusing validation rules and navigation traps.
Estimate potential revenue recovery across funnel drop-off points
Model the financial impact of repairing conversion drop-offs across your funnel. Use this to prioritize engineering fixes by projected dollar value.
Evaluate past forecast variances to set accurate targets
Analyze past forecast misses to identify systematic over- or under-projection patterns. Use this before locking in next quarter's revenue or operational targets.
- Isolate regional or platform drivers behind KPI drops
- Rank survey satisfaction drivers by loyalty impact
- Sanity check revenue projections against past baselines
- Segment conversion funnel drop-offs by device and marketing channel
- Triage sudden metric spikes for event tracking bugs
- Analyze support ticket trends by category