Tabellab
Marketing Analytics Intermediate

Marketplace Seller Math: Fees, ACoS, TACoS & Profit per Unit

Landed cost, referral and fulfilment fees, break-even and target ACoS, TACoS and ROAS by campaign, keyword bids, reorder points and storage fees, returns and a launch P&L for an online-marketplace seller, with every cell checked as you go. Independent course, not affiliated with Amazon, Etsy, eBay or any marketplace; fee rates are illustrative.

8 lessons 8 labs 2 h Certificate

The first lesson is free โ€” no account needed.

About this course

A marketplace seller math course that works out where an online seller's profit goes, product by product, in a spreadsheet, for private-label sellers, e-commerce managers and agency analysts. You split sea freight by weight and add duty and prep costs for the landed cost per unit, apply a referral fee with a minimum and a size-tier fulfilment fee for the profit per unit, turn that profit into a break-even and a target ACoS with a nested IF verdict per SKU, roll eight campaigns up by match type with SUMIFS and compare ACoS, ROAS and the store's TACoS, set keyword bids from conversion rate and target ACoS, calculate days of cover, reorder points and storage fees, price returns and plan a six-month launch P&L with its payback month. An independent course, not affiliated with Amazon, Etsy, eBay or any marketplace. Fee rates are illustrative. The first lab is free.

Lessons

  1. Landed Cost per Unit: Product, Freight & DutyLab14 minFree
  2. Referral & Fulfilment Fees: Profit per Unit and MarginLab14 min Pro
  3. Break-even ACoS, Target ACoS & Max Ad Cost per SaleLab13 min Pro
  4. ACoS vs TACoS vs ROAS by Campaign Type (SUMIFS + Chart)Lab16 min Pro
  5. Keyword Bid Math: Max CPC from Conversion Rate & Target ACoSLab15 min Pro
  6. Reorder Point, Days of Cover & Storage FeesLab15 min Pro
  7. Returns & Refunds: Profit per Order after ReturnsLab15 min Pro
  8. Product-launch P&L: Ramp-up, Ads & Payback (Chart)Lab18 min Pro