What Offsite Ads cost on Etsy, and the price that covers it
sellerprofit_offsite_adsWorks out what Etsy's Offsite Ads cost a shop at its share of sales (12% or 15% of an attributed order, at most $100 an order), per order and per month, and the item price that covers the fee. Call it when a seller asks what Offsite Ads cost them, whether to price them in, or whether to opt out. Pass the item price, shipping charged, the shop's Offsite Ads rate (12-percent past $10,000, 15-percent under, or off), orders a month, and the share of sales from Offsite Ads if the seller knows it (else Etsy's typical 10%, flagged). Materials and label cost are optional and add how far orders could fall before the price rise leaves the seller worse off. Returns the fee per attributed order and on average, the monthly and yearly cost, the price fix and its value if orders hold, and when opting out is possible. US dollars; dated Etsy rules with sources. Free, no sign-in. Takes numbers only; nothing is stored.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| orders | Yes | Orders in a typical month: a number from 1 to 100,000 (Shop Manager > Stats > Orders), or a band: 1-10, 11-30, 31-75, 76-150, 151-300. Over 300: send the number. | |
| itemPrice | Yes | Typical item price, US dollars, before shipping. | |
| labelCost | No | Optional: the shipping label, US dollars. | |
| materials | No | Optional: materials per item, US dollars. With labelCost, adds how far orders could fall before the price fix leaves the seller worse off. | |
| packaging | No | Packaging per order in US dollars, or mailer (about $1), box (about $3) or not-sure. Left out: $1, a weakly sourced typical figure, flagged as a default. | |
| offsiteAds | Yes | The shop's Offsite Ads rate: 12-percent (the shop has sold $10,000 or more in any 12 months; for life, no opt-out), 15-percent (under $10,000, Offsite Ads on), or off (opted out). | |
| offsiteShare | No | Share of sales from Offsite Ads (Marketing > Offsite Ads): a fraction (0.1 is 10%), or under-5, 5-14, 15-24, 25-plus. Left out: Etsy's typical 10% (2020), flagged as a default. | |
| shippingCharged | No | What the buyer pays for shipping, US dollars (0 if free). Offsite Ads are charged on it too. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rate | Yes | The fee on an attributed order: 0.12, 0.15, or 0 when off. | |
| text | Yes | ||
| rates | Yes | Which rules the numbers use, as of when, and where they come from. | |
| share | Yes | Share of sales from Offsite Ads used. | |
| optOut | Yes | Opting out is possible only under $10,000. A test, not a verdict. | |
| yearly | Yes | ||
| monthly | Yes | ||
| platform | Yes | ||
| priceFix | Yes | The item price that covers the Offsite Ads fee; null when there's no fee. | |
| capApplied | Yes | ||
| orderTotal | Yes | ||
| assumptions | Yes | ||
| shareIsDefault | Yes | ||
| averagePerOrder | Yes | The fee spread over every order: share × fee. | |
| feePerAttributedOrder | Yes | min(rate × order, $100), US dollars. |