Journal · 18 January 2026
Margin-aware CLV for marketplace sellers
Marketplace dashboards love GMV. Your bank account does not. Customer Lifetime Value Analytics for a seller who only sees a fragment of the buyer has to start with subtraction, or the ranking will simply copy last month’s ads report.
The sheet we actually use
One row per identifiable buyer key the platform gives you. Columns: first order date, SKU family of first order, gross, commission, estimated ads attributed to that buyer if the platform exposes it, return cost, payment fee, net contribution, count of later orders inside a window you choose (usually 180 or 365 days, not “lifetime” as poetry).
Then rank by net contribution plus a conservative repeat factor — often just historical repeat rate for that first SKU family, not a fancy model. If ads are missing, write “ads unknown” on the memo and do not pretend the top rank is media-proof.
The buyer you cannot see
The same person may buy your cable on one storefront and a competitor’s protector on another. Your CLV is a ranking inside your shop, not a portrait of a human. In the electronics accessories case we published on the reviews page, that humility mattered more than the arithmetic. The cable looked “high lifetime” until commission and a 14% return rate sat on the same line.
When not to bother
If you cannot join returns to the original buyer key, stop. Fix the join. A margin-aware fantasy is still a fantasy. Our Margin-Aware Lifetime Modelling block exists for teams who already have that join and still argue with their agency about which SKU deserves the promo calendar.