Product-Level Sales Analysis Framework

1. Category and Sub-Category Performance

• Total sales and revenue by product category and sub-category

• Units sold by category

• Sales contribution percentage of each category to total revenue

• Average order value per category

• Pie chart for revenue share by category

• Bar chart for sales volume by sub-category

• Treemap for product line performance distribution

• Identify top-selling and underperforming categories

• Understand where most sales volume is concentrated

• Inform category-level decisions on product investment or discontinuation

2. Profitability Analysis

• Total profit by category and sub-category

• Gross margin percentage: (Profit / Sales) × 100

• Profit-to-sales ratio

• Profit contribution percentage by category

• Bar chart comparing profit margins

• Scatter plot of sales vs profit by category

• Bubble chart with category size by revenue and profit

• Identify categories with strong revenue but weak profitability

• Highlight high-margin product lines worth promoting

• Evaluate impact of discounting or cost inefficiencies

3. SKU-Level (Product-Level) Performance

• Top and bottom products by:
• Revenue
• Units sold
• Profit or margin

• Return rates (if available)

• SKU activity duration or sales span

• Ranked bar charts of product performance

• Bubble plots showing revenue vs margin with units sold as bubble size

• Spot high-impact products to promote or bundle

• Flag low-performing SKUs for review or phase-out

• Benchmark top products as models for development

4. Time Series Trend Analysis (Sales Over Time)

• Monthly sales by category and sub-category

• Month-over-month and year-over-year growth

• Moving average or trendline smoothing

• Line graphs for sales trends by product group

• Heatmaps showing category performance across months

• Identify seasonal demand patterns

• Prepare for promotional events or high-demand periods

• Use patterns for forecasting and inventory planning

5. Price Band Analysis

• Low-end: under $50

• Mid-range: $50 to $150

• High-end: over $150

• Revenue, volume, and margin by price tier

• Average margin per band

• Conversion rates if marketing funnel data is available

• Box plots for price vs margin distribution

• Stacked bar charts of revenue by price band

• Evaluate performance of budget vs premium products

• Tailor marketing based on customer price sensitivity

• Adjust pricing strategy and assortment accordingly

6. Product Lifecycle Analysis

• First and last sale date per product

• Monthly performance curve per SKU

• Categorization into lifecycle stages:
• Introduction
• Growth
• Maturity
• Decline

• Product sales timelines

• Sales curve plots over product lifespan

• Support product launches with early-stage marketing

• Extend the life of mature, stable SKUs

• Plan clearance or replacement for declining products

7. Product Contribution Matrix

• X-axis: Revenue contribution percentage

• Y-axis: Profit contribution percentage

• High sales, high profit: Star Products

• High sales, low profit: Volume Drivers

• Low sales, high profit: Niche Winners

• Low sales, low profit: Phase-Out Candidates

• Scatter plot with quadrant lines based on mean or median thresholds

• Focus investment and marketing on star products

• Improve profitability of volume drivers

• Nurture niche winners through targeted sales

• Discontinue phase-out candidates after evaluation