• All Orders (Excluding Mixed SKUs) — the default. Label costs are split proportionally across the items in a box, but orders containing more than one distinct SKU are left out entirely so a shared label cannot skew any single product's average.
• Single-Item Orders Only — only orders of one unit of one SKU. The cleanest read on what a product actually costs to ship on its own.
• All Orders (Including Mixed SKUs) — brings multi-SKU orders back in. Totals become complete, but per-SKU averages carry an allocated share of a shared label rather than a real standalone rate. Use this for company-wide totals, not for judging one product.

📦 Products & SKUs

• SKU Cards: List of products showing volume, average costs, min/max values, and exception rate alerts. Click any card to open the SKU Deep-Dive.
• Product Margins: Integrates Cost of Goods Sold (COGS) with shipping fees to calculate true landed margins. Click on any COGS cell to edit values locally (saved in localStorage).
• Packaging & Estimates: Evaluates box size usage, models dimensional weight (DIM) penalties, and features an interactive guesstimator calculator.
• Bundle Splitter Audit: Evaluates multi-item order shipping costs against individual USPS Ground Advantage package rates to identify splits that save postage.
• Weight & Parcel Audit: Finds parcels sitting just over a carrier billing pound, parcels heavier than their own box type normally runs, and SKUs whose recorded weight is missing or inconsistent.

📊 Cost Analytics

• Shipping Analytics: Core charts tracking shipping costs, carrier spend, and storefront AOV trends.
• Swap Savings: models savings from swapping selected express shipments to Ground Advantage or Cubic services.
• Surcharge Audit: Tracks residential surcharges and models savings by routing residential orders via USPS.
• Order P&L & Subsidy: Order-level revenue against real label cost, how much shipping you recover from buyers, and the orders where freight eats the order.
• Exceptions: Lists voided label audits, customer reshipments, and carrier rating errors.

🚚 Logistics & Transit

• Geographic Transit Hotspots: Interactive US hexagon map. Click states to isolate volume, transit speeds, and city leaderboards.
• Warehouse Fulfillment Log: Deep search tracking log for pick-and-pack performance, with clickable google-search tracking links.
• Operational Latency Speed: Tracks dispatch delays, weekday speed anomalies, and slowest SKUs.

👥 Customers & CRM

• CRM Directory: Lifetime spent leaderboards, contact directories, and acquisition charts.
• Loyalty Tiers: Categorizes accounts into VIP, Loyal, One-Time, and At-Risk groups with churn analytics.
• B2B vs B2C Benchmarking: Compares corporate accounts (those with company names) against B2C consumers, mapping spends, AOV, and LTV.
• Buyer Comments Feed: Logs customer feedback, highlighting operational tags (e.g. *urgent*, *fragile*).

↩️ Returns & Waste

• Returns Overview: Monitors sunk return costs, return reason tags, and high-frequency return items.
• Return Correlator: Scatter plots correlating package weight against return rates to diagnose damaged goods.
• Category Returns: Groups return losses by SKU category prefixes to find low-quality product lines.

💡 Strategic Insights

• Product Bundles: Co-occurrence analysis recommending bundle opportunities for products frequently shipped together.
• Zone Margins: Landed cost margins and gross profit percentages broken down by postal zone.
• Storefront Profiles: Sales channel performance comparisons.

• Leave out of revenue (default) — those rows are skipped entirely. Note this also removes their shipping cost, so the margins tab's Total Shipping runs below your true spend.
• Value at the SKU's median price — each $0 row is priced at the middle of that SKU's other observed prices. Rows whose SKU has no priced sale anywhere are still left out.
• Count as $0 revenue — taken at face value. Units and shipping costs count in full, revenue does not; margins fall accordingly.

• Lines — one product on one label. What the SKU cards count as "times shipped".
• Labels — one physical parcel. What per-parcel figures use: the residential surcharge, and every carrier-swap recommendation.
• Units — actual pieces of product. Where an order ships on more than one label, a unit is shared between them rather than counted twice, so unit totals reconcile to the order.

• Freight % — an order's total label cost as a share of what the buyer paid. Above 100% the shipping cost more than the entire order.
• Recovered — shipping the buyer paid for. Recorded in two places that disagree slightly, so the larger of the order's shipping charge and the label's is used.
• Subsidy — label cost minus recovered: what you absorbed.
• Underwater orders — those where shipping passed 40% of order value.

• Trim candidates — carriers bill in whole pounds above 1 lb, so a parcel 1–3 oz over a boundary pays for a pound it is not using. The saving shown is the median cost of one billed pound for that same service and zone.
• Overweight vs its own box — packaging legitimately weighs something, so a parcel is only flagged when it is more than a pound above the median tare for that same box type. Comparing against contents alone would flag about half of everything you ship.
• SKU weight status — "Varies" means the recorded weight moved by more than 50% between orders; "No weight" means none is on file. Both distort every rate estimate that uses them.

• Voided — the label was cancelled, or its cost came through negative.
• Reshipment — the order has more than one label against it. That covers genuine re-sends, but also split shipments and reprints, so read it as "shipped more than once" rather than proof of a failure.
• Downgraded — the buyer asked for an expedited service and the parcel went out on a slower one. Matching is by service name, covering 2-day, second-day, next-day, overnight, express and expedited wording.

• Click any column header to sort; click again to reverse. Currency, weights and dates sort by value, not as text.
• Charts have a ⛶ button in the corner for full screen.
• Long tables show the first 100 rows with a Show More button beneath.
• Clicking a customer, a returned SKU or an order number opens a detail view of the underlying records.
• Order numbers open your storefront's order page where the Orders report supplies a URL, and otherwise filter the dashboard to that order.