profit-margin-analysis

What this skill does

# Profit Margin Analysis

## Overview

Profit margin analysis identifies exactly where your business makes and loses money — broken down by products, categories, channels, and customer segments. A product that accounts for 40% of revenue might contribute only 10% of gross profit — or actually lose money once fulfillment, marketing, and overhead are factored in.

This skill guides you through building a clear margin hierarchy using your existing platform tools and profit analytics apps, without requiring a data warehouse.

## When to Use This Skill

- When needing to identify which products, categories, or SKUs are most and least profitable
- When comparing margin performance across sales channels (website vs. Amazon vs. wholesale)
- When making pricing decisions and needing to understand the impact on margin
- When rationalizing the product catalog to eliminate low-margin SKUs
- When understanding how marketing spend affects channel-level profitability
- When benchmarking margins against industry peers or investor expectations

## Core Instructions

### Step 1: Establish your margin hierarchy

Before pulling any data, define the margin levels you will track. Use this waterfall consistently across all analyses:

```
Gross Revenue (selling price × units sold)
  - Discounts & coupons applied
  - Returns & refunds
= Net Revenue

  - Product COGS (landed cost: purchase price + freight + duties)
= Gross Profit
  Gross Margin % = Gross Profit / Net Revenue × 100

  - Outbound shipping (actual label cost or estimate)
  - Payment processing fees (~2.9% + $0.30 for Stripe/Shopify Payments)
  - Marketplace fees (Amazon referral + FBA fees; eBay final value fees)
  - Packaging materials
= Fulfillment-Adjusted Gross Profit
  Fulfillment-Adjusted Margin %

  - Direct marketing spend (attributed to this channel/product)
= Contribution Margin
  Contribution Margin % = Contribution Margin / Net Revenue × 100

  - Allocated overhead (warehouse, software, headcount allocation)
= Net Operating Profit
  Net Margin %
```

**Why contribution margin matters most for ecommerce decisions:** Gross margin ignores fulfillment and marketing costs that are often the biggest swing factors. Contribution margin per unit is the number that actually governs whether it makes sense to sell more of a product or scale a channel.

### Step 2: Enter cost data into your platform

Accurate margin analysis starts with accurate cost data. Enter landed cost (not just purchase price) for every product.

---

#### Shopify

1. Go to **Products → [Product] → Variants**
2. For each variant, enter the **Cost per item** — this should be your fully landed cost:
   - Supplier invoice price per unit
   - + Inbound freight per unit (divide total freight by total units in the shipment)
   - + Customs duties per unit
   - + Inspection/prep fees per unit (if applicable)
3. Once costs are entered, go to **Analytics → Reports → Profit by product** — Shopify calculates gross profit per product automatically
4. Go to **Analytics → Reports → Profit by channel** — see gross margin by sales channel

**Limitations of Shopify's built-in profit reports:**
- Shows gross profit only (revenue minus COGS)
- Does not include fulfillment costs, payment fees, or marketing spend
- For full contribution margin analysis, use a profit analytics app

**Recommended Shopify apps for complete margin analysis:**
- **BeProfit:** Adds shipping cost tracking (connects to ShipStation, EasyPost), ad spend integration (Meta, Google, TikTok), and per-order contribution margin
- **Lifetimely:** Focuses on CLV and cohort profitability alongside contribution margin by channel
- **TrueProfit:** Real-time profit dashboard with all cost layers; connects to 20+ ad platforms and shipping carriers

**BeProfit setup for contribution margin:**
1. Install BeProfit from the Shopify App Store
2. Go to **BeProfit → Settings → Costs** — verify product costs are imported from Shopify
3. Go to **BeProfit → Integrations → Shipping** — connect ShipStation or Shippo to pull actual label costs per order
4. Go to **BeProfit → Integrations → Marketing** — connect Meta, Google, TikTok for ad spend allocation
5. Go to **BeProfit → Reports → Products** — view gross margin, fulfillment-adjusted margin, and contribution margin per product

---

#### WooCommerce

1. Install the **Cost of Goods** plugin (WooCommerce extension, $79/yr) to add a cost field to each product
2. Enter landed cost per product/variant (same methodology as Shopify above)
3. **Metorik** pulls this cost data and shows gross profit per product at **Metorik → Products → Profitability**
4. For fulfillment cost tracking: export ShipStation or Shippo costs monthly as CSV; match to WooCommerce orders by order ID in Google Sheets or with Metorik's CSV import

---

#### BigCommerce

1. Go to **Products → [Product] → Pricing → Cost price** — enter landed cost per product
2. Go to **Analytics → Merchandising → Products** — view gross margin % per product with cost entered
3. Install **Glew.io** (App Marketplace) for contribution margin analysis that includes ad spend and fulfillment costs

---

### Step 3: Run margin analysis by dimension

**By product and SKU:**

In your platform analytics or profit app, sort products by contribution margin % ascending to find your least profitable SKUs:

- **Shopify:** BeProfit → Reports → Products → sort by Net Profit % ascending
- **WooCommerce:** Metorik → Products → sort by Gross Profit ascending
- **BigCommerce:** Glew.io → Products → sort by Margin % ascending

**By channel:**

Compare the same product sold on different channels:

| Metric | Your Website | Amazon FBA | Wholesale |
|--------|-------------|-----------|---------|
| Gross Revenue per unit | $39.99 | $39.99 | $20.00 (your price to retailer) |
| Payment/marketplace fees | 3.2% | 15% referral + $4.50 FBA | 0% (invoice-based) |
| Outbound shipping | $5.00 | Included in FBA fee | Bulk freight (lower per unit) |
| Gross Margin % | 62% | 38% | 35% |
| Contribution Margin % | 48% | 25% | 28% |

This shows that despite Amazon's lower margin %, the channel may still be valuable for volume and brand visibility — but you need the numbers to decide.

**By category:**

Group your products into categories and compare average contribution margin % across them:
- Which categories contribute the most gross profit in absolute dollars?
- Which categories have the highest margin % (most efficient products)?
- Which categories have high revenue but low margin (volume products that may be diluting overall profitability)?

### Step 4: Use industry benchmarks to contextualize your analysis

| Business Type | Gross Margin | Contribution Margin | Net Margin |
|---------------|-------------|--------------------|-----------|
| Branded DTC (consumables) | 55–75% | 30–50% | 5–20% |
| Branded DTC (apparel) | 55–70% | 25–45% | 3–15% |
| Electronics reseller | 10–25% | 5–15% | 1–5% |
| Amazon FBA reseller | 15–35% | 5–20% | 2–8% |
| Subscription box | 40–60% | 20–40% | 5–15% |
| Wholesale / B2B | 20–40% | 15–30% | 3–12% |

If your gross margin is significantly below these ranges, investigate:
1. Are COGS entered correctly (including all landed cost components)?
2. Are you selling with excessive discounts?
3. Is your product pricing too low for your cost structure?

### Step 5: Identify and act on margin improvement opportunities

Once you have margin data by SKU, prioritize improvements:

**SKU profitability tiering:**
- **Stars:** High margin + high volume → protect and grow; prioritize in ad spend and inventory
- **Workhorses:** Lower margin + high volume → margin improvement projects (negotiate supplier cost, reduce returns, optimize shipping)
- **Niche:** High margin + low volume → grow with targeted marketing; can sustain higher CAC
- **Dogs:** Low margin + low volume → candidates for discontinuation or price increase

**Quick wins for margin improvement:**
1. **Raise prices on low-margin, low-elasticity SKUs** — test a 10–15% pric