Tabellab

Returns and Breakage: Return Rate and Cost per SKU

Lesson 7 of 20 Lab 🔒 Locked

Lessons in this course

  1. Order Export Cleanup: Order Numbers, SKUs and Line TotalsLabFree
  2. Profit per Order after Payment Fees and ShippingLab Locked
  3. Product Margin Table: Which SKUs Earn Enough?Lab Locked
  4. Pricing with a Target Margin (Not a Markup)Lab Locked
  5. Ad Spend: ROAS, Cost per Order and Break-even ROASLab Locked
  6. Discount Codes: What 15% Off Really CostsLab Locked
  7. Returns and Breakage: Return Rate and Cost per SKULab Locked
  8. Inventory: Days of Stock and When to ReorderLab Locked
  9. Bestseller Ranking with SORT and LARGELab Locked
  10. Monthly Sales by Channel with SUMIFS (Chart)Lab Locked
  11. Customer Repeat Rate and Revenue from Returning BuyersLab Locked
  12. Half-Year Dashboard: Profit, Margin, Chart and Colour ScaleLab Locked
  13. SKU Codes Decoded: Scent and Size with LEFT, FIND and MID – and New SKUs with TEXTLab Locked
  14. Joining Two Exports: Unit Costs into Order Lines with XLOOKUP and a «missing» Safety NetLab Locked
  15. Customer List Cleanup: Clean Emails, Duplicate Flags, Missing Countries & the Real Customer CountLab Locked
  16. Scent × Size Matrix: One SUMIFS with Mixed References and a Colour-Scale Heat MapLab Locked
  17. Order Values in Bands: COUNTIFS from–to, Median vs AOV and a Column ChartLab Locked
  18. Product Reviews by the Numbers: Average Stars, Low-Star Share and Review Rate per SKULab Locked
  19. Growth over Time: Month-over-Month vs Year-over-Year and a 3-Month Average (Line Chart)Lab Locked
  20. Final Project: Year-End Seller Report – Channels, Profit, Margin, Growth and a Stacked ChartLab Locked