Something went wrong!
Hang in there while we get back on track
Top Products by Revenue Analysis
Analyzes quarterly product performance showing revenue rankings, market share percentages, YoY trends, and momentum indicators with actionable recommendations for portfolio optimization.
Input
What you provide to the skill
I have a CSV file at /tmp/sales_data.csv with columns: date, product_name, quantity, revenue, customer_segment, region. What are the top 5 products by revenue this quarter?
Output
What the skill generates for you
TOP 5 PRODUCTS BY REVENUE - Q4 2025 (Oct 1 - Dec 4)
Direct Answer: DataFlow Enterprise leads at $15.3M (24.4% of Q4 revenue), followed by Enterprise Gateway ($11.0M), SecureVault Plus ($9.8M), CloudSync Pro ($7.9M), and AnalyticsPro Suite ($7.5M).
PERFORMANCE SUMMARY
| Product | Revenue | % Total | Units | Transactions | Avg $/Trans |
|---|---|---|---|---|---|
| DataFlow Enterprise | $15,304,148 | 24.4% | 6,109 | 482 | $31,751 |
| Enterprise Gateway | $11,036,160 | 17.6% | 3,348 | 269 | $41,027 |
| SecureVault Plus | $9,815,717 | 15.6% | 5,161 | 416 | $23,595 |
| CloudSync Pro | $7,937,256 | 12.6% | 6,152 | 503 | $15,780 |
| AnalyticsPro Suite | $7,510,472 | 12.0% | 4,737 | 373 | $20,135 |
| TOTAL (TOP 5) | $51.6M | 82.2% | — | — | — |
Quarter Metrics:
- Total Q4 Revenue: $62.8M
- Top 5 drive 82.2% of all revenue
- Average daily revenue from Top 5: $794K
- 12 total products in portfolio
KEY INSIGHTS
1. DATAFLOW ENTERPRISE - CLEAR WINNER WITH ACCELERATING GROWTH
- #1 position with $15.3M (24.4% of total)
- +14.5% momentum (second half vs first half of quarter)
- Highest volume seller (6,109 units) with strong $31K average transaction
- CRITICAL: Only top-5 product showing double-digit growth acceleration
2. ENTERPRISE GATEWAY - HIGH-VALUE BUT DECELERATING
- #2 at $11M with highest average transaction value ($41K)
- Premium positioning attracting large enterprise deals
- CONCERN: -3.1% momentum decline in recent weeks
- Lower volume (3,348 units) suggests complex sales cycle
3. MOMENTUM DIVERGENCE - WATCH SLOWING PRODUCTS
- CloudSync Pro, AnalyticsPro Suite, and Enterprise Gateway all showing -2% to -3% slowdown
- SecureVault Plus maintaining +8.9% growth momentum
- Market may be shifting preference toward DataFlow and SecureVault
4. TOP PRODUCT CUSTOMER PROFILE (DataFlow Enterprise)
- SMB segment drives 51% of revenue ($7.8M)
- Strong North America concentration (37.5%)
- Well-distributed across Enterprise (28.4%) and Individual (20.7%)
- Geographic diversification: Europe 30%, APAC 18%
RECOMMENDATIONS
IMMEDIATE (Next 30 Days):
- Double down on DataFlow Enterprise - Only product with strong positive momentum. Increase marketing spend, expand sales team coverage, create customer success stories.
- Investigate Enterprise Gateway decline - Despite $41K transaction size, -3.1% slowdown suggests pricing resistance or competitive pressure. Conduct win/loss analysis.
STRATEGIC (Q1 2026):
3. Segment-specific campaigns - DataFlow’s SMB success (51% revenue) shows opportunity. Create SMB-focused bundles for other products.
4. Geographic expansion - 68% of revenue from North America/Europe. Accelerate APAC (18%) and LATAM (10%) go-to-market.
5. Product rationalization - Top 5 drive 82% of revenue. Consider sunsetting low performers to focus resources.
RISK ALERT: Three of five top products showing negative momentum. If trend continues, Q1 2026 could see 5-8% revenue shortfall. Urgent pipeline review recommended.
About This Skill
Upload business data and ask questions in plain English to get instant insights, visualizations, and trend analysis without BI tools or SQL knowledge.
View Skill DetailsMore Examples
Customer Segment Profitability Analysis
Identifies most profitable customer segments with margin analysis, profit-per-customer calculations, regional breakdowns, and specific acquisition budget allocation recommendations with expected ROI.
Regional Sales Trends with MoM and YoY Growth
Comprehensive regional performance analysis showing month-over-month changes, year-over-year growth rates, seasonal patterns, and specific recommendations for underperforming regions.